About This Guide > Budget
  
Budget
Budget
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Record ID
 
9999999999
 
 
BudgetCheckReportPeriod
Report Period Check
 
x(20)
 
 
BudgetCode
Budget Code
 
x(20)
 
 
BudgetDescription
Description
Budget Description
x(40)
 
 
BudgetForecastType
Forecast Type
 
x(20)
 
 
BudgetGroupCategory
Budget Group Category
 
9
 
 
BudgetInputLevelBudget
Input Level (Budget)
 
9
 
 
BudgetInputLevelEAC
Input Level (PM)
 
9
 
 
BudgetInputLevelFin
Input Level (Fin)
 
9
 
 
BudgetIsAutoRollUp
Auto Roll-Up
 
yes/no
 
 
BudgetIsCheckActualOnLine
Check Actuals Online
 
yes/no
 
 
BudgetIsCheckCommitOnLine
Check Commitments Online
 
yes/no
 
 
BudgetIsCompanyDependent
Entity Dependent
 
yes/no
 
 
BudgetIsFRWLinked
Use in Financial Report Writer
 
yes/no
 
 
BudgetIsReportStruct
Use as Report
 
yes/no
 
 
BudgetIsSendError
Send E-Mail on Errors
Error E-Mails
yes/no
 
 
BudgetIsSendWarning
Send E-Mail on Warnings
Warning E-Mails
yes/no
 
 
BudgetIsUsedForAllocation
Used for Allocation
 
yes/no
 
 
BudgetIsWithQuantityData
Use Quantity Info
 
yes/no
 
 
BudgetOverrunPeriod
GL Period Overrun
 
x(20)
 
 
BudgetOverrunTotal
Total Overrun
 
x(20)
 
 
BudgetOverrunYTD
Overrun (YTD)
 
x(20)
 
 
BudgetStatus
Status
 
x(20)
 
 
BudgetType
Budget Type
 
x(20)
 
 
CostCentre_ID
Cost Center Code
 
9999999999
 
 
CostCentreSharedSet_ID
Link to SharedSet
 
9999999999
 
 
Currency_ID
Currency Code
Curr
9999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
DivisionSharedSet_ID
Link to SharedSet
 
9999999999
 
 
FRWChart_ID
Link to FRWChart
 
9999999999
 
 
GLSharedSet_ID
Link to SharedSet
 
9999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Project_ID
Project Code
 
9999999999
 
 
ProjectSharedSet_ID
Link to SharedSet
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Usr_ID
Budget Administrator
 
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetCode
yes
BudgetCode
yes
no
 
BudgetIsCheckActOnLine
no
BudgetIsCheckActualOnLine
yes
no
 
BudgetIsCheckComOnLine
no
BudgetIsCheckCommitOnLine
yes
no
 
BudgetTypeIdx
no
BudgetType
yes
no
 
ChartIdx
no
FRWChart_ID
yes
no
 
CostCentre
no
CostCentre_ID
yes
no
 
CostCentreSharedSet
no
CostCentreSharedSet_ID
yes
no
 
Curency
no
Currency_ID
yes
no
 
DivisionSharedSet
no
DivisionSharedSet_ID
yes
no
 
GLSharedSet
no
GLSharedSet_ID
yes
no
 ∗
Prim
yes
Budget_ID
yes
no
 
Project
no
Project_ID
yes
no
 
ProjectSharedSet
no
ProjectSharedSet_ID
yes
no
 
StatusIdx
no
BudgetStatus
yes
no
 
UsedForAllocation
no
BudgetIsUsedForAllocation
yes
no
 
UsrIdx
no
Usr_ID
yes
no