Skip to content

Table schemas

Logical types: string, int64, bool, date, timestamp and number. A number is a decimal.Decimal in Python and decimal128(28, 15) in Arrow.

project

Column Type
file string
cuf_version string
software_house string
created timestamp
encoding string
namespace string
number string
name string
estimator string
client string
address string
estimate_date date
start_date date
currency string
euro_rate number
notes string
contract_sum number
stated_hours number
stated_labour number
stated_material number
stated_equipment number
stated_subcontracting number
stated_other number
hours number
labour number
material number
equipment number
subcontracting number
other number
total number
estimate_style string
bundle_count int64
line_count int64

bundles

Column Type
seq int64
parent_seq int64
depth int64
path string
code string
coding_method string
description string
unit string
reference_quantity number
multiplier number
stated_hours number
stated_labour number
stated_material number
stated_equipment number
stated_subcontracting number
stated_other number
hours number
labour number
material number
equipment number
subcontracting number
other number
total number
applied_multiplier number
extended_total number
comment string
xml_line int64

lines

Column Type
seq int64
bundle_seq int64
depth int64
path string
code string
description string
unit string
quantity number
count_unit string
count number
duration_unit string
duration number
production_unit string
production number
quantity_factor number
factor_code string
hours_per_unit number
hourly_rate number
hourly_rate_code string
material_price number
equipment_price number
subcontract_price number
other_price number
provisional_sum bool
vat_rate number
ean_code string
article_group string
order_unit string
quantity_per_order_unit number
supplier_code string
comment string
is_text bool
resource_count int64
priced_by_resources bool
hours number
labour number
material number
equipment number
subcontracting number
other number
total number
applied_multiplier number
extended_total number
xml_line int64

resource_lines

Column Type
seq int64
line_seq int64
cost_type string
code string
description string
unit string
quantity number
count_unit string
count number
duration_unit string
duration number
production_unit string
production number
price number
price_factor number
factor_code string
hours_per_unit number
hourly_rate number
hourly_rate_code string
ean_code string
article_group string
order_unit string
quantity_per_order_unit number
supplier_code string
comment string
hours number
labour number
material number
equipment number
subcontracting number
other number
total number
xml_line int64

quantity_lines

Column Type
seq int64
owner_type string
owner_seq int64
room string
description string
count number
length number
width number
height number
factor_1 number
factor_2 number
product number
xml_line int64

sort_codes

Column Type
owner_type string
owner_seq int64
scheme string
value string
inherited bool

sort_code_schemes

Column Type
seq int64
name string
purpose string
entry_count int64

sort_code_entries

Column Type
scheme_seq int64
scheme string
code string
description string
unit string
reference_quantity number

tail_items

Column Type
seq int64
description string
amount number