project QadFinancials > class BBudget > dataset BBudget

class dataset

object identification

primary key
Budget_ID
alternate key
BudgetCode
object identity
Budget_ID

table tBudget


field namedata typemnd.description
Budget_IDintegeryesRecord ID
Usr_IDintegernoBudget Administrator
Currency_IDintegeryesCurrency Code
Project_IDintegernoProject Code
CostCentre_IDintegernoCost Center Code
GLSharedSet_IDintegernoLink to SharedSet
DivisionSharedSet_IDintegernoLink to SharedSet
ProjectSharedSet_IDintegernoLink to SharedSet
CostCentreSharedSet_IDintegernoLink to SharedSet
FRWChart_IDintegernoFRWChart ID
BudgetCodecharacter(20)yesBudget Code
BudgetDescriptioncharacter(40)yesDescription
BudgetStatuscharacter(20)yesStatus
value list:{&BUDGETSTATUSES}
BudgetTypecharacter(20)yesBudget Type
value list:{&BUDGETTYPES}
BudgetOverrunTotalcharacter(20)yesTotal Overrun
value list:{&BUDGETOVERRUNS}
BudgetOverrunPeriodcharacter(20)yesGL Period Overrun
value list:{&BUDGETOVERRUNS}
BudgetOverrunYTDcharacter(20)yesOverrun (YTD)
value list:{&BUDGETOVERRUNS}
BudgetCheckReportPeriodcharacter(20)yesReport Period Check
value list:{&BUDGETOVERRUNS}
BudgetInputLevelBudgetintegeryesInput Level (Budget)
BudgetInputLevelFinintegeryesInput Level (Fin)
BudgetInputLevelEACintegeryesInput Level (PM)
BudgetIsWithQuantityDatalogicalyesUse Quantity Info
BudgetIsCompanyDependentlogicalyesEntity Dependent
BudgetIsCheckActualOnLinelogicalyesCheck Actuals Online
BudgetIsCheckCommitOnLinelogicalyesCheck Commitments Online
BudgetIsAutoRollUplogicalyesAuto Roll-Up
BudgetIsSendErrorlogicalyesSend E-Mail on Errors
BudgetIsSendWarninglogicalyesSend E-Mail on Warnings
BudgetIsUsedForAllocationlogicalyesUsed for Allocation
BudgetIsReportStructlogicalyesUse as Report
BudgetIsFRWLinkedlogicalyesBudget is FRW linked
BudgetForecastTypecharacter(20)yesForecast Type
value list:{&BUDGETFORECASTTYPES}
BudgetGroupCategoryintegeryesBudget Group Category
tcCurrencyCodecharacter(3)yesCurrency Code
tcProjectCodecharacter(8)noProject Code
tcCostCentreCodecharacter(4)noCost Center Code
tcUsrLogincharacter(20)noBudget Administrator
tcFRWChartCodecharacter(20)noFRW Chart Report
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tBudgetCompany

Description

Budget Company

field namedata typemnd.description
BudgetCompany_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
Budget_IDintegeryesLink to Budget
tcCompanyCodecharacter(20)noEntity Code
tcCompanyUpdateStatuscharacter(20)no
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudget.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetFDS

Description

Budget-COA

field namedata typemnd.description
BudgetFDS_IDintegeryesRecord ID
Budget_IDintegeryesLink to Budget
BudgetFDSSeqintegeryesWBS Level
BudgetFDSTypecharacter(20)yesCOA Element
value list:{&BUDGETFDSTYPES}
BudgetFDSIsAllocationTotallogicalnoUsed for Proportional Allocation
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudget.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetPeriod

Description

Budget-Period

field namedata typemnd.description
BudgetPeriod_IDintegeryesRecord ID
Budget_IDintegeryesLink to Budget
BudgetPeriodCodecharacter(20)yesPeriod Code
BudgetPeriodFromDatedateyesStart Date
BudgetPeriodTillDatedateyesEnd Date
BudgetPeriodSeqintegernoGL Period Seq
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudget.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetVersion

Description

Budget-Version

field namedata typemnd.description
BudgetVersion_IDintegeryesRecord ID
Budget_IDintegeryesLink to Budget
ReportPeriod_IDintegeryesFrom Report Pd
BudgetVersionCodecharacter(20)yesVersion Code
BudgetVersionDescriptioncharacter(40)noDescription
BudgetVersionIsActivelogicalyesActive
BudgetVersionCreateDatedateyesCreation Date
BudgetVersionCreateTimeintegeryesCreation Time
BudgetVersionCommentcharacter(40)noComment
BudgetVersionPercCompletdecimal(3)no% of Completion
tcBudgetVersionCreateTimeFormcharacter(11)noBudgetVersionCreateTimeFormatted
tiReportPeriodPeriodintegeryesFrom Report Pd
tiReportPeriodYearintegeryesFrom Reporting Year
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudget.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetVersionFig


field namedata typemnd.description
BudgetVersionFig_IDintegeryesRecord ID
BudgetWBS_IDintegeryesLink to BudgetWBS
BudgetVersion_IDintegeryesLink to BudgetVersion
BudgetVersionFig01TCdecimal(4)noBudget Cost (01)
BudgetVersionFig01QTYdecimal(10)noBudget Qty (01)
BudgetVersionFig01PRdecimal(10)noBudget Price (01)
BudgetVersionFig01EacTCdecimal(4)noPM Forecast Cost LTE (01)
BudgetVersionFig01EacQTYdecimal(10)noPM Forecast Qty (01)
BudgetVersionFig01EacETCdecimal(4)noPM Forecast Cost ETC (01)
BudgetVersionFig01FctPRdecimal(10)noForecast Price (01)
BudgetVersionFig01FinTCdecimal(4)noContr Forecast Cost LTE (01)
BudgetVersionFig01FinQTYdecimal(10)noContr Forecast Qty (01)
BudgetVersionFig01FinETCdecimal(4)noContr Forecast Cost ETC (01)
BudgetVersionFig01STCdecimal(4)noBudget Rev (01)
BudgetVersionFig01SFinTCdecimal(4)noContr Forecast Rev (01)
BudgetVersionFig01SEacTCdecimal(4)noPM Forecast Revenue (01)
BudgetVersionFig02TCdecimal(4)noBudget Cost (02)
BudgetVersionFig02QTYdecimal(10)noBudget Qty (02)
BudgetVersionFig02EacTCdecimal(4)noPM Forecast Cost LTE (02)
BudgetVersionFig02EacQTYdecimal(10)noPM Forecast Qty (02)
BudgetVersionFig02FinTCdecimal(4)noContr Forecast Cost LTE (02)
BudgetVersionFig02FinQTYdecimal(10)noContr Forecast Qty (02)
BudgetVersionFig02STCdecimal(4)noBudget Rev (02)
BudgetVersionFig02SFinTCdecimal(4)noContr Forecast Rev (02)
BudgetVersionFig02SEacTCdecimal(4)noPM Forecast Revenue (02)
BudgetVersionFig03TCdecimal(4)noBudget Cost (03)
BudgetVersionFig03QTYdecimal(10)noBudget Qty (03)
BudgetVersionFig03EacTCdecimal(4)noPM Forecast Cost LTE (03)
BudgetVersionFig03EacQTYdecimal(10)noPM Forecast Qty (03)
BudgetVersionFig03FinTCdecimal(4)noContr Forecast Cost LTE (03)
BudgetVersionFig03FinQTYdecimal(10)noContr Forecast Qty (03)
BudgetVersionFig03STCdecimal(4)noBudget Rev (03)
BudgetVersionFig03SFinTCdecimal(4)noContr Forecast Rev (03)
BudgetVersionFig03SEacTCdecimal(4)noPM Forecast Revenue (03)
BudgetVersionFig04TCdecimal(4)noBudget Cost (04)
BudgetVersionFig04QTYdecimal(10)noBudget Qty (04)
BudgetVersionFig04EacTCdecimal(4)noPM Forecast Cost LTE (04)
BudgetVersionFig04EacQTYdecimal(10)noPM Forecast Qty (04)
BudgetVersionFig04FinTCdecimal(4)noContr Forecast Cost LTE (04)
BudgetVersionFig04FinQTYdecimal(10)noContr Forecast Qty (04)
BudgetVersionFig04STCdecimal(4)noBudget Rev (04)
BudgetVersionFig04SFinTCdecimal(4)noContr Forecast Rev (04)
BudgetVersionFig04SEacTCdecimal(4)noPM Forecast Revenue (04)
BudgetVersionFig05TCdecimal(4)noBudget Cost (05)
BudgetVersionFig05QTYdecimal(10)noBudget Qty (05)
BudgetVersionFig05EacTCdecimal(4)noPM Forecast Cost LTE (05)
BudgetVersionFig05EacQTYdecimal(10)noPM Forecast Qty (05)
BudgetVersionFig05FinTCdecimal(4)noContr Forecast Cost LTE (05)
BudgetVersionFig05FinQTYdecimal(10)noContr Forecast Qty (05)
BudgetVersionFig05STCdecimal(4)noBudget Rev (05)
BudgetVersionFig05SFinTCdecimal(4)noContr Forecast Rev (05)
BudgetVersionFig05SEacTCdecimal(4)noPM Forecast Revenue (05)
BudgetVersionFig06TCdecimal(4)noBudget Cost (06)
BudgetVersionFig06QTYdecimal(10)noBudget Qty (06)
BudgetVersionFig06EacTCdecimal(4)noPM Forecast Cost LTE (06)
BudgetVersionFig06EacQTYdecimal(10)noPM Forecast Qty (06)
BudgetVersionFig06FinTCdecimal(4)noContr Forecast Cost LTE (06)
BudgetVersionFig06FinQTYdecimal(10)noContr Forecast Qty (06)
BudgetVersionFig06STCdecimal(4)noBudget Rev (06)
BudgetVersionFig06SFinTCdecimal(4)noContr Forecast Rev (06)
BudgetVersionFig06SEacTCdecimal(4)noPM Forecast Revenue (06)
BudgetVersionFig07TCdecimal(4)noBudget Cost (07)
BudgetVersionFig07QTYdecimal(10)noBudget Qty (07)
BudgetVersionFig07EacTCdecimal(4)noPM Forecast Cost LTE (07)
BudgetVersionFig07EacQTYdecimal(10)noPM Forecast Qty (07)
BudgetVersionFig07FinTCdecimal(4)noContr Forecast Cost LTE (07)
BudgetVersionFig07FinQTYdecimal(10)noContr Forecast Qty (07)
BudgetVersionFig07STCdecimal(4)noBudget Rev (07)
BudgetVersionFig07SFinTCdecimal(4)noContr Forecast Rev (07)
BudgetVersionFig07SEacTCdecimal(4)noPM Forecast Revenue (07)
BudgetVersionFig08TCdecimal(4)noBudget Cost (08)
BudgetVersionFig08QTYdecimal(10)noBudget Qty (08)
BudgetVersionFig08EacTCdecimal(4)noPM Forecast Cost-LTE (08)
BudgetVersionFig08EacQTYdecimal(10)noPM Forecast Qty (08)
BudgetVersionFig08FinTCdecimal(4)noContr Forecast Cost LTE (08)
BudgetVersionFig08FinQTYdecimal(10)noContr Forecast Qty (08)
BudgetVersionFig08STCdecimal(4)noBudget Rev (08)
BudgetVersionFig08SFinTCdecimal(4)noContr Forecast Rev (08)
BudgetVersionFig08SEacTCdecimal(4)noPM Forecast Revenue (08)
BudgetVersionFig09TCdecimal(4)noBudget Cost (09)
BudgetVersionFig09QTYdecimal(10)noBudget Qty (09)
BudgetVersionFig09EacTCdecimal(4)noPM Forecast Cost LTE (09)
BudgetVersionFig09EacQTYdecimal(10)noPM Forecast Qty (09)
BudgetVersionFig09FinTCdecimal(4)noContr Forecast Cost LTE (09)
BudgetVersionFig09FinQTYdecimal(10)noContr Forecast Qty (09)
BudgetVersionFig09STCdecimal(4)noBudget Rev (09)
BudgetVersionFig09SFinTCdecimal(4)noContr Forecast Rev (09)
BudgetVersionFig09SEacTCdecimal(4)noPM Forecast Revenue (09)
BudgetVersionFig10TCdecimal(4)noBudget Cost (10)
BudgetVersionFig10QTYdecimal(10)noBudget Qty (10)
BudgetVersionFig10EacTCdecimal(4)noPM Forecast Cost LTE (10)
BudgetVersionFig10EacQTYdecimal(10)noPM Forecast Qty (10)
BudgetVersionFig10FinTCdecimal(4)noContr Forecast Cost LTE (10)
BudgetVersionFig10FinQTYdecimal(10)noContr Forecast Qty (10)
BudgetVersionFig10STCdecimal(4)noBudget Rev (10)
BudgetVersionFig10SFinTCdecimal(4)noContr Forecast Rev (10)
BudgetVersionFig10SEacTCdecimal(4)noPM Forecast Revenue (10)
BudgetVersionFig11TCdecimal(4)noBudget Cost (11)
BudgetVersionFig11QTYdecimal(10)noBudget Qty (11)
BudgetVersionFig11EacTCdecimal(4)noPM Forecast Cost LTE (11)
BudgetVersionFig11EacQTYdecimal(10)noPM Forecast Qty (11)
BudgetVersionFig11FinTCdecimal(4)noContr Forecast Cost LTE (11)
BudgetVersionFig11FinQTYdecimal(10)noContr Forecast Qty (11)
BudgetVersionFig11STCdecimal(4)noBudget Rev (11)
BudgetVersionFig11SFinTCdecimal(4)noContr Forecast Rev (11)
BudgetVersionFig11SEacTCdecimal(4)noPM Forecast Revenue (11)
BudgetVersionFig12TCdecimal(4)noBudget Cost (12)
BudgetVersionFig12QTYdecimal(10)noBudget Qty (12)
BudgetVersionFig12EacTCdecimal(4)noPM Forecast Cost LTE (12)
BudgetVersionFig12EacQTYdecimal(10)noPM Forecast Qty (12)
BudgetVersionFig12FinTCdecimal(4)noContr Forecast Cost LTE (12)
BudgetVersionFig12FinQTYdecimal(10)noContr Forecast Qty (12)
BudgetVersionFig12STCdecimal(4)noBudget Rev (12)
BudgetVersionFig12SFinTCdecimal(4)noContr Forecast Rev (12)
BudgetVersionFig12SEacTCdecimal(4)noPM Forecast Revenue (12)
BudgetVersionFig13TCdecimal(4)noBudget Cost (13)
BudgetVersionFig13QTYdecimal(10)noBudget Qty (13)
BudgetVersionFig13EacTCdecimal(4)noPM Forecast Cost LTE (13)
BudgetVersionFig13EacQTYdecimal(10)noPM Frc Qty (13)
BudgetVersionFig13FinTCdecimal(4)noContr Forecast Cost LTE (13)
BudgetVersionFig13FinQTYdecimal(10)noContr Forecast Qty (13)
BudgetVersionFig13STCdecimal(4)noBudget Rev (13)
BudgetVersionFig13SFinTCdecimal(4)noContr Forecast Rev (13)
BudgetVersionFig13SEacTCdecimal(4)noPM Frc Rev (13)
BudgetVersionFig14TCdecimal(4)noBudget Cost (14)
BudgetVersionFig14QTYdecimal(10)noBudget Qty (14)
BudgetVersionFig14EacTCdecimal(4)noPM Forecast Cost LTE (14)
BudgetVersionFig14EacQTYdecimal(10)noPM Frc Qty (14)
BudgetVersionFig14FinTCdecimal(4)noContr Forecast Cost LTE (14)
BudgetVersionFig14FinQTYdecimal(10)noContr Forecast Qty (14)
BudgetVersionFig14STCdecimal(4)noBudget Rev (14)
BudgetVersionFig14SFinTCdecimal(4)noContr Forecast Rev (14)
BudgetVersionFig14SEacTCdecimal(4)noPM Frc Rev (14)
BudgetVersionFig15TCdecimal(4)noBudget Cost (15)
BudgetVersionFig15QTYdecimal(10)noBudget Qty (15)
BudgetVersionFig15EacTCdecimal(4)noPM Forecast Cost LTE (15)
BudgetVersionFig15EacQTYdecimal(10)noPM Frc Qty (15)
BudgetVersionFig15FinTCdecimal(4)noContr Forecast Cost LTE (15)
BudgetVersionFig15FinQTYdecimal(10)noContr Forecast Qty (15)
BudgetVersionFig15STCdecimal(4)noBudget Rev (15)
BudgetVersionFig15SFinTCdecimal(4)noContr Forecast Rev (15)
BudgetVersionFig15SEacTCdecimal(4)noPM Frc Rev (15)
BudgetVersionFig16TCdecimal(4)noBudget Cost (16)
BudgetVersionFig16QTYdecimal(10)noBudget Qty (16)
BudgetVersionFig16EacTCdecimal(4)noPM Forecast Cost LTE (16)
BudgetVersionFig16EacQTYdecimal(10)noPM Frc Qty (16)
BudgetVersionFig16FinTCdecimal(4)noContr Forecast Cost LTE (16)
BudgetVersionFig16FinQTYdecimal(10)noContr Forecast Qty (16)
BudgetVersionFig16STCdecimal(4)noBudget Rev (16)
BudgetVersionFig16SFinTCdecimal(4)noContr Forecast Rev (16)
BudgetVersionFig16SEacTCdecimal(4)noPM Frc Rev (16)
BudgetVersionFig17TCdecimal(4)noBudget Cost (17)
BudgetVersionFig17QTYdecimal(10)noBudget Qty (17)
BudgetVersionFig17EacTCdecimal(4)noPM Forecast Cost LTE (17)
BudgetVersionFig17EacQTYdecimal(10)noPM Frc Qty (17)
BudgetVersionFig17FinTCdecimal(4)noContr Forecast Cost LTE (17)
BudgetVersionFig17FinQTYdecimal(10)noContr Forecast Qty (17)
BudgetVersionFig17STCdecimal(4)noBudget Rev (17)
BudgetVersionFig17SFinTCdecimal(4)noContr Forecast Rev (17)
BudgetVersionFig17SEacTCdecimal(4)noPM Frc Rev (17)
BudgetVersionFig18TCdecimal(4)noBudget Cost (18)
BudgetVersionFig18QTYdecimal(10)noBudget Qty (18)
BudgetVersionFig18EacTCdecimal(4)noPM Forecast Cost LTE (18)
BudgetVersionFig18EacQTYdecimal(10)noPM Frc Qty (18)
BudgetVersionFig18FinTCdecimal(4)noContr Forecast Cost LTE (18)
BudgetVersionFig18FinQTYdecimal(10)noContr Forecast Qty (18)
BudgetVersionFig18STCdecimal(4)noBudget Rev (18)
BudgetVersionFig18SFinTCdecimal(4)noContr Forecast Rev (18)
BudgetVersionFig18SEacTCdecimal(4)noPM Frc Rev (18)
BudgetVersionFig19TCdecimal(4)noBudget Cost (19)
BudgetVersionFig19QTYdecimal(10)noBudget Qty (19)
BudgetVersionFig19EacTCdecimal(4)noPM Forecast Cost LTE (19)
BudgetVersionFig19EacQTYdecimal(10)noPM Frc Qty (19)
BudgetVersionFig19FinTCdecimal(4)noContr Forecast Cost LTE (19)
BudgetVersionFig19FinQTYdecimal(10)noContr Forecast Qty (19)
BudgetVersionFig19STCdecimal(4)noBudget Rev (19)
BudgetVersionFig19SFinTCdecimal(4)noContr Forecast Rev (19)
BudgetVersionFig19SEacTCdecimal(4)noPM Frc Rev (19)
BudgetVersionFig20TCdecimal(4)noBudget Cost (20)
BudgetVersionFig20QTYdecimal(10)noBudget Qty (20)
BudgetVersionFig20EacTCdecimal(4)noPM Forecast Cost LTE (20)
BudgetVersionFig20EacQTYdecimal(10)noPM Frc Qty (20)
BudgetVersionFig20FinTCdecimal(4)noContr Forecast Cost LTE (20)
BudgetVersionFig20FinQTYdecimal(10)noContr Forecast Qty (20)
BudgetVersionFig20STCdecimal(4)noBudget Rev (20)
BudgetVersionFig20SFinTCdecimal(4)noContr Forecast Rev (20)
BudgetVersionFig20SEacTCdecimal(4)noPM Frc Rev (20)
BudgetVersionFig21TCdecimal(4)noBudget Cost (21)
BudgetVersionFig21QTYdecimal(10)noBudget Qty (21)
BudgetVersionFig21EacTCdecimal(4)noPM Forecast Cost LTE (21)
BudgetVersionFig21EacQTYdecimal(10)noPM Frc Qty (21)
BudgetVersionFig21FinTCdecimal(4)noContr Forecast Cost LTE (21)
BudgetVersionFig21FinQTYdecimal(10)noContr Forecast Qty (21)
BudgetVersionFig21STCdecimal(4)noBudget Rev (21)
BudgetVersionFig21SFinTCdecimal(4)noContr Forecast Rev (21)
BudgetVersionFig21SEacTCdecimal(4)noPM Frc Rev (21)
BudgetVersionFig22TCdecimal(4)noBudget Cost (22)
BudgetVersionFig22QTYdecimal(10)noBudget Qty (22)
BudgetVersionFig22EacTCdecimal(4)noPM Forecast Cost LTE (22)
BudgetVersionFig22EacQTYdecimal(10)noPM Frc Qty (22)
BudgetVersionFig22FinTCdecimal(4)noContr Forecast Cost LTE (22)
BudgetVersionFig22FinQTYdecimal(10)noContr Forecast Qty (22)
BudgetVersionFig22STCdecimal(4)noBudget Rev (22)
BudgetVersionFig22SFinTCdecimal(4)noContr Forecast Rev (22)
BudgetVersionFig22SEacTCdecimal(4)noPM Frc Rev (22)
BudgetVersionFig23TCdecimal(4)noBudget Cost (23)
BudgetVersionFig23QTYdecimal(10)noBudget Qty (23)
BudgetVersionFig23EacTCdecimal(4)noPM Forecast Cost LTE (23)
BudgetVersionFig23EacQTYdecimal(10)noPM Frc Qty (23)
BudgetVersionFig23FinTCdecimal(4)noContr Forecast Cost LTE (23)
BudgetVersionFig23FinQTYdecimal(10)noContr Forecast Qty (23)
BudgetVersionFig23STCdecimal(4)noBudget Rev (23)
BudgetVersionFig23SFinTCdecimal(4)noContr Forecast Rev (23)
BudgetVersionFig23SEacTCdecimal(4)noPM Frc Rev (23)
BudgetVersionFig24TCdecimal(4)noBudget Cost (24)
BudgetVersionFig24QTYdecimal(10)noBudget Qty (24)
BudgetVersionFig24EacQTYdecimal(10)noPM Frc Qty (24)
BudgetVersionFig24FinTCdecimal(4)noContr Forecast Cost LTE (24)
BudgetVersionFig24FinQTYdecimal(10)noContr Forecast Qty (24)
BudgetVersionFig24STCdecimal(4)noBudget Rev (24)
BudgetVersionFig24SFinTCdecimal(4)noContr Forecast Rev (24)
BudgetVersionFig24SEacTCdecimal(4)noPM Frc Rev (24)
BudgetVersionFig24EacTCdecimal(4)noPM Forecast Cost LTE (24)
tiBudgetFDSSeqintegernoCOA Sequence
tcBudgetFDSTypecharacter(20)noCOA Element
tcBudgetWBSCodecharacter(40)noTopic
tcBudgetWBSSeqcharacternoWBS Seq
tiParentBudgetWBS_IDintegerno
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudgetVersion.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetVersionGLFig


field namedata typemnd.description
BudgetVersionGLFig_IDintegeryesRecord ID
BudgetWBS_IDintegeryesLink to BudgetWBS
BudgetVersion_IDintegeryesLink to BudgetVersion
BudgetVersionGLFig01TCdecimal(4)noTC Amt (01)
BudgetVersionGLFig02TCdecimal(4)noTC Amt (02)
BudgetVersionGLFig03TCdecimal(4)noTC Amt (03)
BudgetVersionGLFig04TCdecimal(4)noTC Amt (04)
BudgetVersionGLFig05TCdecimal(4)noTC Amt (05)
BudgetVersionGLFig06TCdecimal(4)noTC Amt (06)
BudgetVersionGLFig07TCdecimal(4)noTC Amt (07)
BudgetVersionGLFig08TCdecimal(4)noTC Amt (08)
BudgetVersionGLFig09TCdecimal(4)noTC Amt (09)
BudgetVersionGLFig10TCdecimal(4)noTC Amount (10)
BudgetVersionGLFig11TCdecimal(4)noTC Amount (11)
BudgetVersionGLFig12TCdecimal(4)noTC Amount (12)
BudgetVersionGLFig13TCdecimal(4)noTC Amount (13)
BudgetVersionGLFig14TCdecimal(4)noTC Amount (14)
BudgetVersionGLFig15TCdecimal(4)noTC Amount (15)
BudgetVersionGLFig16TCdecimal(4)noTC Amount (16)
BudgetVersionGLFig17TCdecimal(4)noTC Amount (17)
BudgetVersionGLFig18TCdecimal(4)noTC Amount (18)
BudgetVersionGLFig19TCdecimal(4)noTC Amount (19)
BudgetVersionGLFig20TCdecimal(4)noTC Amount (20)
BudgetVersionGLFig21TCdecimal(4)noTC Amount (21)
BudgetVersionGLFig22TCdecimal(4)noTC Amount (22)
BudgetVersionGLFig23TCdecimal(4)noTC Amount (23)
BudgetVersionGLFig24TCdecimal(4)noTC Amount (24)
BudgetVersionGLFig25TCdecimal(4)noTC Amount (25)
BudgetVersionGLFig26TCdecimal(4)noTC Amount (26)
BudgetVersionGLFig27TCdecimal(4)noTC Amount (27)
BudgetVersionGLFig28TCdecimal(4)noTC Amount (28)
BudgetVersionGLFig29TCdecimal(4)noTC Amount (29)
BudgetVersionGLFig30TCdecimal(4)noTC Amount (30)
BudgetVersionGLFig31TCdecimal(4)noTC Amount (31)
BudgetVersionGLFig32TCdecimal(4)noTC Amount (32)
BudgetVersionGLFig33TCdecimal(4)noTC Amount (33)
BudgetVersionGLFig34TCdecimal(4)noTC Amount (34)
BudgetVersionGLFig35TCdecimal(4)noTC Amount (35)
BudgetVersionGLFig36TCdecimal(4)noTC Amount (36)
BudgetVersionGLFig37TCdecimal(4)noTC Amount (37)
BudgetVersionGLFig38TCdecimal(4)noTC Amount (38)
BudgetVersionGLFig39TCdecimal(4)noTC Amount (39)
BudgetVersionGLFig40TCdecimal(4)noTC Amount (40)
BudgetVersionGLFig41TCdecimal(4)noTC Amount (41)
BudgetVersionGLFig42TCdecimal(4)noTC Amount (42)
BudgetVersionGLFig43TCdecimal(4)noTC Amount (43)
BudgetVersionGLFig44TCdecimal(4)noTC Amount (44)
BudgetVersionGLFig45TCdecimal(4)noTC Amount (45)
BudgetVersionGLFig46TCdecimal(4)noTC Amount (46)
BudgetVersionGLFig47TCdecimal(4)noTC Amount (47)
BudgetVersionGLFig48TCdecimal(4)noTC Amount (48)
BudgetVersionGLFig49TCdecimal(4)noTC Amount (49)
BudgetVersionGLFig50TCdecimal(4)noTC Amount (50)
BudgetVersionGLFig51TCdecimal(4)noTC Amount (51)
BudgetVersionGLFig52TCdecimal(4)noTC Amount (52)
BudgetVersionGLFig53TCdecimal(4)noTC Amount (53)
BudgetVersionGLFig54TCdecimal(4)noTC Amount (54)
BudgetVersionGLFig01QTYdecimal(4)noQty (01)
BudgetVersionGLFig02QTYdecimal(4)noQty (02)
BudgetVersionGLFig03QTYdecimal(4)noQty (03)
BudgetVersionGLFig04QTYdecimal(4)noQty (04)
BudgetVersionGLFig05QTYdecimal(4)noQty (05)
BudgetVersionGLFig06QTYdecimal(4)noQty (06)
BudgetVersionGLFig07QTYdecimal(4)noQty (07)
BudgetVersionGLFig08QTYdecimal(4)noQty (08)
BudgetVersionGLFig09QTYdecimal(4)noQty (09)
BudgetVersionGLFig10QTYdecimal(4)noQty (10)
BudgetVersionGLFig11QTYdecimal(4)noQty (11)
BudgetVersionGLFig12QTYdecimal(4)noQty (12)
BudgetVersionGLFig13QTYdecimal(4)noQty (13)
BudgetVersionGLFig14QTYdecimal(4)noQty (14)
BudgetVersionGLFig15QTYdecimal(4)noQty (15)
BudgetVersionGLFig16QTYdecimal(4)noQty (16)
BudgetVersionGLFig17QTYdecimal(4)noQty (17)
BudgetVersionGLFig18QTYdecimal(4)noQty (18)
BudgetVersionGLFig19QTYdecimal(4)noQty (19)
BudgetVersionGLFig20QTYdecimal(4)noQty (20)
BudgetVersionGLFig21QTYdecimal(4)noQty (21)
BudgetVersionGLFig22QTYdecimal(4)noQty (22)
BudgetVersionGLFig23QTYdecimal(4)noQty (23)
BudgetVersionGLFig24QTYdecimal(4)noQty (24)
BudgetVersionGLFig25QTYdecimal(4)noQty (25)
BudgetVersionGLFig26QTYdecimal(4)noQty (26)
BudgetVersionGLFig27QTYdecimal(4)noQty (27)
BudgetVersionGLFig28QTYdecimal(4)noQty (28)
BudgetVersionGLFig29QTYdecimal(4)noQty (29)
BudgetVersionGLFig30QTYdecimal(4)noQty (30)
BudgetVersionGLFig31QTYdecimal(4)noQty (31)
BudgetVersionGLFig32QTYdecimal(4)noQty (32)
BudgetVersionGLFig33QTYdecimal(4)noQty (33)
BudgetVersionGLFig34QTYdecimal(4)noQty (34)
BudgetVersionGLFig35QTYdecimal(4)noQty (35)
BudgetVersionGLFig36QTYdecimal(4)noQty (36)
BudgetVersionGLFig37QTYdecimal(4)noQty (37)
BudgetVersionGLFig38QTYdecimal(4)noQty (38)
BudgetVersionGLFig39QTYdecimal(4)noQty (39)
BudgetVersionGLFig40QTYdecimal(4)noQty (40)
BudgetVersionGLFig41QTYdecimal(4)noQty (41)
BudgetVersionGLFig42QTYdecimal(4)noQty (42)
BudgetVersionGLFig43QTYdecimal(4)noQty (43)
BudgetVersionGLFig44QTYdecimal(4)noQty (44)
BudgetVersionGLFig45QTYdecimal(4)noQty (45)
BudgetVersionGLFig46QTYdecimal(4)noQty (46)
BudgetVersionGLFig47QTYdecimal(4)noQty (47)
BudgetVersionGLFig48QTYdecimal(4)noQty (48)
BudgetVersionGLFig49QTYdecimal(4)noQty (49)
BudgetVersionGLFig50QTYdecimal(4)noQty (50)
BudgetVersionGLFig51QTYdecimal(4)noQty (51)
BudgetVersionGLFig52QTYdecimal(4)noQty (52)
BudgetVersionGLFig53QTYdecimal(4)noQty (53)
BudgetVersionGLFig54QTYdecimal(4)noQty (54)
BudgetVersionGLFig01EacTCdecimal(4)noForecast Cost (01)
BudgetVersionGLFig02EacTCdecimal(4)noForecast Cost (02)
BudgetVersionGLFig03EacTCdecimal(4)noForecast Cost (03)
BudgetVersionGLFig04EacTCdecimal(4)noForecast Cost (04)
BudgetVersionGLFig05EacTCdecimal(4)noForecast Cost (05)
BudgetVersionGLFig06EacTCdecimal(4)noForecast Cost (06)
BudgetVersionGLFig07EacTCdecimal(4)noForecast Cost (07)
BudgetVersionGLFig08EacTCdecimal(4)noForecast Cost (08)
BudgetVersionGLFig09EacTCdecimal(4)noForecast Cost (09)
BudgetVersionGLFig10EacTCdecimal(4)noForecast Cost (10)
BudgetVersionGLFig11EacTCdecimal(4)noForecast Cost (11)
BudgetVersionGLFig12EacTCdecimal(4)noForecast Cost (12)
BudgetVersionGLFig13EacTCdecimal(4)noForecast Cost (13)
BudgetVersionGLFig14EacTCdecimal(4)noForecast Cost (14)
BudgetVersionGLFig15EacTCdecimal(4)noForecast Cost (15)
BudgetVersionGLFig16EacTCdecimal(4)noForecast Cost (16)
BudgetVersionGLFig17EacTCdecimal(4)noForecast Cost (17)
BudgetVersionGLFig18EacTCdecimal(4)noForecast Cost (18)
BudgetVersionGLFig19EacTCdecimal(4)noForecast Cost (19)
BudgetVersionGLFig20EacTCdecimal(4)noForecast Cost (20)
BudgetVersionGLFig21EacTCdecimal(4)noForecast Cost (21)
BudgetVersionGLFig22EacTCdecimal(4)noForecast Cost (22)
BudgetVersionGLFig23EacTCdecimal(4)noForecast Cost (23)
BudgetVersionGLFig24EacTCdecimal(4)noForecast Cost (24)
BudgetVersionGLFig25EacTCdecimal(4)noForecast Cost (25)
BudgetVersionGLFig26EacTCdecimal(4)noForecast Cost (26)
BudgetVersionGLFig27EacTCdecimal(4)noForecast Cost (27)
BudgetVersionGLFig28EacTCdecimal(4)noForecast Cost (28)
BudgetVersionGLFig29EacTCdecimal(4)noForecast Cost (29)
BudgetVersionGLFig30EacTCdecimal(4)noForecast Cost (30)
BudgetVersionGLFig31EacTCdecimal(4)noForecast Cost (31)
BudgetVersionGLFig32EacTCdecimal(4)noForecast Cost (32)
BudgetVersionGLFig33EacTCdecimal(4)noForecast Cost (33)
BudgetVersionGLFig34EacTCdecimal(4)noForecast Cost (34)
BudgetVersionGLFig35EacTCdecimal(4)noForecast Cost (35)
BudgetVersionGLFig36EacTCdecimal(4)noForecast Cost (36)
BudgetVersionGLFig37EacTCdecimal(4)noForecast Cost (37)
BudgetVersionGLFig38EacTCdecimal(4)noForecast Cost (38)
BudgetVersionGLFig39EacTCdecimal(4)noForecast Cost (39)
BudgetVersionGLFig40EacTCdecimal(4)noForecast Cost (40)
BudgetVersionGLFig41EacTCdecimal(4)noForecast Cost (41)
BudgetVersionGLFig42EacTCdecimal(4)noForecast Cost (42)
BudgetVersionGLFig43EacTCdecimal(4)noForecast Cost (43)
BudgetVersionGLFig44EacTCdecimal(4)noForecast Cost (44)
BudgetVersionGLFig45EacTCdecimal(4)noForecast Cost (45)
BudgetVersionGLFig46EacTCdecimal(4)noForecast Cost (46)
BudgetVersionGLFig47EacTCdecimal(4)noForecast Cost (47)
BudgetVersionGLFig48EacTCdecimal(4)noForecast Cost (48)
BudgetVersionGLFig49EacTCdecimal(4)noForecast Cost (49)
BudgetVersionGLFig50EacTCdecimal(4)noForecast Cost (50)
BudgetVersionGLFig51EacTCdecimal(4)noForecast Cost (51)
BudgetVersionGLFig52EacTCdecimal(4)noForecast Cost (52)
BudgetVersionGLFig53EacTCdecimal(4)noForecast Cost (53)
BudgetVersionGLFig54EacTCdecimal(4)noForecast Cost (54)
BudgetVersionGLFig01EacQTYdecimal(4)noForecast Qty (01)
BudgetVersionGLFig02EacQTYdecimal(4)noForecast Qty (02)
BudgetVersionGLFig03EacQTYdecimal(4)noForecast Qty (03)
BudgetVersionGLFig04EacQTYdecimal(4)noForecast Qty (04)
BudgetVersionGLFig05EacQTYdecimal(4)noForecast Qty (05)
BudgetVersionGLFig06EacQTYdecimal(4)noForecast Qty (06)
BudgetVersionGLFig07EacQTYdecimal(4)noForecast Qty (07)
BudgetVersionGLFig08EacQTYdecimal(4)noForecast Qty (08)
BudgetVersionGLFig09EacQTYdecimal(4)noForecast Qty (09)
BudgetVersionGLFig10EacQTYdecimal(4)noForecast Qty (10)
BudgetVersionGLFig11EacQTYdecimal(4)noForecast Qty (11)
BudgetVersionGLFig12EacQTYdecimal(4)noForecast Qty (12)
BudgetVersionGLFig13EacQTYdecimal(4)noForecast Qty (13)
BudgetVersionGLFig14EacQTYdecimal(4)noForecast Qty (14)
BudgetVersionGLFig15EacQTYdecimal(4)noForecast Qty (15)
BudgetVersionGLFig16EacQTYdecimal(4)noForecast Qty (16)
BudgetVersionGLFig17EacQTYdecimal(4)noForecast Qty (17)
BudgetVersionGLFig18EacQTYdecimal(4)noForecast Qty (18)
BudgetVersionGLFig19EacQTYdecimal(4)noForecast Qty (19)
BudgetVersionGLFig20EacQTYdecimal(4)noForecast Qty (20)
BudgetVersionGLFig21EacQTYdecimal(4)noForecast Qty (21)
BudgetVersionGLFig22EacQTYdecimal(4)noForecast Qty (22)
BudgetVersionGLFig23EacQTYdecimal(4)noForecast Qty (23)
BudgetVersionGLFig24EacQTYdecimal(4)noForecast Qty (24)
BudgetVersionGLFig25EacQTYdecimal(4)noForecast Qty (25)
BudgetVersionGLFig26EacQTYdecimal(4)noForecast Qty (26)
BudgetVersionGLFig27EacQTYdecimal(4)noForecast Qty (27)
BudgetVersionGLFig28EacQTYdecimal(4)noForecast Qty (28)
BudgetVersionGLFig29EacQTYdecimal(4)noForecast Qty (29)
BudgetVersionGLFig30EacQTYdecimal(4)noForecast Qty (30)
BudgetVersionGLFig31EacQTYdecimal(4)noForecast Qty (31)
BudgetVersionGLFig32EacQTYdecimal(4)noForecast Qty (32)
BudgetVersionGLFig33EacQTYdecimal(4)noForecast Qty (33)
BudgetVersionGLFig34EacQTYdecimal(4)noForecast Qty (34)
BudgetVersionGLFig35EacQTYdecimal(4)noForecast Qty (35)
BudgetVersionGLFig36EacQTYdecimal(4)noForecast Qty (36)
BudgetVersionGLFig37EacQTYdecimal(4)noForecast Qty (37)
BudgetVersionGLFig38EacQTYdecimal(4)noForecast Qty (38)
BudgetVersionGLFig39EacQTYdecimal(4)noForecast Qty (39)
BudgetVersionGLFig40EacQTYdecimal(4)noForecast Qty (40)
BudgetVersionGLFig41EacQTYdecimal(4)noForecast Qty (41)
BudgetVersionGLFig42EacQTYdecimal(4)noForecast Qty (42)
BudgetVersionGLFig43EacQTYdecimal(4)noForecast Qty (43)
BudgetVersionGLFig44EacQTYdecimal(4)noForecast Qty (44)
BudgetVersionGLFig45EacQTYdecimal(4)noForecast Qty (45)
BudgetVersionGLFig46EacQTYdecimal(4)noForecast Qty (46)
BudgetVersionGLFig47EacQTYdecimal(4)noForecast Qty (47)
BudgetVersionGLFig48EacQTYdecimal(4)noForecast Qty (48)
BudgetVersionGLFig49EacQTYdecimal(4)noForecast Qty (49)
BudgetVersionGLFig50EacQTYdecimal(4)noForecast Qty (50)
BudgetVersionGLFig51EacQTYdecimal(4)noForecast Qty (51)
BudgetVersionGLFig52EacQTYdecimal(4)noForecast Qty (52)
BudgetVersionGLFig53EacQTYdecimal(4)noForecast Qty (53)
BudgetVersionGLFig54EacQTYdecimal(4)noForecast Qty (54)
tiBudgetFDSSeqintegernoBudgetFDSSeq
tcBudgetFDSTypecharacter(20)noBudgetFDSType
tcBudgetWBSCodecharacter(40)noTopic
tcBudgetWBSSeqcharacternoBudgetWBSSeq
tiParentBudgetWBS_IDintegerno
tiBudgetWBSLineNumberintegernoClass
tcBudgetWBSTopicDescriptioncharacter(120)no
tlBudgetWBSIsPrintDesclogicalno
tcBudgetGroupCodecharacter(20)no
tcAltCOAGroupCodecharacter(20)no
tcBudgetWBSFDSLinkcharacter(1024)no
tcBudgetWBSCategorycharacter(20)no
value list:{&BUDGETWBSCATEGORYS}
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudgetVersion.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetWBS


field namedata typemnd.description
BudgetWBS_IDintegeryesRecord ID
Budget_IDintegeryesLink to Budget
ParentBudgetWBS_IDintegernoLink to BudgetWBS
SafStructure_IDintegernoSAF Structure
SafConcept_IDintegernoSAF Concept Code
BudgetGroup_IDintegernoBudget Group
BudgetFDS_IDintegernoLink to BudgetFDS
Unit_IDintegernoGL Account Unit of Measure
AltCOAGroup_IDintegernoAlternate COA Group
BudgetFDSSeqintegeryesCOA Sequence
BudgetFDSTypecharacter(20)yesCOA Type
value list:{&BUDGETFDSTYPES}
BudgetWBSCodecharacter(40)yesWBS Code
BudgetWBSSeqdecimal(0)yesWBS Seq
BudgetWBSFDSFromCodecharacter(20)noFrom COA
BudgetWBSFDSToCodecharacter(20)noTo COA
BudgetWBSFDSCodecharacter(20)noCOA Code
BudgetWBSFDSListcharacter(1024)noCOA List
BudgetWBSFDSLinkcharacter(1024)noLink by Level
BudgetWBSFDSDefaultcharacter(20)noCOA Default
BudgetWBSOverrunTotalcharacter(20)yesTotal Overrun
value list:{&BUDGETOVERRUNS}
BudgetWBSOverrunPeriodcharacter(20)yesGL Period Overrun
value list:{&BUDGETOVERRUNS}
BudgetWBSOverrunYTDcharacter(20)yesOverrun (YTD)
value list:{&BUDGETOVERRUNS}
BudgetWBSPercOfCompdecimal(3)noPercentage (ETC)
BudgetWBSCostRevenuecharacter(20)yesCost/Revenue
value list:{&BUDGETWBSCOSTREVENUES}
BudgetWBSCommentcharacter(2000)noComment
BudgetWBSStatuscharacter(20)yesStatus
value list:{&BUDGETWBSSTATUSES}
BudgetWBSCostTypecharacter(20)noCost Type
value list:{&BUDGETWBSCOSTTYPES}
BudgetWBSIsHideOnReportlogicalyesHide On Reporting
tdBudgetWBSActualTCdecimal(4)noTC Actual
tdBudgetWBSCommitTCdecimal(4)noTC Commitment
BudgetWBSIsInvertBaselogicalyesInvert Base Sign
BudgetWBSLineNumberintegernoClass
BudgetWBSTopicDescriptioncharacter(120)noTopic Description
BudgetWBSIsWithSumLinelogicalyesPrint Sum Line
BudgetWBSIsRollUplogicalyesRoll Up Amount
BudgetWBSIsPrintDesclogicalyesPrint Description
BudgetWBSCategorycharacter(20)yesCategory
value list:{&BUDGETWBSCATEGORYS}
tcSafStructureCodecharacter(20)noSAF Structure
tcSafConceptCodecharacter(20)noSAF Concept Code
tcBudgetGroupCodecharacter(20)noBudget Group
tcUnitCodecharacter(20)noGL Account Unit of Measure
tcAltCOAGroupCodecharacter(20)no
tcBudgetWBSSeqStrcharacterno
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudget.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetWBSBusComponent


field namedata typemnd.description
BudgetWBSBusComponent_IDintegeryesRecord ID
BusComponent_IDintegeryesComponent
BudgetWBS_IDintegeryesLink to BudgetWBS
Budget_IDintegernoLink to Budget
tcBusComponentCodecharacter(26)yesComponent
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudgetWBS.tc_Rowid
tc_Statuscharacternoupdate status

table tBudgetWBSRoster


field namedata typemnd.description
BudgetWBSRoster_IDintegeryesRecord ID
BudgetWBS_IDintegeryesLink to BudgetWBS
BudgetWBSRosterDatedateyesDate
BudgetWBSRosterPercOfCompdecimal(3)yesPercentage (ETC)
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBudgetWBS.tc_Rowid
tc_Statuscharacternoupdate status

table tTransString

Description

Table for keeping translations of end-user data.
The application defines what columns can be translated, and the end-user maintains the translations itself.

field namedata typedescription
tiParentObject_IDinteger
tcLngCodecharacter
tcTranslationStringTextcharacter
tc_ParentRowidcharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_Statuscharacter

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter