Таблица: PR26 - «User Database Field Definitions». Маска имени таблицы: «PR26%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR26001 INT INTEGER 0 0 1 DatabaseID Database Number   1 Да
PR26002 INT INTEGER 0 0 2 Field_No Field Number   2 Да
PR26003 NVARCHAR VSTRING 25 0 25 Field_Name Field Name      
PR26004 INT INTEGER 0 0 2 Field_Length Field Length      
PR26005 INT INTEGER 0 0 2 Field_Type Field Type -1 - Alphanumeric
0 - Numeric value with 0 decimals
1 - Numeric value with 1 decimals
2 - Numeric value with 2 decimals
3 - Numeric value with 3 decimals
4 - Numeric value with 4 decimals
   
PR26006 INT INTEGER 0 0 4 FldInputType Field Input Test 0 - No validation
1 - Convert input to upper case
2 - Date testing, uses 00000000 as default
3 - Date testing, uses 99999999 as default
4 - Yes/No testing, uses Yes as default
5 - Yes/No testing, uses No as default
101 - Project Category
102 - Project Type
103 - Report Code
104 - Budget Code
105 - Price List
106 - Accounting Code Project
107 - Accounting Code Activity
108 - Cost category
109 - Activity Category
110 - Price Code
111 - User Defined Field 1
112 - User Defined Field 2
113 - User Defined Field 3
114 - User Defined Field 4
115 - User Defined Field 5
116 - User Defined Field 6
117 - User Defined Field 7
118 - User Defined Field 8
119 - User Defined Field 9
120 - User Defined Field 10
121 - User Database Code 1
122 - User Database Code 2
123 - User Database Code 3
124 - User Database Code 4
125 - User Database Code 5
126 - User Database Code 6
127 - User Database Code 7
128 - User Database Code 8
129 - User Database Code 9
130 - User Database Code 10
131 - Invoice Sort Code
   

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | User Database Field Definitions