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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SC82 — Picking list line details

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC82001 NCHAR STRING 6 0 6 Warehouse Warehouse   1 Да / Yes
SC82002 NCHAR STRING 10 0 10 PickListID Picking list Id   2 Да / Yes
SC82003 NCHAR STRING 6 0 6 PickListLine Picking list line   3 Да / Yes
SC82004 NCHAR STRING 6 0 6 PickListDetLine Picking list detailed line   4 Да / Yes
SC82005 NVARCHAR VSTRING 22 0 22 LinkedToLine Linked to line      
SC82006 NVARCHAR VSTRING 12 0 12 BatchID Batch Id      
SC82007 NVARCHAR VSTRING 6 0 6 BinNumber Bin number      
SC82008 DATETIME X_DATETIME 0 0 17 PickDateTime Picked date – time      
SC82009 NUMERIC X_NUMERIC 20 8 12 QtyToPickReq Quantity to pick (requested unit)      
SC82010 NUMERIC X_NUMERIC 20 8 12 QtyToPickSC Quantity to pick (stock unit)      
SC82011 NUMERIC X_NUMERIC 20 8 12 PickQtyReq Picked quantity (requested unit)      
SC82012 NUMERIC X_NUMERIC 20 8 12 PickQtySC Picked quantity (stock unit)      
SC82013 NUMERIC X_NUMERIC 20 8 12 QtyIssuedReq Issued quantity (requested unit)      
SC82014 NUMERIC X_NUMERIC 20 8 12 QtyIssuedSC Issued quantity (stock unit)      
SC82015 NUMERIC X_NUMERIC 20 8 12 ShippedQtyReq Shipped quantity (requested unit)      
SC82016 NUMERIC X_NUMERIC 20 8 12 ShippedQtySC Shipped quantity (stock unit)      
SC82017 NVARCHAR VSTRING 4 0 4 WHArea Warehouse area      
SC82018 NVARCHAR VSTRING 35 0 35 Label Label      
SC82019 DATETIME X_DATETIME 0 0 17 ActualShipmentDateTime Actual shipment date – time      
SC82020 NVARCHAR VSTRING 20 0 20 DelNoteNumber Delivery note number      
SC82021 NVARCHAR VSTRING 50 0 50 Comment Comment      
SC82022 NVARCHAR VSTRING 8 0 8 ReportedBy Reported by      
SC82023 NVARCHAR VSTRING 6 0 6 IssuedWarehouse Issued Warehouse      
SC82024 NCHAR SWITCH 1 0 1 DelNotePrinted Delivery note printed      
SC82025 NVARCHAR VSTRING 6 0 6 TargetWH Target warehouse      
SC82026 NVARCHAR VSTRING 6 0 6 TargetBin Target Bin      
SC82027 NVARCHAR VSTRING 6 0 6 OrderDeliveryLine Order delivery line      
SC82028 INT INTEGER 0 0 3 ReportingNo Reporting no      
SC82029 NCHAR STRING 6 0 6 DNIssuerCode DN Issuer Code      
SC82030 NVARCHAR VSTRING 10 0 10 BoxNumber Box Number      

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