fct_pos_saleposition


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pos_saleposition_id int8 19 null
bridge_pos_saleposition_to_payment.pos_saleposition_id bridge_pos_saleposition_to_payment_pos_saleposition_id_fkey R
fct_revenue_invoice_based.pos_saleposition_id Implied Constraint R
internal_payment_id int8 19 √ null
pos_id int8 19 √ null
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_pos_saleposition_organization_unit_id_fkey R
cash_register_id int8 19 √ null
dim_cash_register.cash_register_id Implied Constraint R
sale_type varchar 256 √ null
sale_position_type varchar 256 √ null
sales_time timestamptz 35 √ null
product_id varchar 256 √ null
dim_product.product_id Implied Constraint R
price numeric 19,2 √ null
currency_code varchar 256 √ null
tax_percent numeric 19,2 √ null
discount_amount numeric 19,2 √ null
discount_percentage numeric 19,2 √ null
amount numeric 19,2 √ null
term_of_validity int4 10 √ null
term_of_validity_unit varchar 256 √ null
related_pos_saleposition_id int8 19 √ null
voucher_credit_amount numeric 19,2 √ null
consumption_credit_amount numeric 19,2 √ null
bonus_amount numeric 19,2 √ null
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation