| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAutomatic Payments |
1 | PAYRQ | Payment Requests | 78 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
2 | DPAYH | Payment program - data for payment | 79 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
3 | TFK042U | Payment Medium: Internal Note to Payee | 13 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
4 | PAYRC | Additional Header Data for Recovery Order | 34 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
5 | FPRL_ITEM | Item Data | 144 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
6 | PAYR | Payment Medium File | 13 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
7 | REGUH | Settlement data from payment program | 58 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |
8 | REGUHO | REGUH version before the 'n'th change | 30 | UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | nvarchar | 10 | 0 | | |