Таблица: 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