| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKKPOMND | Payment order Enriched with Mandate details | 46 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
2 | SEPA_MDTENQ_MULT | SEPA Mandate: Auxilliary Table for Multiple Enqueue | 4 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
TOPBank |
3 | SEPA_MANDATE | SEPA Mandate | 49 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
4 | SEPA_MANDATE_ENQ | SEPA Mandate: Internal Table for ENQUEUE | 3 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
5 | SEPA_MANDATE_LCH | SEPA Administration: Global Locks (History) | 3 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
6 | SEPA_MANDATE_LCK | SEPA Mandate Management: Global Locks | 3 | REC_CRDID | Creditor Identification Number | nvarchar | 35 | 0 | | |
TOPContract Accounts Receivable and Payable |
7 | TFK042B | Payment Program: Specifications for Paying Company Code | 12 | REC_CRDID | Vendor ID (Unique Cross-Country) | nvarchar | 35 | 0 | | |