Таблица: 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