One level Up / 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 SC80 — Picking list head

Таблица / Table: SC80 — «Picking list head». Маска имени таблицы / Table name mask: «SC80%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC80001 NCHAR STRING 6 0 6 Warehouse Warehouse   1 Да / Yes
SC80002 NCHAR STRING 10 0 10 PickListID Picking list Id   2 Да / Yes
SC80003 DATETIME X_DATETIME 0 0 17 CreationDateTime Creation date ? time      
SC80004 NVARCHAR VSTRING 8 0 8 CreatedBy Created by      
SC80005 DATETIME X_DATETIME 0 0 17 EarliestPickDateTime Earliest picking date ? time      
SC80006 DATETIME X_DATETIME 0 0 17 LatestPickDateTime Latest picking date ? time      
SC80007 DATETIME X_DATETIME 0 0 17 PlannedShipDateTime Planned shipment date ? time      
SC80008 DATETIME X_DATETIME 0 0 17 LastPrintedDateTime Last printed date ? time      
SC80009 NVARCHAR VSTRING 8 0 8 PrintedBy Printed by      
SC80010 INT INTEGER 0 0 1 Status Status      
SC80011 DATETIME X_DATETIME 0 0 17 StatusDate Status date      
SC80012 NCHAR STRING 1 0 1 ReqType Request type      
SC80013 NVARCHAR VSTRING 10 0 10 RequestNumber Request Number      
SC80014 INT INTEGER 0 0 1 PickType Pick type      
SC80015 NCHAR STRING 1 0 1 DestType Destination type      
SC80016 NVARCHAR VSTRING 10 0 10 DestinationReference1 Destination Reference 1      
SC80017 NVARCHAR VSTRING 10 0 10 DestinationReference2 Destination Reference 2      
SC80018 NVARCHAR VSTRING 10 0 10 DestinationReference3 Destination Reference 3      
SC80019 NUMERIC X_NUMERIC 28 8 20 PickListValue Picking list value      
SC80020 NUMERIC X_NUMERIC 18 8 10 NetWeight Net weight      
SC80021 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross weight      
SC80022 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SC80023 NUMERIC X_NUMERIC 18 8 10 NumOfItems No of items      
SC80024 NVARCHAR VSTRING 10 0 10 MergedPickListID Merged picking list id      
SC80025 INT INTEGER 0 0 1 LineSortDef Line sort definition      
SC80026 NUMERIC X_NUMERIC 18 8 10 GroupNum Group number      
SC80027 NVARCHAR VSTRING 8 0 8 StatusChangedBy Status changed by      
SC80028 INT INTEGER 0 0 1 StatusBeforeOnHold Status before OnHold      
SC80029 NVARCHAR VSTRING 2 0 2 CompanyCode Company Code      
SC80030 NCHAR STRING 3 0 3 LanCodePickList Language code Picking list      
SC80031 NCHAR STRING 3 0 3 LanCodeDN Language code Delivery note      
SC80032 DATETIME X_DATETIME 0 0 17 LatestPlanShipDateTime Shipment date from LTM or latest pick date if LTM not used.      
SC80033 NVARCHAR VSTRING 64 0 64 PickListGroupNum Pick List Group and Number inside the Group      

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