|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MRP Scenarios - Items Array
Table Name: MSN4
Table Description: MRP Scenarios - Items Array
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OMSN | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | - | Â | Â | Â |
| Selected | Selected | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TmpForMrp | Is Temporary for MRP | VarChar | 1 | - | N | Â | Â |
| WorDueDate | Production Order Due Date | Date | 8 | - | Â | Â | Â |
| DsmDueDate | Disassembly Order Due Date | Date | 8 | - | Â | Â | Â |
| NorDueDate | Non Prd Order Doc. Due Date | Date | 8 | - | Â | Â | Â |
| Interval | Order Intervals | Int | 6 | - | Â | Â | Â |
| Multiple | Order Multiple | Num | 19.6 | - | Â | Â | Â |
| MinORdrQty | Minimum Order Quantity | Num | 19.6 | - | Â | Â | Â |
| LeadTime | Lead Time | Int | 11 | - | Â | Â | Â |
| prcrmntMtd | Procurement Method | VarChar | 1 | - | B | B | Buy |
| Â | Â | Â | Â | Â | Â | M | Make |
| ToleranDay | Tolerance Day | Int | 11 | - | Â | Â | Â |
| CompoWH | Component Warehouse | VarChar | 1 | - | B | B | From Bill of Materials Line |
| Â | Â | Â | Â | Â | Â | P | From Parent Item Document Line |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | ItemCode |
| ItemCode | No | ItemCode |