cof_controleremessasind

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_controleremessasind_id numeric 10 null
cof_mprecebida.cof_controleremessasind_id cofcontroleremessasind_cofmpre R
m_productionline.cof_controleremessasind_id cofcontroleremessasind_mproduc R
cof_controleremessasind_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_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 40 √ NULL::character varying
c_doctypetarget_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctypetarget_cofcontrolereme R
lbr_transactiontype varchar 3 √ NULL::character varying
m_pricelist_id numeric 10 √ NULL::numeric
m_pricelist.m_pricelist_id mpricelist_cofcontroleremessas R
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_cofcontroleremessa R
c_bpartner_id numeric 10 NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofcontroleremessasi R
c_invoice_id numeric 10 null
c_invoice.c_invoice_id cinvoice_cofcontroleremessasin R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_cofcontroleremessasind R
lbr_docfiscal_id numeric 10 √ NULL::numeric
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_cofcontroleremess C
cof_datacontafatura timestamp 29,6 √ null
cof_statusprocesso varchar 100 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cof_controleremessasind_key Primary key Asc cof_controleremessasind_id
cof_controleremessasind_uu_idx Must be unique Asc cof_controleremessasind_uu
cof_restricaoregistro Must be unique Asc/Asc/Asc/Asc ad_org_id + c_bpartner_id + c_invoice_id + cof_datacontafatura

Check Constraints

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

Relationships

Close relationships within degrees of separation