Table Description
: A fund transaction. A BudgetAdjustment is a fund transaction impacting fund balances which results from budget modifications or other financial transactions on the system. Each BudgetAdjustment is associated with a financial transaction such as service authorizations, budget creation or adjustment and expenditures which are allocated to a specific fund.
Model Details
Location in Model: Logical View::MetaModel::Curam::FundPM::Service Layer::Budget Adjustment::Entity::BudgetAdjustment
Controlling File: FundPM\model\Packages\Service Layer\Fund Line Item\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
budgetAdjustmentIDkeynoUnique reference number assigned by the system to a Fund Line Item record.BUDGET_ADJUSTMENT_ID SVR_INT64
creditDebitTypedetailsnoCode value denoting whether the fund transaction increases or decreases the fund balance.CREDIT_DEBIT_CODECreditDebitSVR_STRING<10>
amountdetails The financial amount associated with the fund transaction.CURAM_AMOUNT SVR_MONEY
creationDatedetailsnoThe date the record was created.CURAM_DATE SVR_DATE
commentsdetails Comments associated with the fund transaction.COMMENTS SVR_STRING<300>
allocationRefNodetails Allocation Reference number assigned to the fund fiscal year line item when it is recorded, to reference where the allocation originated.REFERENCE_NUMBER SVR_STRING<20>
userFirstNamedetails First name of the user who created the record.USER_FIRST_FORENAME SVR_STRING<65>
userLastNamedetails Last name of the user who created the record.USER_SURNAME SVR_STRING<65>
relatedIDdetailsnoThe unique reference number of the related financial transaction which caused the fund transaction to be created, such as a Product Delivery or Planned Item. INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe related type for the fund fiscal year set aside.BUDGET_ADJUSTMENT_RELATED_TYPEBudgetAdjustmentTypeSVR_STRING<10>
Indices (1)
Index NameAttributes
IND_490747193relatedID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: budgetAdjustmentID
Creates a budget adjustment record. 
readread Reads a budget adjustment record details. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing budget adjustment record. 
removeremove Deletes an existing budget adjustment record. 
searchByRelatedIDreadmultiORDER_BY: creationDate
Retrieves the budget adjustment by related ID. 
Related Pages (18)