| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBanking |
1 | ARC2 | Incoming Payment - Invoices - History | 61 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
2 | ARCT | Incoming Payment - History | 164 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
3 | ITR1 | Internal Reconciliation - Rows | 24 | MIType | MI Type Include this Recon. | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
4 | OPDF | Payment Draft | 164 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
5 | ORCT | Incoming Payment | 164 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
6 | OVPM | Outgoing Payments | 164 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
7 | PDF2 | Payment Draft - Invoices | 61 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
8 | RCT2 | Incoming Payments - Invoices | 61 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |
9 | VPM2 | Outgoing Payments - Invoices | 61 | MIType | MI Type Include this Payment | nVarChar | 20 | 0 | | 140000014=A/P Monthly Invoice, 270=A/R Monthly Invoice |