c_invoiceline_v

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id Implied Constraint R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
salesrep_id numeric 10 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
documentno varchar 30 √ null
dateinvoiced timestamp 29,6 √ null
dateacct timestamp 29,6 √ null
issotrx bpchar 1 √ null
docstatus bpchar 2 √ null
linenetamt numeric 0 √ null
linelistamt numeric 0 √ null
linelimitamt numeric 0 √ null
linediscountamt numeric 0 √ null
lineoverlimitamt numeric 0 √ null
qtyinvoiced numeric 0 √ null
qtyentered numeric 0 √ null
line numeric 10 √ null
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id Implied Constraint R
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
c_projectphase_id numeric 10 √ null
c_projectphase.c_projectphase_id Implied Constraint R
c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views