Таблица: MPGI - «MRP Group Dep Item Data». Маска имени таблицы: «MPGI%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 OrderQtyEOQ_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 ReservationForecast 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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | MRP Group Dependent Item Data