| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2NZ_LVACC | Payroll Result: Leave Accruals LVACC - NZ | 7 | RECYR | Record Sequence Year Number | nvarchar | 6 | 0 | | |
2 | P2NZ_LVTAK | Payroll Result: Leave Taken LVTAK - NZ | 6 | RECYR | Record Sequence Year Number | nvarchar | 6 | 0 | | |
TOPNew Zealand |
3 | PA0312 | Leave History Adjustments NZ | 25 | RECYR | Record Sequence Year Number | nvarchar | 6 | 0 | | |
TOPUse Subcomponents |
4 | SOCS | SAPoffice: table for storage of an Office ID (SAPcomm) | 18 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
5 | SOCX | SAPoffice: table for storing SAPcomm IDs | 17 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
6 | SOES | SAPoffice: External send operation | 3 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
7 | SOOS | SAPoffice: send process | 9 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
8 | SOSC | SAPoffice: Connection table to SAPcomm and SAPconnect | 10 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
9 | SOST | SAPoffice: Status log table | 9 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |
10 | SOSXTEST | SAPoffice/SAPconnect: Temporary folder for test results | 7 | RECYR | Recipient year from the ID | nvarchar | 2 | 0 | | |