| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBank Customer Accounts |
1 | BCA_US_OD_TRANS | Transaction details for Overdraft protection | 11 | REF_PO_NO | Payment order number | nvarchar | 12 | 0 | | |
2 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 69 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |
TOPPayment Item |
3 | BKKIT | Payment Item | 69 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |
4 | BKKITENQ | Blocked Payment Items | 69 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |
5 | BKKITREL | Payment Item | 69 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |
6 | BKKITTMP | Planned Payment Items | 70 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |
7 | BKKITTMP_DEL | Planned Payment Items - Completed | 70 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | | |