На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SC87 — Picking list line details history

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC87001 NCHAR STRING 6 0 6 Warehouse Warehouse   1 Да / Yes
SC87002 NCHAR STRING 10 0 10 PickListID Picking list Id   2 Да / Yes
SC87003 NCHAR STRING 6 0 6 PickListLine Picking list line   3 Да / Yes
SC87004 NCHAR STRING 6 0 6 PickListDetLine Picking list detailed line   4 Да / Yes
SC87005 NVARCHAR VSTRING 22 0 22 LinkedToLine Linked to line      
SC87006 NVARCHAR VSTRING 12 0 12 BatchID Batch Id      
SC87007 NVARCHAR VSTRING 6 0 6 BinNumber Bin number      
SC87008 DATETIME X_DATETIME 0 0 17 PickDateTime Picked date – time      
SC87009 NUMERIC X_NUMERIC 20 8 12 QtyToPickReq Quantity to pick (requested unit)      
SC87010 NUMERIC X_NUMERIC 20 8 12 QtyToPickSC Quantity to pick (stock unit)      
SC87011 NUMERIC X_NUMERIC 20 8 12 PickQtyReq Picked quantity (requested unit)      
SC87012 NUMERIC X_NUMERIC 20 8 12 PickQtySC Picked quantity (stock unit)      
SC87013 NUMERIC X_NUMERIC 20 8 12 QtyIssuedReq Issued quantity (requested unit)      
SC87014 NUMERIC X_NUMERIC 20 8 12 QtyIssuedSC Issued quantity (stock unit)      
SC87015 NUMERIC X_NUMERIC 20 8 12 ShippedQtyReq Shipped quantity (requested unit)      
SC87016 NUMERIC X_NUMERIC 20 8 12 ShippedQtySC Shipped quantity (stock unit)      
SC87017 NVARCHAR VSTRING 4 0 4 WHArea Warehouse area      
SC87018 NVARCHAR VSTRING 35 0 35 Label Label      
SC87019 DATETIME X_DATETIME 0 0 17 ActualShipmentDateTime Actual shipment date – time      
SC87020 NVARCHAR VSTRING 20 0 20 DelNoteNumber Delivery note number      
SC87021 NVARCHAR VSTRING 50 0 50 Comment Comment      
SC87022 NVARCHAR VSTRING 8 0 8 ReportedBy Reported by      
SC87023 NVARCHAR VSTRING 6 0 6 IssuedWarehouse Issued Warehouse      
SC87024 NCHAR SWITCH 1 0 1 DelNotePrinted Delivery note printed      
SC87025 NVARCHAR VSTRING 6 0 6 TargetWH Target warehouse      
SC87026 NVARCHAR VSTRING 6 0 6 TargetBin Target Bin      
SC87027 NVARCHAR VSTRING 6 0 6 OrderDeliveryLine Order delivery line      
SC87028 INT INTEGER 0 0 3 ReportingNo Reporting no      
SC87029 NCHAR STRING 6 0 6 DNIssuerCode DN Issuer Code      
SC87030 NVARCHAR VSTRING 10 0 10 BoxNumber Box Number      

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