Таблица: MP61 - «MPC Bill of Material». Маска имени таблицы: «MP61%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP61001 NCHAR STRING 1 0 1 StructType Type of BOM M - Production bill of material
E - Engineer bill of material
C - Costing bill of material
O - Open item list
A - Accessory list
1 Да
MP61002 NCHAR STRING 35 0 35 ParentItem Parent Stock Item   2 Да
MP61003 NCHAR STRING 2 0 2 Alternate Alternate Routing   3 Да
MP61004 NCHAR STRING 4 0 4 Number Number   4 Да
MP61005 NCHAR STRING 35 0 35 Component Stock Item Code Component   5 Да
MP61006 NCHAR STRING 3 0 3 CodeOpenComponent Open Component Code      
MP61007 NVARCHAR VSTRING 10 0 10 Reference Reference      
MP61008 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
MP61009 NCHAR STRING 3 0 3 CodeOpenQty Open Quantity Code      
MP61010 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP61011 NUMERIC X_NUMERIC 12 8 4 ScrapFactor Scrap %      
MP61012 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
MP61013 NCHAR STRING 3 0 3 OperationNo Operation Number      
MP61014 NVARCHAR VSTRING 6 0 6 UserAppField User Application Field      
MP61015 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
MP61016 NCHAR SWITCH 1 0 1 NotDependVol Volume Independent      
MP61017 DATETIME DATE 0 0 8 DateActStruct Date BOM Activated      
MP61018 DATETIME DATE 0 0 8 DateDesactStru Date BOM Deactivated      
MP61019 INT INTEGER 0 0 1 TextCode Extra Text Exist      
MP61020 NVARCHAR VSTRING 12 0 12 Additional reference Additional Reference      
MP61021 INT INTEGER 0 0 3 Lead-time offset Lead Time Offset      
MP61022 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
MP61023 NCHAR SWITCH 1 0 1 DependingLot Lot Dependent      
MP61024 INT INTEGER 0 0 2 UnitCode Unit Code      
MP61025 NVARCHAR VSTRING 8 0 8 AssemblyStation Assembly Station      
MP61026 INT INTEGER 0 0 1 SparePartCode Spare Part Code 0 - Spare part code from stock item
1 - Not a spare part
2 - May be a spare part
3 - Always a spare part
   
MP61027 NUMERIC X_NUMERIC 15 8 7 Distribution Distribution %      
MP61028 NVARCHAR VSTRING 35 0 35 OpenItemList Open Item List      
MP61029 INT INTEGER 0 0 1 OpenItemAcc Open Items or Accessories 0 - Not related to open item or accessory list
1 - Related to open item list
2 - Related to accessory list
   
MP61030 NUMERIC X_NUMERIC 18 8 10 UnitConvFactor Unit Conversion Factor      
MP61031 NCHAR SWITCH 1 0 1 CriticalMaterial Is Critical Material      
MP61032 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
MP61033 NCHAR SWITCH 1 0 1 Exclusive Item Exclusive Item      
MP61034 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | MPC Bill of Material