Таблица: SC19 - «Customer Order Discounts». Маска имени таблицы: «SC19%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| 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 | Да |
| 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 |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Customer Order Discounts
