| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | DAR1 | Data Archive - Transaction Log | 9 | Remarks | Remarks | nVarChar | 100 | 0 | ||
| 2 | DAR2 | Data Archive - Transaction Log | 13 | Remarks | Remarks | nVarChar | 50 | 0 | ||
| 3 | OWST | Confirmation Level | 3 | Remarks | Description | nVarChar | 100 | 0 | ||
| 4 | OWTM | Approval Templates | 3 | Remarks | Description | nVarChar | 100 | 0 | ||
| 5 | WTM2 | Confirmation Templates - Stages | 4 | Remarks | Description | nVarChar | 100 | 0 | ||
| Banking | ||||||||||
| 6 | OUBR | Branches | 3 | Remarks | Description | nVarChar | 100 | 0 | ||
| 7 | OUDP | Departments | 3 | Remarks | Description | nVarChar | 100 | 0 | ||
| Business Partners | ||||||||||
| 8 | ACPN | Campaign | 9 | Remarks | Campaign Remarks | nVarChar | 254 | 0 | ||
| 9 | AOAT | Blanket Agreement | 16 | Remarks | Remarks | Text | 16 | 0 | ||
| 10 | OCPN | Campaign | 9 | Remarks | Campaign Remarks | nVarChar | 254 | 0 | ||
| 11 | OOAT | Blanket Agreement | 16 | Remarks | Remarks | Text | 16 | 0 | ||
| Finance | ||||||||||
| 12 | OBTD | Journal Vouchers List | 10 | Remarks | Journal Voucher Remarks Field | nVarChar | 50 | 0 | ||
| Human Resources | ||||||||||
| 13 | AHE3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | ||
| 14 | AHE4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | ||
| 15 | HEM3 | Employee Reviews | 7 | remarks | Reviews | Text | 16 | 0 | ||
| 16 | HEM4 | Previous Employment | 7 | remarks | Previous Employment | Text | 16 | 0 | ||
| Inventory and Production | ||||||||||
| 17 | APKL | Pick List - History | 6 | Remarks | Remarks | Text | 16 | 0 | ||
| 18 | OALI | Alternative Items 2 | 4 | Remarks | Item Remarks | nVarChar | 50 | 0 | ||
| 19 | OPKL | Pick List | 6 | Remarks | Remarks | Text | 16 | 0 | ||
| Marketing Documents | ||||||||||
| 20 | ODWZ | Dunning Wizard | 36 | Remarks | Remarks | nVarChar | 254 | 0 | ||
| 21 | OGTI | GTS Invoice | 22 | Remarks | Remarks | nVarChar | 160 | 0 | ||
| 22 | OVRT | Tax Invoice Report | 16 | Remarks | Remarks | nVarChar | 254 | 0 | ||
| 23 | OWDD | Docs. for Confirmation | 9 | Remarks | Remarks | nVarChar | 100 | 0 | ||
| 24 | WDD1 | Documents for Approval - Authorizers | 5 | Remarks | Remarks | nVarChar | 100 | 0 | ||