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 SC60 — Shipment

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC60001 NCHAR STRING 10 0 10 Shipment Shipment Number   1 Да / Yes
SC60002 NVARCHAR VSTRING 10 0 10 Supplier Supplier Code      
SC60003 NCHAR STRING 2 0 2 ShippingMethod Shipping Method      
SC60004 NVARCHAR VSTRING 10 0 10 ShippingAgent Shipping Agent      
SC60005 NUMERIC MONEY 28 8 20 Cost Cost      
SC60006 INT INTEGER 0 0 2 Currency Currency Code      
SC60007 NVARCHAR VSTRING 20 0 20 SupplShipmNumber Supplier Shipment Number      
SC60008 NVARCHAR VSTRING 20 0 20 UserField01 User Field 1      
SC60009 NVARCHAR VSTRING 20 0 20 UserField02 User Field 2      
SC60010 NVARCHAR VSTRING 20 0 20 UserField03 User Field 3      
SC60011 NVARCHAR VSTRING 20 0 20 UserField04 User Field 4      
SC60012 NVARCHAR VSTRING 20 0 20 UserField05 User Field 5      
SC60013 NVARCHAR VSTRING 20 0 20 UserField06 User Field 6      
SC60014 NVARCHAR VSTRING 20 0 20 UserField07 User Field 7      
SC60015 NVARCHAR VSTRING 20 0 20 UserField08 User Field 8      
SC60016 NVARCHAR VSTRING 20 0 20 UserField09 User Field 9      
SC60017 NVARCHAR VSTRING 20 0 20 UserField10 User Field 10      
SC60018 NVARCHAR VSTRING 20 0 20 UserField11 User Field 11      
SC60019 NVARCHAR VSTRING 20 0 20 UserField12 User Field 12      
SC60020 NVARCHAR VSTRING 20 0 20 UserField13 User Field 13      
SC60021 NVARCHAR VSTRING 20 0 20 UserField14 User Field 14      
SC60022 NVARCHAR VSTRING 20 0 20 UserField15 User Field 15      
SC60023 NVARCHAR VSTRING 20 0 20 UserField16 User Field 16      
SC60024 NVARCHAR VSTRING 20 0 20 UserField17 User Field 17      
SC60025 NVARCHAR VSTRING 20 0 20 UserField18 User Field 18      
SC60026 NVARCHAR VSTRING 20 0 20 UserField19 User Field 19      
SC60027 NVARCHAR VSTRING 20 0 20 UserField20 User Field 20      
SC60028 DATETIME DATE 0 0 8 ShipmentDate Shipment Date      

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