пользователям программных продуктов 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 «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table ORTH — Order Template header

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ORTH001 NCHAR STRING 4 0 4 OrderTemplateID Order Template ID   1 Да / Yes
ORTH002 NVARCHAR VSTRING 25 0 25 Description Description      
ORTH003 NCHAR SWITCH 1 0 1 Horizontalscroll Horizontal scroll      
ORTH004 INT INTEGER 0 0 2 Frozencolumns Frozen columns      
ORTH005 NCHAR SWITCH 1 0 1 ApplyOrderType0 Applicable to order type 0      
ORTH006 INT INTEGER 0 0 2 PermissionOrderType0 Permission order type 0      
ORTH007 NCHAR SWITCH 1 0 1 DefaultOrderType0 Default for order type 0      
ORTH008 NCHAR SWITCH 1 0 1 ApplyOrderType1 Applicable to order type 1      
ORTH009 INT INTEGER 0 0 2 PermissionOrderType1 Permission order type 1      
ORTH010 NCHAR SWITCH 1 0 1 DefaultOrderType1 Default for order type 1      
ORTH011 NCHAR SWITCH 1 0 1 ApplyOrderType2 Applicable to order type 2      
ORTH012 INT INTEGER 0 0 2 PermissionOrderType2 Permission order type 2      
ORTH013 NCHAR SWITCH 1 0 1 DefaultOrderType2 Default for order type 2      
ORTH014 NCHAR SWITCH 1 0 1 ApplyOrderType3 Applicable to order type 3      
ORTH015 INT INTEGER 0 0 2 PermissionOrderType3 Permission order type 3      
ORTH016 NCHAR SWITCH 1 0 1 DefaultOrderType3 Default for order type 3      
ORTH017 NCHAR SWITCH 1 0 1 ApplyOrderType4 Applicable to order type 4      
ORTH018 INT INTEGER 0 0 2 PermissionOrderType4 Permission order type 4      
ORTH019 NCHAR SWITCH 1 0 1 DefaultOrderType4 Default for order type 4      
ORTH020 NCHAR SWITCH 1 0 1 ApplyOrderType5 Applicable to order type 5      
ORTH021 INT INTEGER 0 0 2 PermissionOrderType5 Permission order type 5      
ORTH022 NCHAR SWITCH 1 0 1 DefaultOrderType5 Default for order type 5      
ORTH023 NCHAR SWITCH 1 0 1 ApplyOrderType6 Applicable to order type 6      
ORTH024 INT INTEGER 0 0 2 PermissionOrderType6 Permission order type 6      
ORTH025 NCHAR SWITCH 1 0 1 DefaultOrderType6 Default for order type 6      
ORTH026 NCHAR SWITCH 1 0 1 ApplyOrderType7 Applicable to order type 7      
ORTH027 INT INTEGER 0 0 2 PermissionOrderType7 Permission order type 7      
ORTH028 NCHAR SWITCH 1 0 1 DefaultOrderType7 Default for order type 7      
ORTH029 NCHAR SWITCH 1 0 1 ApplyOrderType8 Applicable to order type 8      
ORTH030 INT INTEGER 0 0 2 PermissionOrderType8 Permission order type 8      
ORTH031 NCHAR SWITCH 1 0 1 DefaultOrderType8 Default for order type 8      
ORTH032 NCHAR SWITCH 1 0 1 ApplyOrderType9 Applicable to order type 9      
ORTH033 INT INTEGER 0 0 2 PermissionOrderType9 Permission order type 9      
ORTH034 NCHAR SWITCH 1 0 1 DefaultOrderType9 Default for order type 9      
ORTH035 NCHAR SWITCH 1 0 1 TemplateProperty1 Template Property 1      
ORTH036 NCHAR SWITCH 1 0 1 TemplateProperty2 Template Property 2      
ORTH037 NCHAR SWITCH 1 0 1 TemplateProperty3 Template Property 3      
ORTH038 NCHAR SWITCH 1 0 1 TemplateProperty4 Template Property 4      
ORTH039 NCHAR SWITCH 1 0 1 TemplateProperty5 Template Property 5      
ORTH040 NCHAR SWITCH 1 0 1 TemplateProperty6 Template Property 6      
ORTH041 INT INTEGER 0 0 10 Foregroundrw Foreground rw      
ORTH042 INT INTEGER 0 0 10 Backgroundrw Background rw      
ORTH043 INT INTEGER 0 0 10 ForegroundRO_CMD Foreground ro + cmd      
ORTH044 INT INTEGER 0 0 10 BackgroundRO_CMD Background ro + cmd      
ORTH045 INT INTEGER 0 0 10 Foregroundro Foreground ro      
ORTH046 INT INTEGER 0 0 10 Backgroundro Background ro      
ORTH047 INT INTEGER 0 0 10 ForegroundLinked Foreground Linked      
ORTH048 INT INTEGER 0 0 10 BackgroundLinked Background Linked      
ORTH049 NCHAR SWITCH 1 0 1 QueryTemplate0 Query Template 0      
ORTH050 NCHAR SWITCH 1 0 1 QueryTemplate1 Query Template 1      
ORTH051 NCHAR SWITCH 1 0 1 QueryTemplate2 Query Template 2      
ORTH052 NCHAR SWITCH 1 0 1 QueryTemplate3 Query Template 3      
ORTH053 NCHAR SWITCH 1 0 1 QueryTemplate4 Query Template 4      
ORTH054 NCHAR SWITCH 1 0 1 QueryTemplate5 Query Template 5      
ORTH055 NCHAR SWITCH 1 0 1 QueryTemplate6 Query Template 6      
ORTH056 NCHAR SWITCH 1 0 1 QueryTemplate7 Query Template 7      
ORTH057 NCHAR SWITCH 1 0 1 QueryTemplate8 Query Template 8      
ORTH058 NCHAR SWITCH 1 0 1 QueryTemplate9 Query Template 9      

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