| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 39 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 40 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
3 | /OPT/CT_IDH_HEAD | Inbound Document Handler: Registration table with header inf | 43 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
4 | /OPT/VIM_CA_TAX | Tax Code Determination Configuration for Canada | 11 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
5 | /OPT/X110 | Tax Code Determination Configuration | 7 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
6 | /OPT/Y110 | Tax Code Determination Configuration | 7 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
7 | /OPT/Z110 | Tax Code Determination Configuration | 7 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
8 | /ORS/INV_ADD | Invoice Add | 7 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
9 | ARBERP_C_TAXCODE | Incoming Invoice: Map Tax Codes for Logistics Invoice Verif. | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
10 | ARBERP_C_TAXCTGY | Map ERP tax code to cXML tax category | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
11 | ARBERP_C_TAXC_SD | Map ERP tax code to cXML tax category for SD outbound msg | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
12 | BBPC_PRES_UNPL | Templates for Items in the Confirmation | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
13 | BBP_DET_TAX_CODE | Tax Code Determination | 6 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
14 | BBP_PCACC | Procurement Card: Accounting Data | 10 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
15 | BBP_PCIAC | Accounting Data for Procurement Card Company | 7 | TAX_CODE | Input Tax Code for Non-Taxable Transactions | nvarchar | 2 | 0 | | |
16 | BBP_PCLOG | Procurement Card Statement: Logistic data | 19 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
17 | BBP_PCMOD | Procurement Card: Modified Statement Data | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
18 | BBP_PCTAX | Procurement Card: Tax Data | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
19 | BBP_PDFRT | Shipment Costs | 5 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
20 | BBP_PDIGP | Business Transaction Item-Purchasing Information | 29 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
21 | BBP_PDTAX | Tax | 5 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
22 | BBP_TAX | Tax Codes for Enterprise Buyer | 2 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
23 | BBP_TAXCODE_FAV | User-Specific Favorites for Tax Types per Country | 3 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
24 | BBP_TAXT | Enterprise Buyer: Tax Code Description | 3 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
25 | DCFLC_TAXCODE_TV | Tax Code | 8 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
26 | DCFLC_TXCD_TJ_TV | Tax Code | 8 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
27 | IDPL_II_TAX | Polish internal invoice - Tax exemptions | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
28 | IDPL_II_TAX_EXEM | Polish internal invoice - Tax exemptions | 2 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
29 | REQLINEMA | Temporary Line Data: Requirement Coverage Request(MRO Lines) | 97 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |
30 | REQLINESR | Temporary Line Data: Requirement Coverage Request (Services) | 46 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
31 | T5ITF24BG | Module group table | 8 | TAX_CODE | F24: Compensated tax payer's reference number | nvarchar | 4 | 0 | | |
32 | TCM_C_TCTXC_MAP | Map transportation charge type to Tax code | 5 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPBasis Components |
33 | /XFT/INV_Q_1 | Invoice receipt queue: Items | 11 | TAX_CODE | Sales Tax Code | nvarchar | 2 | 0 | | |
34 | /XFT/INV_Q_11 | Account assignment data | 7 | TAX_CODE | Sales Tax Code | nvarchar | 2 | 0 | | |
35 | /XFT/INV_Q_11_S | Account assignment data | 7 | TAX_CODE | Sales Tax Code | nvarchar | 2 | 0 | | |
36 | /XFT/INV_Q_1_S | Invoice receipt queue: Items | 11 | TAX_CODE | Sales Tax Code | nvarchar | 2 | 0 | | |
37 | /XFT/INV_Q_7 | Tax data | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
38 | /XFT/INV_Q_7_S | Tax data | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPClaims Management |
39 | TICL553 | Relationship of Payment Type to Main/Sub-Transaction | 4 | TAX_CODE | Government Type Code / Tax Authorities Payment Type | nvarchar | 2 | 0 | | |
40 | TICL557 | Combination of Tax Role and Participant | 6 | TAX_CODE | Government Type Code / Tax Authorities Payment Type | nvarchar | 2 | 0 | | |
TOPDown Payment Chains |
41 | /SAPPCE/TDPC20 | Down Payment Chain: Document Header | 14 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
42 | /SAPPCE/TDPC21 | Down Payment Chain: Document Segments | 10 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
43 | /OPT/VIM_1HEAD | Document Header | 98 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
44 | /OPT/VIM_TAX_CFG | Tax Code Determination Configuration | 7 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
TOPGL Account Posting |
45 | TCJ_POSITIONS | Cash Journal Document Items | 17 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
46 | TCJ_TRANSACTIONS | Cash Journal Business Transactions | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPIncentive and Commission Management ICM |
47 | CACS00_DOCFI_P | Data Transfer: FI Documents (Items) | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
48 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 17 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
49 | CACSCD_DOCCD_TX | Settlement to FS-CD: Reference Document Tax | 5 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
50 | CACSFI_DOCFI_CO | Settlement to FI: Reference Document Costs | 8 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
51 | CACSFI_DOCFI_PD | Settlement to FI: Reference Line Item | 11 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
52 | CACSFI_DOCFI_TX | Settlement to FI: Reference Document Tax | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
53 | CACSHR_DOCHR_TX | Settlement to PY: Reference Document Tax | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
54 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 5 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
55 | YCRM01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 5 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
56 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 4 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
57 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 14 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
58 | YHITEC_DOCFI_P | Data Transfer: FI Documents Item | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
59 | YSVMA_ACCAS | Account Assignment Type/Cost Information for Remuneration | 7 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
60 | YSVMA_ACCST | Account Assignment Type/Cost Info for Settlement Types | 11 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
61 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
62 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 13 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
63 | YTEL01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
64 | YTEL01_DOCFI_P | Data Transfer: FI Documents Item | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
65 | YTEL05_ACCAS | Account Assignment Type/Cost Information for Remuneration | 11 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
66 | YTEL05_ACCST | Account Assignment Type/Cost Info for Settlement Types | 11 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
67 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
68 | ZICMAG_DOCFI_P | Data Transfer: FI Documents (Items) | 12 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
69 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 19 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPSAP Retail Store |
70 | WOSCR_EXI_003 | Tax Code Lines for Expense Invoice | 3 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
71 | WOSCR_EXI_003T | Text Table - Tax Code Lines for Expense Invoice | 4 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPTariffs, Duties and Permits |
72 | OIH_J1B_PCK | Brazil: Check table for tax codes in Purchasing | 13 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
73 | OIH_J1B_SAL | Brazil: Check table for tax codes in sales process | 15 | TAX_CODE | SD tax code | nvarchar | 2 | 0 | | |
74 | OIH_J1B_SAL_2 | Brazil: ICMS Deferment | 14 | TAX_CODE | SD tax code | nvarchar | 2 | 0 | | |
75 | OIH_J1B_SDTXCD | SD tax code for ICMS ST calculation | 2 | TAX_CODE | SD tax code | nvarchar | 2 | 0 | | |
76 | OIH_J1B_TIN | Brazil: Check table for tax codes in Transfer Incoming | 9 | TAX_CODE | Tax code for Brazil localization | nvarchar | 1 | 0 | | |
77 | OIH_J1B_TOU | Brazil: Check table for tax codes in Transfer Outgoing | 13 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
78 | TRXT_FLOW | TRM Tax Transaction Flows | 6 | TAX_CODE | Tax Code | nvarchar | 2 | 0 | | |
TOPTravel Expenses |
79 | PTRV_SREC | Trip Statistics - Receipts | 15 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPVehicle Management System |
80 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 27 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | |
TOPWarranty Claim Processing |
81 | PVWTY | Warranty Claim Item (PPE Variant) | 28 | TAX_CODE | Tax on Sales/Purchases Code | nvarchar | 2 | 0 | | |