lbr_cfopline

173 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_cfopline_id numeric 10 null
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
lbr_cfop_id numeric 10 null
lbr_cfop.lbr_cfop_id lbr_cfopline_fk1 R
lbr_destionationtype varchar 1 null
lbr_productcategory_id numeric 10 √ null
lbr_productcategory.lbr_productcategory_id Implied Constraint R
c_doctype_id numeric 10 null
c_doctype.c_doctype_id Implied Constraint R
lbr_issubtributaria bpchar 1 'N'::bpchar
lbr_transactiontype bpchar 3 √ null
ismanufactured bpchar 1 √ 'N'::bpchar
lbr_bpartnercategory_id numeric 10 √ null
lbr_bpartnercategory.lbr_bpartnercategory_id Implied Constraint R
lbr_tax_id numeric 0 √ null
lbr_legalmessage_id numeric 10 √ null
lbr_legalmessage.lbr_legalmessage_id lbrlegalmessage_lbrcfopline R
cof_tax_id numeric 10 √ NULL::numeric
lbr_cfopline_uu varchar 36 √ NULL::character varying
cof_validatetax bpchar 1 √ 'N'::bpchar
cof_taxforcost varchar 2000 √ NULL::character varying
cof_cfop_delivery_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfoptransp_lbrcfopline R
cof_legalmessagedelivery_id numeric 10 √ NULL::numeric
lbr_legalmessage.lbr_legalmessage_id coflegalmessagedelivery_lbrcfo R
cof_cfop_movement_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id cofcfopmovement_lbrcfopline R
cof_indie bpchar 1 √ NULL::bpchar

Indexes

Constraint Name Type Sort Column(s)
lbr_cfopline_key Primary key Asc lbr_cfopline_id
lbr_cfopline_uu_idx Must be unique Asc lbr_cfopline_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation