Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица | Table: PR19 - «Project Sub-project/Consultant/Activity Price/Markup». Маска имени таблицы | Table Name Mask: «PR19%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
PR19001 | NCHAR | STRING | 1 | 0 | 1 | RecordType01 | Record Type | 1 | Да / Yes | |
PR19002 | NCHAR | STRING | 12 | 0 | 12 | ProjectNo | Project Number | 2 | Да / Yes | |
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 | Да / Yes |
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 | Да / Yes |
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 | Да / Yes |
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 % |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Project Management | Project Sub-project/Resource/Activity Price/Markup