Таблица: PA46 - «PA46 Emp.Rec.Chng.». Маска имени таблицы: «PA46%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PA46001 | NCHAR | STRING | 6 | 0 | 6 | EmployeeCode | Employee Code | 1 | Да | |
PA46002 | DATETIME | DATE | 0 | 0 | 8 | LastDateAction | Date Last Action | 2 | Да | |
PA46003 | NVARCHAR | VSTRING | 30 | 0 | 30 | FlagsChanging | Changed Fields | String where each character represent a field from this table and 1 means that it was changed and 0 that it was not changed. | ||
PA46004 | NVARCHAR | VSTRING | 50 | 0 | 50 | GLAccNumber | Accounting String | |||
PA46005 | NCHAR | STRING | 1 | 0 | 1 | FormerCostCenter | (obsolete) | |||
PA46006 | NCHAR | STRING | 1 | 0 | 1 | FormerProduct | (obsolete) | |||
PA46007 | NCHAR | STRING | 1 | 0 | 1 | FormerProject | (obsolete) | |||
PA46008 | NCHAR | STRING | 4 | 0 | 4 | WorkCalendar | Work Calendar | |||
PA46009 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField8 | User Defined Parameter 8 | |||
PA46010 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField9 | User Defined Parameter 9 | |||
PA46011 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField10 | User Defined Parameter 10 | |||
PA46012 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField1 | User Defined Parameter 1 | |||
PA46013 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField2 | User Defined Parameter 2 | |||
PA46014 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField3 | User Defined Parameter 3 | |||
PA46015 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField4 | User Defined Parameter 4 | |||
PA46016 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField5 | User Defined Parameter 5 | |||
PA46017 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField6 | User Defined Parameter 6 | |||
PA46018 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserField7 | User Defined Parameter 7 | |||
PA46019 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator1 | Accumulator 1 | |||
PA46020 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator2 | Accumulator 2 | |||
PA46021 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator3 | Accumulator 3 | |||
PA46022 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator4 | Accumulator 4 | |||
PA46023 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator5 | Accumulator 5 | |||
PA46024 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator6 | Accumulator 6 | |||
PA46025 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator7 | Accumulator 7 | |||
PA46026 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator8 | Accumulator 8 | |||
PA46027 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulator9 | Accumulator 9 | |||
PA46028 | NVARCHAR | VSTRING | 20 | 0 | 20 | Accumulato10 | Accumulator 10 | |||
PA46029 | NCHAR | STRING | 8 | 0 | 8 | UserChoiFld1 | Field Selected by User 1 | |||
PA46030 | NCHAR | STRING | 8 | 0 | 8 | UserChoiFld2 | Field Selected by User 2 | |||
PA46031 | NCHAR | STRING | 8 | 0 | 8 | UserChoiFld3 | Field Selected by User 3 | |||
PA46032 | NCHAR | STRING | 8 | 0 | 8 | UserChoiFld4 | Field Selected by User 4 | |||
PA46033 | NCHAR | STRING | 8 | 0 | 8 | UserChoiFld5 | Field Selected by User 5 |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Payroll | Employee History of Field Changes