| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | APJ1 | Project Plan Steps | 11 | EndDate | End Date | Date | 8 | 0 | ||
| 2 | NNM6 | Documents Numbering - Supplementary Code | 4 | EndDate | End Date | Date | 8 | 0 | ||
| 3 | OCPL | Quick Copy Log Manager | 4 | EndDate | End Date | Date | 8 | 0 | ||
| 4 | OWFI | Workflow - Instances | 9 | EndDate | End Date | Date | 8 | 0 | ||
| 5 | PJT1 | Project Plan Steps | 11 | EndDate | End Date | Date | 8 | 0 | ||
| Banking | ||||||||||
| 6 | OSVR | Saved Reconciliations | 3 | endDate | Bank Statement Ending Date | Date | 8 | 0 | ||
| Business Partners | ||||||||||
| 7 | AOAT | Blanket Agreement | 6 | EndDate | End Date | Date | 8 | 0 | ||
| 8 | OCLG | Activities | 41 | endDate | End/Due Date | Date | 8 | 0 | ||
| 9 | OOAT | Blanket Agreement | 6 | EndDate | End Date | Date | 8 | 0 | ||
| Finance | ||||||||||
| 10 | OCFH | Cash Flow Statement History | 7 | EndDate | End Date | Date | 8 | 0 | ||
| 11 | OCFL | Cash Flow Additional Trans. | 13 | EndDate | Execution End Date | Date | 8 | 0 | ||
| 12 | OFYM | Financial Year Master | 5 | EndDate | End Date | Date | 8 | 0 | ||
| 13 | OSHR | Shareholder's Rights and Interests Report History | 7 | EndDate | Date Range End | Date | 8 | 0 | ||
| Human Resources | ||||||||||
| 14 | HLD1 | Holiday Dates | 3 | EndDate | End Date | Date | 8 | 0 | ||
| Marketing Documents | ||||||||||
| 15 | ORCP | Recurring Transaction Template | 10 | EndDate | Execution End Date | Date | 8 | 0 | ||
| MRP | ||||||||||
| 16 | MSN3 | MRP Pegging Information | 14 | EndDate | Period End Date | Date | 8 | 0 | ||
| 17 | OFCT | Sales Forecast | 6 | EndDate | Forecast End Date | Date | 8 | 0 | ||
| 18 | OMSN | MRP Scenarios | 7 | EndDate | Report End Date | Date | 8 | 0 | ||
| Reports | ||||||||||
| 19 | OSRA | Scheduled Report Actions | 13 | EndDate | Recurrence End Date | Date | 8 | 0 | ||
| Service | ||||||||||
| 20 | ASCL | History | 65 | EndDate | End Date | Date | 8 | 0 | ||
| 21 | CTR1 | Service Contract - Items | 9 | EndDate | End Date | Date | 8 | 0 | ||
| 22 | OCTR | Service Contracts | 14 | EndDate | End Date | Date | 8 | 0 | ||
| 23 | OSCL | Service Calls | 65 | EndDate | End Date | Date | 8 | 0 | ||