Таблица: PCHC - «Authorization levels». Маска имени таблицы: «PCHC%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| PCHC001 | NCHAR | STRING | 8 | 0 | 8 | UserName | User | 1 | Да | |
| PCHC002 | NCHAR | STRING | 6 | 0 | 6 | DepartmentCode | Department Code | 2 | Да | |
| PCHC003 | NCHAR | STRING | 10 | 0 | 10 | ProductCategory | Product Category | 3 | Да | |
| PCHC004 | NCHAR | STRING | 1 | 0 | 1 | RequisitionType | Requisition Type | 0 - Undefined
1 - Normal purchase order 2 - Stock transfer 3 - Direct delivery 4 - Commissary item 5 - Stock issue |
4 | Да |
| PCHC005 | NUMERIC | MONEY | 28 | 8 | 20 | MinimumAmount | Minimum Amount | |||
| PCHC006 | NUMERIC | MONEY | 28 | 8 | 20 | MaximumAmount | Maximum Amount | |||
| PCHC007 | NCHAR | STRING | 1 | 0 | 1 | AuthorizationLevel | Authorization Level | 0 - Can enter requisitions, can't authorize
1 - Enter requisition and can make first approval, second is required 2 - Enter requisition and can make approval without additional |
||
| PCHC008 | NCHAR | STRING | 1 | 0 | 1 | AllowDenyAccess | Allow Access |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Order | Authorization levels
/* */