|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MRP Job Details Header
Table Name: MSN6
Table Description: MRP Job Details Header
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| JobID | Job ID | Int | 11 | - | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | - | Â | Â | Â |
| ItemDesc | Item Description | nVarChar | 200 | - | Â | Â | Â |
| ItemGroup | Item Group | nVarChar | 100 | - | Â | Â | Â |
| StockType | Stock Type | VarChar | 1 | - | Â | Â | Â |
| ItemType | Item Type | nVarChar | 100 | - | Â | Â | Â |
| PastDue | Past Due Data | nVarChar | 50 | - | Â | Â | Â |
| PastDueRed | Past Due is Red | VarChar | 1 | - | Â | Â | Â |
| PastDueGry | Past Due is Grey | VarChar | 1 | - | Â | Â | Â |
| PastDueRmk | Past Due Remarks | nVarChar | 200 | - | Â | Â | Â |
| HistData | Historic Data | nVarChar | 50 | - | Â | Â | Â |
| HistRed | Historic Data is Red | VarChar | 1 | - | Â | Â | Â |
| HistGrey | Historic Data is Grey | VarChar | 1 | - | Â | Â | Â |
| ItmCodeRed | Item Code is Red | VarChar | 1 | - | Â | Â | Â |
| ItmProcMtd | Item Procurement Method | VarChar | 1 | - | Â | Â | Â |
| ItmLeadTm | Item Lead Time | nVarChar | 20 | - | Â | Â | Â |
| ItmMinOrdQ | Item Minimum Order Quantity | nVarChar | 20 | - | Â | Â | Â |
| ItmOrdMult | Item Order Multiple | nVarChar | 20 | - | Â | Â | Â |
| ItmOrdIntv | Item Order Interval | nVarChar | 20 | - | Â | Â | Â |
| ItmTolDays | Item Tolerance Days | nVarChar | 20 | - | Â | Â | Â |
| ItmCmpWhs | Item Component Warehouse | nVarChar | 8 | - | Â | Â | Â |
| MrpPrcMtd | MRP Procurement Method | VarChar | 1 | - | Â | Â | Â |
| MrpLeadTm | MRP Lead Time | nVarChar | 20 | - | Â | Â | Â |
| MrpMinOrdQ | MRP Minimum Order Quantity | nVarChar | 20 | - | Â | Â | Â |
| MrpOrdMult | MRP Order Multiple | nVarChar | 20 | - | Â | Â | Â |
| MrpOrdIntv | MRP Order Interval | nVarChar | 20 | - | Â | Â | Â |
| MrpTolDays | MRP Tolerance Days | nVarChar | 20 | - | Â | Â | Â |
| MrpCmpWhs | MRP Component Warehouse | nVarChar | 8 | - | Â | Â | Â |
| PrvwEnbld | Preview Enabled Flag | VarChar | 1 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | JobID |
| Â | Â | LineNum |