Таблица: PR10 - «Project Activity File». Маска имени таблицы: «PR10%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR10001 NCHAR STRING 6 0 6 ActivityCode Activity Code   1 Да
PR10002 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10003 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10004 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10005 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10006 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10007 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10008 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10009 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10010 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
PR10011 NVARCHAR VSTRING 35 0 35 Spare (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 LinkPO 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 AllowLinkPO 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 OperationType Operation Type      
PR10041 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
PR10042 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
PR10043 NCHAR STRING 1 0 1 FixedRevenue Fixed Revenue      
PR10044 NCHAR STRING 1 0 1 IncludeInRevenueRcgn Included into Revenue Recognition      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Activity Master Table