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