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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table MP92 — MRP Stock Planning

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP92001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
MP92002 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   2 Да / Yes
MP92003 NCHAR STRING 1 0 1 CodeReceiDel Receipt or Delivery 0 — Receipt of good

1 — Delivery of goods

2 — Safety Stock		 3 Да / Yes
MP92004 NCHAR STRING 10 0 10 OrderNo Order Number   4 Да / Yes
MP92005 NCHAR STRING 6 0 6 Warehouse Warehouse   5 Да / Yes
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 Да / Yes
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 Да / Yes
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      

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