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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC80001 NCHAR STRING 6 0 6 Warehouse Warehouse   1 Да
SC80002 NCHAR STRING 10 0 10 PickListID Picking list Id   2 Да
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      

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