| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPGeneral |
| 1 | ARSC | Resource Master Data - Log | 119 | ResAlloc | Resource Allocation | VarChar | 1 | 0 | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| 2 | ORSC | Resources | 119 | ResAlloc | Resource Allocation | VarChar | 1 | 0 | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| TOPInventory and Production |
| 3 | AWO1 | Production Order (Rows) - History | 29 | ResAlloc | Resource Allocation | VarChar | 1 | 0 | | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| 4 | UWOR1 | Production Order - Rows | 29 | ResAlloc | Resource Allocation | VarChar | 1 | 0 | | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| 5 | WOR1 | Production Order - Rows | 29 | ResAlloc | Resource Allocation | VarChar | 1 | 0 | | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
