One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PR26 — User Database Field Definitions

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR26001 INT INTEGER 0 0 1 DatabaseID Database Number   1 Да / Yes
PR26002 INT INTEGER 0 0 2 FieldNo Field Number   2 Да / Yes
PR26003 NVARCHAR VSTRING 25 0 25 FieldName Field Name      
PR26004 INT INTEGER 0 0 2 FieldLength Field Length      
PR26005 INT INTEGER 0 0 2 FieldType 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
   

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