One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PR10 — Activity Master Table

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR10001 NCHAR STRING 6 0 6 ActivityCode Activity Code   1 Да / Yes
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 120 0 120 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      
PR10045 NVARCHAR VSTRING 10 0 10 OperationType_DefaultValue Operation Type (Default Value)      
PR10046 NVARCHAR VSTRING 10 0 10 FinancialOperationCode_DefaultValue Financial Operation Code (Default Value)      
PR10047 NVARCHAR VSTRING 25 0 25 NCMCode_DefaultValue NCM Code (Default Value)      
PR10048 NVARCHAR VSTRING 10 0 10 ProductTaxType_DefaultValue Product Tax Type (Default Value)      
PR10049 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

Навигация / Navigation: