| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Banking | ||||||||||
| 1 | ABOE | Bill of Exchange for Payment - History | 10 | Details | Details | nVarChar | 50 | 0 | ||
| 2 | ACHO | Checks for Payment - History | 10 | Details | Details | nVarChar | 50 | 0 | ||
| 3 | ARC1 | Incoming Payment - Checks - History | 8 | Details | Details | nVarChar | 254 | 0 | ||
| 4 | OBOE | Bill of Exchange for Payment | 10 | Details | Details | nVarChar | 50 | 0 | ||
| 5 | OCHD | Checks for Payment Drafts | 10 | Details | Details | nVarChar | 50 | 0 | ||
| 6 | OCHH | Check Register | 7 | Details | Details | nVarChar | 20 | 0 | ||
| 7 | OCHO | Checks for Payment | 10 | Details | Details | nVarChar | 50 | 0 | ||
| 8 | PDF1 | Payment Draft - Checks | 8 | Details | Details | nVarChar | 254 | 0 | ||
| 9 | RCT1 | Incoming Payment - Checks | 8 | Details | Details | nVarChar | 254 | 0 | ||
| 10 | VPM1 | Outgoing Payments - Check Rows | 8 | Details | Details | nVarChar | 254 | 0 | ||
| Business Partners | ||||||||||
| 11 | ACLG | Activities - History | 24 | Details | Details | nVarChar | 100 | 0 | ||
| 12 | OCLG | Activities | 24 | Details | Details | nVarChar | 100 | 0 | ||
| Finance | ||||||||||
| 13 | AACT | G/L Account - History | 41 | Details | Details - History | nVarChar | 254 | 0 | ||
| 14 | OACT | G/L Accounts | 41 | Details | Details | nVarChar | 254 | 0 | ||