c_invoiceline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_invoiceline_id numeric 10 null
a_asset_addition.c_invoiceline_id cinvoiceline_aassetaddition R
a_asset_disposed.c_invoiceline_id cinvoiceline_aassetdisposed R
a_asset_retirement.c_invoiceline_id cinvoiceline_aassetretirement R
c_commissiondetail.c_invoiceline_id cinvoiceline_ccommissiondet R
c_invoicebatchline.c_invoiceline_id cinvoiceline_cinvoicebline R
c_invoiceline.cof_invoiceline_id cofinvoiceline_cinvoiceline R
c_invoiceline.ref_invoiceline_id convoiceline_ref R
c_invoiceline_v.c_invoiceline_id Implied Constraint R
c_landedcost.c_invoiceline_id cinvoiceline_clandedcost C
c_landedcostallocation.c_invoiceline_id cinvoiceline_clandedcostalloc R
c_revenuerecognition_plan.c_invoiceline_id cinvoiceline_crevenuerecplan R
c_taxdeclarationline.c_invoiceline_id cinvoiceline_ctaxdeclline R
cof_c_comexinfo.c_invoiceline_id cinvoiceline_cofccomexinfo R
cof_c_diadi.c_invoiceline_id cinvoiceline_cofcdiadi R
cof_mprecebida.c_invoiceline_id cinvoiceline_cofmprecebida R
cof_rv_docfiscal.c_invoiceline_id Implied Constraint R
i_invoice.c_invoiceline_id cinvliceline_iinvoice N
lbr_docfiscal_line.c_invoiceline_id Implied Constraint R
lbr_docfiscal_line.cof_invoiceline_id cofinvoiceline_lbrdocfiscallin R
m_costdetail.c_invoiceline_id minvoiceline_mcostdetail R
m_costmovement_v.c_invoiceline_id Implied Constraint R
m_inoutlineconfirm.c_invoiceline_id cinvoiceline_minoutlineconfirm R
m_matchinv.c_invoiceline_id convoiceline_mmatchinv R
m_matchpo.c_invoiceline_id cinvoiceline_mmatchpo R
rv_c_invoiceline.c_invoiceline_id Implied Constraint R
rv_commissionrundetail.c_invoiceline_id Implied Constraint R
rv_costdetail.c_invoiceline_id Implied Constraint R
s_timeexpenseline.c_invoiceline_id cinvoiceline_stimeexpenseline R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cinvoiceline R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
c_invoice_id numeric 10 null
c_invoice.c_invoice_id cinvoice_cinvoiceline C
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_cinvoiceline R
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_cinvoiceline R
line numeric 10 null
description varchar 255 √ null
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_cinvoiceline R
qtyinvoiced numeric 0 0
pricelist numeric 0 0
priceactual numeric 0 0
pricelimit numeric 0 0
linenetamt numeric 0 0
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_cinvoiceline R
c_uom_id numeric 10 √ null
c_uom.c_uom_id cuom_cinvoiceline R
c_tax_id numeric 10 √ null
c_tax.c_tax_id ctax_cinvoiceline R
s_resourceassignment_id numeric 10 √ null
s_resourceassignment.s_resourceassignment_id sresourceassign_cinvoiceline R
a_asset_id numeric 10 √ null
a_asset.a_asset_id aasset_cinvoiceline R
taxamt numeric 0 √ 0
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id mattrsetinst_cinvoiceline R
isdescription bpchar 1 'N'::bpchar
isprinted bpchar 1 'Y'::bpchar
linetotalamt numeric 0 √ 0
ref_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id convoiceline_ref R
processed bpchar 1 'N'::bpchar
qtyentered numeric 0 null
priceentered numeric 0 null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_cinvoiceline R
c_projectphase_id numeric 10 √ null
c_projectphase.c_projectphase_id cprojectphase_cinvoiceline N
c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id cprojecttask_cinvoiceline N
rrstartdate timestamp 29,6 √ null
rramt numeric 0 √ null
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_cinvoiceline R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cinvoiceline R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser1_cinvline R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser2_cinvline R
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_cinvoiceline R
m_rmaline_id numeric 10 √ null
m_rmaline.m_rmaline_id mrmaline_cinvoiceline R
a_createasset bpchar 1 √ 'N'::bpchar
a_processed bpchar 1 √ 'N'::bpchar
a_capvsexp varchar 3 √ null
a_asset_group_id numeric 10 √ null
a_asset_group.a_asset_group_id aassetgroup_cinvoiceline R
c_invoiceline_uu varchar 36 √ NULL::character varying
isfixedassetinvoice bpchar 1 √ null
c_1099box_id numeric 10 √ NULL::numeric
c_1099box.c_1099box_id c1099box_cinvoiceline R
lbr_tax_id numeric 0 √ null
lbr_cfop_id numeric 10 √ null
lbr_cfop.lbr_cfop_id Implied Constraint R
lbr_legalmessage_id numeric 10 √ null
lbr_legalmessage.lbr_legalmessage_id lbrlegalmessage_cinvoiceline R
lbr_recalculatetax bpchar 1 'N'::bpchar
cof_freightamt numeric 0 '0'::numeric
cof_insuranceamt numeric 0 '0'::numeric
cof_otheramt numeric 0 '0'::numeric
cof_poreferenceline numeric 10 √ null
cof_taxruleshistory varchar 255 √ NULL::character varying
cof_isgenericitem bpchar 1 √ 'N'::bpchar
cof_vendorproductno varchar 40 √ NULL::character varying
cof_vendorproductname varchar 255 √ null
cof_poreference varchar 15 √ NULL::character varying
cof_pdevol numeric 0 √ null
cof_sourceqty numeric 0 √ null
discount numeric 0 √ null
cof_situacaocomercial varchar 4 √ NULL::character varying
cof_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id cofinvoiceline_cinvoiceline R
cof_fatorfinanceiro numeric 0 √ '0'::numeric
cof_products_id numeric 10 √ NULL::numeric
cof_products.cof_products_id cofproducts_cinvoiceline R
cof_linhaopindusprestador_id numeric 10 √ NULL::numeric
m_productionline.m_productionline_id coflinhaopindusprestador_cinvo R
cof_linhaopmataplicadoprest_id numeric 10 √ NULL::numeric
m_productionline.m_productionline_id coflinhaopmataplicadoprest_cin R
cof_tipooperacao varchar 100 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_invoiceline_pkey Primary key Asc c_invoiceline_id
c_invoiceline_invoice Performance Asc c_invoice_id
c_invoiceline_orderline Performance Asc c_orderline_id
c_invoiceline_product Performance Asc m_product_id
c_invoiceline_uu_idx Must be unique Asc c_invoiceline_uu

Check Constraints

Constraint Name Constraint
c_invoiceline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoiceline_lbr_recalculatetax_check ((lbr_recalculatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoiceline_a_createasset_check ((a_createasset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoiceline_a_processed_check ((a_processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoiceline_cof_isgenericitem_check ((cof_isgenericitem = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoiceline_isfixedassetinvoice_check ((isfixedassetinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation