Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: SC04 - «Stock Extra Information». Маска имени таблицы | Table Name Mask: «SC04%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SC04001 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да / Yes | |
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 | Да / Yes |
SC04003 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | 3 | Да / Yes | |
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). |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Stock Extra Information