пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Project Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR10 — Activity Master Table

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      
PR10045 NVARCHAR VSTRING 10 0 10 Operation Type (Default Value) Operation Type (Default Value)      
PR10046 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Default Value) Financial Operation Code (Default Value)      
PR10047 NVARCHAR VSTRING 25 0 25 NCM Code (Default Value) NCM Code (Default Value)      
PR10048 NVARCHAR VSTRING 10 0 10 Product Tax Type (Default Value) Product Tax Type (Default Value)      

Навигация: