Таблица: STCS - «Salesman Commission Setup». Маска имени таблицы: «STCS%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
STCS001 | NVARCHAR | VSTRING | 2 | 0 | 2 | Record Type | OR record types:
00 – Sales order line SM record types: 01 – SM Material line 02 – SM Time Activity 03 – SM Cost Activity 04 – SM Header Value 05 – SM Generic PR record types: 06 – PR Material line 07 – PR Time Activity 08 – PR Cost Activity 09 - PR Header Value 10 – PR Generic CM record types: 11 - CM Maintenance line 12 - CM Lease Asset line 13 - CM Lease Accessory line 14 – CM Generic |
1 | Да | |
STCS002 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman code | Filled by salesman code, or by *** (generic for all salesman without commission explicitly defined) | 2 | Да | |
STCS003 | NVARCHAR | VSTRING | 2 | 0 | 2 | Customer Ext. Comm. Code | Defined in SL code file. | 3 | Да | |
STCS004 | NVARCHAR | VSTRING | 2 | 0 | 2 | Line Ext. Comm. Code | Defined in SC Code file | 4 | Да | |
STCS005 | NUMERIC | MONEY | 28 | 8 | 20 | Boundary | Additional PK field, allows to vary commission by some additional property. Now used only for Record Type 00, to split commission by discount %.
For record type 00, keeps discount% ( from -999.9% to 100%) |
5 | Да | |
STCS006 | NUMERIC | MONEY | 28 | 8 | 20 | Commission | Commission percent, from 0% to 100.00% |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Statistics | Salesman Commission Setup