На один уровень вверх / 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 STST — Generic Salesman Group

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
STST001 NVARCHAR VSTRING 2 0 2 ObjectType Object Type 00 ? customer (SL01)

01 ? sales ledger invoice (SL03)

02 ? sales order (OR01)

03 ? sales order in history (OR20)

04 ? sales order in version history (OR40)

05 ? payments (SL21)

 1 Да / Yes
STST002 NVARCHAR VSTRING 50 0 50 ObjectReference Object Reference Depends on object type:

00 ? customer (SL01)

Reference = customer code (10 char)

01 ? sales ledger invoice (SL03)

Reference = customer code (10 char) + invoice number (15 char)

02 ? sales order (OR01)

Reference = order number (10 char)

Depends on object type:

03 ? sales order in history (OR20)

Reference = order number (10 char) + invoice number (15 char)

Depends on object type:

04 ? sales order in version history (OR40)

Reference = order number (10 char) + version no (4 char)

05 ? payment (SL21)

Reference = customer code (10 char) + invoice number (15) char + line no (2 char)

 2 Да / Yes
STST003 NVARCHAR VSTRING 3 0 3 SalesmanCode Salesman Code   3 Да / Yes
STST004 INT INTEGER 0 0 4 SalesmanRange Salesman Range Defines number of salesmen in grid. (to keep order of entry). Started with 0000 and increased by 1 for each new salesman in object (consequent number of salesman for the each object).

For sales order object types (02-04), salesman with number 0000 should be same as salesman code in order header (OR01019, OR20019, OR40019)

For customer (object type 00), salesman with number 0000 should be same as SL01035

    
STST005 NUMERIC MONEY 28 8 20 DistributionPercent Distribution % From 00.00 to 100.00    
STST006 NUMERIC MONEY 28 8 20 CommissionPercent Commission % From 00.00 to 100.00    
STST007 NUMERIC MONEY 28 8 20 CommissionAmount Commission Amount Commission Amount (used only for payments)    

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