Таблица: 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      
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 Planning date Planning date      
MP93029 NCHAR SWITCH 1 0 1 Firmed order Firmed order      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | MPS Stock Planning