| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | MsnCode | MRP Scenario Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 3 | Descr | Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 4 | GrpPeriods | Group Data into Periods of | char | 1 | 0 | | D | D, M, W | Allow NULL? |
| 5 | PeriodsLen | Group Data into Periods of | int | 11 | 0 | | 1 | | Allow NULL? |
| 6 | StartDate | Report Start Date | date | 8 | 0 | | | | |
| 7 | EndDate | Report End Date | date | 8 | 0 | | | | |
| 8 | MaxLdTime | Maximum Cumulative Lead Time | int | 11 | 0 | | | | Allow NULL? |
| 9 | HldaysProd | Holidays for Production | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 10 | HldaysPurc | Holidays for Purchase | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 11 | ItmFrom | Items Codes From | nvarchar | 20 | 0 | OITM | | | Allow NULL? |
| 12 | ItmTo | Items Codes To | nvarchar | 20 | 0 | OITM | | | Allow NULL? |
| 13 | ItmGrp | Items Groups | int | 11 | 0 | OITB | | | Allow NULL? |
| 14 | ItmQryGrp | Item Summary Report Group | nvarchar | 250 | 0 | | | | Allow NULL? |
| 15 | ExistStock | Consider Existing Inventory | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 16 | PurchOrder | Consider Purchase Orders | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 17 | SalesOrder | Consider Sales Orders | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 18 | WorkOrder | Consider Work Orders | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 19 | MinStckLvl | Minimum Inventory Level | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 20 | FCTAbs | Forecast Absolute Entry | int | 11 | 0 | OFCT | | | Allow NULL? |
| 21 | SortBy | Sort by | char | 1 | 0 | | L | C, G, L, N | Allow NULL? |
| 22 | ItmReq | Items without Requirement | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 23 | Simulation | Is Scenario a Simulation | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 24 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 25 | UpdateBy | Update By | nvarchar | 20 | 0 | | | | Allow NULL? |
| 26 | LastExecDa | Last Execute Date | date | 8 | 0 | | | | |
| 27 | AllItems | All Items | char | 1 | 0 | | Y | | Allow NULL? |
| 28 | ByCompany | By Company | char | 1 | 0 | | Y | | Allow NULL? |
| 29 | IncHisData | Include Historical Data | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 30 | ResInv | Reserve Invoice | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 31 | Wtrq | Inventory Transfer Request | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 32 | InvtLevel | Inventory Level | char | 1 | 0 | | D | A, D, I, R | Allow NULL? |
| 33 | RcmPO | Recommend Purchase Order | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 34 | RcmWO | Recommend Production Order | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 35 | RcmWTRQ | Recommend ITRQ | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 36 | RCMDefWhs | Recommend to Default Warehouse | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 37 | OnlyNettbl | Only Nettable | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 38 | ExpandedPO | Expanded Purchase Order | char | 1 | 0 | | N | | Allow NULL? |
| 39 | ExpandedSO | Expanded Sales Order | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 40 | RcmCalDate | Recommendation Calculated Date | date | 8 | 0 | | | | |
| 41 | RcmCalTime | Recommendation Calculated Time | int | 11 | 0 | | | | Allow NULL? |
| 42 | PurchOAT | Blanket Purchase Agreement | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 43 | SalesOAT | Blanket Sales Agreement | char | 1 | 0 | | Y | | Allow NULL? |
| 44 | Rots | Recurring Order Transactions | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 45 | ExpdResINV | Expanded Reserve Invoice | char | 1 | 0 | | N | | Allow NULL? |
| 46 | ExpdWOR | Expanded Production Order | char | 1 | 0 | | N | N, Y | Allow NULL? |
