|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MRP Job Period Data
Table Name: MSN7
Table Description: MRP Job Period Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| JobID | Job ID | Int | 11 | - | Â | Â | Â |
| ParentLn | Parent Line Number | Int | 11 | - | Â | Â | Â |
| SeqNum | Sequence Number | Int | 11 | - | Â | Â | Â |
| PeriodId | Period ID | Int | 11 | - | Â | Â | Â |
| PrdDate | Period Date | nVarChar | 8 | - | Â | Â | Â |
| Quantity | Quantity | nVarChar | 50 | - | Â | Â | Â |
| IsRed | Is Red | VarChar | 1 | - | Â | Â | Â |
| IsGrey | Is Grey | VarChar | 1 | - | Â | Â | Â |
| IsLightGry | Is Light Grey | VarChar | 1 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 200 | - | Â | Â | Â |
| IsFuture | Is Future Data | VarChar | 1 | - | Â | Â | Â |
| PegFlag | Pegging Flag | VarChar | 1 | - | Â | Â | Â |
| PrvwEnbld | Preview Enabled Flag | VarChar | 1 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | JobID |
| Â | Â | ParentLn |
| Â | Â | SeqNum |