| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BR_BRTAX | Withholding Income Tax | 12 | AYEAR | Payment of cumulated tax in year | decimal | 15 | 2 | | |
2 | PIQDB_DE_STATHDR | Header Table for Statistical Reporting Germany | 8 | AYEAR | Academic Year | nvarchar | 4 | 0 | | |
3 | T7RUADV | ADV-6-2 external sums | 3 | AYEAR | Year | nvarchar | 4 | 0 | | |
4 | T7RUADVN | ADV-6-2 external sums | 3 | AYEAR | Year | nvarchar | 4 | 0 | | |
5 | VIXCESM180REC | Modelo 180 - Witholding Tax Recipients DMEE Line 02 | 15 | AYEAR | Accrual Fiscal year | nvarchar | 4 | 0 | | |
6 | HRP1771 | DB Table for Infotype 1771 | 18 | AYEAR | Academic Year | nvarchar | 4 | 0 | | |
7 | HRP1772 | DB Table for Infotype 1772 | 53 | AYEAR | Academic Year | nvarchar | 4 | 0 | | |
8 | HRPAD503 | Additional Data for PAD503 | 3 | AYEAR | Academic Year | nvarchar | 4 | 0 | | |
9 | PIQDBAGR_APPR | Appraisal | 8 | AYEAR | Academic Year | nvarchar | 4 | 0 | | |
TOPConsolidation |
10 | TF635 | Goodwill/Neg.Goodwill | 14 | AYEAR | Year of incurrence of the amount to be amortized/depreciated | nvarchar | 4 | 0 | | |
11 | TF635A | Goodwill/Neg.Goodwill | 13 | AYEAR | Year of incurrence of the amount to be amortized/depreciated | nvarchar | 4 | 0 | | |
12 | TF646 | Recorded Fair Value Adjustments | 15 | AYEAR | Year of incurrence of the amount to be amortized/depreciated | nvarchar | 4 | 0 | | |
TOPTransaction Tax Engine |
13 | TTE_WT_ACCUMVALU | AP-TTE accumulated base amounts and withholding tax amounts | 7 | AYEAR | Year | nvarchar | 4 | 0 | | |