Таблица: MP92 - «MRP Mtrl.». Маска имени таблицы: «MP92%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP92001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да
MP92002 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   2 Да
MP92003 NCHAR STRING 1 0 1 CodeReceiDel Receipt or Delivery 0 - Receipt of good
1 - Delivery of goods
2 - Safety Stock
3 Да
MP92004 NCHAR STRING 10 0 10 OrderNo Order Number   4 Да
MP92005 NCHAR STRING 6 0 6 Warehouse Warehouse   5 Да
MP92006 NCHAR STRING 2 0 2 Type Type 00 - Customer order
01 - Purchase order
02 - Work order
03 - Material to work order
04 - Project
05 - Budget
06 - Forecast
07 - MRP Work order
08 - Material to MRP Work order
09 - MRP Purchase order
10 - Master planning schedule
13 - MPS planned order
15 - Greatest of forecast/reservation
16 - Test record for safety stock
17 - Service order
97 - Saved MRP work order
98 - Saved Material to MRP work order
99 - Saved MRP purchase order
6 Да
MP92007 NUMERIC X_NUMERIC 20 8 12 Qty Quantity      
MP92008 NVARCHAR VSTRING 10 0 10 CustSuppCode Customer/Supplier Code      
MP92009 NVARCHAR VSTRING 35 0 35 CustsuppName Customer/Supplier Name      
MP92010 DATETIME DATE 0 0 8 OldDate Old Date      
MP92011 INT INTEGER 0 0 1 Status Status      
MP92012 INT INTEGER 0 0 1 WorkOrderCreated Work Order Created      
MP92013 NCHAR STRING 22 0 22 SalesOrdKey Sales Order Line      
MP92014 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
MP92015 NVARCHAR VSTRING 6 0 6 StockWarehouse Warehouse Stock      
MP92016 NVARCHAR VSTRING 6 0 6 ProductionWh Warehouse Production      
MP92017 NCHAR STRING 10 0 10 ParentOrdNo Parent Order Number      
MP92018 NVARCHAR VSTRING 35 0 35 ParentRef Parent Stock Item Code      
MP92019 NCHAR STRING 14 0 14 OriginaOrder Original Order   7 Да
MP92020 NCHAR STRING 14 0 14 TargetOLinNo Target Order Line Number      
MP92021 NCHAR STRING 10 0 10 TargetOrdNo Target Order Number      
MP92022 DATETIME DATE 0 0 8 ProposalStartDate Proposal Start Date      
MP92023 NVARCHAR VSTRING 12 0 12 ProjectNumber Project Number      
MP92024 NVARCHAR VSTRING 6 0 6 SubProjectNumber Sub-Project      
MP92025 NVARCHAR VSTRING 6 0 6 ActivityLine Project Activity Line Number      
MP92026 NVARCHAR VSTRING 6 0 6 ActivityStructLine Project Activity Sub-line Number      
MP92027 NCHAR STRING 1 0 1 NeedFrom Need From      
MP92028 DATETIME DATE 0 0 8 PlanningDate Planning date      
MP92029 NCHAR SWITCH 1 0 1 FirmedOrder Firmed order      
MP92030 NUMERIC X_NUMERIC 28 8 20 PurchasePrice Purchase Price      
MP92031 INT INTEGER 0 0 2 CurrencyCode Currency Code      
MP92032 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
MP92033 NVARCHAR VSTRING 10 0 10 Supplier Supplier      
MP92034 NVARCHAR VSTRING 10 0 10 ContractNumber Contract Number      
MP92035 NVARCHAR VSTRING 6 0 6 ContractLine Contract Line      
MP92036 NUMERIC X_NUMERIC 20 8 12 QuantityPCU Quantity PCU      
MP92037 NUMERIC X_NUMERIC 18 8 10 FactorSCPC Factor SC->PC      
MP92038 NVARCHAR VSTRING 2 0 2 AlternateRouting Alternate Routing      
MP92039 INT INTEGER 0 0 1 SchedulingCode Scheduling Code      
MP92040 NUMERIC X_NUMERIC 20 8 12 NumberOfUnitsPerLot Number of units per lot      
MP92041 NUMERIC X_NUMERIC 20 8 12 LotSize Lot Size      
MP92042 NVARCHAR VSTRING 6 0 6 NeedFromMRPGroup Need from MRP group      
MP92043 NUMERIC X_NUMERIC 20 8 12 AllocatedQty Allocated Qty      
MP92044 NUMERIC X_NUMERIC 20 8 12 LockedQty Locked Qty      
MP92045 NUMERIC X_NUMERIC 20 8 12 UsedCoveredQty Used/Covered Qty      
MP92046 INT INTEGER 0 0 8 Message Message      
MP92047 NVARCHAR VSTRING 1 0 1 NeverMore Never More      
MP92048 NUMERIC X_NUMERIC 20 8 12 StartDateTimeFactor Start Date Time Factor      
MP92049 NUMERIC X_NUMERIC 20 8 12 DueDateTimeFactor Due Date Time Factor      
MP92050 DATETIME DATE 0 0 8 MtrlReservDate Material reservation date      
MP92051 DATETIME DATE 0 0 8 PTFDate PTF date      
MP92052 DATETIME DATE 0 0 8 OrigStartDate Original start date      
MP92053 NVARCHAR VSTRING 25 0 25 TextLine1 Text line 1      
MP92054 NVARCHAR VSTRING 25 0 25 TextLine2 Text line 2      
MP92055 NVARCHAR VSTRING 25 0 25 TextLine3 Text line 3      
MP92056 NVARCHAR VSTRING 6 0 6 SourceWHSTO Source Warehouse, STO      
MP92057 DATETIME DATE 0 0 8 ShippingdateSTO Shipping date, STO      
MP92058 DATETIME DATE 0 0 8 DeliverydateSTO Delivery date, STO      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | MRP Stock Planning