Таблица: STST - «Generic Salesman Group». Маска имени таблицы: «STST%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 | Да |
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 | Да |
STST003 | NVARCHAR | VSTRING | 3 | 0 | 3 | SalesmanCode | Salesman Code | 3 | Да | |
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) |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Statistics | Generic Salesman Group