Таблица: MP65 - «WO BOM». Маска имени таблицы: «MP65%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP65001 NCHAR STRING 10 0 10 WorkOrderNo Work Order Number   1 Да
MP65002 NCHAR STRING 10 0 10 ReportNo Report Number   2 Да
MP65003 NCHAR STRING 4 0 4 Number Number   3 Да
MP65004 NCHAR STRING 35 0 35 Component Stock Item Code Component   4 Да
MP65005 NCHAR STRING 3 0 3 CodeOpenItem Open Component Code      
MP65006 NVARCHAR VSTRING 10 0 10 Reference Reference      
MP65007 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
MP65008 NCHAR STRING 3 0 3 CodeOpenQty Open Quantity Code      
MP65009 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP65010 NUMERIC X_NUMERIC 12 8 4 ScrapFactor Scrap %      
MP65011 NVARCHAR VSTRING 6 0 6 WareHouse Warehouse      
MP65012 NVARCHAR VSTRING 35 0 35 ParentItem Parent Stock Item      
MP65013 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
MP65014 NCHAR SWITCH 1 0 1 NotDependVol Volume Independent      
MP65015 DATETIME DATE 0 0 8 MaterResDate Material Reservation Date      
MP65016 NUMERIC X_NUMERIC 20 8 12 IssuedQty Quantity Issued      
MP65017 NVARCHAR VSTRING 1 0 1 TextCode Extra Text Exist      
MP65018 NCHAR SWITCH 1 0 1 DependingLot Lot Dependent      
MP65019 NCHAR SWITCH 1 0 1 Released Released      
MP65020 NCHAR SWITCH 1 0 1 Exclusive Item Exclusive Item      
MP65021 NUMERIC X_NUMERIC 20 8 12 WOQuantity Work Order Quantity      
MP65022 NUMERIC X_NUMERIC 20 8 12 ReservedQty Quantity Reserved      
MP65023 NCHAR SWITCH 1 0 1 OptionRegistered Option Entered      
MP65024 NCHAR SWITCH 1 0 1 OpenQtyReg Open Quantity Entered      
MP65025 NUMERIC X_NUMERIC 20 8 12 TotalScrap Total Scrap Quantity      
MP65026 NCHAR SWITCH 1 0 1 ActCostItem Actual Cost Item      
MP65027 NCHAR STRING 10 0 10 ParentRepNo Parent Report Number      
MP65028 INT INTEGER 0 0 12 InternalCounter Internal Counter      
MP65029 NUMERIC X_NUMERIC 20 8 12 BoMQuantity BOM Quantity      
MP65030 NUMERIC MONEY 28 8 20 PlanMtrlCost Material Cost Planned      
MP65031 NUMERIC MONEY 28 8 20 ActMtrlCost Material Cost Actual      
MP65032 NUMERIC MONEY 28 8 20 StdCostPrice Standard Unit Cost Price      
MP65033 NUMERIC MONEY 28 8 20 WIPAmount WIP Amount      
MP65034 INT INTEGER 0 0 3 Level Level      
MP65035 NCHAR STRING 10 0 10 MadeWrkOrdNo Made Work Order Number      
MP65036 INT INTEGER 0 0 2 UnitCode Unit Code      
MP65037 NVARCHAR VSTRING 8 0 8 AssemblyStation Assembly Station      
MP65038 INT INTEGER 0 0 1 SparePartCode Spare Part Code      
MP65039 NUMERIC X_NUMERIC 15 8 7 Distribution Distribution %      
MP65040 NCHAR STRING 10 0 10 RepNoMaterial Report Number Material      
MP65041 NUMERIC X_NUMERIC 18 8 10 UnitConvFactor Unit Conversion Factor      
MP65042 NCHAR STRING 3 0 3 OperationNo Operation Number      
MP65043 NCHAR SWITCH 1 0 1 CriticalMaterial Critical Material      
MP65044 NCHAR SWITCH 1 0 1 BoundToOrder Bound to Order      
MP65045 NCHAR STRING 10 0 10 PurchOrderNo Purchase Order Number      
MP65046 NCHAR STRING 9 0 9 PurchOrdLine Purchase Order Line Number      
MP65047 NCHAR STRING 4 0 4 DelivLineNo Delivery Line Number      
MP65048 NUMERIC X_NUMERIC 28 8 20 AllocatedQuantity Quantity Allocated      
MP65049 NVARCHAR VSTRING 12 0 12 Additional reference Additional Reference      
MP65050 INT INTEGER 0 0 3 Lead-time offset Lead Time Offset      
MP65051 NVARCHAR VSTRING 3 0 3 Spare (obsolete)      
MP65052 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
MP65053 NVARCHAR VSTRING 12 0 12 ProjectNumber Project Number      
MP65054 NVARCHAR VSTRING 6 0 6 SubProjectNumber Sub-Project      
MP65055 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number      
MP65056 NVARCHAR VSTRING 6 0 6 ActivityStructLine Activity Sub-line Number      

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