One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table OR14 — Order Status

Таблица / Table: OR14 — «Order Status». Маска имени таблицы / Table name mask: «OR14%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR14001 NCHAR STRING 1 0 1 No No   1 Да / Yes
OR14002 NVARCHAR VSTRING 25 0 25 Text0 Status 0 Text      
OR14003 NVARCHAR VSTRING 25 0 25 Flags0 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 25 0 25 Flags1 Status 1 Allowed Functions      
OR14006 NVARCHAR VSTRING 25 0 25 Text2 Status 2 Text      
OR14007 NVARCHAR VSTRING 25 0 25 Flags2 Status 2 Allowed Functions      
OR14008 NVARCHAR VSTRING 25 0 25 Text3 Status 3 Text      
OR14009 NVARCHAR VSTRING 25 0 25 Flags3 Status 3 Allowed Functions      
OR14010 NVARCHAR VSTRING 25 0 25 Text4 Status 4 Text      
OR14011 NVARCHAR VSTRING 25 0 25 Flags4 Status 4 Allowed Functions      
OR14012 NVARCHAR VSTRING 25 0 25 Text5 Status 5 Text      
OR14013 NVARCHAR VSTRING 25 0 25 Flags5 Status 5 Allowed Functions      
OR14014 NVARCHAR VSTRING 25 0 25 Text6 Status 6 Text      
OR14015 NVARCHAR VSTRING 25 0 25 Flags6 Status 6 Allowed Functions      
OR14016 NVARCHAR VSTRING 25 0 25 Text7 Status 7 Text      
OR14017 NVARCHAR VSTRING 25 0 25 Flags7 Status 7 Allowed Functions      
OR14018 NVARCHAR VSTRING 25 0 25 Text8 Status 8 Text      
OR14019 NVARCHAR VSTRING 25 0 25 Flags8 Status 8 Allowed Functions      
OR14020 NVARCHAR VSTRING 25 0 25 Text9 Status 9 Text      
OR14021 NVARCHAR VSTRING 25 0 25 Flags9 Status 9 Allowed Functions      

Навигация / Navigation: