На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Statistics»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table STCS — Salesman Commission Setup

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
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 Да / Yes
STCS002 NVARCHAR VSTRING 3 0 3 SalesmanCode Salesman code Filled by salesman code, or by *** (generic for all salesman without commission explicitly defined) 2 Да / Yes
STCS003 NVARCHAR VSTRING 2 0 2 CustomerExtCommCode Customer Ext. Comm. Code Defined in SL code file. 3 Да / Yes
STCS004 NVARCHAR VSTRING 2 0 2 LineExtCommCode Line Ext. Comm. Code Defined in SC Code file 4 Да / Yes
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 Да / Yes
STCS006 NUMERIC MONEY 28 8 20 Commission Commission Commission percent, from 0% to 100.00%    

Навигация / Navigation: