c_taxdefinition

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
name varchar 60 null
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id cbpgroup_ctaxdefinition R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_ctaxdefinition R
c_taxbase_id numeric 10 √ null
c_taxbase.c_taxbase_id ctaxbase_ctaxdefinition R
c_taxcategory_id numeric 10 √ null
c_taxcategory.c_taxcategory_id ctaxcategory_ctaxdefinition R
c_taxdefinition_id numeric 10 null
c_taxgroup_id numeric 10 √ null
c_taxgroup.c_taxgroup_id ctaxgroup_ctaxdefinition R
c_taxtype_id numeric 10 √ null
c_taxtype.c_taxtype_id ctaxtype_ctaxdefinition R
c_tax_id numeric 10 √ null
c_tax.c_tax_id ctax_ctaxdefinition R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ null
help varchar 2000 √ null
isactive bpchar 1 null
isinvoiced bpchar 1 √ null
m_product_category_id numeric 10 √ null
m_product_category.m_product_category_id mproductcategory_ctaxdefinitio R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_ctaxdefinition R
maxtaxable numeric 10 √ null
mintaxable numeric 10 √ null
seqno numeric 10 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
ad_client_id numeric 10 null
value varchar 40 null
ad_orgtype_id numeric 10 √ null
ad_orgtype.ad_orgtype_id adorgtype_ctaxdefinition R
ad_org_id numeric 10 null
c_taxdefinition_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_taxdefinition_key Primary key Asc c_taxdefinition_id
c_taxdefinition_uu_idx Must be unique Asc c_taxdefinition_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation