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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SC70001 NCHAR STRING 10 0 10 Counter Index Key   1 Да / Yes
SC70002 NVARCHAR VSTRING 2 0 2 Module_Code 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 Stock_Code 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 Qty_SC_Unit Quantity in Stock Units      
SC70010 NUMERIC X_NUMERIC 20 8 12 Qty_OR_Unit Quantity in Order Units      
SC70011 NCHAR STRING 8 0 8 User_Alias User      
SC70012 DATETIME DATE 0 0 8 Date Date      
SC70013 NCHAR STRING 8 0 8 Time Time      
SC70014 NVARCHAR VSTRING 2 0 2 Reason_Code 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
   

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Allocation History