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 |