| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | OPCI | Process Checklist Instance | 8 | CloseDate | Close Date | Date | 8 | 0 | ||
| Business Partners | ||||||||||
| 2 | ACLG | Activities - History | 8 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 3 | OCLG | Activities | 8 | CloseDate | Closing Date | Date | 8 | 0 | ||
| General | ||||||||||
| 4 | APH8 | Project Management - Summary - History | 34 | CloseDate | Actual Closing Date | Date | 8 | 0 | ||
| 5 | APM8 | Project Management - Summary - History | 34 | CloseDate | Actual Closing Date | Date | 8 | 0 | ||
| 6 | PHA8 | Project Management - Summary | 34 | CloseDate | Actual Closing Date | Date | 8 | 0 | ||
| 7 | PMG8 | Project Management - Summary | 34 | CloseDate | Actual Closing Date | Date | 8 | 0 | ||
| Inventory and Production | ||||||||||
| 8 | AWOR | Production Order - History | 17 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 9 | OIPF | Landed Costs | 32 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 10 | OWOR | Production Order | 17 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 11 | UWOR | Production Order | 17 | CloseDate | Closing Date | Date | 8 | 0 | ||
| Sales Opportunities | ||||||||||
| 12 | AOPR | Opportunity | 34 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 13 | OOPR | Opportunity | 34 | CloseDate | Closing Date | Date | 8 | 0 | ||
| 14 | OPR1 | Opportunity - Rows | 6 | CloseDate | Closing Date | Date | 8 | 0 | ||
| Service | ||||||||||
| 15 | ASCL | History | 29 | closeDate | Closing Date | Date | 8 | 0 | ||
| 16 | OSCL | Service Calls | 29 | closeDate | Closing Date | Date | 8 | 0 | ||