| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 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 | OSUL | Support User Login Record | 9 | EndDate | End Date | Date | 8 | 0 | | |
| 5 | OVMC | Value Mapping Communication Object | 7 | EndDate | End Date | Date | 8 | 0 | | |
| 6 | OWFI | Workflow - Instances | 9 | EndDate | End Date | Date | 8 | 0 | | |
| 7 | PJT1 | Project Plan Steps | 11 | EndDate | End Date | Date | 8 | 0 | | |
| TOPBanking |
| 8 | OSVR | Saved Reconciliations | 3 | endDate | Bank Statement Ending Date | Date | 8 | 0 | | |
| TOPBusiness Partners |
| 9 | ACLG | Activities - History | 41 | endDate | End/Due Date | Date | 8 | 0 | | |
| 10 | AOAT | Blanket Agreement | 6 | EndDate | End Date | Date | 8 | 0 | | |
| 11 | OCLG | Activities | 41 | endDate | End/Due Date | Date | 8 | 0 | | |
| 12 | OOAT | Blanket Agreement | 6 | EndDate | End Date | Date | 8 | 0 | | |
| TOPFinance |
| 13 | OCFH | Cash Flow Statement History | 7 | EndDate | End Date | Date | 8 | 0 | | |
| 14 | OCFL | Cash Flow Additional Trans. | 13 | EndDate | Execution End Date | Date | 8 | 0 | | |
| 15 | OFYM | Financial Year Master | 5 | EndDate | End Date | Date | 8 | 0 | | |
| 16 | OSHR | Shareholder's Rights and Interests Report History | 7 | EndDate | Date Range End | Date | 8 | 0 | | |
| TOPHuman Resources |
| 17 | HLD1 | Holiday Dates | 3 | EndDate | End Date | Date | 8 | 0 | | |
| TOPInventory and Production |
| 18 | AWO1 | Production Order (Rows) - History | 31 | EndDate | End Date | Date | 8 | 0 | | |
| 19 | AWO4 | Production Order - Route Stages - History | 8 | EndDate | End Date | Date | 8 | 0 | | |
| 20 | UWOR1 | Production Order - Rows | 31 | EndDate | End Date | Date | 8 | 0 | | |
| 21 | UWOR4 | Production Order - Route Stages | 8 | EndDate | End Date | Date | 8 | 0 | | |
| 22 | WOR1 | Production Order - Rows | 31 | EndDate | End Date | Date | 8 | 0 | | |
| 23 | WOR4 | Production Order - Route Stages | 8 | EndDate | End Date | Date | 8 | 0 | | |
| TOPMarketing Documents |
| 24 | ORCP | Recurring Transaction Template | 10 | EndDate | Execution End Date | Date | 8 | 0 | | |
| TOPMRP |
| 25 | MSN3 | MRP Pegging Information | 14 | EndDate | Period End Date | Date | 8 | 0 | | |
| 26 | OFCT | Sales Forecast | 6 | EndDate | Forecast End Date | Date | 8 | 0 | | |
| 27 | OMSN | MRP Scenarios | 7 | EndDate | Report End Date | Date | 8 | 0 | | |
| TOPReports |
| 28 | OSRA | Scheduled Report Actions | 13 | EndDate | Recurrence End Date | Date | 8 | 0 | | |
| TOPService |
| 29 | ACT1 | Service Contract - Items | 9 | EndDate | End Date | Date | 8 | 0 | | |
| 30 | ACTR | Service Contracts | 14 | EndDate | End Date | Date | 8 | 0 | | |
| 31 | ASC6 | Service Call Scheduling - History | 7 | EndDate | End Date | Date | 8 | 0 | | |
| 32 | ASCL | History | 65 | EndDate | End Date | Date | 8 | 0 | | |
| 33 | CTR1 | Service Contract - Items | 9 | EndDate | End Date | Date | 8 | 0 | | |
| 34 | OCTR | Service Contracts | 14 | EndDate | End Date | Date | 8 | 0 | | |
| 35 | OSCL | Service Calls | 65 | EndDate | End Date | Date | 8 | 0 | | |
| 36 | SCL6 | Service Call Scheduling | 7 | EndDate | End Date | Date | 8 | 0 | | |
