cof_fciline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_fciline_id numeric 10 null
cof_fci_prod.cof_fciline_id coffciline_coffciprod R
cof_fciline_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
name varchar 60 √ NULL::character varying
lbr_ncm_id numeric 10 √ NULL::numeric
lbr_ncm.lbr_ncm_id lbrncm_coffciline R
cof_fci_id numeric 10 √ NULL::numeric
cof_fci.cof_fci_id coffci_coffciline R
upc varchar 30 √ NULL::character varying
description varchar 255 √ null
cof_numerofci varchar 36 √ NULL::character varying
lbr_productsource bpchar 1 √ '0'::bpchar
cof_origemsugerida bpchar 1 √ '0'::bpchar
cof_vlsaidamercadoria numeric 0 √ null
cof_vlparcelaimportada numeric 0 √ null
cof_conteudoimportacao numeric 0 √ null
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_coffciline R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_coffciline R
cof_producttype varchar 2 √ NULL::character varying
ismanufactured bpchar 1 √ 'N'::bpchar
lbr_productcategory_id numeric 10 √ NULL::numeric
lbr_productcategory.lbr_productcategory_id lbrproductcategory_coffciline R
lbr_fiscalgroup_product_id numeric 10 √ NULL::numeric
lbr_fiscalgroup_product.lbr_fiscalgroup_product_id lbrfiscalgroupproduct_coffcili R
cof_processing bpchar 1 √ 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_fciline_key Primary key Asc cof_fciline_id
cof_fciline_uu_idx Must be unique Asc cof_fciline_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation