field name | data type | db field | description |
tiBudget_ID | integer | BudgetWBS.Budget_ID | Link to Budget |
tiBudgetFDS_ID | integer | BudgetWBS.BudgetFDS_ID | Link to BudgetFDS |
tiBudgetFDSSeq | integer | BudgetWBS.BudgetFDSSeq | COA Sequence |
tcBudgetFDSType | character | BudgetWBS.BudgetFDSType | COA Type |
tiBudgetGroup_ID | integer | BudgetWBS.BudgetGroup_ID | Budget Group |
tiBudgetWBS_ID | integer | BudgetWBS.BudgetWBS_ID | Record ID |
tcBudgetWBSCode | character | BudgetWBS.BudgetWBSCode | WBS Code |
tcBudgetWBSCostRevenue | character | BudgetWBS.BudgetWBSCostRevenue | Cost/Revenue |
tcBudgetWBSCostType | character | BudgetWBS.BudgetWBSCostType | Cost Type |
tcBudgetWBSFDSCode | character | BudgetWBS.BudgetWBSFDSCode | COA Code |
tcBudgetWBSFDSDefault | character | BudgetWBS.BudgetWBSFDSDefault | COA Default |
tcBudgetWBSFDSFromCode | character | BudgetWBS.BudgetWBSFDSFromCode | From COA |
tcBudgetWBSFDSList | character | BudgetWBS.BudgetWBSFDSList | COA List |
tcBudgetWBSFDSToCode | character | BudgetWBS.BudgetWBSFDSToCode | To COA |
tcBudgetWBSOverrunPeriod | character | BudgetWBS.BudgetWBSOverrunPeriod | GL Period Overrun |
tcBudgetWBSOverrunTotal | character | BudgetWBS.BudgetWBSOverrunTotal | Total Overrun |
tcBudgetWBSOverrunYTD | character | BudgetWBS.BudgetWBSOverrunYTD | Overrun (YTD) |
tdBudgetWBSPercOfComp | decimal | BudgetWBS.BudgetWBSPercOfComp | Percentage (ETC) |
tdBudgetWBSSeq | decimal | BudgetWBS.BudgetWBSSeq | WBS Seq |
tcBudgetWBSStatus | character | BudgetWBS.BudgetWBSStatus | Status |
tiParentBudgetWBS_ID | integer | BudgetWBS.ParentBudgetWBS_ID | Link to BudgetWBS |
tiSafConcept_ID | integer | BudgetWBS.SafConcept_ID | SAF Concept Code |
tiSafStructure_ID | integer | BudgetWBS.SafStructure_ID | SAF Structure |
tiUnit_ID | integer | BudgetWBS.Unit_ID | GL Account Unit of Measure |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(BudgetWBS) |