Таблица: SC04 - «Stock Extra Information». Маска имени таблицы: «SC04%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SC04001 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да | |
SC04002 | NVARCHAR | VSTRING | 2 | 0 | 2 | RecordType | Record Type | Specifies the type of information that is stored in the information field (SC04004):
B_ - Foreign description (line 1 and two) C0-C9 - Extra description block 1 and line 1-10 G0-G9 - Extra description block 2 and line 1-10 H0-H9 - Extra description block 3 and line 1-10 I0-I9 - Extra description block 4 and line 1-10 ST - Long description TP - Long description for stock item templates |
2 | Да |
SC04003 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | 3 | Да | |
SC04004 | NVARCHAR | VSTRING | 100 | 0 | 100 | Info | Information | Information according to record type in SC04002. In case of foreign descriptions the information field includes both description line 1 (first 25 characters) and description line 2 (character 26-50). |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Stock Extra Information