Таблица: PR10 - «Project Activity File». Маска имени таблицы: «PR10%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR10001 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | 1 | Да | |
PR10002 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang0 | (obsolete) | |||
PR10003 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang1 | (obsolete) | |||
PR10004 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang2 | (obsolete) | |||
PR10005 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang3 | (obsolete) | |||
PR10006 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang4 | (obsolete) | |||
PR10007 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang5 | (obsolete) | |||
PR10008 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang6 | (obsolete) | |||
PR10009 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang7 | (obsolete) | |||
PR10010 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang8 | (obsolete) | |||
PR10011 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescripLang9 | (obsolete) | |||
PR10012 | NCHAR | STRING | 1 | 0 | 1 | ActivityType | Activity Type | 0 - Cost Activity
1 - Time Activity 2 - Material Activity (Sales Order or Purchase Order) 3 - Milestone 4 - Text Annotation 5 - Linked Sales Order 6 - Linked Purchase Order 7 - Linked Service Order 8 - Linked Contract 9 - Linked Work Order |
||
PR10013 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvSpecCode | Invoice Line Layout | 1 - Invoice lines include quantity, unit price and total amount.
2 - Invoice lines include only the totals. (The actual layout is defined in the ddf files for invoices and invoice proposal) |
||
PR10014 | NVARCHAR | VSTRING | 1 | 0 | 1 | CostCategory | Cost Category | |||
PR10015 | NVARCHAR | VSTRING | 6 | 0 | 6 | VATCode | VAT Code | |||
PR10016 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
PR10017 | NVARCHAR | VSTRING | 1 | 0 | 1 | ChargeCode01 | Charge Activity | 0 - Activity shall not be charged to customer but cost allocated to the project
1 - Activity will included when invoicing the project |
||
PR10018 | NVARCHAR | VSTRING | 10 | 0 | 10 | PurchaseOrderMarkup | Purchase Order Mark-up % | |||
PR10019 | NVARCHAR | VSTRING | 10 | 0 | 10 | DefauResCode | Default Resource Code | |||
PR10020 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DefaultHours | Default Quantity/Hours | |||
PR10021 | NUMERIC | MONEY | 28 | 8 | 20 | DefaPriceQty | Default Unit Price (Local Currency) | Unit price used for price list 00 | ||
PR10022 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
PR10023 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PR10024 | NCHAR | STRING | 10 | 0 | 10 | ActivitCateg | Activity Category | |||
PR10025 | NUMERIC | MONEY | 28 | 8 | 20 | DefCostQty | Default Unit Cost (Local Currency) | |||
PR10026 | NVARCHAR | VSTRING | 2 | 0 | 2 | DiscountCode | Discount Code | |||
PR10027 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccounString | Accounting String | |||
PR10028 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MinHoursQty | Minimum Quantity/Hours | |||
PR10029 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MaxHoursQty | Maximum Quantity/Hours | |||
PR10030 | NVARCHAR | VSTRING | 1 | 0 | 1 | HrReportType | Time Reporting Types | 1 - Presence
2 - Presence Internal 3 - Sick-leave 4 - Vacation 5 - Other leave 6 - Unpaid leave 7 - Overtime |
||
PR10031 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpA | Wage Type Cost Category A | |||
PR10032 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpB | Wage Type Cost Category B | |||
PR10033 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpC | Wage Type Cost Category C | |||
PR10034 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpD | Wage Type Cost Category D | |||
PR10035 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpE | Wage Type Cost Category E | |||
PR10036 | NVARCHAR | VSTRING | 6 | 0 | 6 | WageCostTpF | Wage Type Cost Category F | |||
PR10037 | NCHAR | STRING | 1 | 0 | 1 | SuppNoPriceWarn | Suppress Zero Price Warning | |||
PR10038 | NCHAR | SWITCH | 1 | 0 | 1 | Link_PO | Allow Link to Purchase Order | This value will be inherited when creating new activity lines:
0 - The system does not allow creating direct PO from such cost activity line 1 - The system allows creating direct PO from such cost activity line. |
||
PR10039 | NCHAR | SWITCH | 1 | 0 | 1 | Allow_Link_PO | Allow Adjust Purchase Order Link Option | 0 - The system does not allow adjusting default value of the field PR10038 on activity lines.
1 - The system allows adjusting default value of the field PR10038 on activity lines. |
||
PR10040 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type | Operation Type | |||
PR10041 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code | Financial Operation Code | |||
PR10042 | NCHAR | STRING | 2 | 0 | 2 | ExtendedCommissionCode | Extended Commission Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Activity Master Table