| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5C1J | Pension Rates (CH) | 4 | BJAHR | Contribution years | nvarchar | 2 | 0 | | |
TOPBalance Sheet Valuation Procedures |
2 | TMY02 | Balance Sheet Valuation Method (LIFO/FIFO) | 6 | BJAHR | Base year for LIFO/FIFO valuation | nvarchar | 4 | 0 | | |
TOPCompany Pension Scheme Germany |
3 | P01CBE | Active CPS Contributions | 19 | BJAHR | Valuation Year for Determination of Benefit | nvarchar | 4 | 0 | | |
4 | P01VA_BE | Actual Contributions CPS for Pension Equalization Payment | 20 | BJAHR | Valuation Year for Determination of Benefit | nvarchar | 4 | 0 | | |
5 | P01VA_CBE | Reduction Amounts for Actual Contributions CPS | 20 | BJAHR | Valuation Year for Determination of Benefit | nvarchar | 4 | 0 | | |
TOPGermany |
6 | T5D2M | Month of Issue: Employment Tax Statement (Tax Germany) | 3 | BJAHR | Statement Year | nvarchar | 4 | 0 | | |
TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
7 | TFACD | Factory calendar definition | 3 | BJAHR | Year until which data is saved | nvarchar | 4 | 0 | | |
8 | THOCI | Public holiday calendar index | 3 | BJAHR | Year until which data is saved | nvarchar | 4 | 0 | | |
TOPReturnable Packaging Logistics |
9 | RLACPOHD | Account Posting Header | 3 | BJAHR | Posting year | nvarchar | 4 | 0 | | |
10 | RLACPOIT | Account Posting Record | 3 | BJAHR | Posting year | nvarchar | 4 | 0 | | |
11 | RLREPROC | Reprocessing Record for Returnable Packaging Acct Postings | 6 | BJAHR | Posting year | nvarchar | 4 | 0 | | |
TOPTax |
12 | P01T_LST | ETStmt: General Employment Tax Data | 8 | BJAHR | Employment Tax Statement: Statement Year | nvarchar | 4 | 0 | | |