| 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=Canceled, 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=Canceled, 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 | OPWZ | Payment Wizard | 62 | BoeStatus | Bill of Exchange Status | nVarChar | 32 | 0 | | |
6 | ORCT | Incoming Payment | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
7 | OROC | Retorno Operation Codes | 4 | BoeStatus | BoE Status | VarChar | 1 | 0 | | C=Canceled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor |
8 | OVPM | Outgoing Payments | 96 | BoeStatus | Bill of Exchange Status | VarChar | 1 | 0 | | |
TOPMarketing Documents |
9 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 39 | BoEStatus | BoE Status | VarChar | 1 | 0 | | |