| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | AWOR | Production Order - History | 51 | RouDatCalc | Routing Date Calculation | VarChar | 1 | 0 | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| 2 | OWOR | Production Order | 51 | RouDatCalc | Routing Date Calculation | VarChar | 1 | 0 | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| 3 | UWOR | Production Order | 51 | RouDatCalc | Routing Date Calculation | VarChar | 1 | 0 | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date |
| TOPMRP |
| 4 | ORCM | Recommendation Data | 31 | RouDatCalc | Routing Date Calculation | VarChar | 1 | 0 | | B=End Date Backwards, D=On End Date, F=Start Date Onwards, S=On Start Date |
