c_tax

66 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_tax_id numeric 10 null
c_invoicebatchline.c_tax_id ctax_cinvoicebatchline R
c_invoiceline.c_tax_id ctax_cinvoiceline R
c_invoicetax.c_tax_id ctax_cinvoicetax R
c_orderline.c_tax_id ctax_corderline R
c_ordertax.c_tax_id ctax_cordertax R
c_tax.parent_tax_id ctax_parent R
c_tax_trl.c_tax_id ctax_ctaxtrl C
c_taxdeclarationline.c_tax_id ctax_ctaxdeclline R
c_taxdefinition.c_tax_id ctax_ctaxdefinition R
c_taxpostal.c_tax_id ctax_ctaxpostal R
fact_acct.c_tax_id ctax_factacct R
i_invoice.c_tax_id ctax_iinvoice N
i_order.c_tax_id ctax_iorder N
m_movementline.cof_tax_id coftax_mmovementline R
m_rmaline.c_tax_id ctax_mrmaline R
m_rmatax.c_tax_id ctax_mrmatax R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
name varchar 60 null
updatedby numeric 10 null
description varchar 255 √ null
taxindicator varchar 10 √ null
isdocumentlevel bpchar 1 'Y'::bpchar
validfrom timestamp 29,6 null
issummary bpchar 1 'N'::bpchar
requirestaxcertificate bpchar 1 'N'::bpchar
rate numeric 0 null
parent_tax_id numeric 10 √ null
c_tax.c_tax_id ctax_parent R
c_country_id numeric 10 √ null
c_country.c_country_id c_country_c_tax R
c_region_id numeric 10 √ null
c_region.c_region_id c_region_c_tax R
to_country_id numeric 10 √ null
c_country.c_country_id c_countryto_c_tax R
to_region_id numeric 10 √ null
c_region.c_region_id c_regionto_c_tax R
c_taxcategory_id numeric 10 null
c_taxcategory.c_taxcategory_id ctaxcategory_ctax C
isdefault bpchar 1 'N'::bpchar
istaxexempt bpchar 1 'N'::bpchar
sopotype bpchar 1 'B'::bpchar
issalestax bpchar 1 'N'::bpchar
ad_rule_id numeric 10 √ null
ad_rule.ad_rule_id adrule_ctax R
c_tax_uu varchar 36 √ NULL::character varying
c_taxprovider_id numeric 10 √ NULL::numeric
c_taxprovider.c_taxprovider_id ctaxprovider_ctax R
lbr_taxname_id numeric 10 √ null
lbr_taxname.lbr_taxname_id lbrtaxname_ctax R
c_countrygroupfrom_id numeric 10 √ NULL::numeric
c_countrygroup.c_countrygroup_id ccountrygroupfrom_ctax R
c_countrygroupto_id numeric 10 √ NULL::numeric
c_countrygroup.c_countrygroup_id ccountrygroupto_ctax R
cof_posttax bpchar 1 √ 'Y'::bpchar
taxpostingindicator bpchar 1 √ '0'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_tax_pkey Primary key Asc c_tax_id
c_tax_name Must be unique Asc/Asc ad_client_id + name
c_tax_uu_idx Must be unique Asc c_tax_uu

Check Constraints

Constraint Name Constraint
c_tax_isdocumentlevel_check ((isdocumentlevel = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_tax_cof_posttax_check ((cof_posttax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_tax_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_tax_requirestaxcertificate_check ((requirestaxcertificate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation