lbr_taxdefinition

9 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_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_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
description varchar 255 √ NULL::character varying
isactive bpchar 1 null
lbr_bpartnercategory_id numeric 10 √ NULL::numeric
lbr_bpartnercategory.lbr_bpartnercategory_id Implied Constraint R
lbr_fiscalgroup_bpartner_id numeric 10 √ NULL::numeric
lbr_fiscalgroup_bpartner.lbr_fiscalgroup_bpartner_id Implied Constraint R
lbr_fiscalgroup_product_id numeric 10 √ NULL::numeric
lbr_fiscalgroup_product.lbr_fiscalgroup_product_id Implied Constraint R
lbr_legalmessage_id numeric 10 √ null
lbr_legalmessage.lbr_legalmessage_id lbrlegalmessage_lbrtaxdefiniti R
lbr_ncm_id numeric 10 √ NULL::numeric
lbr_ncm.lbr_ncm_id Implied Constraint R
lbr_productcategory_id numeric 10 √ NULL::numeric
lbr_productcategory.lbr_productcategory_id Implied Constraint R
lbr_taxdefinition_id numeric 10 null
cof_rv_confimpostos.lbr_taxdefinition_id Implied Constraint R
lbr_tax_id numeric 10 √ NULL::numeric
lbr_tax.lbr_tax_id Implied Constraint R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id Implied Constraint R
to_region_id numeric 10 √ NULL::numeric
updated timestamp 29,6 null
updatedby numeric 10 null
lbr_issubtributaria bpchar 1 'B'::bpchar
lbr_transactiontype varchar 3 √ NULL::character varying
validfrom timestamp 29,6 null
priorityno numeric 10 √ NULL::numeric
issotrx bpchar 1 'B'::bpchar
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id Implied Constraint R
lbr_taxdefinition_uu varchar 36 √ NULL::character varying
cof_taxregimecode bpchar 1 √ NULL::bpchar
cof_taxregimecodebp bpchar 1 √ NULL::bpchar
cof_taxincentive varchar 3 √ NULL::character varying
lbr_productsource bpchar 1 √ NULL::bpchar
cof_indie bpchar 1 √ null
ismanual bpchar 1 √ 'N'::bpchar
value varchar 40 √ NULL::character varying
cof_taxdefinition_group_id numeric 10 √ NULL::numeric
cof_taxdefinition_group.cof_taxdefinition_group_id coftaxdefinitiongroup_lbrtaxde R
c_city_id numeric 10 √ NULL::numeric
c_city.c_city_id ccity_lbrtaxdefinition R
cof_cityto_id numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
lbr_taxdefinition_key Primary key Asc lbr_taxdefinition_id
lbr_taxdefinition_uu_idx Must be unique Asc lbr_taxdefinition_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation