lbr_di

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id Implied Constraint R
c_region_id numeric 10 √ NULL::numeric
c_region.c_region_id Implied Constraint R
created timestamp 29,6 null
createdby numeric 10 null
datedoc timestamp 29,6 √ null
datetrx timestamp 29,6 √ null
description varchar 512 √ NULL::character varying
documentno varchar 40 √ NULL::character varying
isactive bpchar 1 null
lbr_di_id numeric 10 null
processed bpchar 1 'N'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
lbr_siscomexamt numeric 0 √ null
lbr_di_uu varchar 36 √ NULL::character varying
cof_importer_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofimporterbpartner_lbrdi R
cof_purchaser_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofpurchaserbpartner_lbrdi R
cof_legalrepresent_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id coflegalrepresentbpartner_lbrd R
cof_manifesttype bpchar 1 √ NULL::bpchar
cof_manifestno varchar 15 √ NULL::character varying
cof_customsfacilities varchar 60 √ NULL::character varying
cof_package varchar 60 √ NULL::character varying
cof_grossweight numeric 0 √ (0)::numeric
cof_netweight numeric 0 √ (0)::numeric
qtyentered numeric 0 √ (0)::numeric
c_currency_id numeric 10 (100)::numeric
c_currency.c_currency_id ccurrency_lbrdi R
cof_freightamt numeric 0 √ (0)::numeric
cof_insuranceamt numeric 0 √ (0)::numeric
cof_vmle numeric 0 √ (0)::numeric
cof_vmld numeric 0 √ (0)::numeric
imposto_ii_vii numeric 0 √ (0)::numeric
imposto_ipi_vipi numeric 0 √ (0)::numeric
imposto_pis_vpis numeric 0 √ (0)::numeric
imposto_cofins_vcofins numeric 0 √ (0)::numeric
cof_antidumpingduty numeric 0 √ (0)::numeric
det_prod_di_tpviatrans varchar 2 '1'::character varying
det_prod_di_vafrmm numeric 0 √ null
det_prod_di_tpintermedio bpchar 1 √ NULL::bpchar
imposto_ii_viof numeric 0 √ null
cof_exchangerate numeric 0 √ null
cof_customsexpenses numeric 0 √ null
cof_manifest varchar 512 √ NULL::character varying
cof_discountamt numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
lbr_di_key Primary key Asc lbr_di_id
lbr_di_uu_idx Must be unique Asc lbr_di_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation