| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TIVXCITIREFT | Mapping of IRE Status to Contract-Flow type-Taxcode | 3 | TYEAR | IRE Status of Contract | nvarchar | 1 | 0 | | |
TOPCanada |
2 | T5KYH | Year end reporting History table | 7 | TYEAR | Payroll Year | nvarchar | 4 | 0 | | |
TOPConsolidation |
3 | TF189 | Assignment of CG/CU, Version- and Period-Dependent | 8 | TYEAR | Effective until (fiscal) year | nvarchar | 4 | 0 | | |
4 | TF189A | Inactive Consolidation Units per Consolidation Group | 8 | TYEAR | Effective until (fiscal) year | nvarchar | 4 | 0 | | |
TOPFinland |
5 | T7FILIS | Table for Low Income Support Statement | 3 | TYEAR | Tax year for Annual Tax Statement Finland | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
6 | TIVXCITIRECALCPA | IRE Calculation parameters | 3 | TYEAR | IRE Status of Contract | nvarchar | 1 | 0 | | |
7 | VIXCITIREDATA | IRE master data | 18 | TYEAR | IRE Status of Contract | nvarchar | 1 | 0 | | |
TOPPayroll |
8 | T5H2M | Adóvégelsz. - APEH-nek elküldött dolg. rekordokról info. | 2 | TYEAR | Adatszolgáltatás éve | nvarchar | 4 | 0 | | |
9 | T5H2N | Regisztráció az APEH-nek beküldött nyomtatványokról | 2 | TYEAR | Adatszolgáltatás éve | nvarchar | 4 | 0 | | |
10 | T5T4045 | Výsledky RZD pro prevzetí do výpoctu - MD /404 a /405 | 3 | TYEAR | Danový rok | nvarchar | 4 | 0 | | |
11 | T5TA3 | Results of annual tax calculation for RPCALC | 3 | TYEAR | Tax Year | nvarchar | 4 | 0 | | |
12 | T7SIA0 | Annual tax - Paydays x Days of payments | 2 | TYEAR | Tax year for annual tax statement | nvarchar | 4 | 0 | | |
13 | T7SIA1 | Annual tax - Master data | 2 | TYEAR | Tax year for annual tax statement | nvarchar | 4 | 0 | | |
14 | T7SIA4 | DPZ temporary data | 2 | TYEAR | Tax year for annual tax statement | nvarchar | 4 | 0 | | |
15 | T7SIA8 | Data for VIRVDC | 2 | TYEAR | Tax year for annual tax statement | nvarchar | 4 | 0 | | |
16 | T7SKA3 | Results of annual tax calculation for RPCALC | 3 | TYEAR | Tax Year | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
17 | T7SIA2 | Annual tax - Earnings | 2 | TYEAR | Tax year for annual tax statement | nvarchar | 4 | 0 | | |
TOPPersonnel Management |
18 | T7HRA2 | IP Form - Master data | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
19 | T7HRA2N | IP Form - Master data - New (w. OIB) | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
20 | T7HRA2O | IP Form - Master data - with IDENT in key | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
21 | T7HRA3 | IP Form - Earnings | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
22 | T7HRA3N | IP Form - Earnings - New (w. OIB) | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
23 | T7HRA3O | IP Form - Earnings - with IDENT in key | 2 | TYEAR | Tax year for IP form | nvarchar | 4 | 0 | | |
TOPProduct Safety |
24 | CCRCT_CALC | EHS: Calculated Average | 8 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
25 | CCRCT_CO | EHS: Confirmed Consumed Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
26 | CCRCT_COPL | EHS: Planned Consumed Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
27 | CCRCT_CU | EHS: Customer List - Header Data | 5 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
28 | CCRCT_PR | EHS: Confirmed Produced Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
29 | CCRCT_PRPL | EHS: Planned Produced Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
30 | CCRCT_PU | EHS: Confirmed Purchased Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
31 | CCRCT_PUPL | EHS: Planned Purchased Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
32 | CCRCT_SO | EHS: Confirmed Sold Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
33 | CCRCT_SOPL | EHS: Planned Sold Quantities | 3 | TYEAR | Monitoring Year | nvarchar | 4 | 0 | | |
TOPTax Reporter |
34 | T5UX1 | Tax Reporter Employee Index | 2 | TYEAR | Tax year | nvarchar | 4 | 0 | | |
35 | T5UX6 | W-2/W-2C Puerto Rico Control Number | 2 | TYEAR | Tax year | nvarchar | 4 | 0 | | |
TOPUnited Kingdom |
36 | T5G35P | HR-GB: Checklist fields for P35 | 4 | TYEAR | Payroll Year | nvarchar | 4 | 0 | | |
37 | T5G57 | HR-GB: Supplementary fields for P35 | 5 | TYEAR | Payroll Year | nvarchar | 4 | 0 | | |