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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR02001 NCHAR STRING 12 0 12 ProjectNo Project Number   1 Да
PR02002 NCHAR STRING 6 0 6 SubProject Sub-Project   2 Да
PR02003 NCHAR STRING 6 0 6 ActivityLine Activity Line Number   3 Да
PR02004 NCHAR STRING 6 0 6 ActiStruLine Activity Sub-line Number   4 Да
PR02005 NCHAR STRING 1 0 1 ActivType05 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		    
PR02006 NCHAR STRING 6 0 6 ActivityCode Activity Code      
PR02007 NCHAR STRING 10 0 10 ResourceCode Resource Code      
PR02008 NVARCHAR VSTRING 35 0 35 Description Description      
PR02009 NVARCHAR VSTRING 35 0 35 ExtraDescr1 Extra Description Line 1      
PR02010 NVARCHAR VSTRING 35 0 35 ExtraDescr2 Extra Description Line 2      
PR02011 NVARCHAR VSTRING 35 0 35 ExtraDescr3 Extra Description Line 3      
PR02012 NCHAR STRING 10 0 10 Manager Resource Code Manager      
PR02013 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR02014 NVARCHAR VSTRING 2 0 2 AccounCode Accounting Code      
PR02015 DATETIME DATE 0 0 8 EstStartDate Estimated Start Date      
PR02016 DATETIME DATE 0 0 8 ActStartDate Actual Start Date      
PR02017 DATETIME DATE 0 0 8 EstimEndDate Estimated End Date      
PR02018 DATETIME DATE 0 0 8 ActuEndDate Actual End Date      
PR02019 NVARCHAR VSTRING 1 0 1 IncFixedPric Is Included in Fixed Price      
PR02020 NUMERIC X_NUMERIC 20 8 12 ForecastHour Estimated Quantity/Hours      
PR02021 NUMERIC X_NUMERIC 20 8 12 ForcDeHrsQty Estimated Quantity/Hours to Charge      
PR02022 NUMERIC X_NUMERIC 20 8 12 ActRepHrsQty Actual Reported Quantity/Hours      
PR02023 NUMERIC X_NUMERIC 20 8 12 ActDebHrsQty Actual Invoiced Quantity/Hours      
PR02024 NUMERIC X_NUMERIC 20 8 12 EstRemHrsQty Estimated Remaining Quantity/Hours      
PR02025 NUMERIC X_NUMERIC 20 8 12 PlannedHours Scheduled/Planned Hours The number of hours that has been allocated to resources using the time planning feature.    
PR02026 NUMERIC MONEY 28 8 20 ForecRevenue Estimated Total Revenue (Project Currency)      
PR02027 NUMERIC MONEY 28 8 20 ForecDebReve Estimated Total Revenue to Charge (Project Currency)      
PR02028 NUMERIC MONEY 28 8 20 ActualReven Actual Total Revenue (Project Currency)      
PR02029 NVARCHAR VSTRING 20 0 20 Spare Update Rule (Linked Order) 0 - Upload estimates assigned to internal customers only
1 - Upload estimates assigned to external customers only
2 - Upload estimates assigned to any customers		    
PR02030 NVARCHAR VSTRING 20 0 20 Spare Estimate Settings (Linked Order) 0 - Update estimated revenue and estimated cost
1 - Update estimated cost only
2 - Update estimated revenue only		    
PR02031 NUMERIC MONEY 28 8 20 ForecastReve Estimated Total Revenue (Local Currency)      
PR02032 NUMERIC MONEY 28 8 20 ForecastCost Estimated Total Cost (Local Currency)      
PR02033 NUMERIC MONEY 28 8 20 ActualCost Actual Total Cost (Local Currency)      
PR02034 NVARCHAR VSTRING 20 0 20 Spare (obsolete)      
PR02035 NUMERIC MONEY 28 8 20 ForecDebReve Estimated Total Revenuer to Charge (Local Currency)      
PR02036 NVARCHAR VSTRING 20 0 20 PurchaseOrderMarkup Purchase Order Mark-up %      
PR02037 NUMERIC MONEY 28 8 20 ActualDebRev Actual Invoiced Revenue (Local Currency)      
PR02038 NVARCHAR VSTRING 20 0 20 ActivityToPurchOrd Is Linked to Purchase Order      
PR02039 NVARCHAR VSTRING 1 0 1 InvLinLayout 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)		    
PR02040 NVARCHAR VSTRING 6 0 6 VATCode VAT Code      
PR02041 NVARCHAR VSTRING 8 0 8 ReporCode Report Code      
PR02042 NVARCHAR VSTRING 1 0 1 LinkedModule Linked Module Only used for activity type 0 and 2:
0 - Purchase Order
1 - Sales Order		    
PR02043 NVARCHAR VSTRING 10 0 10 LinkedOrdNo Linked Order Number Depends on PR02042 and PR02005 and PR02038:
PR02005 = '0' and PR02038 = '1' : Contains Purchase Order Number (PC01001)
PR02005 = '2' and PR02042 = '0' : Contains Purchase Order Number (PC01001)
PR02005 = '2' and PR02042 = '1' : Contains Sales Order Number (OR01001)
PR02005 = '5' : : Contains Sales Order Number (OR01001)
PR02005 = '6' : : Contains Purchase Order Number (PC01001)
PR02005 = '7' : : Contains Service Order Number (SM01001)
PR02005 = '8' : : Contains Contract Number (SM11001)
PR02005 = '9' : : Contains Work Order Number (MP64001)		    
PR02044 DATETIME DATE 0 0 8 EstDelivDate Estimated Delivery Date      
PR02045 NVARCHAR VSTRING 1 0 1 AutUpdEstMtr Automatically Update Estimates with Order Value      
PR02046 DATETIME DATE 0 0 8 LinkCreatDat Linked Object Date Created      
PR02047 DATETIME DATE 0 0 8 LinkClosDate Linked Object Close Date      
PR02048 NVARCHAR VSTRING 2 0 2 LinkStatus Linked Object Status      
PR02049 NUMERIC MONEY 28 8 20 WIPTransAmo WIP Transaction Amount (Local Currency)      
PR02050 NVARCHAR VSTRING 1 0 1 WIPStatus WIP Status 0 - WIP has not been updated for the activity line
1 - WIP has been updated for the activity line		    
PR02051 NVARCHAR VSTRING 1 0 1 FlReqNotePrn Request Note Print Status      
PR02052 NCHAR STRING 12 0 12 ReverIndLine Reversed Index Key      
PR02053 NVARCHAR VSTRING 1 0 1 FlaPrintDoc1 Document 1 Print Status      
PR02054 NVARCHAR VSTRING 1 0 1 FlaPrintDoc2 Document 2 Print Status      
PR02055 NVARCHAR VSTRING 1 0 1 FlaPrintDoc3 Document 3 Print Status      
PR02056 NVARCHAR VSTRING 1 0 1 FlaPrintDoc4 Document 4 Print Status      
PR02057 NVARCHAR VSTRING 1 0 1 FixPriceUnit Fixed Price Entered      
PR02058 NUMERIC X_NUMERIC 18 8 10 ExchangeRate1 Currency Exchange Rate 1      
PR02059 NUMERIC X_NUMERIC 18 8 10 ExchangeRate2 Currency Exchange Rate 2      
PR02060 NCHAR STRING 3 0 3 ExchangeAlgorithm Currency Exchange Algorithm      
PR02061 INT INTEGER 0 0 2 CurrencyCode Currency Code      
PR02062 NCHAR STRING 35 0 35 StockCode Stock Item Code      
PR02063 NCHAR STRING 10 0 10 Workorder Work Order      
PR02064 INT INTEGER 0 0 4 PlanStartTime Estimated Start Time      
PR02065 INT INTEGER 0 0 4 PlanEndTime Estimated End Time      
PR02066 NVARCHAR VSTRING 32 0 32 Line GUID Line GUID      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Project Activities