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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      
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 Planning date Planning date      
MP92029 NCHAR SWITCH 1 0 1 Firmed order Firmed order      

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