One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Statistics»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица STCS — Salesman Commission Setup

Таблица: STCS — «Salesman Commission Setup». Маска имени таблицы: «STCS%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
STCS001 NVARCHAR VSTRING 2 0 2 RecordType 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 SalesmanCode Salesman code Filled by salesman code, or by *** (generic for all salesman without commission explicitly defined) 2 Да
STCS003 NVARCHAR VSTRING 2 0 2 CustomerExtCommCode Customer Ext. Comm. Code Defined in SL code file. 3 Да
STCS004 NVARCHAR VSTRING 2 0 2 LineExtCommCode Line Ext. Comm. Code Defined in SC Code file 4 Да
STCS005 NUMERIC MONEY 28 8 20 Boundary 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 Commission percent, from 0% to 100.00%    

Навигация: