fct_revenue_invoice_based


Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_invoice_based_id int8 19 null
accounting_date date 13 √ null
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R
revenue_group_id int8 19 √ null
dim_revenue_group.revenue_group_id Implied Constraint R
credit_account_number varchar 256 √ null
credit_account_name varchar 256 √ null
debit_account_number varchar 256 √ null
debit_account_name varchar 256 √ null
gross_amount numeric 19,2 √ null
net_amount numeric 19,2 √ null
tax_amount numeric 19,2 √ null
tax_percent numeric 19,2 √ null
currency_id varchar 256 √ null
dim_currency.currency_id Implied Constraint R
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R
contract_id int8 19 √ null
fct_contract.contract_id Implied Constraint R
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R
product_id varchar 256 √ null
dim_product.product_id Implied Constraint R
service_period_start_date date 13 √ null
service_period_end_date date 13 √ null
adjustment_type varchar 256 √ null
description varchar 65535 √ null
invoice_id int8 19 √ null
fct_invoice.invoice_id Implied Constraint R
pos_saleposition_id int8 19 √ null
fct_pos_saleposition.pos_saleposition_id Implied Constraint R
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation