One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table MP61 — MPC Bill of Material

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
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 Да / Yes
MP61002 NCHAR STRING 35 0 35 ParentItem Parent Stock Item   2 Да / Yes
MP61003 NCHAR STRING 2 0 2 Alternate Alternate Routing   3 Да / Yes
MP61004 NCHAR STRING 4 0 4 Number Number   4 Да / Yes
MP61005 NCHAR STRING 35 0 35 Component Stock Item Code Component   5 Да / Yes
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 14 8 6 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 AdditionalReference Additional Reference      
MP61021 INT INTEGER 0 0 3 LeadTimeOffset 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 4 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 ExclusiveItem Exclusive Item      
MP61034 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      

Навигация / Navigation: