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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PR34 — Project Budgets and Forecasts

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR34001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR34002 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project Sub-project is empty for budget values on project level (either specified on the project level or added up as totals from sub-project/activity level) 2 Да / Yes
PR34003 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number Activity line number is empty for budget values on sub-project level (either specified on the sub-project or added up as totals from the activity level) 3 Да / Yes
PR34004 NVARCHAR VSTRING 6 0 6 ActiStruLine Activity Sub-line Number   4 Да / Yes
PR34005 NVARCHAR VSTRING 2 0 2 BudgForecID Budget Code The budget code can be one of the following options:

A0-ZZ : A user defined budget code, entered in the project dictionary for budget coded

00-99 : One of the system budget codes, used for base line budget

*1 : Actual reported transactions

*2 : Invoiced

*3 : WIP Booked

*4 : WIP Reversed		 5 Да / Yes
PR34006 NVARCHAR VSTRING 4 0 4 BudgYear Budget Year Holds the budget year or is empty for cumulated budget (summary of all years). 6 Да / Yes
PR34007 NVARCHAR VSTRING 25 0 25 Description Description      
PR34008 NVARCHAR VSTRING 4 0 4 GLBEYear Financial Book-Entry Year      
PR34009 NVARCHAR VSTRING 1 0 1 GLBudgAltern General Ledger Budget Alternative      
PR34010 NVARCHAR VSTRING 1 0 1 GLBudgUpdate General Ledger Budget Updated      
PR34011 NVARCHAR VSTRING 1 0 1 BudUpdFrolow Budget Updated From Lower Level 0 — Budget value can be entered independently on any level, nothing is added up to a higher level.

1 — Budget values are entered on lower levels (sub-project, activity line) and added to the project level, bud can’t be entered directly on the project level (see also PR34109).		    
PR34012 NVARCHAR VSTRING 8 0 8 EnterByUser Created By      
PR34013 DATETIME DATE 0 0 8 DateEntered Date Created      
PR34014 NVARCHAR VSTRING 1 0 1 BudgetLocked Budget Locked 0 — Budget is open and new values can be entered.

1 — Budget is locked on no changes can be done to the specific budget code.		    
PR34015 DATETIME DATE 0 0 8 BudgLockDate Date Budget Locked      
PR34016 NVARCHAR VSTRING 8 0 8 BudgLockbyus Budget Locked By      
PR34017 INT INTEGER 0 0 2 NoOfPeriods Number of Budget Periods      
PR34018 NVARCHAR VSTRING 1 0 1 BudgSpliYear Budget Split into Years 0 — Budget has not been split into year and is entered as totals independent of the year.

1 — Budget has been split into year and budget needs to be specified on a year basis (See also PR34020).		    
PR34019 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
PR34020 NVARCHAR VSTRING 1 0 1 BudSplIntPer Budget Split into Periods 0 — Budget has not been split into period and is entered as totals or per year depending on PR34018.

1 — Budget has been split into periods and budget needs to be specified on a period basis according to the planning calendar in project.		    
PR34021 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
PR34022 NUMERIC X_NUMERIC 20 8 12 OBQtyHours Opening Balance Quantity/Hours      
PR34023 NUMERIC MONEY 28 8 20 CostUnitOB Opening Balance Cost (Local Currency)      
PR34024 NUMERIC MONEY 28 8 20 PricUnLCUOB Opening Balance Revenue (Local Currency)      
PR34025 NUMERIC MONEY 28 8 20 PricUnPCUOB Opening Balance Revenue (Project Currency)      
PR34026 NUMERIC X_NUMERIC 20 8 12 Period1QtyHr Period 1 Quantity/Hours      
PR34027 NUMERIC MONEY 28 8 20 CostUnitPer1 Period 1 Cost (Local Currency)      
PR34028 NUMERIC MONEY 28 8 20 PrUnLCUPer1 Period 1 Revenue (Local Currency)      
PR34029 NUMERIC MONEY 28 8 20 PrUnPCUPer1 Period 1 Revenue (Project Currency)      
PR34030 NUMERIC X_NUMERIC 20 8 12 Perio2QtyHrs Period 2 Quantity/Hours      
PR34031 NUMERIC MONEY 28 8 20 CostUnitPer2 Period 2 Cost (Local Currency)      
PR34032 NUMERIC MONEY 28 8 20 PrUnLCUPer2 Period 2 Revenue (Local Currency)      
PR34033 NUMERIC MONEY 28 8 20 PrUnPCUPer2 Period 2 Revenue (Project Currency)      
PR34034 NUMERIC X_NUMERIC 20 8 12 Perio3QtyHrs Period 3 Quantity/Hours      
PR34035 NUMERIC MONEY 28 8 20 CostUnitPer3 Period 3 Cost (Local Currency)      
PR34036 NUMERIC MONEY 28 8 20 PrUnLCUPer3 Period 3 Revenue (Local Currency)      
PR34037 NUMERIC MONEY 28 8 20 PrUnPCUPer3 Period 3 Revenue (Project Currency)      
PR34038 NUMERIC X_NUMERIC 20 8 12 Perio4QtyHrs Period 4 Quantity/Hours      
PR34039 NUMERIC MONEY 28 8 20 CostUnitPer4 Period 4 Cost (Local Currency)      
PR34040 NUMERIC MONEY 28 8 20 PrUnLCUPer4 Period 4 Revenue (Local Currency)      
PR34041 NUMERIC MONEY 28 8 20 PrUnPCUPer4 Period 4 Revenue (Project Currency)      
PR34042 NUMERIC X_NUMERIC 20 8 12 Perio5QtyHrs Period 5 Quantity/Hours      
PR34043 NUMERIC MONEY 28 8 20 CostUnitPer5 Period 5 Cost (Local Currency)      
PR34044 NUMERIC MONEY 28 8 20 PrUnLCUPer5 Period 5 Revenue (Local Currency)      
PR34045 NUMERIC MONEY 28 8 20 PrUnPCUPer5 Period 5 Revenue (Project Currency)      
PR34046 NUMERIC X_NUMERIC 20 8 12 Perio6QtyHrs Period 6 Quantity/Hours      
PR34047 NUMERIC MONEY 28 8 20 CostUnitPer6 Period 6 Cost (Local Currency)      
PR34048 NUMERIC MONEY 28 8 20 PrUnLCUPer6 Period 6 Revenue (Local Currency)      
PR34049 NUMERIC MONEY 28 8 20 PrUnPCUPer6 Period 6 Revenue (Project Currency)      
PR34050 NUMERIC X_NUMERIC 20 8 12 Perio7QtyHrs Period 7 Quantity/Hours      
PR34051 NUMERIC MONEY 28 8 20 CostUnitPer7 Period 7 Cost (Local Currency)      
PR34052 NUMERIC MONEY 28 8 20 PrUnLCUPer7 Period 7 Revenue (Local Currency)      
PR34053 NUMERIC MONEY 28 8 20 PrUnPCUPer7 Period 7 Revenue (Project Currency)      
PR34054 NUMERIC X_NUMERIC 20 8 12 Perio8QtyHrs Period 8 Quantity/Hours      
PR34055 NUMERIC MONEY 28 8 20 CostUnitPer8 Period 8 Cost (Local Currency)      
PR34056 NUMERIC MONEY 28 8 20 PrUnLCUPer8 Period 8 Revenue (Local Currency)      
PR34057 NUMERIC MONEY 28 8 20 PrUnPCUPer8 Period 8 Revenue (Project Currency)      
PR34058 NUMERIC X_NUMERIC 20 8 12 Perio9QtyHrs Period 9 Quantity/Hours      
PR34059 NUMERIC MONEY 28 8 20 CostUnitPer9 Period 9 Cost (Local Currency)      
PR34060 NUMERIC MONEY 28 8 20 PrUnLCUPer9 Period 9 Revenue (Local Currency)      
PR34061 NUMERIC MONEY 28 8 20 PrUnPCUPer9 Period 9 Revenue (Project Currency)      
PR34062 NUMERIC X_NUMERIC 20 8 12 Peri10QtyHrs Period 10 Quantity/Hours      
PR34063 NUMERIC MONEY 28 8 20 CostUniPer10 Period 10 Cost (Local Currency)      
PR34064 NUMERIC MONEY 28 8 20 PrUnLCUPer10 Period 10 Revenue (Local Currency)      
PR34065 NUMERIC MONEY 28 8 20 PrUnPCUPer10 Period 10 Revenue (Project Currency)      
PR34066 NUMERIC X_NUMERIC 20 8 12 Peri11QtyHrs Period 11 Quantity/Hours      
PR34067 NUMERIC MONEY 28 8 20 CostUnPer11 Period 11 Cost (Local Currency)      
PR34068 NUMERIC MONEY 28 8 20 PrUnLCUPer11 Period 11 Revenue (Local Currency)      
PR34069 NUMERIC MONEY 28 8 20 PrUnPCUPer11 Period 11 Revenue (Project Currency)      
PR34070 NUMERIC X_NUMERIC 20 8 12 Peri12QtyHrs Period 12 Quantity/Hours      
PR34071 NUMERIC MONEY 28 8 20 CostUniPer12 Period 12 Cost (Local Currency)      
PR34072 NUMERIC MONEY 28 8 20 PrUnLCUPer12 Period 12 Revenue (Local Currency)      
PR34073 NUMERIC MONEY 28 8 20 PrUnPCUPer12 Period 12 Revenue (Project Currency)      
PR34074 NUMERIC X_NUMERIC 20 8 12 Peri13QtyHrs Period 13 Quantity/Hours      
PR34075 NUMERIC MONEY 28 8 20 CostUniPer13 Period 13 Cost (Local Currency)      
PR34076 NUMERIC MONEY 28 8 20 PrUnLCUPer13 Period 13 Revenue (Local Currency)      
PR34077 NUMERIC MONEY 28 8 20 PrUnPCUPer13 Period 13 Revenue (Project Currency)      
PR34078 NUMERIC X_NUMERIC 20 8 12 Peri14QtyHrs Period 14 Quantity/Hours      
PR34079 NUMERIC MONEY 28 8 20 CostUniPer14 Period 14 Cost (Local Currency)      
PR34080 NUMERIC MONEY 28 8 20 PrUnLCUPer14 Period 14 Revenue (Local Currency)      
PR34081 NUMERIC MONEY 28 8 20 PrUnPCUPer14 Period 14 Revenue (Project Currency)      
PR34082 NUMERIC X_NUMERIC 20 8 12 Peri15QtyHrs Period 15 Quantity/Hours      
PR34083 NUMERIC MONEY 28 8 20 CostUniPer15 Period 15 Cost (Local Currency)      
PR34084 NUMERIC MONEY 28 8 20 PrUnLCUPer15 Period 15 Revenue (Local Currency)      
PR34085 NUMERIC MONEY 28 8 20 PrUnPCUPer15 Period 15 Revenue (Project Currency)      
PR34086 NUMERIC X_NUMERIC 20 8 12 Peri16QtyHrs Period 16 Quantity/Hours      
PR34087 NUMERIC MONEY 28 8 20 CostUniPer16 Period 16 Cost (Local Currency)      
PR34088 NUMERIC MONEY 28 8 20 PrUnLCUPer16 Period 16 Revenue (Local Currency)      
PR34089 NUMERIC MONEY 28 8 20 PrUnPCUPer16 Period 16 Revenue (Project Currency)      
PR34090 NUMERIC X_NUMERIC 20 8 12 Peri17QtyHrs Period 17 Quantity/Hours      
PR34091 NUMERIC MONEY 28 8 20 CostUniPer17 Period 17 Cost (Local Currency)      
PR34092 NUMERIC MONEY 28 8 20 PrUnLCUPer17 Period 17 Revenue (Local Currency)      
PR34093 NUMERIC MONEY 28 8 20 PrUnPCUPer17 Period 17 Revenue (Project Currency)      
PR34094 NUMERIC X_NUMERIC 20 8 12 Peri18QtyHrs Period 18 Quantity/Hours      
PR34095 NUMERIC MONEY 28 8 20 CostUnitPer18 Period 18 Cost (Local Currency)      
PR34096 NUMERIC MONEY 28 8 20 PrUnLCUPer18 Period 18 Revenue (Local Currency)      
PR34097 NUMERIC MONEY 28 8 20 PrUnPCUPer18 Period 18 Revenue (Project Currency)      
PR34098 NUMERIC X_NUMERIC 20 8 12 CBQtyHrs Closing Balance Quantity/Hours      
PR34099 NUMERIC MONEY 28 8 20 CostUnitCB Closing Balance Cost (Local Currency)      
PR34100 NUMERIC MONEY 28 8 20 PriUniLCUCB Closing Balance Revenue (Local Currency)      
PR34101 NUMERIC MONEY 28 8 20 PrUnitPCUCB Closing Balance Revenue (Project Currency)      
PR34102 NUMERIC X_NUMERIC 20 8 12 RemainQtyHrs Remaining Quantity/Hours      
PR34103 NUMERIC MONEY 28 8 20 CostUnitRema Remaining Cost (Local Currency)      
PR34104 NUMERIC MONEY 28 8 20 PrUnitLCURem Remaining Revenue (Local Currency)      
PR34105 NUMERIC MONEY 28 8 20 PrUnitPCURem Remaining Revenue (Project Currency)      
PR34106 NVARCHAR VSTRING 1 0 1 AutUpdCosAct Automatic Update from Cost Activity      
PR34107 NVARCHAR VSTRING 1 0 1 AutUpdTimAct Automatic Update from Time Activity      
PR34108 NVARCHAR VSTRING 1 0 1 AutUpdMtrAct Automatic Update from Material Activity      
PR34109 NVARCHAR VSTRING 1 0 1 Spare Entry Level Defines from which level budget is entered when it’s specified to be updated from lower levels (see PR34011).

0 — Budget is entered on activity level

1 — Budget is entered on sub-project level.		    
PR34110 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR34111 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR34112 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR34113 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR34114 NCHAR STRING 3 0 3 ReasonCodeEstimLock Reason Code of Estimate Locking      

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

Добавить комментарий