Appendix II: Data types related to tax
This appendix helps companies switching to a VAT based tax system by identifying tables that are potentially impacted. This list is not exhaustive, and depends on the version of Sage X3, or potential verticals or customizations.
BP tax rule and Product tax codes
The following table (extracted from Sage X3 V12.0.14 using the data types TVB – BP tax rule and TVI – Tax level) lists tables where BP tax rules and Product tax codes are associated. This list excludes transactions, and the objective is to build an initial check list for those in charge of the implementation. Please make sure that this list is exhaustive in your context, which could mean a different version or a customized environment.
|
Module |
Table code |
Table title |
Field code |
Long text |
Data type |
|---|---|---|---|---|---|
|
Common data |
BPCCATEG |
Customer category |
VACBPR |
Tax rule |
TVB |
|
BPCUSTOMER |
Customers |
VACBPR |
Tax rule |
TVB |
|
|
BPDLVCUST |
Ship-to customer |
VACBPR |
Tax rule |
TVB |
|
|
BPEXCEPT |
BP-Company exception |
VACBPC |
Customer tax rule |
TVB |
|
|
VACBPR |
BP tax rule |
TVB |
|||
|
VACBPS |
Supplier tax rule |
TVB |
|||
|
BPSCATEG |
Supplier category |
VACBPR |
Tax rule |
TVB |
|
|
BPSUPPLIER |
Suppliers |
VACBPR |
Tax rule |
TVB |
|
|
CONTSERV |
Service contract |
CONVACBPR |
Tax rule |
TVB |
|
|
CONTSERVX |
Service contract |
CONVACBPR |
Tax rule |
TVB |
|
|
ITMCATEG |
Product category |
VACITM |
Tax level |
TVI |
|
|
ITMMASTER |
Products |
VACITM |
Tax level |
TVI |
|
|
PFOOTINV |
Purchasing invoicing elements |
VACITM |
Tax element level (fixed rate) |
TVI |
|
|
PJMSOLITMH |
Sold product management |
VACBPR |
Tax rule |
TVB |
|
|
SFOOTINV |
Invoicing elements |
CLCVACITM |
Tax level |
TVI |
|
|
VACITM |
Tax element level (fixed rate) |
TVI |
|||
|
TABVAC |
Tax determination table |
VACBPR |
BP tax rule |
TVB |
|
|
VACITM |
Product tax levels |
TVI |
|||
|
TABVACBPR |
BP tax rule table |
VACBPR |
BP tax rule |
TVB |
|
|
TABVACITM |
Tax level table |
VACITM |
Tax level |
TVI |
|
|
TABVAT |
Tax code table |
VATVAC |
Tax rule |
TVB |
Tax code
The following table (extracted from Sage X3 V12.0.14 using the data type VAT – Tax code) lists tables where tax codes are associated. This list excludes transactions, and the objective is to build an initial check list for users in charge of the implementation. Please make sure that this list is exhaustive in your context, which could mean a different version or a customized environment..
|
Module |
Table code |
Table title |
Field code |
Long text |
Data type |
|---|---|---|---|---|---|
|
Common data |
GACCOUNT |
Accounts |
VAT |
Tax |
VAT |
|
GACCOUNTA |
Accounts (additional table) |
VATCTL |
Tax codes |
VAT |
|
|
TABRATVAT |
Tax rates |
VAT |
Tax |
VAT |
|
|
TABVAC |
Tax determination table |
VAT |
Tax |
VAT |
|
|
TABVACBPR |
BP tax rule table |
VAT |
Tax code |
VAT |
|
|
TABVAT |
Tax code table |
AUSVAT |
Associated tax code |
VAT |
|
|
Tax code table |
SPAVAT |
Associated tax code |
VAT |
||
|
Tax code table |
VAT |
Tax |
VAT |
||
|
TABVATEXE |
Tax exemption table |
VAT |
Tax |
VAT |
|
|
VATCLS |
Tax classification |
VAT |
Tax |
VAT |
|
|
Financials |
DATEVTAX |
DATEV tax code assignment |
TAX |
Tax code |
VAT |
|
VATBOXD |
VAT boxes |
VAT |
Tax code |
VAT |
|
|
VDGERRSP |
Recapitulative statem. param. |
VAT |
Rate 1 activation date |
VAT |
|
|
VDGERTRP |
German tax return parameter |
VAT |
Tax |
VAT |
|
|
VDSWITRP |
Switzerland |
VAT |
Tax |
VAT |
|
|
A/P-A/R accounting |
TABEXPENS |
Expenses tables |
VAT |
Tax |
VAT |
Other components
|
Module |
Component |
|
|
Activity codes |
|
General parameters |
|
|
Sales |
Pricing |
|
Purchasing |
Pricing |
|
Financials |
Accounting code lines |
|
Accounting codes |
|
|
Automatic journals |
|
|
A/P-A/R accounting |
Payment attributes |