Таблица | Table: ORTH - «Order Template header». Маска имени таблицы | Table Name Mask: «ORTH%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
ORTH001 NCHAR STRING 4 0 4 Order Template ID Order Template ID   1 Да / Yes
ORTH002 NVARCHAR VSTRING 25 0 25 Description Description      
ORTH003 NCHAR SWITCH 1 0 1 Horizontal scroll Horizontal scroll      
ORTH004 INT INTEGER 0 0 2 Frozen columns 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 Template Property 1 Template Property 1      
ORTH036 NCHAR SWITCH 1 0 1 Template Property 2 Template Property 2      
ORTH037 NCHAR SWITCH 1 0 1 Template Property 3 Template Property 3      
ORTH038 NCHAR SWITCH 1 0 1 Template Property 4 Template Property 4      
ORTH039 NCHAR SWITCH 1 0 1 Template Property 5 Template Property 5      
ORTH040 NCHAR SWITCH 1 0 1 Template Property 6 Template Property 6      
ORTH041 INT INTEGER 0 0 10 Foreground rw Foreground rw      
ORTH042 INT INTEGER 0 0 10 Background rw Background rw      
ORTH043 INT INTEGER 0 0 10 Foreground ro + cmd Foreground ro + cmd      
ORTH044 INT INTEGER 0 0 10 Background ro + cmd Background ro + cmd      
ORTH045 INT INTEGER 0 0 10 Foreground ro Foreground ro      
ORTH046 INT INTEGER 0 0 10 Background ro Background ro      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Order | Order Template header