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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table MP65 — Work Order BOM

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP65001 NCHAR STRING 10 0 10 WorkOrderNo Work Order Number   1 Да / Yes
MP65002 NCHAR STRING 10 0 10 ReportNo Report Number   2 Да / Yes
MP65003 NCHAR STRING 4 0 4 Number Number   3 Да / Yes
MP65004 NCHAR STRING 35 0 35 Component Stock Item Code Component   4 Да / Yes
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 14 8 6 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 ExclusiveItem 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 4 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 AdditionalReference Additional Reference      
MP65050 INT INTEGER 0 0 3 LeadTimeOffset 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      
MP65057 NUMERIC X_NUMERIC 20 8 12 NotIssuedQtySC Not Issued Quantity [SC Unit]      
MP65058 NCHAR SWITCH 1 0 1 SpecialLine Special line 1 – Repair order line

2 – Disassembly		    
MP65059 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      

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