Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SCUC - «unit codes». Маска имени таблицы: «SCUC%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SCUC001 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | Integer value, shown in UI with leading zeros (4 digits). Allowed values : 0000 – 9999
|
1 | Да |
SCUC002 | INT | INTEGER | 0 | 0 | 1 | HasParent | Has Parent | 0 if unit does not have parent
1 if unit has parent. Note, several units may have no parent. |
||
SCUC003 | INT | INTEGER | 0 | 0 | 4 | ParentUnitCode | Parent Unit Code | If unit has parent, then keeps parent unit code.
If unit has no parent, then value is not used (saved as 0) |
||
SCUC004 | INT | INTEGER | 0 | 0 | 4 | LinkNum | Link Number | Started with zero, increased by 1 for each next child. | ||
SCUC005 | INT | INTEGER | 0 | 0 | 1 | NumOfDecimals | Number of decimals for unit | Number of decimals in the quantity of in this unit
From 0 to 5 |
||
SCUC006 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | ChildUnitFactor | Child Unit Factor | Defines how many parent units in one child unit. | ||
SCUC007 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | EffectiveUnitFactor | Effective Unit Factor | Defines unit factor to be used for conversion between units. |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | unit codes