Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: SC19 - «Customer Order Discounts». Маска имени таблицы | Table Name Mask: «SC19%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SC19001 | NCHAR | STRING | 2 | 0 | 2 | No | Discount Group | Related to discount code on customer where group 00 is used for discount code 00-09, group 01 for 10-19 and so on. | 1 | Да / Yes |
SC19002 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Discount_00 | Order Value Limit 1 | |||
SC19003 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount_01 | Discount 1 | |||
SC19004 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Discount_10 | Order Value Limit 2 | |||
SC19005 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount_11 | Discount 2 | |||
SC19006 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Discount_20 | Order Value Limit 3 | |||
SC19007 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount_21 | Discount 3 | |||
SC19008 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Discount_30 | Order Value Limit 4 | |||
SC19009 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount_31 | Discount 4 | |||
SC19010 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Discount_40 | Order Value Limit 5 | |||
SC19011 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount_41 | Discount 5 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Customer Order Discounts