QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
bom_mstr
Product Structure (Bill of Material) Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
bom__chr01
 
 
x(8)
 
 
bom__chr02
 
 
x(8)
 
 
bom__chr03
 
 
x(8)
 
 
bom__chr04
 
 
x(8)
 
 
bom__chr05
 
 
x(8)
 
 
bom__dec01
 
 
>>>,>>>,>>9.99
10
 
bom__dec02
 
 
>>>,>>>,>>9.99
10
 
bom__dte01
 
 
99/99/99
 
 
bom__dte02
 
 
99/99/99
 
 
bom__log01
 
 
yes/no
 
 
bom__qadc01
QAD Character Field
 
X(8)
0
 
bom__qadc02
QAD Character Field
 
X(8)
0
 
bom__qadc03
QAD Character field
 
X(8)
0
 
bom__qadd01
QAD Decimal Field
 
->>,>>9.99
10
 
bom__qadi01
QAD Integer Field
 
->,>>>,>>9
 
 
bom__qadi02
QAD Integer Field
 
->,>>>,>>9
 
 
bom__qadl01
QAD Logical Field
 
yes/no
 
 
bom__qadl02
QAD Logical Field
 
yes/no
 
 
bom__qadt01
QAD Date Field
 
99/99/99
 
 
bom__qadt02
QAD Date Field
 
99/99/99
 
 
bom_batch
Batch Size
 
>>>,>>>,>>9.9<<<<<<<<
10
 
bom_batch_um
UM
 
x(2)
 
 
bom_cmtindx
Comment Index
Comment
>>>,>>>,>>9
 
 
bom_desc
Description
 
x(24)
 
 
bom_domain
Domain
 
x(8)
 
 
bom_formula
Formula
 
yes/no
 
 
bom_fsm_type
FSM Type
 
x(8)
 
 
bom_ll_code
Low Level
Low Lvl
->>>>>9
 
 
bom_loc
Home Location
 
X(8)
 
 
bom_mod_date
Modified Date
Mod Date
99/99/99
 
 
bom_mthd
Backflush Mthd
BM
x(1)
 
 
bom_mthd_qtycompl
Qty Complete Mthd
QtyComp!Mthd
x(8)
 
 
bom_parent
BOM Code
 
x(18)
 
 
bom_site
Home Site
 
X(8)
 
 
bom_user1
Ufld1
 
x(8)
 
 
bom_user2
Ufld2
 
x(8)
 
 
bom_userid
User ID
 
x(8)
 
 
oid_bom_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
bom_fsm_type
no
bom_domain
yes
no
 
 
 
bom_fsm_type
yes
no
 
 
 
bom_parent
yes
no
bom_parent
yes
bom_domain
yes
no
 
 
 
bom_parent
yes
no
 
oid_bom_mstr
yes
oid_bom_mstr
yes
no
bopd_det
Bill Of Packaging Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
bopd__qadc01
 
 
x(24)
 
 
bopd__qadc02
 
 
x(24)
 
 
bopd__qadc03
 
 
x(24)
 
 
bopd__qadc04
 
 
x(24)
 
 
bopd__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bopd__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bopd_content_um
UM
 
x(2)
 
 
bopd_dataset
Content Type
 
x(18)
 
 
bopd_label_format
Label Format
 
x(30)
 
 
bopd_mod_date
Modified Date
Mod Date
99/99/99
 
 
bopd_mod_userid
User ID
 
x(8)
 
 
bopd_qty_per
Quantity Per
 
->,>>>,>>9.9<<<<<<<<
10
 
bopd_serialized
Serialized
 
>9
 
 
bopd_stack_level
Stacking Level
 
>>9
 
 
bopd_user1
User Field Character 1
 
x(24)
 
 
bopd_user2
User Field Character 2
 
x(24)
 
 
oid_bop_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_bopd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_dataset
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_pckc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bopd_mstr_pack
yes
oid_bop_mstr
yes
no
 
 
 
oid_pckc_mstr
yes
no
 
oid_bopd_det
yes
oid_bopd_det
yes
no
 
oid_pckc_mstr
no
oid_pckc_mstr
yes
no
bop_mstr
Bill Of Packaging Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
bop__qadc01
 
 
x(24)
 
 
bop__qadc02
 
 
x(24)
 
 
bop__qadc03
 
 
x(24)
 
 
bop__qadc04
 
 
x(24)
 
 
bop__qadc05
 
 
x(24)
 
 
bop__qadc06
 
 
x(24)
 
 
bop__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bop__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bop__qadd03
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bop__qadd04
 
 
->>>,>>>,>>9.9<<<<<<<<
10
 
bop_code
BOP Code
 
x(18)
 
 
bop_desc
Description
 
x(24)
 
 
bop_domain
Domain
 
x(8)
 
 
bop_margin
Margin
 
>>9.99%
10
 
bop_mod_date
Modified Date
Mod Date
99/99/99
 
 
bop_mod_userid
User ID
 
x(8)
 
 
bop_start_date
Start Date
 
99/99/99
 
 
bop_user1
User Field Character 1
 
x(24)
 
 
bop_user2
User Field Character 2
 
x(24)
 
 
oid_bop_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bop_code_start
yes
bop_domain
yes
no
 
 
 
bop_code
yes
no
 
 
 
bop_start_date
yes
no
 
oid_bop_mstr
yes
oid_bop_mstr
yes
no
Box1099
1099 Box
 
 
Field Name
Label
Col-Label
Format
Dec
 
Box1099_ID
Record ID
 
-99999999999
 
 
Box1099CalendarYear
Calendar Year
 
9999
 
 
Box1099Code
1099 Box Code
 
x(8)
 
 
Box1099Description
Description
 
x(40)
 
 
Box1099IsActive
Active
 
yes/no
 
 
Box1099MinimumAmountLC
Minimum Amount
 
->>>,>>>,>>>,>>9.99
4
 
Box1099Reference
1099 Box Reference
 
x(8)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CodeYearActive
no
Box1099Code
yes
no
 
 
 
Box1099CalendarYear
yes
no
 
 
 
Box1099IsActive
yes
no
 ∗
Prim
yes
Box1099_ID
yes
no
 
UniqueIdx
yes
Box1099Code
yes
no
 
 
 
Box1099Reference
yes
no
 
 
 
Box1099CalendarYear
yes
no
Box1099PurchaseTypeLink
1099 Box Purchase Type Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
Box1099_ID
Link to Box1099
 
-99999999999
 
 
Box1099PurchaseTypeLink_ID
Record ID
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PurchaseType_ID
Purchase Type
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Box
no
Box1099_ID
yes
no
 ∗
Prim
yes
Box1099PurchaseTypeLink_ID
yes
no
 
PurTp
no
PurchaseType_ID
yes
no
 
Uniq
yes
Box1099_ID
yes
no
 
 
 
PurchaseType_ID
yes
no
btb_det
Enterprise Material Transfer Primary Business Unit Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
btb__qadc01
 
 
x(8)
 
 
btb_cm_addr
End Customer
End Cust
x(8)
 
 
btb_cm_desc
Description
 
x(24)
 
 
btb_cm_part
End Customer Item
 
x(18)
 
 
btb_domain
Domain
 
x(8)
 
 
btb_mod_date
Modified Date
Mod Date
99/99/99
 
 
btb_mod_userid
User ID
 
x(16)
 
 
btb_pr_so
Primary SO
 
x(8)
 
 
btb_pr_sod_line
Primary SO Line
Pr SO Ln
>>9
 
 
btb_so
Secondary SO
Sec SO
x(8)
 
 
btb_so_price
Primary SO Price
Pr SO Price
>>>>,>>>,>>9.99<<<
10
 
btb_sod_line
Secondary SO Line
Sec SO Ln
>>9
 
 
btb_user1
Ufld1
 
x(8)
 
 
btb_user2
Ufld2
 
x(8)
 
 
oid_btb_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
btb_so
yes
btb_domain
yes
no
 
 
 
btb_so
yes
no
 
 
 
btb_sod_line
yes
no
 
oid_btb_det
yes
oid_btb_det
yes
no
btrd_det
Blocked Transaction Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
btrd__qadc01
 
 
x(24)
 
 
btrd__qadc02
 
 
x(24)
 
 
btrd_mod_date
Modified Date
Mod Date
99/99/99
 
 
btrd_mod_userid
User ID
 
x(8)
 
 
btrd_user1
User Field Character 1
 
x(24)
 
 
btrd_user2
User Field Character 2
 
x(24)
 
 
oid_btr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_btrd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lngd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
btrd_oid_btr_mstr
yes
oid_btr_mstr
yes
no
 
 
 
oid_btrd_det
yes
no
 
oid_btrd_det
yes
oid_btrd_det
yes
no
btr_mstr
Blocked Transaction Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
btr__qadc01
 
 
x(24)
 
 
btr__qadc02
 
 
x(24)
 
 
btr_blocked_trans_code
Blocked Code
 
x(8)
 
 
btr_desc
Description
 
x(24)
 
 
btr_domain
Domain
 
x(8)
 
 
btr_mod_date
Modified Date
Mod Date
99/99/99
 
 
btr_mod_userid
User ID
 
x(8)
 
 
btr_user1
User Field Character 1
 
x(24)
 
 
btr_user2
User Field Character 2
 
x(24)
 
 
oid_btr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
btr_blocked_code
yes
btr_domain
yes
no
 
 
 
btr_blocked_trans_code
yes
no
 
oid_btr_mstr
yes
oid_btr_mstr
yes
no
Budget
Budget
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Record ID
 
-99999999999
 
 
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
 
-99999999999
 
 
CostCentreSharedSet_ID
Link to SharedSet
 
-99999999999
 
 
Currency_ID
Currency Code
Curr
-99999999999
 
 
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
 
-99999999999
 
 
FRWChart_ID
Link to FRWChart
 
-99999999999
 
 
GLSharedSet_ID
Link to SharedSet
 
-99999999999
 
 
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
 
-99999999999
 
 
ProjectSharedSet_ID
Link to SharedSet
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Usr_ID
Budget Administrator
 
-99999999999
 
 
 
 
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
BudgetCompany
Budget Entity
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetCompany_ID
Record ID
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetIdx
no
Budget_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 ∗
Prim
yes
BudgetCompany_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
Budget_ID
yes
no
BudgetFDS
Budget COA
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetFDS_ID
Record ID
 
-99999999999
 
 
BudgetFDSIsAllocationTotal
Used for Proportional Allocation
 
yes/no
 
 
BudgetFDSSeq
WBS Level
 
->,>>>,>>9
 
 
BudgetFDSType
COA Element
 
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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Budget
no
Budget_ID
yes
no
 
BudgetFDSSeqIdx
no
BudgetFDSSeq
yes
no
 ∗
Prim
yes
BudgetFDS_ID
yes
no
 
UniqueIdx
yes
Budget_ID
yes
no
 
 
 
BudgetFDSSeq
yes
no
BudgetGroup
Budget Group
 
 
Field Name
Label
Col-Label
Format
Dec
 
BudgetGroup_ID
Record ID
 
-99999999999
 
 
BudgetGroupCategory
Budget Group Category
 
9
 
 
BudgetGroupCode
Budget Group
 
x(20)
 
 
BudgetGroupDescription
Description
 
x(40)
 
 
BudgetGroupIsActive
Active
 
yes/no
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetGroupActive
no
BudgetGroupIsActive
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
BudgetGroup_ID
yes
no
 
UniqueIdx
yes
BudgetGroupCode
yes
no
 
 
 
BudgetGroupCategory
yes
no
 
ViewIndex
no
BudgetGroupIsActive
yes
no
 
 
 
BudgetGroupCode
yes
no
BudgetLink
Budget Posting Commitment Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetLink_ID
Record ID
 
-99999999999
 
 
BudgetLinkActualQTY
Quantity
Qty
->>>,>>>,>>9.99999
10
 
BudgetLinkActualSalesQTY
Sales Quantity
 
->>>,>>>,>>9.99999
10
 
BudgetLinkActualSalesTC
Sales Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkActualTC
Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkCommitQTY
Commitment Quantity
 
->>>,>>>,>>9.99999
10
 
BudgetLinkCommitTC
Commitment Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetPeriod_ID
Link to BudgetPeriod
 
-99999999999
 
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetIdx
no
Budget_ID
yes
no
 
BudgetPeriodIdx
no
BudgetPeriod_ID
yes
no
 
BudgetWBSBudgetIdx
yes
BudgetWBS_ID
yes
no
 
 
 
BudgetPeriod_ID
yes
no
 
BudgetWBSId
no
BudgetWBS_ID
yes
no
 ∗
Prim
yes
BudgetLink_ID
yes
no
BudgetLinkAcc
Budget Accumulation by Period
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetLinkAcc_ID
Record ID
 
-99999999999
 
 
BudgetLinkAccCreditCC
SC Credit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccCreditLC
BC Credit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccDebitCC
SC Debit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccDebitLC
BC Debit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccQTY
Qty
 
->>>,>>>,>>9.99999
10
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
Layer_ID
Link to Layer
 
-99999999999
 
 
Period_ID
Link to Period
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Budget
no
Budget_ID
yes
no
 
BudgetWBS
no
BudgetWBS_ID
yes
no
 
Period
no
Period_ID
yes
no
 ∗
Prim
yes
BudgetLinkAcc_ID
yes
no
 
UniqueIdx
yes
Period_ID
yes
no
 
 
 
BudgetWBS_ID
yes
no
 
 
 
Layer_ID
yes
no
BudgetLinkAccDet
Budget Accumulation by Sub-ledger
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetLinkAccDet_ID
Record ID
 
-99999999999
 
 
BudgetLinkAccDetCreditLC
BC Credit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccDetDebitLC
BC Debit
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkAccDetQTY
Qty
 
->>>,>>>,>>9.99999
10
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
CostCentre_ID
Link to CostCentre
 
-99999999999
 
 
Division_ID
Link to Division
 
-99999999999
 
 
Layer_ID
Link to Layer
 
-99999999999
 
 
Period_ID
Link to Period
 
-99999999999
 
 
Project_ID
Link to Project
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Saf_ID
Link to Saf
 
-99999999999
 
 
SafConcept_ID
Link to SafConcept
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Budget
no
Budget_ID
yes
no
 
BudgetWBS
no
BudgetWBS_ID
yes
no
 
CostCentre
no
CostCentre_ID
yes
no
 
Division
no
Division_ID
yes
no
 
Period
no
Period_ID
yes
no
 ∗
Prim
yes
BudgetLinkAccDet_ID
yes
no
 
Project
no
Project_ID
yes
no
 
Saf
no
Saf_ID
yes
no
 
SafConcept
no
SafConcept_ID
yes
no
 
UniqueIdx
yes
BudgetWBS_ID
yes
no
 
 
 
Period_ID
yes
no
 
 
 
Saf_ID
yes
no
 
 
 
Project_ID
yes
no
 
 
 
CostCentre_ID
yes
no
 
 
 
Division_ID
yes
no
 
 
 
Layer_ID
yes
no
BudgetLinkActual
Budget Posting Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Budget
 
-99999999999
 
 
BudgetLinkActual_ID
Record ID
 
-99999999999
 
 
BudgetLinkActualCCCode
Cost Center
 
x(20)
 
 
BudgetLinkActualDate
Posting Date
 
99/99/9999
 
 
BudgetLinkActualDivCode
Sub-Account
Sub-Acct
x(20)
 
 
BudgetLinkActualGLCode
GL Account
GL
x(20)
 
 
BudgetLinkActualInfo
Info
 
x(40)
 
 
BudgetLinkActualIsAfterRep
After Reporting
 
yes/no
 
 
BudgetLinkActualPrjCode
Project Code
Project
x(20)
 
 
BudgetLinkActualQTY
Quantity
Qty
->>>,>>>,>>9.99999
10
 
BudgetLinkActualSaf1Code
SAF 1
 
x(20)
 
 
BudgetLinkActualSaf1Concpt
SAF Concept 1
 
x(20)
 
 
BudgetLinkActualSaf2Code
SAF 2
 
x(20)
 
 
BudgetLinkActualSaf2Concpt
SAF Concept 2
 
x(20)
 
 
BudgetLinkActualSaf3Code
SAF 3
 
x(20)
 
 
BudgetLinkActualSaf3Concpt
SAF Concept 3
 
x(20)
 
 
BudgetLinkActualSaf4Code
SAF 4
 
x(20)
 
 
BudgetLinkActualSaf4Concpt
SAF Concept 4
 
x(20)
 
 
BudgetLinkActualSaf5Code
SAF 5
 
x(20)
 
 
BudgetLinkActualSaf5Concpt
SAF Concept 5
 
x(20)
 
 
BudgetLinkActualSafStruct
SAF Structure
 
x(20)
 
 
BudgetLinkActualSalesQTY
Sales Quantity
 
->>>,>>>,>>9.99999
10
 
BudgetLinkActualSalesTC
Sales Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetLinkActualTC
Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetPeriod_ID
Budget Period
 
-99999999999
 
 
BudgetWBS_ID
Budget WBS
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
Journal_ID
Link to Journal
 
-99999999999
 
 
Layer_ID
Link to Layer
 
-99999999999
 
 
LayerTypeCode
Layer Type Code
 
x(20)
 
 
PostingLine_ID
Link to PostingLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
ReportPeriod_ID
Link to ReportPeriod
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetDate
no
Budget_ID
yes
no
 
 
 
BudgetLinkActualDate
yes
no
 
BudgetPeriod
no
BudgetPeriod_ID
yes
no
 
BudgetWBSIdx
no
BudgetWBS_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
CostCentre
no
BudgetLinkActualCCCode
yes
no
 
DateIdx
no
BudgetLinkActualDate
yes
no
 
DivIdx
no
BudgetLinkActualDivCode
yes
no
 
GLIdx
no
BudgetLinkActualGLCode
yes
no
 
JrnlIdx
no
Journal_ID
yes
no
 
LayerIDIdx
no
Layer_ID
yes
no
 
LayerTpCode
no
LayerTypeCode
yes
no
 
PostingLine
no
PostingLine_ID
yes
no
 ∗
Prim
yes
BudgetLinkActual_ID
yes
no
 
ProjectIdx
no
BudgetLinkActualPrjCode
yes
no
 
RepPdIdx
no
ReportPeriod_ID
yes
no
 
SafStructure
no
BudgetLinkActualSafStruct
yes
no
BudgetLinkCommit
Budget Commitment Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Budget
 
-99999999999
 
 
BudgetLinkCommit_ID
Record ID
 
-99999999999
 
 
BudgetLinkCommitCCCode
Cost Center
 
x(20)
 
 
BudgetLinkCommitDate
Commitment Date
 
99/99/9999
 
 
BudgetLinkCommitDivCode
Sub-Account
Sub-Acct
x(20)
 
 
BudgetLinkCommitExternKey
External Key
 
x(20)
 
 
BudgetLinkCommitGLCode
GL Account
GL
x(20)
 
 
BudgetLinkCommitInfo
Info
 
x(40)
 
 
BudgetLinkCommitIsExternal
External
 
yes/no
 
 
BudgetLinkCommitPrjCode
Project
 
x(20)
 
 
BudgetLinkCommitQTY
Qty
 
->>>,>>>,>>9.99999
10
 
BudgetLinkCommitSaf1Code
SAF 1
 
x(20)
 
 
BudgetLinkCommitSaf1Concpt
SAF Concept 1
 
x(20)
 
 
BudgetLinkCommitSaf2Code
SAF 2
 
x(20)
 
 
BudgetLinkCommitSaf2Concpt
SAF Concept 2
 
x(20)
 
 
BudgetLinkCommitSaf3Code
SAF 3
 
x(20)
 
 
BudgetLinkCommitSaf3Concpt
SAF Concept 3
 
x(20)
 
 
BudgetLinkCommitSaf4Code
SAF 4
 
x(20)
 
 
BudgetLinkCommitSaf4Concpt
SAF Concept 4
 
x(20)
 
 
BudgetLinkCommitSaf5Code
SAF 5
 
x(20)
 
 
BudgetLinkCommitSaf5Concpt
SAF Concept 5
 
x(20)
 
 
BudgetLinkCommitSafStruct
SAF Structure
 
x(20)
 
 
BudgetLinkCommitTC
TC Amount
 
->>>,>>>,>>>,>>9.99
4
 
BudgetPeriod_ID
Budget Period
 
-99999999999
 
 
BudgetWBS_ID
BudgetWBS
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
POLine_ID
Purchase Order
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetDate
no
Budget_ID
yes
no
 
 
 
BudgetLinkCommitDate
yes
no
 
BudgetIdx
no
Budget_ID
yes
no
 
BudgetPeriod
no
BudgetPeriod_ID
yes
no
 
BudgetWBSIdx
no
BudgetWBS_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
DateIdx
no
BudgetLinkCommitDate
yes
no
 
ExternalKey
no
BudgetLinkCommitIsExternal
yes
no
 
 
 
BudgetLinkCommitExternKey
yes
no
 
NonUniq
no
BudgetLinkCommitExternKey
yes
no
 
POLine
no
POLine_ID
yes
no
 ∗
Prim
yes
BudgetLinkCommit_ID
yes
no
BudgetPeriod
Budget Period
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetPeriod_ID
Record ID
 
-99999999999
 
 
BudgetPeriodCode
Period Code
 
x(20)
 
 
BudgetPeriodFromDate
Start Date
 
99/99/9999
 
 
BudgetPeriodSeq
GL Period Seq
 
->,>>>,>>9
 
 
BudgetPeriodTillDate
End Date
 
99/99/9999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Budget
no
Budget_ID
yes
no
 
BudgetPeriodSeq
yes
Budget_ID
yes
no
 
 
 
BudgetPeriodSeq
yes
no
 
Code
yes
Budget_ID
yes
no
 
 
 
BudgetPeriodCode
yes
no
 
FromDate
no
Budget_ID
yes
no
 
 
 
BudgetPeriodFromDate
yes
no
 ∗
Prim
yes
BudgetPeriod_ID
yes
no
 
TillDate
no
Budget_ID
yes
no
 
 
 
BudgetPeriodTillDate
yes
no
BudgetReport
Budget Report
 
 
Field Name
Label
Col-Label
Format
Dec
 
BudgetProjectCode
Project Code
 
x(20)
 
 
BudgetProjectDescription
Project Description
 
x(40)
 
 
BudgetTopicAct1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicBud1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicBud2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicBud3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicBud4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCode1
 
 
x(20)
 
 
BudgetTopicCode2
 
 
x(20)
 
 
BudgetTopicCode3
 
 
x(20)
 
 
BudgetTopicCode4
 
 
x(20)
 
 
BudgetTopicCom1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicDescription1
 
 
x(40)
 
 
BudgetTopicDescription2
 
 
x(40)
 
 
BudgetTopicDescription3
 
 
x(40)
 
 
BudgetTopicDescription4
 
 
x(40)
 
 
BudgetTopicEtc1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicEtc2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicEtc3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicEtc4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicSequence1
 
 
->,>>>,>>9
 
 
BudgetTopicSequence2
 
 
->,>>>,>>9
 
 
BudgetTopicSequence3
 
 
->,>>>,>>9
 
 
BudgetTopicSequence4
 
 
->,>>>,>>9
 
 
BudgetVersionNumber
Version
 
->,>>>,>>9
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
DummyPrim
yes
BudgetProjectCode
yes
no
 
 
 
BudgetVersionNumber
yes
no
 
 
 
BudgetTopicCode1
yes
no
 
 
 
BudgetTopicCode2
yes
no
 
 
 
BudgetTopicCode3
yes
no
 
 
 
BudgetTopicCode4
yes
no
 
Project
no
BudgetProjectCode
yes
no
 
Sequence1
no
BudgetTopicSequence1
yes
no
 
Sequence2
no
BudgetTopicSequence2
yes
no
 
Sequence3
no
BudgetTopicSequence3
yes
no
 
Sequence4
no
BudgetTopicSequence4
yes
no
 
Topic1
no
BudgetTopicCode1
yes
no
 
Topic2
no
BudgetTopicCode2
yes
no
 
Topic3
no
BudgetTopicCode3
yes
no
 
Topic4
no
BudgetTopicCode4
yes
no
BudgetReportDetail
Budget Report Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
BudgetProjectCode
Project Code
 
x(20)
 
 
BudgetProjectDescription
Project Description
 
x(40)
 
 
BudgetTopicAct1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicAct4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCode1
 
 
x(20)
 
 
BudgetTopicCode2
 
 
x(20)
 
 
BudgetTopicCode3
 
 
x(20)
 
 
BudgetTopicCode4
 
 
x(20)
 
 
BudgetTopicCom1LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom2LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom3LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicCom4LC
 
 
->>>,>>>,>>>,>>9.99
4
 
BudgetTopicDescription1
 
 
x(40)
 
 
BudgetTopicDescription2
 
 
x(40)
 
 
BudgetTopicDescription3
 
 
x(40)
 
 
BudgetTopicDescription4
 
 
x(40)
 
 
BudgetTopicFDSCode
FDS Code
 
x(40)
 
 
BudgetTopicSequence1
 
 
->,>>>,>>9
 
 
BudgetTopicSequence2
 
 
->,>>>,>>9
 
 
BudgetTopicSequence3
 
 
->,>>>,>>9
 
 
BudgetTopicSequence4
 
 
->,>>>,>>9
 
 
BudgetTopicVoucherString
Voucher
 
x(40)
 
 
BudgetVersionNumber
Version
 
->,>>>,>>9
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
DummyPrim
yes
BudgetProjectCode
yes
no
 
 
 
BudgetVersionNumber
yes
no
 
 
 
BudgetTopicCode1
yes
no
 
 
 
BudgetTopicCode2
yes
no
 
 
 
BudgetTopicCode3
yes
no
 
 
 
BudgetTopicCode4
yes
no
 
 
 
BudgetTopicVoucherString
yes
no
 
Project
no
BudgetProjectCode
yes
no
 
Sequence1
no
BudgetTopicSequence1
yes
no
 
Sequence2
no
BudgetTopicSequence2
yes
no
 
Sequence3
no
BudgetTopicSequence3
yes
no
 
Sequence4
no
BudgetTopicSequence4
yes
no
 
Topic1
no
BudgetTopicCode1
yes
no
 
Topic2
no
BudgetTopicCode2
yes
no
 
Topic3
no
BudgetTopicCode3
yes
no
 
Topic4
no
BudgetTopicCode4
yes
no
BudgetVersion
Budget Version
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetVersion_ID
Record ID
 
-99999999999
 
 
BudgetVersionCode
Version Code
 
x(20)
 
 
BudgetVersionComment
Comment
 
x(40)
 
 
BudgetVersionCreateDate
Creation Date
 
99/99/9999
 
 
BudgetVersionCreateTime
Creation Time
 
->,>>>,>>9
 
 
BudgetVersionDescription
Description
 
x(40)
 
 
BudgetVersionIsActive
Active
 
yes/no
 
 
BudgetVersionPercComplet
% of Completion
 
->,>>>,>>9.99
3
 
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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
ReportPeriod_ID
From Report Pd
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Budget
no
Budget_ID
yes
no
 
Code
yes
BudgetVersionCode
yes
no
 
 
 
Budget_ID
yes
no
 ∗
Prim
yes
BudgetVersion_ID
yes
no
 
ReportPeriodIdx
no
ReportPeriod_ID
yes
no
 
ViewIndex
no
BudgetVersionIsActive
yes
no
 
 
 
BudgetVersionCode
yes
no
BudgetVersionFig
Budget Version Figures
 
 
Field Name
Label
Col-Label
Format
Dec
 
BudgetVersion_ID
Link to BudgetVersion
 
-99999999999
 
 
BudgetVersionFig_ID
Record ID
 
-99999999999
 
 
BudgetVersionFig01EacETC
PM Forecast Cost ETC (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01EacQTY
PM Forecast Qty (01)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig01EacTC
PM Forecast Cost LTE (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01FctPR
Forecast Price (01)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig01FinETC
Contr Forecast Cost ETC (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01FinQTY
Contr Forecast Qty (01)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig01FinTC
Contr Forecast Cost LTE (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01PR
Budget Price (01)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig01QTY
Budget Qty (01)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig01SEacTC
PM Forecast Revenue (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01SFinTC
Contr Forecast Rev (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01STC
Budget Rev (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig01TC
Budget Cost (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02EacQTY
PM Forecast Qty (02)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig02EacTC
PM Forecast Cost LTE (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02FinQTY
Contr Forecast Qty (02)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig02FinTC
Contr Forecast Cost LTE (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02QTY
Budget Qty (02)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig02SEacTC
PM Forecast Revenue (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02SFinTC
Contr Forecast Rev (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02STC
Budget Rev (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig02TC
Budget Cost (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03EacQTY
PM Forecast Qty (03)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig03EacTC
PM Forecast Cost LTE (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03FinQTY
Contr Forecast Qty (03)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig03FinTC
Contr Forecast Cost LTE (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03QTY
Budget Qty (03)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig03SEacTC
PM Forecast Revenue (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03SFinTC
Contr Forecast Rev (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03STC
Budget Rev (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig03TC
Budget Cost (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04EacQTY
PM Forecast Qty (04)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig04EacTC
PM Forecast Cost LTE (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04FinQTY
Contr Forecast Qty (04)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig04FinTC
Contr Forecast Cost LTE (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04QTY
Budget Qty (04)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig04SEacTC
PM Forecast Revenue (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04SFinTC
Contr Forecast Rev (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04STC
Budget Rev (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig04TC
Budget Cost (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05EacQTY
PM Forecast Qty (05)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig05EacTC
PM Forecast Cost LTE (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05FinQTY
Contr Forecast Qty (05)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig05FinTC
Contr Forecast Cost LTE (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05QTY
Budget Qty (05)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig05SEacTC
PM Forecast Revenue (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05SFinTC
Contr Forecast Rev (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05STC
Budget Rev (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig05TC
Budget Cost (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06EacQTY
PM Forecast Qty (06)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig06EacTC
PM Forecast Cost LTE (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06FinQTY
Contr Forecast Qty (06)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig06FinTC
Contr Forecast Cost LTE (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06QTY
Budget Qty (06)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig06SEacTC
PM Forecast Revenue (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06SFinTC
Contr Forecast Rev (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06STC
Budget Rev (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig06TC
Budget Cost (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07EacQTY
PM Forecast Qty (07)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig07EacTC
PM Forecast Cost LTE (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07FinQTY
Contr Forecast Qty (07)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig07FinTC
Contr Forecast Cost LTE (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07QTY
Budget Qty (07)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig07SEacTC
PM Forecast Revenue (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07SFinTC
Contr Forecast Rev (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07STC
Budget Rev (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig07TC
Budget Cost (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08EacQTY
PM Forecast Qty (08)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig08EacTC
PM Forecast Cost-LTE (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08FinQTY
Contr Forecast Qty (08)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig08FinTC
Contr Forecast Cost LTE (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08QTY
Budget Qty (08)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig08SEacTC
PM Forecast Revenue (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08SFinTC
Contr Forecast Rev (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08STC
Budget Rev (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig08TC
Budget Cost (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09EacQTY
PM Forecast Qty (09)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig09EacTC
PM Forecast Cost LTE (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09FinQTY
Contr Forecast Qty (09)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig09FinTC
Contr Forecast Cost LTE (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09QTY
Budget Qty (09)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig09SEacTC
PM Forecast Revenue (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09SFinTC
Contr Forecast Rev (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09STC
Budget Rev (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig09TC
Budget Cost (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10EacQTY
PM Forecast Qty (10)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig10EacTC
PM Forecast Cost LTE (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10FinQTY
Contr Forecast Qty (10)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig10FinTC
Contr Forecast Cost LTE (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10QTY
Budget Qty (10)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig10SEacTC
PM Forecast Revenue (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10SFinTC
Contr Forecast Rev (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10STC
Budget Rev (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig10TC
Budget Cost (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11EacQTY
PM Forecast Qty (11)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig11EacTC
PM Forecast Cost LTE (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11FinQTY
Contr Forecast Qty (11)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig11FinTC
Contr Forecast Cost LTE (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11QTY
Budget Qty (11)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig11SEacTC
PM Forecast Revenue (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11SFinTC
Contr Forecast Rev (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11STC
Budget Rev (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig11TC
Budget Cost (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12EacQTY
PM Forecast Qty (12)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig12EacTC
PM Forecast Cost LTE (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12FinQTY
Contr Forecast Qty (12)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig12FinTC
Contr Forecast Cost LTE (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12QTY
Budget Qty (12)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig12SEacTC
PM Forecast Revenue (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12SFinTC
Contr Forecast Rev (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12STC
Budget Rev (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig12TC
Budget Cost (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13EacQTY
PM Frc Qty (13)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig13EacTC
PM Forecast Cost LTE (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13FinQTY
Contr Forecast Qty (13)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig13FinTC
Contr Forecast Cost LTE (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13QTY
Budget Qty (13)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig13SEacTC
PM Frc Rev (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13SFinTC
Contr Forecast Rev (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13STC
Budget Rev (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig13TC
Budget Cost (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14EacQTY
PM Frc Qty (14)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig14EacTC
PM Forecast Cost LTE (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14FinQTY
Contr Forecast Qty (14)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig14FinTC
Contr Forecast Cost LTE (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14QTY
Budget Qty (14)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig14SEacTC
PM Frc Rev (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14SFinTC
Contr Forecast Rev (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14STC
Budget Rev (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig14TC
Budget Cost (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15EacQTY
PM Frc Qty (15)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig15EacTC
PM Forecast Cost LTE (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15FinQTY
Contr Forecast Qty (15)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig15FinTC
Contr Forecast Cost LTE (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15QTY
Budget Qty (15)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig15SEacTC
PM Frc Rev (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15SFinTC
Contr Forecast Rev (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15STC
Budget Rev (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig15TC
Budget Cost (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16EacQTY
PM Frc Qty (16)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig16EacTC
PM Forecast Cost LTE (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16FinQTY
Contr Forecast Qty (16)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig16FinTC
Contr Forecast Cost LTE (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16QTY
Budget Qty (16)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig16SEacTC
PM Frc Rev (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16SFinTC
Contr Forecast Rev (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16STC
Budget Rev (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig16TC
Budget Cost (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17EacQTY
PM Frc Qty (17)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig17EacTC
PM Forecast Cost LTE (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17FinQTY
Contr Forecast Qty (17)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig17FinTC
Contr Forecast Cost LTE (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17QTY
Budget Qty (17)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig17SEacTC
PM Frc Rev (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17SFinTC
Contr Forecast Rev (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17STC
Budget Rev (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig17TC
Budget Cost (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18EacQTY
PM Frc Qty (18)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig18EacTC
PM Forecast Cost LTE (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18FinQTY
Contr Forecast Qty (18)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig18FinTC
Contr Forecast Cost LTE (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18QTY
Budget Qty (18)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig18SEacTC
PM Frc Rev (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18SFinTC
Contr Forecast Rev (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18STC
Budget Rev (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig18TC
Budget Cost (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19EacQTY
PM Frc Qty (19)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig19EacTC
PM Forecast Cost LTE (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19FinQTY
Contr Forecast Qty (19)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig19FinTC
Contr Forecast Cost LTE (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19QTY
Budget Qty (19)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig19SEacTC
PM Frc Rev (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19SFinTC
Contr Forecast Rev (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19STC
Budget Rev (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig19TC
Budget Cost (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20EacQTY
PM Frc Qty (20)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig20EacTC
PM Forecast Cost LTE (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20FinQTY
Contr Forecast Qty (20)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig20FinTC
Contr Forecast Cost LTE (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20QTY
Budget Qty (20)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig20SEacTC
PM Frc Rev (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20SFinTC
Contr Forecast Rev (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20STC
Budget Rev (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig20TC
Budget Cost (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21EacQTY
PM Frc Qty (21)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig21EacTC
PM Forecast Cost LTE (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21FinQTY
Contr Forecast Qty (21)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig21FinTC
Contr Forecast Cost LTE (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21QTY
Budget Qty (21)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig21SEacTC
PM Frc Rev (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21SFinTC
Contr Forecast Rev (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21STC
Budget Rev (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig21TC
Budget Cost (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22EacQTY
PM Frc Qty (22)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig22EacTC
PM Forecast Cost LTE (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22FinQTY
Contr Forecast Qty (22)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig22FinTC
Contr Forecast Cost LTE (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22QTY
Budget Qty (22)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig22SEacTC
PM Frc Rev (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22SFinTC
Contr Forecast Rev (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22STC
Budget Rev (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig22TC
Budget Cost (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23EacQTY
PM Frc Qty (23)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig23EacTC
PM Forecast Cost LTE (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23FinQTY
Contr Forecast Qty (23)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig23FinTC
Contr Forecast Cost LTE (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23QTY
Budget Qty (23)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig23SEacTC
PM Frc Rev (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23SFinTC
Contr Forecast Rev (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23STC
Budget Rev (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig23TC
Budget Cost (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24EacQTY
PM Frc Qty (24)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig24EacTC
PM Forecast Cost LTE (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24FinQTY
Contr Forecast Qty (24)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig24FinTC
Contr Forecast Cost LTE (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24QTY
Budget Qty (24)
 
->>>,>>>,>>9.99999
10
 
BudgetVersionFig24SEacTC
PM Frc Rev (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24SFinTC
Contr Forecast Rev (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24STC
Budget Rev (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionFig24TC
Budget Cost (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetV
no
BudgetVersion_ID
yes
no
 
BudgetWBS
no
BudgetWBS_ID
yes
no
 ∗
Prim
yes
BudgetVersionFig_ID
yes
no
 
UniqueIdx
yes
BudgetWBS_ID
yes
no
 
 
 
BudgetVersion_ID
yes
no
BudgetVersionGLFig
Budget Version GL Figures
 
 
Field Name
Label
Col-Label
Format
Dec
 
BudgetVersion_ID
Link to BudgetVersion
 
-99999999999
 
 
BudgetVersionGLFig_ID
Record ID
 
-99999999999
 
 
BudgetVersionGLFig01EacQTY
Forecast Qty (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig01EacTC
Forecast Cost (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig01QTY
Qty (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig01TC
TC Amt (01)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig02EacQTY
Forecast Qty (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig02EacTC
Forecast Cost (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig02QTY
Qty (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig02TC
TC Amt (02)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig03EacQTY
Forecast Qty (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig03EacTC
Forecast Cost (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig03QTY
Qty (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig03TC
TC Amt (03)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig04EacQTY
Forecast Qty (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig04EacTC
Forecast Cost (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig04QTY
Qty (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig04TC
TC Amt (04)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig05EacQTY
Forecast Qty (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig05EacTC
Forecast Cost (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig05QTY
Qty (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig05TC
TC Amt (05)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig06EacQTY
Forecast Qty (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig06EacTC
Forecast Cost (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig06QTY
Qty (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig06TC
TC Amt (06)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig07EacQTY
Forecast Qty (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig07EacTC
Forecast Cost (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig07QTY
Qty (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig07TC
TC Amt (07)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig08EacQTY
Forecast Qty (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig08EacTC
Forecast Cost (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig08QTY
Qty (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig08TC
TC Amt (08)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig09EacQTY
Forecast Qty (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig09EacTC
Forecast Cost (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig09QTY
Qty (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig09TC
TC Amt (09)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig10EacQTY
Forecast Qty (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig10EacTC
Forecast Cost (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig10QTY
Qty (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig10TC
TC Amount (10)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig11EacQTY
Forecast Qty (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig11EacTC
Forecast Cost (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig11QTY
Qty (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig11TC
TC Amount (11)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig12EacQTY
Forecast Qty (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig12EacTC
Forecast Cost (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig12QTY
Qty (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig12TC
TC Amount (12)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig13EacQTY
Forecast Qty (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig13EacTC
Forecast Cost (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig13QTY
Qty (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig13TC
TC Amount (13)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig14EacQTY
Forecast Qty (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig14EacTC
Forecast Cost (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig14QTY
Qty (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig14TC
TC Amount (14)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig15EacQTY
Forecast Qty (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig15EacTC
Forecast Cost (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig15QTY
Qty (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig15TC
TC Amount (15)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig16EacQTY
Forecast Qty (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig16EacTC
Forecast Cost (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig16QTY
Qty (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig16TC
TC Amount (16)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig17EacQTY
Forecast Qty (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig17EacTC
Forecast Cost (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig17QTY
Qty (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig17TC
TC Amount (17)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig18EacQTY
Forecast Qty (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig18EacTC
Forecast Cost (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig18QTY
Qty (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig18TC
TC Amount (18)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig19EacQTY
Forecast Qty (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig19EacTC
Forecast Cost (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig19QTY
Qty (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig19TC
TC Amount (19)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig20EacQTY
Forecast Qty (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig20EacTC
Forecast Cost (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig20QTY
Qty (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig20TC
TC Amount (20)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig21EacQTY
Forecast Qty (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig21EacTC
Forecast Cost (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig21QTY
Qty (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig21TC
TC Amount (21)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig22EacQTY
Forecast Qty (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig22EacTC
Forecast Cost (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig22QTY
Qty (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig22TC
TC Amount (22)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig23EacQTY
Forecast Qty (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig23EacTC
Forecast Cost (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig23QTY
Qty (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig23TC
TC Amount (23)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig24EacQTY
Forecast Qty (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig24EacTC
Forecast Cost (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig24QTY
Qty (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig24TC
TC Amount (24)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig25EacQTY
Forecast Qty (25)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig25EacTC
Forecast Cost (25)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig25QTY
Qty (25)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig25TC
TC Amount (25)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig26EacQTY
Forecast Qty (26)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig26EacTC
Forecast Cost (26)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig26QTY
Qty (26)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig26TC
TC Amount (26)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig27EacQTY
Forecast Qty (27)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig27EacTC
Forecast Cost (27)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig27QTY
Qty (27)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig27TC
TC Amount (27)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig28EacQTY
Forecast Qty (28)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig28EacTC
Forecast Cost (28)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig28QTY
Qty (28)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig28TC
TC Amount (28)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig29EacQTY
Forecast Qty (29)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig29EacTC
Forecast Cost (29)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig29QTY
Qty (29)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig29TC
TC Amount (29)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig30EacQTY
Forecast Qty (30)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig30EacTC
Forecast Cost (30)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig30QTY
Qty (30)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig30TC
TC Amount (30)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig31EacQTY
Forecast Qty (31)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig31EacTC
Forecast Cost (31)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig31QTY
Qty (31)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig31TC
TC Amount (31)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig32EacQTY
Forecast Qty (32)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig32EacTC
Forecast Cost (32)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig32QTY
Qty (32)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig32TC
TC Amount (32)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig33EacQTY
Forecast Qty (33)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig33EacTC
Forecast Cost (33)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig33QTY
Qty (33)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig33TC
TC Amount (33)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig34EacQTY
Forecast Qty (34)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig34EacTC
Forecast Cost (34)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig34QTY
Qty (34)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig34TC
TC Amount (34)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig35EacQTY
Forecast Qty (35)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig35EacTC
Forecast Cost (35)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig35QTY
Qty (35)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig35TC
TC Amount (35)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig36EacQTY
Forecast Qty (36)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig36EacTC
Forecast Cost (36)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig36QTY
Qty (36)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig36TC
TC Amount (36)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig37EacQTY
Forecast Qty (37)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig37EacTC
Forecast Cost (37)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig37QTY
Qty (37)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig37TC
TC Amount (37)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig38EacQTY
Forecast Qty (38)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig38EacTC
Forecast Cost (38)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig38QTY
Qty (38)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig38TC
TC Amount (38)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig39EacQTY
Forecast Qty (39)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig39EacTC
Forecast Cost (39)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig39QTY
Qty (39)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig39TC
TC Amount (39)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig40EacQTY
Forecast Qty (40)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig40EacTC
Forecast Cost (40)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig40QTY
Qty (40)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig40TC
TC Amount (40)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig41EacQTY
Forecast Qty (41)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig41EacTC
Forecast Cost (41)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig41QTY
Qty (41)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig41TC
TC Amount (41)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig42EacQTY
Forecast Qty (42)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig42EacTC
Forecast Cost (42)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig42QTY
Qty (42)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig42TC
TC Amount (42)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig43EacQTY
Forecast Qty (43)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig43EacTC
Forecast Cost (43)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig43QTY
Qty (43)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig43TC
TC Amount (43)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig44EacQTY
Forecast Qty (44)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig44EacTC
Forecast Cost (44)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig44QTY
Qty (44)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig44TC
TC Amount (44)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig45EacQTY
Forecast Qty (45)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig45EacTC
Forecast Cost (45)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig45QTY
Qty (45)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig45TC
TC Amount (45)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig46EacQTY
Forecast Qty (46)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig46EacTC
Forecast Cost (46)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig46QTY
Qty (46)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig46TC
TC Amount (46)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig47EacQTY
Forecast Qty (47)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig47EacTC
Forecast Cost (47)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig47QTY
Qty (47)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig47TC
TC Amount (47)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig48EacQTY
Forecast Qty (48)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig48EacTC
Forecast Cost (48)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig48QTY
Qty (48)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig48TC
TC Amount (48)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig49EacQTY
Forecast Qty (49)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig49EacTC
Forecast Cost (49)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig49QTY
Qty (49)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig49TC
TC Amount (49)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig50EacQTY
Forecast Qty (50)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig50EacTC
Forecast Cost (50)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig50QTY
Qty (50)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig50TC
TC Amount (50)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig51EacQTY
Forecast Qty (51)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig51EacTC
Forecast Cost (51)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig51QTY
Qty (51)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig51TC
TC Amount (51)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig52EacQTY
Forecast Qty (52)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig52EacTC
Forecast Cost (52)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig52QTY
Qty (52)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig52TC
TC Amount (52)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig53EacQTY
Forecast Qty (53)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig53EacTC
Forecast Cost (53)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig53QTY
Qty (53)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig53TC
TC Amount (53)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig54EacQTY
Forecast Qty (54)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig54EacTC
Forecast Cost (54)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig54QTY
Qty (54)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetVersionGLFig54TC
TC Amount (54)
 
->>>,>>>,>>>,>>9.99
4
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BudgetV
no
BudgetVersion_ID
yes
no
 
BudgetWBS
no
BudgetWBS_ID
yes
no
 ∗
Prim
yes
BudgetVersionGLFig_ID
yes
no
 
UniqueIdx
yes
BudgetWBS_ID
yes
no
 
 
 
BudgetVersion_ID
yes
no
BudgetWBS
Budget Topic
 
 
Field Name
Label
Col-Label
Format
Dec
 
AltCOAGroup_ID
Alternate COA Group
 
-99999999999
 
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetFDS_ID
Link to BudgetFDS
 
-99999999999
 
 
BudgetFDSSeq
COA Sequence
 
->,>>>,>>9
 
 
BudgetFDSType
COA Type
 
x(20)
 
 
BudgetGroup_ID
Budget Group
 
-99999999999
 
 
BudgetWBS_ID
Record ID
 
-99999999999
 
 
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
Line Number
 
->,>>>,>>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
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SafConcept_ID
SAF Concept Code
 
-99999999999
 
 
SafStructure_ID
SAF Structure
 
-99999999999
 
 
Unit_ID
GL Account Unit of Measure
UM
-99999999999
 
 
 
 
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
BudgetWBSBusComponent
Budget Topic Component Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
Budget_ID
Link to Budget
 
-99999999999
 
 
BudgetWBS_ID
Link to BudgetWBS
 
-99999999999
 
 
BudgetWBSBusComponent_ID
Record ID
 
-99999999999
 
 
BusComponent_ID
Component
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Bud
no
Budget_ID
yes
no
 
BudgWBS
no
BudgetWBS_ID
yes
no
 
BusComp
no
BusComponent_ID
yes
no
 ∗
Prim
yes
BudgetWBSBusComponent_ID
yes
no
 
UniIdx
yes
BusComponent_ID
yes
no
 
 
 
BudgetWBS_ID
yes
no