Таблица | Table: HR03 - «Resource Transactions». Маска имени таблицы | Table Name Mask: «HR03%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
| HR03001 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | 1 | Да / Yes | |
| HR03002 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | 2 | Да / Yes | |
| HR03003 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | Transaction Source | 0 - Project Management
1 - Service Order |
3 | Да / Yes |
| HR03004 | NVARCHAR | VSTRING | 12 | 0 | 12 | TransObject | Transaction Object | 4 | Да / Yes | |
| HR03005 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransSubObj | Transaction Sub-Project | 5 | Да / Yes | |
| HR03006 | NVARCHAR | VSTRING | 1 | 0 | 1 | ActivityType | Activity Type | For project transactions:
0 - Cost activity 1 - Time activity For service transactions: 0 - Time activity |
6 | Да / Yes |
| HR03007 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityCode | Activity Code | 7 | Да / Yes | |
| HR03008 | NVARCHAR | VSTRING | 3 | 0 | 3 | TransLineNo | Transaction Line Number | 8 | Да / Yes | |
| HR03009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HrsQuantity | Quantity/Hours | |||
| HR03010 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | InvHrsQty | Quantity/Hours to Invoice | |||
| HR03011 | NUMERIC | MONEY | 28 | 8 | 20 | Price | Unit Price | |||
| HR03012 | NUMERIC | MONEY | 28 | 8 | 20 | Cost | Unit Cost | |||
| HR03013 | NUMERIC | MONEY | 28 | 8 | 20 | InvAmount | Unit Price to Invoice | |||
| HR03014 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccCode | Accounting Code | |||
| HR03015 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
| HR03016 | NVARCHAR | VSTRING | 6 | 0 | 6 | ProjObjType | Project Type | |||
| HR03017 | NVARCHAR | VSTRING | 6 | 0 | 6 | WeekNo | Week Number | |||
| HR03018 | NVARCHAR | VSTRING | 1 | 0 | 1 | DateType | Date Type | Time reported as per:
0 - Date 1 - Week 2 - Month |
||
| HR03019 | NVARCHAR | VSTRING | 12 | 0 | 12 | ActivityLine | Activity Line | |||
| HR03020 | NVARCHAR | VSTRING | 6 | 0 | 6 | PrjTransLine | Project Transaction Line Number | |||
| HR03021 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | InvHrsQty | Quantity/Hours Invoiced | |||
| HR03022 | NVARCHAR | VSTRING | 1 | 0 | 1 | Invoiced | Transaction Has Been Invoiced | |||
| HR03023 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remark | Text | |||
| HR03024 | NVARCHAR | VSTRING | 1 | 0 | 1 | CostCategory | Cost Category |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Resourse Management | Resource Transactions
/* */