| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/VFI00004 | Withholding tax (extended) to percentage group from Shaam | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
2 | /OPT/VIM_CWHTAX | Classic Withholding tax data for document | 3 | WT_WITHCD | Withholding Tax Code | nvarchar | 2 | 0 | | |
3 | /OPT/VIM_WHTAX | Withholding tax data for document | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
4 | /SMD/MD_____00OX | SID-Tabelle fuer Withholding tax code | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
5 | FIWTIN_ACC_EXEM | Cumulative values for accounts payable/ account receivable | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
6 | FIWTIN_TAN_EXEM | Table for mapping TAN and Exemption Number | 8 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
7 | FIWTQAC_SCC | Service Category Classification | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
8 | J_1AWTH_TAX_TAXT | Conditions per Tax Type for Applying WithholdingTax | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
9 | J_1ICO_VENDDET | Columbia: Monthly data for freelancers/vendors | 7 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPBasic Functions |
10 | KNBW | Customer master record (withholding tax types) X | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
11 | LFBW | Vendor master record (withholding tax types) X | 8 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
12 | REGUPW | W/tax information per w/tax type/FI line item in pmnt run | 9 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
13 | T059FB | Formulae for calculating withholding tax (new functions) | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
14 | T059FBH | W/tax formulae: Header | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
15 | T059MINMAX | Minimum and maximum amounts for withholding tax | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
16 | T059Z | Withholding tax code (enhanced functions) | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
17 | T059ZT | Text table: Withholding tax codes | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
18 | T059ZZINS | Withholding tax code for interest calculation | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
19 | WITH_ITEM | Witholding tax info per W/tax type and FI line item | 7 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
20 | WITH_ITEM_EXCL | Withholding Tax Info per WTax Type (Exclusion) | 7 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
21 | WTAD | Cumulative values for accounts receivable | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
22 | WTADP | Cumulative values for accounts receivable (payment proposal) | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
23 | WTADPN | Cumulative values for accounts receivable (payment proposal) | 9 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
24 | WTAK | Cumulative values for accounts payable | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
25 | WTAKP | Cumulative values for accounts payable (payment proposal) | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
26 | WTAKPN | Cumulative values for accounts payable (payment proposal) | 9 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
27 | WTMIGMATCH | Withholding Tax Changeover: Creation of Code -> Type/Code | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
28 | WTMIG_PROT1 | Withholding Tax Changeover: Global Log Data | 8 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
29 | WTMIG_PROT2 | Withholding Tax Changeover: Detailed Log Data | 9 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPDown Payment Chains |
30 | /SAPPCE/TDPC23 | Down Payment Chain: Withholding Tax Information | 10 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
31 | VSPLTWT | FI Document Parking (Enjoy): W/Tax Data Amount Split | 7 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPFunds Management |
32 | FMRPWTCUST | Define Withholding Tax Codes | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPGL Account Posting |
33 | TCJ_WTAX_ITEMS | Withholding Tax Items for Cash Journal Document Items | 12 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPInvoice Verification |
34 | RBWS | Withholding Tax Data, Incoming Invoice | 6 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
35 | RBWT | Withholding Tax Data, Incoming Invoice | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
TOPLocalization |
36 | J_1IEWTECESS | Education Cess Codes | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
37 | J_1IEWTHKONT | Table for for TDS provisions Accounts / Loss Accounts | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
38 | J_1IEWTPROV | Table for TDS provisions | 22 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
39 | J_1IEWTSURC | Surcharge Tax Codes | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
40 | J_1IEWT_ECESS1 | Education Cess Rates | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
41 | J_1IEWT_MAPEXMPT | Table for Vendor type/exemption indicators in Annual Returns | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
42 | J_1IEWT_MIGRATE | Map Classic tax code to EWT Tax type - Tax codes | 5 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
43 | J_1IEWT_SURC1 | Surcharge Rates | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
44 | J_1ISERCATGTA | Service Category based on GTA Code (LEVEL 5) | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
45 | J_1ISERCATMM | Service category determination for GTA and imports Invoices | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
46 | J_1I_WTH_SER_GTA | Table to determine withholding line for GTA | 3 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |
47 | J_1I_WTH_SER_MM | Table to determine withholding line for GTA and Imports | 4 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | | |