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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SC70 — Allocation History

Таблица: SC70 — «Allocation History». Маска имени таблицы: «SC70%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC70001 NCHAR STRING 10 0 10 Counter Index Key   1 Да
SC70002 NVARCHAR VSTRING 2 0 2 ModuleCode Module Code 8 — Sales Order
9 — Sales Order Allocated from Drop Shipment Purchase Order
12 — Service Order
14 — Work Order
   
SC70003 NCHAR STRING 10 0 10 OrderNo Order Number      
SC70004 NCHAR STRING 10 0 10 OrderLineNo Order Line Number      
SC70005 NCHAR STRING 6 0 6 OrderStructLineNo Order Sub Line Number      
SC70006 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
SC70007 NVARCHAR VSTRING 6 0 6 WH Warehouse      
SC70008 NVARCHAR VSTRING 12 0 12 BatchNo Batch ID      
SC70009 NUMERIC X_NUMERIC 20 8 12 QtySCUnit Quantity in Stock Units      
SC70010 NUMERIC X_NUMERIC 20 8 12 QtyORUnit Quantity in Order Units      
SC70011 NCHAR STRING 8 0 8 UserAlias User      
SC70012 DATETIME DATE 0 0 8 Date Date      
SC70013 NCHAR STRING 8 0 8 Time Time      
SC70014 NVARCHAR VSTRING 2 0 2 ReasonCode Reason Code 8 — Work order manual allocation created
9 — Work order manual allocation deleted
20 — Work order automatic allocation created
21 — Work order automatic allocation deleted
22 — Material issued (allocation deleted) from work order material issue
23 — Allocation deleted from work order material issue
24 — Allocation deleted from sanity test
25 — Sales order allocation deleted from enter quality control results
26 — Work order allocation deleted from enter quality control results
   

Навигация: