About This Guide > BudgetWBS
  
BudgetWBS
Budget Topic
 
 
Field Name
Label
Col-Label
Format
Dec
 
AltCOAGroup_ID
Alternate COA Group
 
9999999999
 
 
Budget_ID
Link to Budget
 
9999999999
 
 
BudgetFDS_ID
Link to BudgetFDS
 
9999999999
 
 
BudgetFDSSeq
COA Sequence
 
->,>>>,>>9
 
 
BudgetFDSType
COA Type
 
x(20)
 
 
BudgetGroup_ID
Budget Group
 
9999999999
 
 
BudgetWBS_ID
Record ID
 
9999999999
 
 
BudgetWBSCategory
Category
 
x(20)
 
 
BudgetWBSCode
WBS Code
 
x(40)
 
 
BudgetWBSComment
Comment
 
x(2000)
 
 
BudgetWBSCostRevenue
Cost/Revenue
 
x(20)
 
 
BudgetWBSCostType
Cost Type
 
x(20)
 
 
BudgetWBSFDSCode
COA Code
 
x(20)
 
 
BudgetWBSFDSDefault
COA Default
 
x(20)
 
 
BudgetWBSFDSFromCode
From COA
 
x(20)
 
 
BudgetWBSFDSLink
Link by Level
 
x(1024)
 
 
BudgetWBSFDSList
COA List
 
x(1024)
 
 
BudgetWBSFDSToCode
To COA
 
x(20)
 
 
BudgetWBSIsHideOnReport
Hide On Reporting
 
yes/no
 
 
BudgetWBSIsInvertBase
Invert Base Sign
 
yes/no
 
 
BudgetWBSIsPrintDesc
Print Description
 
yes/no
 
 
BudgetWBSIsRollUp
Roll Up Amount
 
yes/no
 
 
BudgetWBSIsWithSumLine
Print Sum Line
 
yes/no
 
 
BudgetWBSLineNumber
Class
 
->,>>>,>>9
 
 
BudgetWBSOverrunPeriod
GL Period Overrun
 
x(20)
 
 
BudgetWBSOverrunTotal
Total Overrun
 
x(20)
 
 
BudgetWBSOverrunYTD
Overrun (YTD)
 
x(20)
 
 
BudgetWBSPercOfComp
Percentage (ETC)
 
->,>>>,>>9.99
3
 
BudgetWBSSeq
WBS Seq
 
>>>,>>>,>>>,>>9
0
 
BudgetWBSStatus
Status
 
x(20)
 
 
BudgetWBSTopicDescription
Topic Description
 
x(120)
 
 
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)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
ParentBudgetWBS_ID
Link to BudgetWBS
 
9999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SafConcept_ID
SAF Concept Code
 
9999999999
 
 
SafStructure_ID
SAF Structure
 
9999999999
 
 
Unit_ID
GL Account Unit of Measure
UM
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AltCOAGroup
no
AltCOAGroup_ID
yes
no
 
Budget
no
Budget_ID
yes
no
 
BudgetFDS
no
BudgetFDS_ID
yes
no
 
BudgetGroup
no
BudgetGroup_ID
yes
no
 
BudgetIDBudgetWBSSq
no
Budget_ID
yes
no
 
 
 
BudgetWBSSeq
yes
no
 
BudgetWBSCode
no
BudgetWBSCode
yes
no
 
BudgetWBSFDSFrom
no
BudgetWBSFDSFromCode
yes
no
 
BudgetWBSFDSTo
no
BudgetWBSFDSToCode
yes
no
 
BudgetWBSSeq
no
BudgetWBSSeq
yes
no
 
OverrunPeriodIdx
no
BudgetWBSOverrunPeriod
yes
no
 
OverrunTotalIdx
no
BudgetWBSOverrunTotal
yes
no
 
OverrunYTDIdx
no
BudgetWBSOverrunYTD
yes
no
 
ParentBudgetWBS
no
ParentBudgetWBS_ID
yes
no
 ∗
Prim
yes
BudgetWBS_ID
yes
no
 
SafConcept
no
SafConcept_ID
yes
no
 
SafStructure
no
SafStructure_ID
yes
no
 
UniqueIdx
yes
Budget_ID
yes
no
 
 
 
BudgetFDS_ID
yes
no
 
 
 
BudgetWBSSeq
yes
no
 
UnitIdx
no
Unit_ID
yes
no