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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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		    

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Allocation History