Table idempiere9.adempiere.c_tax
Tax identifier

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_tax_id numeric 10
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_acct.c_tax_id ctax_ctaxacct C
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_rmaline.c_tax_id ctax_mrmaline R
m_rmatax.c_tax_id ctax_mrmatax R
Tax identifier
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
name varchar 60 Alphanumeric identifier of the entity
updatedby numeric 10 User who updated this records
description varchar 255  √  null Optional short description of the record
taxindicator varchar 10  √  null Short form for Tax to be printed on documents
isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
validfrom timestamp 29,6 Valid from including this date (first day)
issummary bpchar 1 'N'::bpchar This is a summary entity
requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
rate numeric 0 Rate or Tax or Exchange
parent_tax_id numeric 10  √  null
c_tax.c_tax_id ctax_parent R
Parent Tax indicates a tax that is made up of multiple taxes
c_country_id numeric 10  √  null
c_country.c_country_id c_country_c_tax R
Country
c_region_id numeric 10  √  null
c_region.c_region_id c_region_c_tax R
Identifies a geographical Region
to_country_id numeric 10  √  null
c_country.c_country_id c_countryto_c_tax R
Receiving Country
to_region_id numeric 10  √  null
c_region.c_region_id c_regionto_c_tax R
Receiving Region
c_taxcategory_id numeric 10
c_taxcategory.c_taxcategory_id ctaxcategory_ctax C
Tax Category
isdefault bpchar 1 'N'::bpchar Default value
istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
ad_rule_id numeric 10  √  null
ad_rule.ad_rule_id adrule_ctax R
Rule
c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_taxprovider_id numeric 10  √  NULL::numeric
c_taxprovider.c_taxprovider_id ctaxprovider_ctax R
Tax Provider
c_countrygroupfrom_id numeric 10  √  NULL::numeric
c_countrygroup.c_countrygroup_id ccountrygroupfrom_ctax R
Country Group From
c_countrygroupto_id numeric 10  √  NULL::numeric
c_countrygroup.c_countrygroup_id ccountrygroupto_ctax R
Country Group To

Table contained 6 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.