Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица | Table: STST - «Generic Salesman Group». Маска имени таблицы | Table Name Mask: «STST%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
STST001 | NVARCHAR | VSTRING | 2 | 0 | 2 | 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 | 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 | Salesman Code | 3 | Да / Yes | ||
STST004 | INT | INTEGER | 0 | 0 | 4 | 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 | Distribution % | From 00.00 to 100.00 | |||
STST006 | NUMERIC | MONEY | 28 | 8 | 20 | Commission % | From 00.00 to 100.00 | |||
STST007 | NUMERIC | MONEY | 28 | 8 | 20 | Commission Amount | Commission Amount (used only for payments) |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Statistics | Generic Salesman Group