| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2HK_RETI | Payroll structure for retroactive accounting | 6 | PAPER | Payroll period | nvarchar | 6 | 0 | | |
2 | P2HK_RETO | Payroll structure for retroactive accounting | 6 | PAPER | Payroll period | nvarchar | 6 | 0 | | |
3 | P2IS_RETI | Payroll structure for retroactive accounting | 6 | PAPER | Payroll period | nvarchar | 6 | 0 | | |
4 | P2IS_RETO | Payroll structure for retroactive accounting | 6 | PAPER | Payroll period | nvarchar | 6 | 0 | | |
5 | P2RN_NB | Payroll results: Adjustments and Arrears Payments (NL) | 6 | PAPER | For-period for garnishment | nvarchar | 6 | 0 | | |
6 | PYC_D_PY_MSG | PYC: payroll message | 12 | PAPER | Character field of length 6 | nvarchar | 6 | 0 | | |
7 | T5JCR | 36 Agreement: Check Rule of Overtime Work | 7 | PAPER | Percentage of Worked Days | decimal | 5 | 2 | | |
TOPCanada |
8 | T5KYH | Year end reporting History table | 14 | PAPER | Single-Character Indicator | nvarchar | 1 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
9 | T8JO | Partner | 6 | PAPER | Indicator: Hardcopy billings | nvarchar | 1 | 0 | | |
TOPPayroll |
10 | T5H84 | Payroll log | 4 | PAPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPPrint and Output Management |
11 | TSP06A | Spool: Implemented format type of a device type | 2 | PAPER | Spool: Format | nvarchar | 16 | 0 | | |
12 | TSP0L | Spool events | 23 | PAPER | Spool: Format type | nvarchar | 16 | 0 | | |