Таблица: 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 12 8 4 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 NUMERIC X_NUMERIC 20 8 12 CalcQty1 Old Value: Additional Reference      
MP97022 NUMERIC X_NUMERIC 20 8 12 CalcQty2 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 12 8 4 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 NUMERIC X_NUMERIC 20 8 12 CalcQty1 New Value: Additional Reference      
MP97043 NUMERIC X_NUMERIC 20 8 12 CalcQty2 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 2 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 2 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 | iScala 2.2 HF 2.3318 - 2.02.3318 | Material Production Control | ECO History