Таблица: OR14 - «Order Status». Маска имени таблицы: «OR14%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR14001 NCHAR STRING 1 0 1 No No   1 Да
OR14002 NVARCHAR VSTRING 25 0 25 Text0 Status 0 Text      
OR14003 NVARCHAR VSTRING 23 0 23 Flags Status 0 Allowed Functions Each character stands for one switch indicating if the function is allowed or not for order assigned with this status, the following is the functions per position in the string and it has the value 0 (not allowed) and 1 (allowed):
1 - Print quotation
2 - Convert quotation to order
3 - Print confirmation
4 - Create purchase order proposal
5 - Print delivery proposal
6 - Change delivery proposal
7 - Print picking list
8 - Enter stock withdrawal
9 - Print delivery note
10 - Print label
11 - Print export documents
12 - Print transport documents
13 - Order Merge
14 - Print invoice/credit note
15 - Close invoice/credit note
16 - Delete order
17 - Export order
18 - (reserved)
(The same setup is for all status code 0-9)
   
OR14004 NVARCHAR VSTRING 25 0 25 Text1 Status 1 Text      
OR14005 NVARCHAR VSTRING 23 0 23 Flags Status 1 Allowed Functions      
OR14006 NVARCHAR VSTRING 25 0 25 Text2 Status 2 Text      
OR14007 NVARCHAR VSTRING 23 0 23 Flags Status 2 Allowed Functions      
OR14008 NVARCHAR VSTRING 25 0 25 Text3 Status 3 Text      
OR14009 NVARCHAR VSTRING 23 0 23 Flags Status 3 Allowed Functions      
OR14010 NVARCHAR VSTRING 25 0 25 Text4 Status 4 Text      
OR14011 NVARCHAR VSTRING 23 0 23 Flags Status 4 Allowed Functions      
OR14012 NVARCHAR VSTRING 25 0 25 Text5 Status 5 Text      
OR14013 NVARCHAR VSTRING 23 0 23 Flags Status 5 Allowed Functions      
OR14014 NVARCHAR VSTRING 25 0 25 Text6 Status 6 Text      
OR14015 NVARCHAR VSTRING 23 0 23 Flags Status 6 Allowed Functions      
OR14016 NVARCHAR VSTRING 25 0 25 Text7 Status 7 Text      
OR14017 NVARCHAR VSTRING 23 0 23 Flags Status 7 Allowed Functions      
OR14018 NVARCHAR VSTRING 25 0 25 Text8 Status 8 Text      
OR14019 NVARCHAR VSTRING 23 0 23 Flags Status 8 Allowed Functions      
OR14020 NVARCHAR VSTRING 25 0 25 Text9 Status 9 Text      
OR14021 NVARCHAR VSTRING 23 0 23 Flags Status 9 Allowed Functions      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Order Status