Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: SCUC - «unit codes». Маска имени таблицы | Table Name Mask: «SCUC%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SCUC001 | INT | INTEGER | 0 | 0 | 4 | Unit_Code | Unit Code | Integer value, shown in UI with leading zeros (4 digits). Allowed values : 0000 – 9999
|
1 | Да / Yes |
SCUC002 | INT | INTEGER | 0 | 0 | 1 | Has_Parent | 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 | Parent_Unit_Code | 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 | Link_Num | Link Number | Started with zero, increased by 1 for each next child. | ||
SCUC005 | INT | INTEGER | 0 | 0 | 1 | Num_of_decimals | 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 | Child_Unit_Factor | Child Unit Factor | Defines how many parent units in one child unit. | ||
SCUC007 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Effective_Unit_Factor | Effective Unit Factor | Defines unit factor to be used for conversion between units. |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | unit codes