invoice_line

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
account_debit.invoice_line_oid fkacct_deb_inv_lineC
invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkeyC
type wcof_tag 2147483647 √ null
subtype wcof_tag 2147483647 √ null
invoice_oid int8 19 √ null
invoice.obj_oid invoice_line_invoice_oid_fkeyC
resource_oid int8 19 √ null
resource.obj_oid fkinv_line_resN
description varchar 2147483647 √ null
creation_date timestamptz 35,6 √ null
created_by int8 19 √ 1
person.obj_oid fkinv_line_created_by
modified timestamptz 35,6 √ null
modified_by int8 19 √ 1
person.obj_oid fkinv_line_modified_by
struck bool 1 √ null
strike_date timestamptz 35,6 √ null
amount money 2147483647 0.0
quantity int4 10 1
subtotal money 2147483647 0.0
taxable bool 1 √ null
tax money 2147483647 0.0
total money 2147483647 0.0

Indexes

Constraint Name Type Sort Column(s)
invoice_line_pkey Primary key Asc obj_oid
invoice_line_invoice_idx Performance Asc invoice_oid
invoice_line_resource_idx Performance Asc resource_oid

Relationships

Close relationships within degrees of separation