| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | APJ1 | Project Plan Steps | 10 | StartDate | Start Date | Date | 8 | 0 | ||
| 2 | NNM6 | Documents Numbering - Supplementary Code | 3 | StartDate | Start Date | Date | 8 | 0 | ||
| 3 | OCPL | Quick Copy Log Manager | 2 | StartDate | Start Date | Date | 8 | 0 | ||
| 4 | OJPE | Local Era Calendar | 3 | StartDate | Start Date | Date | 8 | 0 | ||
| 5 | OPCI | Process Checklist Instance | 7 | StartDate | Start Date | Date | 8 | 0 | ||
| 6 | OWFI | Workflow - Instances | 6 | StartDate | Start Date | Date | 8 | 0 | ||
| 7 | OWTI | Workflow Timer Definition | 4 | StartDate | Start Date | Date | 8 | 0 | ||
| 8 | OWTJ | Workflow Timer Job | 4 | StartDate | Start Date | Date | 8 | 0 | ||
| 9 | PJT1 | Project Plan Steps | 10 | StartDate | Start Date | Date | 8 | 0 | ||
| Business Partners | ||||||||||
| 10 | ACPN | Campaign | 7 | StartDate | Campaign Start Date | Date | 8 | 0 | ||
| 11 | AOAT | Blanket Agreement | 5 | StartDate | Start Date | Date | 8 | 0 | ||
| 12 | OCPN | Campaign | 7 | StartDate | Campaign Start Date | Date | 8 | 0 | ||
| 13 | OOAT | Blanket Agreement | 5 | StartDate | Start Date | Date | 8 | 0 | ||
| Finance | ||||||||||
| 14 | OCFH | Cash Flow Statement History | 6 | StartDate | Start Date | Date | 8 | 0 | ||
| 15 | OFYM | Financial Year Master | 4 | StartDate | Start Date | Date | 8 | 0 | ||
| 16 | OSHR | Shareholder's Rights and Interests Report History | 6 | StartDate | Date Range Start | Date | 8 | 0 | ||
| General | ||||||||||
| 17 | SEWBU | SEWBU | 8 | StartDate | Bck start date | nVarChar | 10 | 0 | ||
| Human Resources | ||||||||||
| 18 | AHEM | Employees | 27 | startDate | Start Date | Date | 8 | 0 | ||
| 19 | OHEM | Employees | 27 | startDate | Start Date | Date | 8 | 0 | ||
| Marketing Documents | ||||||||||
| 20 | ORCP | Recurring Transaction Template | 9 | StartDate | Execution Start Date | Date | 8 | 0 | ||
| MRP | ||||||||||
| 21 | MSN3 | MRP Pegging Information | 13 | StartDate | Period Start Date | Date | 8 | 0 | ||
| 22 | OFCT | Sales Forecast | 5 | StartDate | Forecast Start Date | Date | 8 | 0 | ||
| 23 | OMSN | MRP Scenarios | 6 | StartDate | Report Start Date | Date | 8 | 0 | ||
| Reports | ||||||||||
| 24 | OSRA | Scheduled Report Actions | 11 | StartDate | Recurrence Start Date | Date | 8 | 0 | ||
| Service | ||||||||||
| 25 | ASCL | History | 63 | StartDate | Start Date | Date | 8 | 0 | ||
| 26 | CTR1 | Service Contract - Items | 8 | StartDate | Start Date | Date | 8 | 0 | ||
| 27 | OCTR | Service Contracts | 13 | StartDate | Start Date | Date | 8 | 0 | ||
| 28 | OSCL | Service Calls | 63 | StartDate | Start Date | Date | 8 | 0 | ||