|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MRP Pegging Information
Table Name: MSN3
Table Description: MRP Pegging Information
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| PeriodID | Period ID | Int | 11 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| BaseEntry | Base Document Internal ID | Int | 11 | - | Â | Â | Â |
| BaseLine | Base Row | Int | 11 | - | Â | Â | Â |
| BaseObj | Base Object Type | nVarChar | 20 | - | Â | Â | Â |
| BaseDocNum | Base Document Number | nVarChar | 16 | - | Â | Â | Â |
| BaseDue | Base Due Date | Date | 8 | - | Â | Â | Â |
| StockType | Stock Operation Type | VarChar | 1 | - | I | I | Stock Issue |
| Â | Â | Â | Â | Â | Â | R | Stock Receipt |
| LineID | Row Number | Int | 11 | - | Â | Â | Â |
| ParentCode | Parent Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| StartDate | Period Start Date | Date | 8 | - | Â | Â | Â |
| EndDate | Period End Date | Date | 8 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineID |