На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SC70 — Allocation History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 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
   

Навигация / Navigation: