| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 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 | OSUL | Support User Login Record | 7 | StartDate | Start Date | Date | 8 | 0 | | |
| 7 | OVMC | Value Mapping Communication Object | 5 | StartDate | Start Date | Date | 8 | 0 | | |
| 8 | OWFI | Workflow - Instances | 6 | StartDate | Start Date | Date | 8 | 0 | | |
| 9 | OWTI | Workflow Timer Definition | 4 | StartDate | Start Date | Date | 8 | 0 | | |
| 10 | OWTJ | Workflow Timer Job | 4 | StartDate | Start Date | Date | 8 | 0 | | |
| 11 | PJT1 | Project Plan Steps | 10 | StartDate | Start Date | Date | 8 | 0 | | |
| TOPBusiness Partners |
| 12 | ACPN | Campaign | 7 | StartDate | Campaign Start Date | Date | 8 | 0 | | |
| 13 | AOAT | Blanket Agreement | 5 | StartDate | Start Date | Date | 8 | 0 | | |
| 14 | OCPN | Campaign | 7 | StartDate | Campaign Start Date | Date | 8 | 0 | | |
| 15 | OOAT | Blanket Agreement | 5 | StartDate | Start Date | Date | 8 | 0 | | |
| TOPFinance |
| 16 | OCFH | Cash Flow Statement History | 6 | StartDate | Start Date | Date | 8 | 0 | | |
| 17 | OFYM | Financial Year Master | 4 | StartDate | Start Date | Date | 8 | 0 | | |
| 18 | OSHR | Shareholder's Rights and Interests Report History | 6 | StartDate | Date Range Start | Date | 8 | 0 | | |
| TOPGeneral |
| 19 | OUGR | Authorization Group | 6 | StartDate | Start Date | Date | 8 | 0 | | |
| 20 | SEWBU | SEWBU | 8 | StartDate | Bck start date | nVarChar | 10 | 0 | | |
| 21 | USR7 | Group User Association | 4 | StartDate | Start Date | Date | 8 | 0 | | |
| TOPHuman Resources |
| 22 | AHEM | Employees - History | 27 | startDate | Start Date | Date | 8 | 0 | | |
| 23 | OHEM | Employees | 27 | startDate | Start Date | Date | 8 | 0 | | |
| TOPInventory and Production |
| 24 | AWO1 | Production Order (Rows) - History | 30 | StartDate | Start Date | Date | 8 | 0 | | |
| 25 | AWO4 | Production Order - Route Stages - History | 7 | StartDate | Start Date | Date | 8 | 0 | | |
| 26 | AWOR | Production Order - History | 47 | StartDate | Start Date | Date | 8 | 0 | | |
| 27 | OWOR | Production Order | 47 | StartDate | Start Date | Date | 8 | 0 | | |
| 28 | UWOR | Production Order | 47 | StartDate | Start Date | Date | 8 | 0 | | |
| 29 | UWOR1 | Production Order - Rows | 30 | StartDate | Start Date | Date | 8 | 0 | | |
| 30 | UWOR4 | Production Order - Route Stages | 7 | StartDate | Start Date | Date | 8 | 0 | | |
| 31 | WOR1 | Production Order - Rows | 30 | StartDate | Start Date | Date | 8 | 0 | | |
| 32 | WOR4 | Production Order - Route Stages | 7 | StartDate | Start Date | Date | 8 | 0 | | |
| TOPMarketing Documents |
| 33 | ORCP | Recurring Transaction Template | 9 | StartDate | Execution Start Date | Date | 8 | 0 | | |
| TOPMRP |
| 34 | MSN3 | MRP Pegging Information | 13 | StartDate | Period Start Date | Date | 8 | 0 | | |
| 35 | OFCT | Sales Forecast | 5 | StartDate | Forecast Start Date | Date | 8 | 0 | | |
| 36 | OMSN | MRP Scenarios | 6 | StartDate | Report Start Date | Date | 8 | 0 | | |
| TOPReports |
| 37 | OSRA | Scheduled Report Actions | 11 | StartDate | Recurrence Start Date | Date | 8 | 0 | | |
| TOPService |
| 38 | ACT1 | Service Contract - Items | 8 | StartDate | Start Date | Date | 8 | 0 | | |
| 39 | ACTR | Service Contracts | 13 | StartDate | Start Date | Date | 8 | 0 | | |
| 40 | ASC6 | Service Call Scheduling - History | 5 | StartDate | Start Date | Date | 8 | 0 | | |
| 41 | ASCL | History | 63 | StartDate | Start Date | Date | 8 | 0 | | |
| 42 | CTR1 | Service Contract - Items | 8 | StartDate | Start Date | Date | 8 | 0 | | |
| 43 | OCTR | Service Contracts | 13 | StartDate | Start Date | Date | 8 | 0 | | |
| 44 | OSCL | Service Calls | 63 | StartDate | Start Date | Date | 8 | 0 | | |
| 45 | SCL6 | Service Call Scheduling | 5 | StartDate | Start Date | Date | 8 | 0 | | |
