| 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=Days, M=Months, W=Weeks | 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=No, Y=Yes | Allow NULL? |
| 10 | HldaysPurc | Holidays for Purchase | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 11 | ItmFrom | Items Codes From | nvarchar | 50 | 0 | OITM | | | Allow NULL? |
| 12 | ItmTo | Items Codes To | nvarchar | 50 | 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=No, Y=Yes | Allow NULL? |
| 16 | PurchOrder | Consider Purchase Orders | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 17 | SalesOrder | Consider Sales Orders | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 18 | WorkOrder | Consider Work Orders | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 19 | MinStckLvl | Minimum Inventory Level | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | FCTAbs | Forecast Absolute Entry | int | 11 | 0 | OFCT | | | Allow NULL? |
| 21 | SortBy | Sort By | char | 1 | 0 | | L | C=Item Number, G=Item Group, L=Assembly Sequence, N=Item Description | Allow NULL? |
| 22 | ItmReq | Items Without Requirement | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | Simulation | Is Scenario a Simulation | char | 1 | 0 | | N | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 30 | ResInv | Reserve Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 31 | Wtrq | Inventory Transfer Request | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | InvtLevel | Inventory Level | char | 1 | 0 | | D | A=Maximum, D, I=Minimum, M=Minimum - Maximum, R=Required | Allow NULL? |
| 33 | RcmPO | Recommend Purchase Order | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 34 | RcmWO | Recommend Production Order | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 35 | RcmWTRQ | Recommend ITRQ | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 36 | RCMDefWhs | Recommend to Default Warehouse | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 37 | OnlyNettbl | Only Nettable | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 38 | ExpandedPO | Expanded Purchase Order | char | 1 | 0 | | N | | Allow NULL? |
| 39 | ExpandedSO | Expanded Sales Order | char | 1 | 0 | | N | N=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 43 | SalesOAT | Blanket Sales Agreement | char | 1 | 0 | | Y | | Allow NULL? |
| 44 | Rots | Recurring Order Transactions | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 45 | ExpdResINV | Expanded Reserve Invoice | char | 1 | 0 | | N | | Allow NULL? |
| 46 | ExpdWOR | Expanded Production Order | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 47 | IgnoreCLT | Ignore Cumulative Lead Time | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 48 | PurchReq | Consider Purchase Request | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 49 | PurchQuota | Consider Purchase Quotations | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 50 | SalesQuota | Consider Sales Quotations | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | ExpdPurReq | Expanded Purchase Request | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 52 | ExpdPQuota | Expanded Purchase Quotations | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 53 | ExpdSQuota | Expanded Sales Quotations | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 54 | ExpdPAgree | Expanded Purchase Agreements | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 55 | ExpdSAgree | Expanded Sales Agreements | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 56 | ExpdTraReq | Expanded Transfer Request | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 57 | DisSelItem | Display Selected Item Only | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
