lbr_cfop

622 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_cfop_id numeric 10 null
c_invoiceline.lbr_cfop_id Implied Constraint R
c_orderline.cof_cfop_delivery_id cofcfoptransp_corderline R
c_orderline.lbr_cfop_id Implied Constraint R
cof_c_taxclassificationline.lbr_cfop_id lbrcfop_cofctaxclassificationl R
cof_c_taxdetermination_line.lbr_cfop_id lbrcfop_cofctaxdeterminationli R
cof_configuracaoestoquefiscal.lbr_cfop_id lbrcfop_cofconfiguracaoestoque R
cof_preferenciaxml.lbr_cfop_id lbrcfop_cofpreferenciaxml R
cof_rv_confimpostos.lbr_cfop_id Implied Constraint R
cof_rv_detalhesestoqueprevisto.lbr_cfop_id Implied Constraint R
cof_rv_docfiscal.lbr_cfop_id Implied Constraint R
gl_distribution.lbr_cfop_id lbrcfop_gldistribution R
i_invoice.lbr_cfop_id lbrcfop_iinvoice R
i_order.lbr_cfop_id lbrcfop_iorder R
lbr_cfopline.cof_cfop_delivery_id lbrcfoptransp_lbrcfopline R
lbr_cfopline.cof_cfop_movement_id cofcfopmovement_lbrcfopline R
lbr_cfopline.lbr_cfop_id lbr_cfopline_fk1 R
lbr_docfiscal_line.lbr_cfop_id Implied Constraint R
lbr_taxdefinition.lbr_cfop_id Implied Constraint R
m_movementline.cof_cfop_movement_id cofcfopmovement_mmovementline R
m_movementline.lbr_cfop_id lbrcfop_mmovementline R
rv_c_invoiceline.lbr_cfop_id Implied Constraint R
ad_org_id numeric 10 null
ad_client_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 √ null
value varchar 5 null
description varchar 255 √ null
cof_movement varchar 2 √ NULL::character varying
cof_classification varchar 2 √ NULL::character varying
lbr_cfop_uu varchar 36 √ NULL::character varying
cof_natopresumida varchar 60 √ null
cof_cfopapplication varchar 255 √ NULL::character varying
cof_estoqueprevisto bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
lbr_cfop_key Primary key Asc lbr_cfop_id
lbr_cfop_uu_idx Must be unique Asc lbr_cfop_uu
lbr_cfop_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
lbr_cfop_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_cfop_cof_estoqueprevisto_check ((cof_estoqueprevisto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation