cof_mprecebida

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_mprecebida_id numeric 10 null
c_invoiceline.cof_mprecebida_id cofmprecebida_cinvoiceline R
lbr_docfiscal_line.cof_mprecebida_id cofmprecebida_lbrdocfiscalline R
m_inoutline.cof_mprecebida_id cofmprecebida_minoutline R
m_productionline.cof_mprecebida_id cofmprecebida_mproductionline R
m_rmaline.cof_mprecebida_id cofmprecebida_mrmaline R
cof_mprecebida_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
c_invoiceline_id numeric 10 NULL::numeric
c_invoiceline.c_invoiceline_id cinvoiceline_cofmprecebida R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_cofmprecebida R
cof_quantidaderecebida numeric 0 √ null
cof_valorunitario numeric 0 √ '0'::numeric
cof_frete numeric 0 √ '0'::numeric
insuredamount numeric 0 √ null
cof_otheramt numeric 0 √ '0'::numeric
cof_quantidadeproduzida numeric 0 √ null
cof_quantidaderetornada numeric 0 √ null
cof_saldoretornarnf numeric 0 √ null
cof_saldompproduzir numeric 0 √ null
cof_controleremessasind_id numeric 10 √ NULL::numeric
cof_controleremessasind.cof_controleremessasind_id cofcontroleremessasind_cofmpre R
cof_insuranceamt numeric 0 √ '0'::numeric
line numeric 10 √ null
m_attributesetinstance_id numeric 10 √ NULL::numeric
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_cofmprecebida R
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfop_cofmprecebida R
imposto_pis_cst varchar 2 √ NULL::character varying
imposto_cofins_cst varchar 2 √ NULL::character varying
imposto_icms_cst varchar 2 √ NULL::character varying
imposto_ipi_cst varchar 2 √ NULL::character varying
imposto_ipi_cenq_id numeric 10 √ NULL::numeric
cof_cenq.cof_cenq_id impostoipicenq_cofmprecebida R
cof_qtdmaterialnaoaplicado numeric 0 √ '0'::numeric
imposto_ibscbs_cct_id numeric 10 √ NULL::numeric
imposto_ibscbs_cst_id numeric 10 √ NULL::numeric
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_cofmprecebida R

Indexes

Constraint Name Type Sort Column(s)
cof_mprecebida_key Primary key Asc cof_mprecebida_id
cof_mprecebida_c_invoiceline_id_idx Performance Asc c_invoiceline_id
cof_mprecebida_uu_idx Must be unique Asc cof_mprecebida_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation