| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_DPAY | Header Table for Payment Program entries | 7 | PAYNO | | int | 10 | 0 | | |
2 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 14 | PAYNO | Sequential payment number | int | 10 | 0 | | |
3 | P2RW_CST | Payroll Result: Cumulated Tax Data for South Africa. | 32 | PAYNO | PAYE Reference Number | nvarchar | 10 | 0 | | |
4 | P2RW_ST | Payroll Result: Tax Data for South Africa. | 33 | PAYNO | PAYE Reference Number | nvarchar | 10 | 0 | | |
5 | T5Q_SUPERSTREAM | Super Stream Master Table | 76 | PAYNO | Payroll Number Identifier | nvarchar | 8 | 0 | | |
6 | T5WSE | Employer SIC Code - Assigned to PAYE reference number | 2 | PAYNO | PAYE Reference Number | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
7 | VVKKPAYHX | Additional Specif. For Payment (Insurance-Related) | 6 | PAYNO | Sequential payment number | int | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | DPAYH | Payment program - data for payment | 6 | PAYNO | Sequential payment number | int | 10 | 0 | | |
9 | DPAYP | Payment program - data on paid item | 6 | PAYNO | Sequential payment number | int | 10 | 0 | | |