пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / 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 SC63 — Box Line

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC63001 NCHAR STRING 10 0 10 Shipment Shipment Number   1 Да / Yes
SC63002 NVARCHAR VSTRING 20 0 20 PackList Pack List Number   2 Да / Yes
SC63003 NVARCHAR VSTRING 20 0 20 Box Box ID   3 Да / Yes
SC63004 NCHAR STRING 4 0 4 BoxLine Box Line Number   4 Да / Yes
SC63005 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
SC63006 NVARCHAR VSTRING 35 0 35 SupStockCode Supplier Stock Item Code      
SC63007 NVARCHAR VSTRING 25 0 25 Description Description      
SC63008 NCHAR STRING 10 0 10 PurchaseOrder Purchase Order Number      
SC63009 NCHAR STRING 6 0 6 POline Purchase Order Line Number      
SC63010 NCHAR STRING 6 0 6 POSline Purchase Order Sub-Line Number      
SC63011 NVARCHAR VSTRING 20 0 20 SupBatchID Supplier Batch ID      
SC63012 NVARCHAR VSTRING 20 0 20 SupplierOrder Supplier Order Number      
SC63013 NCHAR STRING 3 0 3 CounttyOfOrig Country of Origin      
SC63014 NVARCHAR VSTRING 10 0 10 RState R-State      
SC63015 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
SC63016 NCHAR STRING 10 0 10 SalesOrder Sales Order Number      
SC63017 NCHAR STRING 6 0 6 SalesOrderLine Sales Order Line Number      
SC63018 NCHAR STRING 6 0 6 SOSubLine Sales Order Sub-line Number      
SC63019 NVARCHAR VSTRING 20 0 20 CustomerPO Customer Purchase Order Number      
SC63020 NVARCHAR VSTRING 25 0 25 Site Site Code      
SC63021 NVARCHAR VSTRING 12 0 12 Project Project      
SC63022 NVARCHAR VSTRING 35 0 35 Remark1 Remark Line 1      
SC63023 NVARCHAR VSTRING 35 0 35 Remark2 Remark Line 2      
SC63024 NVARCHAR VSTRING 20 0 20 UserField01 User Field 1      
SC63025 NVARCHAR VSTRING 20 0 20 UserField02 User Field 2      
SC63026 NVARCHAR VSTRING 20 0 20 UserField03 User Field 3      
SC63027 NVARCHAR VSTRING 20 0 20 UserField04 User Field 4      
SC63028 NVARCHAR VSTRING 20 0 20 UserField05 User Field 5      
SC63029 NVARCHAR VSTRING 20 0 20 UserField06 User Field 6      
SC63030 NVARCHAR VSTRING 20 0 20 UserField07 User Field 7      
SC63031 NVARCHAR VSTRING 20 0 20 UserField08 User Field 8      
SC63032 NVARCHAR VSTRING 20 0 20 UserField09 User Field 9      
SC63033 NVARCHAR VSTRING 20 0 20 UserField10 User Field 10      
SC63034 NVARCHAR VSTRING 20 0 20 UserField11 User Field 11      
SC63035 NVARCHAR VSTRING 20 0 20 UserField12 User Field 12      
SC63036 NVARCHAR VSTRING 20 0 20 UserField13 User Field 13      
SC63037 NVARCHAR VSTRING 20 0 20 UserField14 User Field 14      
SC63038 NVARCHAR VSTRING 20 0 20 UserField15 User Field 15      
SC63039 NVARCHAR VSTRING 20 0 20 UserField16 User Field 16      
SC63040 NVARCHAR VSTRING 20 0 20 UserField17 User Field 17      
SC63041 NVARCHAR VSTRING 20 0 20 UserField18 User Field 18      
SC63042 NVARCHAR VSTRING 20 0 20 UserField19 User Field 19      
SC63043 NVARCHAR VSTRING 20 0 20 UserField20 User Field 20      
SC63044 NUMERIC X_NUMERIC 20 8 12 QtyReceived Quantity Received      
SC63045 NVARCHAR VSTRING 10 0 10 GRNNumber Goods Received Note Number      
SC63046 NVARCHAR VSTRING 4 0 4 PCSubSubLineNum Purchase Order Delivery Line Number      
SC63047 NVARCHAR VSTRING 4 0 4 ORSubSubLineNum Sales Order Delivery Line Number      
SC63048 NCHAR STRING 10 0 10 OrigShipment Original Shipment Number      
SC63049 NCHAR STRING 10 0 10 OrigPackList Original Pack List Number      
SC63050 NVARCHAR VSTRING 20 0 20 OrigBox Original Box ID      
SC63051 NCHAR STRING 4 0 4 OrigBoxLine Original Box Line Number      

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