| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKOP_DP | Down Payments: Tax Data for Business Partner Item | 15 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
2 | FKKSK_VATLED | FI-CA Slovakia: VAT Ledger Exported Data | 24 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
3 | TSTL | Taxes: Valid Tax Categories for Each Country | 5 | STPRZ | Tax percentage rate from Table T007 | nvarchar | 1 | 0 | | |
TOPCollectionsDisbursements |
4 | VVKKFOP | Single Doc in Posting Data Interface | 44 | STPRZ | Insurance tax percentage | decimal | 5 | 2 | | |
5 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 38 | STPRZ | Insurance tax percentage in CHAR format | nvarchar | 11 | 0 | | |
6 | VVKKTAXREP | Tax Reporting ITA: Data for Tax Report | 17 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
7 | VVSCITEMWH | Payment Plan Subitem: Variable Withholding Tax Supplements | 8 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
8 | VVSCPOS | Payment Plan Item | 155 | STPRZ | Tax Percentage | nvarchar | 6 | 0 | | |
9 | VVSCPOSETAX | Payment Plan Items Supplement: Ext. Calculated Tax Data | 9 | STPRZ | Tax Percentage | nvarchar | 6 | 0 | | |
10 | VVSCPOSWH | Payment Plan Item: Variable Withholding Tax Supplements | 7 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
11 | DFKK1099 | 1099 Statutory Reporting Data | 15 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
12 | DFKKMOPK | Items in contract account document | 38 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
13 | DFKKOPK | Items in contract account document | 38 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
14 | DFKKOPK_SHORT | Offsetting Items for FI-CA Document - Extracts | 11 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
15 | DFKKOPWH | Withholding Tax Data for Business Partner Item | 7 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
16 | DFKKORDERPOS | Requests: Items | 57 | STPRZ | Tax rate | decimal | 6 | 0 | | |
17 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 13 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
18 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 13 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
19 | DFKKREP07 | Tax Report Data (Clearing Time) | 13 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
20 | DFKKSUM | Posting totals from FI-CA | 30 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
TOPIntercompany Data Exchange |
21 | TINV_INV_LINE_A | Payment Advice Line | 10 | STPRZ | Tax rate | decimal | 6 | 0 | | |
22 | TINV_INV_TRANSF | Transfer Table for Bill Data to FI-CA | 17 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
23 | TINV_TRNSF_SHORT | Extract of Bill Receipt (Eval. System): FI-CA Transfer Data | 17 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
TOPInvoicing |
24 | DBERDL | Print Document Line Items | 26 | STPRZ | Tax rate in output format | nvarchar | 8 | 0 | | |
25 | DBERDZ | DB Table: Individ. Lines - Print Document | 7 | STPRZ | Tax rate in output format | nvarchar | 8 | 0 | | |
26 | ERDTS | Additional Charges and Taxes of a Print Document | 21 | STPRZ | Tax rate | nvarchar | 6 | 0 | | |
27 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 7 | STPRZ | Tax rate in output format | nvarchar | 8 | 0 | | |