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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MP93 — MPS Stock Planning

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP93001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
MP93002 DATETIME DATE 0 0 8 DeliveryDate Delivery Date   2 Да / Yes
MP93003 NCHAR STRING 1 0 1 CodeRecDeli Receipt or Delivery   3 Да / Yes
MP93004 NCHAR STRING 10 0 10 OrderNo Order Number   4 Да / Yes
MP93005 NCHAR STRING 6 0 6 WareHouse Warehouse   5 Да / Yes
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 Да / Yes
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 Да / Yes
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      
MP93053 INT INTEGER 0 0 1 ATPWOShift ATP WO Shift      

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