|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MRP Job Recommendations
Table Name: MSN8
Table Description: MRP Job Recommendations
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| JobID | Job ID | Int | 11 | - | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| OrderType | Order Type | VarChar | 1 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | - | Â | Â | Â |
| ItemDesc | Item Description | nVarChar | 200 | - | Â | Â | Â |
| ItemGroup | Item Group | nVarChar | 100 | - | Â | Â | Â |
| Manufactr | Manufacturer | nVarChar | 100 | - | Â | Â | Â |
| BarCode | Bar Code | nVarChar | 100 | - | Â | Â | Â |
| Quantity | Quantity | nVarChar | 50 | - | Â | Â | Â |
| TotQtyInv | Total Qty in Inventory UoM | nVarChar | 50 | - | Â | Â | Â |
| UOM | UoM Code | nVarChar | 50 | - | Â | Â | Â |
| UoMName | UoM Name | nVarChar | 100 | - | Â | Â | Â |
| NumPerMsr | Number per Unit of Measure | nVarChar | 50 | - | Â | Â | Â |
| ReleasDate | Release Date | Date | 8 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| VendorCode | Vendor Code | nVarChar | 15 | - | Â | Â | Â |
| VendorName | Vendor Name | nVarChar | 200 | - | Â | Â | Â |
| Price | Price | nVarChar | 50 | - | Â | Â | Â |
| DiscPrcnt | Discount % | nVarChar | 50 | - | Â | Â | Â |
| PriceAftV | Price After VAT | nVarChar | 50 | - | Â | Â | Â |
| Total | Total | nVarChar | 50 | - | Â | Â | Â |
| FromWhse | From Warehouse | nVarChar | 8 | - | Â | Â | Â |
| ToWhse | To Warehouse | nVarChar | 8 | - | Â | Â | Â |
| Exception | Exception | nVarChar | 100 | - | Â | Â | Â |
| FstReqDate | First Request Date | Date | 8 | - | Â | Â | Â |
| PriceMode | Price Mode | nVarChar | 20 | - | Â | Â | Â |
| PrvwEnbld | Preview Enabled Flag | VarChar | 1 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | JobID |
| Â | Â | LineNum |