One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Material Production Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица MP93 — MPS Stock Planning

Таблица: MP93 — «MPS Mtrl.». Маска имени таблицы: «MP93%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP93001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да
MP93002 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   2 Да
MP93003 NCHAR STRING 1 0 1 CodeRecDeli Receipt or Delivery   3 Да
MP93004 NCHAR STRING 10 0 10 OrderNo Order Number   4 Да
MP93005 NCHAR STRING 6 0 6 WareHouse Warehouse   5 Да
MP93006 NCHAR STRING 2 0 2 Type Type 0 — Customer Order
1 — Purchase Order
2 — Work Order
3 — Material to Work Order
4 — Project
5 — Budget
6 — Forecast
10 — Master Planning Schedule
11 — MPS Purchase Schedule
12 — Material to MPS
13 — MPS planned order
20 — Old Master Planning Schedule
21 — Old MPS Purchase Schedule
6 Да
MP93007 NUMERIC X_NUMERIC 20 8 12 Qty Quantity      
MP93008 NVARCHAR VSTRING 10 0 10 CustSuppCode Customer/Supplier Code      
MP93009 NVARCHAR VSTRING 35 0 35 CustSuppName Customer/Supplier Name      
MP93010 DATETIME DATE 0 0 8 OldDate Old Date      
MP93011 INT INTEGER 0 0 1 Status Status      
MP93012 INT INTEGER 0 0 1 WorkOrderCreated Work Order Created      
MP93013 NCHAR STRING 22 0 22 SalesOrdKey Sales Order Line      
MP93014 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
MP93015 NVARCHAR VSTRING 6 0 6 StockWarehouse Warehouse Stock      
MP93016 NVARCHAR VSTRING 6 0 6 ProductionWh Warehouse Production      
MP93017 NCHAR STRING 10 0 10 ParentOrdNo Parent Order Number      
MP93018 NVARCHAR VSTRING 35 0 35 ParentRef Parent Stock Item Code      
MP93019 NCHAR STRING 20 0 20 OriginaOrder Original Order   7 Да
MP93020 NCHAR STRING 20 0 20 TargetOLinNo Target Order Line Number      
MP93021 NCHAR STRING 10 0 10 TargetOrdNo Target Order Number      
MP93022 DATETIME DATE 0 0 8 SODeliveryDate Sales Order Delivery Date      
MP93023 NVARCHAR VSTRING 12 0 12 ProjectNumber Project Number      
MP93024 NVARCHAR VSTRING 6 0 6 SubProjectNumber Sub-Project      
MP93025 NVARCHAR VSTRING 6 0 6 ActivityLine Project Activity Line Number      
MP93026 NVARCHAR VSTRING 6 0 6 ActivityStructLine Project Activity Sub-line Number      
MP93027 NCHAR STRING 1 0 1 NeedFrom Need From      
MP93028 DATETIME DATE 0 0 8 PlanningDate Planning date      
MP93029 NCHAR SWITCH 1 0 1 FirmedOrder Firmed order      
MP93030 NUMERIC X_NUMERIC 28 8 20 PurchasePrice Purchase Price      
MP93031 INT INTEGER 0 0 2 CurrencyCode Currency Code      
MP93032 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
MP93033 NVARCHAR VSTRING 10 0 10 Supplier Supplier      
MP93034 NVARCHAR VSTRING 10 0 10 ContractNumber Contract Number      
MP93035 NVARCHAR VSTRING 6 0 6 ContractLine Contract Line      
MP93036 NUMERIC X_NUMERIC 20 8 12 QuantityPCU Quantity PCU      
MP93037 NUMERIC X_NUMERIC 18 8 10 FactorSCPC Factor SC->PC      
MP93038 NVARCHAR VSTRING 2 0 2 AlternateRouting Alternate Routing      
MP93039 INT INTEGER 0 0 1 SchedulingCode Scheduling Code      
MP93040 NUMERIC X_NUMERIC 20 8 12 NumberOfUnitsPerLot Number of units per lot      
MP93041 NUMERIC X_NUMERIC 20 8 12 LotSize Lot Size      
MP93042 NUMERIC X_NUMERIC 20 8 12 StartDateTimeFactor Start Date Time Factor      
MP93043 NUMERIC X_NUMERIC 20 8 12 DueDateTimeFactor Due Date Time Factor      
MP93044 DATETIME DATE 0 0 8 MtrlReservDate Material reservation date      
MP93045 DATETIME DATE 0 0 8 PTFDate PTF date      
MP93046 DATETIME DATE 0 0 8 OrigStartDate Original start date      
MP93047 NVARCHAR VSTRING 25 0 25 TextLine1 Text line 1      
MP93048 NVARCHAR VSTRING 25 0 25 TextLine2 Text line 2      
MP93049 NVARCHAR VSTRING 25 0 25 TextLine3 Text line 3      
MP93050 NVARCHAR VSTRING 6 0 6 SourceWHSTO Source Warehouse, STO      
MP93051 DATETIME DATE 0 0 8 ShippingdateSTO Shipping date, STO      
MP93052 DATETIME DATE 0 0 8 DeliverydateSTO Delivery date, STO      

Навигация: