Таблица: PR19 - «Project Sub-project/Consultant/Activity Price/Markup». Маска имени таблицы: «PR19%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR19001 | NCHAR | STRING | 1 | 0 | 1 | RecordType01 | Record Type | 1 | Да | |
PR19002 | NCHAR | STRING | 12 | 0 | 12 | ProjectNo | Project Number | 2 | Да | |
PR19003 | NCHAR | STRING | 6 | 0 | 6 | SubProject | Sub-Project | Can be either a valid sub-project or '******' if the price/mark-up applies to all sub projects. | 3 | Да |
PR19004 | NCHAR | STRING | 10 | 0 | 10 | Resource | Resource Code | Can be either a valid resource or '**********' if the price/mark-up applies to all resources. | 4 | Да |
PR19005 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | Can be either a valid activity code or '******' if the price/mark-up applies to all activities. | 5 | Да |
PR19006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Description | Description | |||
PR19007 | NVARCHAR | VSTRING | 1 | 0 | 1 | PriceType | Price Type | 0 - Specific Unit Price for Project, Sub Project, Resource or Activity
1 - Mark-up to be applied to existing price for Project, Sub Project, Resource or Activity |
||
PR19008 | NUMERIC | MONEY | 28 | 8 | 20 | Price | Unit Price (Project Currency) | |||
PR19009 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Markup | Mark-up % |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project Sub-project/Resource/Activity Price/Markup