| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | ABOE | Bill of Exchange for Payment - History | 3 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | C=Cancelled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor |
| 2 | ARCT | Incoming Payment - History | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
| 3 | OBOE | Bill of Exchange for Payment | 3 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | C=Cancelled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor |
| 4 | OPDF | Payment Draft | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
| 5 | ORCT | Incoming Payment | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
| 6 | OVPM | Outgoing Payments | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
