Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица | Table: MPGI - «MRP Group Dep Item Data». Маска имени таблицы | Table Name Mask: «MPGI%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
MPGI001 | NVARCHAR | VSTRING | 6 | 0 | 6 | MRPGroup | MRP Group | 1 | Да / Yes | |
MPGI002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Code | 2 | Да / Yes | |
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 | |||
MPGI017 | INT | INTEGER | 0 | 0 | 2 | FixedBucketSchedule | Fixed Bucket Schedule for MRP |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Material Production Control | MRP Group Dependent Item Data