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_orderline.c_tax_id ctax_corderline R
c_ordertax.c_tax_id ctax_cordertax R
c_tax.parent_tax_id ctax_parent 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 Country
c_region_id numeric 10  √  null Identifies a geographical Region
to_country_id numeric 10  √  null Receiving Country
to_region_id numeric 10  √  null 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 Rule
c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_countrygroupfrom_id numeric 10  √  NULL::numeric Country Group From
c_countrygroupto_id numeric 10  √  NULL::numeric Country Group To

Table contained 6 rows at 2021-12-25 14:52 +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

Close relationships  within of separation: