Таблица: MP97 - «ECO History». Маска имени таблицы: «MP97%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 | Да |
MP97002 | NCHAR | STRING | 35 | 0 | 35 | ParentItem | Parent Stock Item | 2 | Да | |
MP97003 | NCHAR | STRING | 10 | 0 | 10 | Versiom | Version | 3 | Да | |
MP97004 | NCHAR | STRING | 4 | 0 | 4 | Release | Release | 4 | Да | |
MP97005 | DATETIME | DATE | 0 | 0 | 8 | Date_ | Date | 5 | Да | |
MP97006 | NCHAR | STRING | 4 | 0 | 4 | Index | Line Number | 6 | Да | |
MP97007 | NCHAR | STRING | 3 | 0 | 3 | CodeOpenComponent | Old Value: Open Component Code | |||
MP97008 | NVARCHAR | VSTRING | 10 | 0 | 10 | Reference | Old Value: Reference | |||
MP97009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Old Value: Quantity | |||
MP97010 | NCHAR | STRING | 3 | 0 | 3 | CodeOpenQty | 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 | Warehouse | Old Value: Warehouse | |||
MP97014 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | 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 | NotDependVol | Old Value: Volume Independent | |||
MP97018 | DATETIME | DATE | 0 | 0 | 8 | DateActStructure | 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 | TextCode | 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 | CalcQty3 | (obsolete) | |||
MP97024 | NCHAR | SWITCH | 1 | 0 | 1 | DependingLot | 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 | Reference | New Value: Reference | |||
MP97030 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | New Value: Quantity | |||
MP97031 | NCHAR | STRING | 3 | 0 | 3 | CodeOpenQty | 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 | Warehouse | New Value: Warehouse | |||
MP97035 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | New Value: Operation Number | |||
MP97036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | New Value: User Application Field | |||
MP97037 | INT | INTEGER | 0 | 0 | 4 | LeadTimeOffset | (obsolete) | |||
MP97038 | NCHAR | SWITCH | 1 | 0 | 1 | NotDependVol | New Value: Volume Independent | |||
MP97039 | DATETIME | DATE | 0 | 0 | 8 | DateActStructure | 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 | TextCode | 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 | DependingLot | 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 | UnitCode | New Value: Unit Code | |||
MP97049 | NVARCHAR | VSTRING | 8 | 0 | 8 | AssemblyStation | New Value: Assembly Station | |||
MP97050 | INT | INTEGER | 0 | 0 | 1 | SparePartCode | 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 | Distribution | New Value: Distribution % | |||
MP97052 | NVARCHAR | VSTRING | 35 | 0 | 35 | OpenItemList | New Value: Open Item List | |||
MP97053 | INT | INTEGER | 0 | 0 | 1 | OpenItemAcc | 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 | UnitConvFactor | New Value: Unit Conversion Factor | |||
MP97055 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Old Value:: Unit Code | |||
MP97056 | NVARCHAR | VSTRING | 8 | 0 | 8 | AssemblyStation | Old Value:: Assembly Station | |||
MP97057 | INT | INTEGER | 0 | 0 | 1 | SparePartCode | 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 | Distribution | Old Value:: Distribution % | |||
MP97059 | NVARCHAR | VSTRING | 35 | 0 | 35 | OpenItemList | Old Value:: Open Item List | |||
MP97060 | INT | INTEGER | 0 | 0 | 1 | OpenItemAcc | 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 | UnitConvFactor | Old Value:: Unit Conversion Factor |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Material Production Control | ECO History