c_orderline

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_orderline_id numeric 10 null
c_commissiondetail.c_orderline_id corderline_ccommissiondetail R
c_invoiceline.c_orderline_id corderline_cinvoiceline R
c_orderlandedcostallocation.c_orderline_id corderline_corderlandedcostall R
c_orderline.link_orderline_id linkorderline_corderline N
c_orderline.ref_orderline_id corderline_ref R
cof_c_comexinfo.c_orderline_id corderline_cofccomexinfo R
cof_imagenslinhaov.c_orderline_id corderline_cofimagenslinhaov R
cof_itemsubstituto.c_orderline_id corderline_cofitemsubstituto R
cof_linhareposicao.c_orderline_id corderline_coflinhareposicao N
cof_orderdeducaomateriais.c_orderline_id corderline_coforderdeducaomateriais C
i_order.c_orderline_id corderline_iorder N
lbr_docfiscal_line.c_orderline_id corderline_lbrdocfiscalline R
m_costdetail.c_orderline_id corderline_mcostdetail R
m_demanddetail.c_orderline_id corderline_mdemanddetail C
m_inoutline.c_orderline_id corderline_minout R
m_matchpo.c_orderline_id corderline_mmatchpo R
m_movementline.cof_orderline_id coforderline_mmovementline R
m_production.c_orderline_id corderline_mproduction R
m_requisitionline.c_orderline_id corderline_mrequisitionline R
pp_mrp.c_orderline_id corderline_ppmrp R
pp_order.c_orderline_id corderline_pporder R
s_timeexpenseline.c_orderline_id corderline_stimeexpenseline R
t_cof_relatoriocompra.c_orderline_id corderline_tcofrelatoriocompra N
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_corderline 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_order_id numeric 10 null
c_order.c_order_id corder_corderline R
line numeric 10 null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_soline R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_soline R
dateordered timestamp 29,6 null
datepromised timestamp 29,6 √ null
datedelivered timestamp 29,6 √ null
dateinvoiced timestamp 29,6 √ null
description varchar 255 √ null
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_corderline R
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_corderline R
c_uom_id numeric 10 null
c_uom.c_uom_id cuom_corderline R
qtyordered numeric 0 0
qtyreserved numeric 0 0
qtydelivered numeric 0 0
qtyinvoiced numeric 0 0
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_corderline R
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_corderline R
pricelist numeric 0 0
priceactual numeric 0 0
pricelimit numeric 0 0
linenetamt numeric 0 0
discount numeric 0 √ null
freightamt numeric 0 0
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_corderline R
c_tax_id numeric 10 null
c_tax.c_tax_id ctax_corderline R
s_resourceassignment_id numeric 10 √ null
s_resourceassignment.s_resourceassignment_id sresourceassign_corderline R
ref_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_ref R
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id mattrsetinst_corderline R
isdescription bpchar 1 'N'::bpchar
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_corderline R
pricecost numeric 0 √ null
qtylostsales numeric 0 0
c_projectphase_id numeric 10 √ null
c_projectphase.c_projectphase_id cprojectphase_corderline N
c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id cprojecttask_corderline N
rrstartdate timestamp 29,6 √ null
rramt numeric 0 √ null
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_corderline R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_corderline R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser1_corderline R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser2_corderline R
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_corderline R
link_orderline_id numeric 10 √ null
c_orderline.c_orderline_id linkorderline_corderline N
pp_cost_collector_id numeric 10 √ null
pp_cost_collector.pp_cost_collector_id ppcostcollector_corderline R
m_promotion_id numeric 10 √ null
m_promotion.m_promotion_id mpromotion_corderline R
c_orderline_uu varchar 36 √ NULL::character varying
createshipment bpchar 1 √ 'N'::bpchar
createproduction bpchar 1 √ 'N'::bpchar
lbr_tax_id numeric 0 √ null
lbr_cfop_id numeric 10 √ null
lbr_legalmessage_id numeric 10 √ null
lbr_legalmessage.lbr_legalmessage_id lbrlegalmessage_corderline R
m_productionline_id numeric 10 √ null
taxamt numeric 0 √ (0)::numeric
lbr_recalculatetax bpchar 1 'N'::bpchar
cof_freightamt numeric 0 '0'::numeric
cof_otheramt numeric 0 '0'::numeric
cof_insuranceamt numeric 0 '0'::numeric
cof_markupprice numeric 0 √ (0)::numeric
cof_realmargin numeric 0 √ (0)::numeric
cof_markupbaseprice numeric 0 √ (0)::numeric
cof_markupminimum numeric 0 √ '0'::numeric
cof_markupmaximum numeric 0 √ '0'::numeric
cof_poreferenceline numeric 10 √ null
cof_cfop_delivery_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id cofcfoptransp_corderline R
cof_legalmessagedelivery_id numeric 10 √ null
lbr_legalmessage.lbr_legalmessage_id coflegalmessagedelivery_corder R
cof_taxruleshistory varchar 255 √ null
cof_estimatedweight numeric 0 √ (0)::numeric
cof_isgenericitem bpchar 1 √ 'N'::bpchar
cof_vendorproductno varchar 40 √ null
cof_vendorproductname varchar 255 √ NULL::character varying
cof_poreference varchar 15 √ NULL::character varying
cof_pp_qtdfatorconversao numeric 0 √ null
cof_qtdanulada numeric 0 √ '0'::numeric
cof_situacaocomercial varchar 4 √ NULL::character varying
cof_products_id numeric 10 √ NULL::numeric
cof_products.cof_products_id cofproducts_corderline R
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_corderline R
a_capvsexp varchar 3 √ 'Cap'::character varying
a_createasset bpchar 1 √ 'N'::bpchar
cof_precobase numeric 0 '0'::numeric
cof_preconegociacao numeric 0 '0'::numeric
cof_juros numeric 0 '0'::numeric
cof_qtdentregafutura numeric 0 '0'::numeric
cof_entregaparcial bpchar 1 'N'::bpchar
cof_linhaopindusprestador_id numeric 10 √ NULL::numeric
m_productionline.m_productionline_id coflinhaopindustrializacaopres R
cof_linhaopmataplicadoprest_id numeric 10 √ null
cof_materialaplicado.cof_materialaplicado_id linhaovlinhamaterialaplicado R
cof_tipooperacao varchar 100 √ NULL::character varying
cof_porccomissao numeric 0 √ '0'::numeric
cof_isservicoatrelado bpchar 1 'N'::bpchar
cof_pontoremessa_id numeric 10 √ NULL::numeric
cof_pontoremessa.cof_pontoremessa_id cofpontoremessa_corderline R
cof_kitcomercial bpchar 1 'N'::bpchar
cof_cpv numeric 0 '0'::numeric
cof_cpvunitario numeric 0 '0'::numeric
cof_percmargem numeric 0 '0'::numeric
cof_valormargem numeric 0 '0'::numeric
cof_kitvendas_id numeric 10 √ NULL::numeric
m_product.m_product_id cofkitvendas_corderline R
pp_product_bom_id numeric 10 √ NULL::numeric
pp_product_bom.pp_product_bom_id ppproductbom_corderline R
cof_qtdkit numeric 0 √ null
cof_excluidoprocesso bpchar 1 'N'::bpchar
cof_pedidodesmembrado_id numeric 10 √ NULL::numeric
cof_uomcomercial_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cofuomcomercial_corderline R
cof_linhareposicao_id numeric 10 √ null
cof_linhareposicao.cof_linhareposicao_id coflinhareposicao_corderline N
imposto_ibscbs_inddoacao bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_orderline_pkey Primary key Asc c_orderline_id
c_orderline_link_orderline_id_idx Performance Asc link_orderline_id
c_orderline_order Performance Asc c_order_id
c_orderline_product Performance Asc m_product_id
c_orderline_ref_orderline_id_idx Performance Asc ref_orderline_id
c_orderline_uu_idx Must be unique Asc c_orderline_uu

Check Constraints

Constraint Name Constraint
c_orderline_cof_isgenericitem_check ((cof_isgenericitem = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_a_createasset_check ((a_createasset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_lbr_recalculatetax_check ((lbr_recalculatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_cof_excluidoprocesso_check ((cof_excluidoprocesso = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_cof_entregaparcial_check ((cof_entregaparcial = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_cof_isservicoatrelado_check ((cof_isservicoatrelado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_cof_kitcomercial_check ((cof_kitcomercial = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_orderline_imposto_ibscbs_inddoacao_check ((imposto_ibscbs_inddoacao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation