| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | DPAYH | Payment program - data for payment | 48 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
TOPPayment Transactions |
2 | FPRL_ITEM | Item Data | 134 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
3 | PAYR | Payment Medium File | 44 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
4 | REGUH | Settlement data from payment program | 41 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
5 | REGUHH | REGUH version before the 'n'th change | 36 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
6 | REGUHO | REGUH version before the 'n'th change | 16 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
TOPPayroll |
7 | T7BGA1 | Bank transfer - interface table | 29 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |
8 | T7ROA1 | Bank transfer - interface table | 30 | ZSWIF | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | |