Таблица: HR05 - «Payroll Transactions». Маска имени таблицы: «HR05%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
HR05001 | NCHAR | STRING | 8 | 0 | 8 | LineNumber | Line Number | 1 | Да | |
HR05002 | NCHAR | STRING | 10 | 0 | 10 | EmployeeCode | Employee Code | |||
HR05003 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
HR05004 | NCHAR | STRING | 6 | 0 | 6 | WageType | Wage Type | |||
HR05005 | NCHAR | STRING | 1 | 0 | 1 | SourceModule | Source Module | 0 - Project Management
1 - Service Order |
||
HR05006 | NVARCHAR | VSTRING | 20 | 0 | 20 | MainSrcObj | Source Object | |||
HR05007 | NVARCHAR | VSTRING | 20 | 0 | 20 | LineSrcObj | Source Object Line Number | |||
HR05008 | NVARCHAR | VSTRING | 8 | 0 | 8 | ActivityCode | Activity Code | |||
HR05009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
HR05010 | NCHAR | STRING | 1 | 0 | 1 | CostType | Cost Category | |||
HR05011 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ActualHours | Hours Actual | |||
HR05012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | InvHours | Hours to Invoice | |||
HR05013 | NUMERIC | MONEY | 28 | 8 | 20 | Cost | Unit Cost | |||
HR05014 | NUMERIC | MONEY | 28 | 8 | 20 | Price | Unit Price | |||
HR05015 | NVARCHAR | VSTRING | 35 | 0 | 35 | Text | Transaction Text | |||
HR05016 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
HR05017 | DATETIME | DATE | 0 | 0 | 8 | EndDate | End Date | |||
HR05018 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | |||
HR05019 | NCHAR | STRING | 1 | 0 | 1 | UpdateInPA | Update in Payroll |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Resourse Management | Payroll Transactions