| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCanada |
1 | T5KRM | Canadian Tax Remittance Form PD7A Data | 11 | GRPAY | Gross payroll amount | decimal | 15 | 2 | | |
2 | T5KV1 | Vacation pay: Accrual and Payout | 19 | GRPAY | Vacation pay accrual year grouping | nvarchar | 2 | 0 | | |
3 | T5KV3 | Vacation pay: Accrual Years | 2 | GRPAY | Vacation pay accrual year grouping | nvarchar | 2 | 0 | | |
TOPPayroll |
4 | T7BGA1 | Bank transfer - interface table | 33 | GRPAY | Grounds for payment | nvarchar | 29 | 0 | | |
TOPReuse Services for Country Development |
5 | T799L10 | Employee Grouping and Number of Days in Divisor 30 | 3 | GRPAY | Employee grouping to set the fixed number of days in DIV30 | nvarchar | 4 | 0 | | |