Таблица: 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 - 2.03.3363 | Project Management | User Database Field Definitions