Таблица: HR03 - «Resource Transactions». Маска имени таблицы: «HR03%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
HR03001 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | 1 | Да | |
HR03002 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | 2 | Да | |
HR03003 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | Transaction Source | 0 - Project Management
1 - Service Order |
3 | Да |
HR03004 | NVARCHAR | VSTRING | 12 | 0 | 12 | TransObject | Transaction Object | 4 | Да | |
HR03005 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransSubObj | Transaction Sub-Project | 5 | Да | |
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 | Да |
HR03007 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityCode | Activity Code | 7 | Да | |
HR03008 | NVARCHAR | VSTRING | 3 | 0 | 3 | TransLineNo | Transaction Line Number | 8 | Да | |
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 | 3 | 0 | 3 | 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 |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Resourse Management | Resource Transactions