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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PR02 — Project Activities

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR02001 NCHAR STRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR02002 NCHAR STRING 6 0 6 SubProject Sub-Project   2 Да / Yes
PR02003 NCHAR STRING 6 0 6 ActivityLine Activity Line Number   3 Да / Yes
PR02004 NCHAR STRING 6 0 6 ActiStruLine Activity Sub-line Number   4 Да / Yes
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 120 0 120 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 FctDebRevenueLCU 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 36 0 36 LineGUID External ID      
PR02067 NCHAR STRING 1 0 1 FixedRevenue Fixed Revenue      
PR02068 NCHAR STRING 1 0 1 IncludeInRevenueRcgn Included into Revenue Recognition      
PR02069 NUMERIC MONEY 28 8 20 ActivityRevenuePCU Activity Revenue PCU      
PR02070 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved Credit Limit      
PR02071 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PR02072 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
PR02073 NVARCHAR VSTRING 25 0 25 NCMCode NCM Code      
PR02074 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
PR02075 NCHAR STRING 3 0 3 TaxationReasonCode Taxation Reason Code      

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