На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table MP97 — ECO History

Таблица / Table: MP97 — «ECO History». Маска имени таблицы / Table name mask: «MP97%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP97001 NCHAR STRING 1 0 1 StructureType 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
MP97002 NCHAR STRING 35 0 35 ParentItem Parent Stock Item   2 Да / Yes
MP97003 NCHAR STRING 10 0 10 Versiom Version   3 Да / Yes
MP97004 NCHAR STRING 4 0 4 Release Release   4 Да / Yes
MP97005 DATETIME DATE 0 0 8 Date_ Date   5 Да / Yes
MP97006 NCHAR STRING 4 0 4 Index Line Number   6 Да / Yes
MP97007 NCHAR STRING 3 0 3 CodeOpenComponent Old Value: Open Component Code      
MP97008 NVARCHAR VSTRING 10 0 10 ReferenceOld Old Value: Reference      
MP97009 NUMERIC X_NUMERIC 20 8 12 QuantityOld Old Value: Quantity      
MP97010 NCHAR STRING 3 0 3 CodeOpenQtyOld Old Value: Open Quantity Code      
MP97011 NCHAR STRING 3 0 3 CodeCalcQty (obsolete)      
MP97012 NUMERIC X_NUMERIC 14 8 6 ScrapFactor Old Value: Scrap %      
MP97013 NVARCHAR VSTRING 6 0 6 WarehouseOld Old Value: Warehouse      
MP97014 NCHAR STRING 3 0 3 OperationNoOld Old Value: Operation Number      
MP97015 NVARCHAR VSTRING 6 0 6 Spare Old Value: User Application Field      
MP97016 INT INTEGER 0 0 4 LeadTimeOffset (obsolete)      
MP97017 NCHAR SWITCH 1 0 1 NotDependVolOld Old Value: Volume Independent      
MP97018 DATETIME DATE 0 0 8 DateActStructureOld Old Value: Date to Activate BOM      
MP97019 DATETIME DATE 0 0 8 DateDesactivate Old Value: Date to Deactivate BOM      
MP97020 INT INTEGER 0 0 1 TextCodeOld Old Value: Extra Text Exist      
MP97021 NVARCHAR VSTRING 12 0 12 AddRefOld Old Value: Additional Reference      
MP97022 INT INTEGER 0 0 3 LeadTimeOffsetOld Old Value: Lead Time Offset      
MP97023 NUMERIC X_NUMERIC 20 8 12 CalcQty3Old (obsolete)      
MP97024 NCHAR SWITCH 1 0 1 DependingLotOld Old Value: Lot Dependent      
MP97025 NVARCHAR VSTRING 2 0 2 Alternate Alternate Routing      
MP97026 NCHAR STRING 4 0 4 Number Number      
MP97027 NVARCHAR VSTRING 35 0 35 Component Stock Item Code Component      
MP97028 NCHAR STRING 3 0 3 CodeOpenComp New Value: Open Component Code      
MP97029 NVARCHAR VSTRING 10 0 10 ReferenceNew New Value: Reference      
MP97030 NUMERIC X_NUMERIC 20 8 12 QuantityNew New Value: Quantity      
MP97031 NCHAR STRING 3 0 3 CodeOpenQtyNew New Value: Open Quantity Code      
MP97032 NCHAR STRING 3 0 3 CodeCalcuQty (obsolete)      
MP97033 NUMERIC X_NUMERIC 14 8 6 ScrapFactor1 New Value: Scrap %      
MP97034 NVARCHAR VSTRING 6 0 6 WarehouseNew New Value: Warehouse      
MP97035 NCHAR STRING 3 0 3 OperationNoNew New Value: Operation Number      
MP97036 NVARCHAR VSTRING 6 0 6 Spare New Value: User Application Field      
MP97037 INT INTEGER 0 0 4 LTOffset (obsolete)      
MP97038 NCHAR SWITCH 1 0 1 NotDependVolNew New Value: Volume Independent      
MP97039 DATETIME DATE 0 0 8 DateActStructureNew New Value: Date to Activate BOM      
MP97040 DATETIME DATE 0 0 8 DateDesactStructure New Value: Date to Deactivate BOM      
MP97041 INT INTEGER 0 0 1 TextCodeNew New Value: Extra Text Exist      
MP97042 NVARCHAR VSTRING 12 0 12 AddRefNew New Value: Additional Reference      
MP97043 INT INTEGER 0 0 3 LeadTimeOffsetNew New Value: Lead Time Offset      
MP97044 NUMERIC X_NUMERIC 20 8 12 CalcQty3 (obsolete)      
MP97045 NCHAR SWITCH 1 0 1 DependingLotNew New Value: Lot Dependent      
MP97046 NVARCHAR VSTRING 1 0 1 ECOType ECO Type 1 — Changed Bill of Material

2 — New Bill of Material

3 — Deleted Bill of Material		    
MP97047 NVARCHAR VSTRING 8 0 8 ChgLoginId Changed By      
MP97048 INT INTEGER 0 0 4 UnitCodeNew New Value: Unit Code      
MP97049 NVARCHAR VSTRING 8 0 8 AssemblyStationNew New Value: Assembly Station      
MP97050 INT INTEGER 0 0 1 SparePartCodeNew New Value: 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		    
MP97051 NUMERIC X_NUMERIC 15 8 7 DistributionNew New Value: Distribution %      
MP97052 NVARCHAR VSTRING 35 0 35 OpenItemListNew New Value: Open Item List      
MP97053 INT INTEGER 0 0 1 OpenItemAccNew New Value: Open Items or Accessories 0 — Not related to open item or accessory list

1 — Related to open item list

2 — Related to accessory list		    
MP97054 NUMERIC X_NUMERIC 18 8 10 UnitConvFactorNew New Value: Unit Conversion Factor      
MP97055 INT INTEGER 0 0 4 UnitCodeOld Old Value:: Unit Code      
MP97056 NVARCHAR VSTRING 8 0 8 AssemblyStationOld Old Value:: Assembly Station      
MP97057 INT INTEGER 0 0 1 SparePartCodeOld Old Value:: 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		    
MP97058 NUMERIC X_NUMERIC 15 8 7 DistributionOld Old Value:: Distribution %      
MP97059 NVARCHAR VSTRING 35 0 35 OpenItemListOld Old Value:: Open Item List      
MP97060 INT INTEGER 0 0 1 OpenItemAccOld Old Value:: Open Items or Accessories 0 — Not related to open item or accessory list

1 — Related to open item list

2 — Related to accessory list		    
MP97061 NUMERIC X_NUMERIC 18 8 10 UnitConvFactorOld Old Value:: Unit Conversion Factor      

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