Таблица: MPGI - «MRP Group Dep Item Data». Маска имени таблицы: «MPGI%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| MPGI001 | NVARCHAR | VSTRING | 6 | 0 | 6 | MRPGroup | MRP Group | 1 | Да | |
| MPGI002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Code | 2 | Да | |
| MPGI003 | INT | INTEGER | 0 | 0 | 1 | LotSizingTechnique | Lot Sizing Technique | |||
| MPGI004 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OrderQtyForEOQ/FOQ/MOQ | Order Qty For EOQ, FOQ, MOQ | |||
| MPGI005 | INT | INTEGER | 0 | 0 | 5 | BucketSize | Bucket Size | |||
| MPGI006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MultipleForQtyAdjust | Multiple For Qty Adjustment | |||
| MPGI007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | SafetyStock | Safety Stock | |||
| MPGI008 | INT | INTEGER | 0 | 0 | 3 | SafetyStockLeadTime | Safety Stock Lead Time | |||
| MPGI009 | INT | INTEGER | 0 | 0 | 3 | DueBeforeNeed | Due Before Need | |||
| MPGI010 | INT | INTEGER | 0 | 0 | 1 | Reservation/Forecast | Reservation/Forecast | |||
| MPGI011 | INT | INTEGER | 0 | 0 | 3 | DaysForReservations | Days For Reservations | |||
| MPGI012 | NVARCHAR | VSTRING | 6 | 0 | 6 | StandardWhForDelivery | Standard Warehouse For Delivery | |||
| MPGI013 | NCHAR | SWITCH | 1 | 0 | 1 | ExcludedFromMRPNet | Excluded From MRP Net | |||
| MPGI014 | INT | INTEGER | 0 | 0 | 5 | DaysBeforeNeedToSearchCoverage | Days Before Need To Search Coverage | |||
| MPGI015 | INT | INTEGER | 0 | 0 | 5 | DaysAfterNeedToSearchCoverage | Days After Need To Search Coverage | |||
| MPGI016 | INT | INTEGER | 0 | 0 | 3 | LeadTimeMRP | Lead Time MRP |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Material Production Control | MRP Group Dependent Item Data
/* */