| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBank Customer Accounts |
1 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 37 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
TOPPayment Item |
2 | BKKIT | Payment Item | 37 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
3 | BKKITENQ | Blocked Payment Items | 37 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
4 | BKKITREL | Payment Item | 37 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
5 | BKKITTMP | Planned Payment Items | 38 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
6 | BKKITTMP_DEL | Planned Payment Items - Completed | 38 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
7 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 32 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
8 | BKKPAYMIN_IT | Table of Imported Items | 26 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
9 | TBKK_TRNSTYPE_DE | Assignment Transaction Type -> Text Key | 3 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
10 | TBKK_TXTKEY_DE | Assignment: Text Key -> Transaction Type | 8 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
TOPPayment Order |
11 | BKKPOHD | Payment Order, Header Data | 16 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
12 | BKKPOHD_TMP | Planned Payment Order, Header Data | 17 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
13 | BKKPOHD_TMP_DEL | Planned Payment Order, Header Data | 17 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
TOPProduct definition |
14 | TBKKG31 | Return Reason, Assigned Transaction Types | 3 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
15 | TBKKG31T | Return Reason | 4 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
16 | TBKKG34 | Transaction Types: Payment Notes for Returns | 4 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
17 | TBKKG34K | Transaction Types: Payment Notes for Returns W/o Sequ.No. | 4 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |
18 | TBKKG34P | Payment Notes for Returns, Text Symbols for SAPscript | 5 | RETURNK | Return Reason | nvarchar | 4 | 0 | | |