| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T042ZA_FORMAT | Different PMW Format | 5 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
TOPBank Accounting |
2 | DFPAYG | Payment date: Grouping | 6 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
3 | DFPAYV | Payment Medium: Selection Variants | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
4 | TFPM042F | Payment medium formats: General attributes | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
5 | TFPM042FB | Payment medium formats: Events | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
6 | TFPM042FBC | Payment medium formats: Customer events | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
7 | TFPM042FD | Payment Medium Formats: Preassignment of Format Parameters | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
8 | TFPM042FDC | Payt Medium Formats: Cust. Preassignm. of Format Parameters | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
9 | TFPM042FF | Payment medium formats: Format parameters | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
10 | TFPM042FFC | Payment medium formats: Customer format parameters | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
11 | TFPM042FG | Payment medium formats: Level of detail of payment medium | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
12 | TFPM042FGC | Payt. medium formats: Cust. level of det. of payment mediums | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
13 | TFPM042FM | Payment medium formats: Reqd fields for format parameters | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
14 | TFPM042FMC | Payment medium formats: Cust. reqd. fields for format para. | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
15 | TFPM042FT | Payment medium formats: Texts | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
16 | TFPM042FV | Payment medium formats: Note to payee fields | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
17 | TFPM042FZ | Payment medium formats: Supplements | 1 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
18 | TFPM042FZT | Payment medium formats: Supplement text | 2 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DPAYG | Payment program - payment group | 6 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
20 | DPAYV | Payment program: Variants for payment medium and list | 5 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
21 | TFK042F | Payment medium formats | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
22 | TFK042FB | Payment medium events | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
23 | TFK042FE | Payment program: company code format specifications | 3 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
24 | TFK042FF | Level of Detail When Creating Payment Medium | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
25 | TFK042FG | Level of Detail When Creating Payment Medium (Refinement) | 2 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
26 | TFK042FM | Required Fields for Format Parameters | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
27 | TFK042FT | Payment medium formats (long text) | 2 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
28 | TFK042FX | Text Fields for Reference Details (Note to Payee) | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
29 | TFK042FZ | Supplements for payment medium formats | 1 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
30 | TFK042FZT | Supplements for payment medium formats (long text) | 2 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
31 | TFK042Z | Payment Program: Additional Specifications for Payt Methods | 11 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
32 | TFKPAYMFBC | Payment Medium: Installation-Specific Modules | 4 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
33 | TFKPAYMFBM | Payment Medium: Events and Standard Function Modules | 2 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
34 | TFKPAYMFBS | Payment Medium: Standard Modules | 4 | FORMI | Payment medium format | nvarchar | 30 | 0 | | |
TOPPayment Transactions |
35 | T042Z | Payment Methods for Automatic Payment | 15 | FORMI | Payment Medium Format | nvarchar | 30 | 0 | | |