Таблица | Table: SC49 - «Discount Setup». Маска имени таблицы | Table Name Mask: «SC49%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SC49001 | INT | INTEGER | 0 | 0 | 9 | DiscountCode | Discount Code | 1 | Да / Yes | |
SC49002 | INT | INTEGER | 0 | 0 | 9 | Counter | Discount Setup Code | 2 | Да / Yes | |
SC49003 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
SC49004 | DATETIME | DATE | 0 | 0 | 8 | EndDate | End Date | |||
SC49005 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MaxQuantity | Maximum Quantity | |||
SC49006 | NVARCHAR | VSTRING | 2 | 0 | 2 | Price List from Code File | Price List | A valid price list or the column can have the value '*' which in this case means that it's applicable for all price lists. | ||
SC49007 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | MaxAmount | Maximum Amount (Setup Currency) | |||
SC49008 | NVARCHAR | VSTRING | 1 | 0 | 1 | UpdateOnDelivery | Update on Delivery | 0 - Counter will be updated during order entering and order updating
1 - Counter will be updated during delivery |
||
SC49009 | INT | INTEGER | 0 | 0 | 1 | Flag_Qty\Amount | Range Type | 0 - Quantity range
1 - Amount range |
||
SC49010 | INT | INTEGER | 0 | 0 | 2 | Curr_Code | Currency Code Setup |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Discount Setup