Таблица: HR04 - «Time Planning». Маска имени таблицы: «HR04%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| HR04001 | NVARCHAR | VSTRING | 1 | 0 | 1 | PlanningType | Planning Type | 0 - Planned only on date
1 - Planned with date and time |
1 | Да |
| HR04002 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | 2 | Да | |
| HR04003 | DATETIME | DATE | 0 | 0 | 8 | PlannedDate | Planned Start Date | 3 | Да | |
| HR04004 | NVARCHAR | VSTRING | 4 | 0 | 4 | PlannedTime | Planned Start Time | 4 | Да | |
| HR04005 | NVARCHAR | VSTRING | 1 | 0 | 1 | PlanModSrc | Planning Source | 0 - Project Management
1 - Service Order |
5 | Да |
| HR04006 | NVARCHAR | VSTRING | 30 | 0 | 30 | PlanOrdProj | Planning Object | Includes full qualifier for project activity line or service order line | 6 | Да |
| HR04007 | NVARCHAR | VSTRING | 10 | 0 | 10 | PlanActItem | Activity Code | |||
| HR04008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlanHrsQty | Planned Hours | |||
| HR04009 | NVARCHAR | VSTRING | 1 | 0 | 1 | PlanActClo | Status | |||
| HR04010 | DATETIME | DATE | 0 | 0 | 8 | DoneDate | Date Planning Created | |||
| HR04011 | NVARCHAR | VSTRING | 8 | 0 | 8 | DoneByUser | Created By | |||
| HR04012 | DATETIME | DATE | 0 | 0 | 8 | LatestChDate | Date Changed | |||
| HR04013 | NVARCHAR | VSTRING | 8 | 0 | 8 | LatesrChUser | Updated By | |||
| HR04014 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceGrp | Resource Group | |||
| HR04015 | NVARCHAR | VSTRING | 1 | 0 | 1 | FlagCloseTsk | Task is Closed | |||
| HR04016 | DATETIME | DATE | 0 | 0 | 8 | EndDate | Planned End Date | |||
| HR04017 | NVARCHAR | VSTRING | 4 | 0 | 4 | EndTime | Planned End Time |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Resourse Management | Time Planning
/* */