| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | BKKSONT | Payment Notes of Standing Orders | 7 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| TOPCondition |
| 2 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 21 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| TOPPayment Item |
| 3 | BKKNT | Purpose | 6 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| 4 | BKKNTTMP | Payment Notes of Planned Payment Items | 6 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| 5 | BKKPAYMEX_PYNOT | Payment Notes in Outgoing Payment Transactions | 6 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| TOPPayment Order |
| 6 | BKKPONT | Payment Order, Application of Funds | 6 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| 7 | BKKPONT_TMP | Planned Payment Order, Payment Details | 7 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| 8 | BKKPONT_TMP_DEL | Planned Payment Order, Payment Details | 7 | PAYM_NOTE | Purpose | nvarchar | 70 | 0 | | |
| TOPProduct definition |
| 9 | TBKKG34 | Transaction Types: Payment Notes for Returns | 7 | PAYM_NOTE | Payment Notes (Unedited) | nvarchar | 132 | 0 | | |
