RetrieveBudgetAmount
Retrieve Budget Amount
Minor Business Rule
Object Name: B0000323
Parent DLL: CFIN
Location: Client/Server
Language: C
Functional Description
Purpose
This business function will return the period amounts and the annual budget amounts for a specified
account, fiscal year, century, ledger type, subledger, subledger type, and currency code.
Technical Specification
• Determine the number of keys to use to retrieve the F0902 record
• Open the F0902 table
• Retrieve the F0902 record based on the keys passed in as parameters.
• If the retrieval is successful
• Return the 14 period amounts, requested budget, approved budget amount, final budget amount, memo
budget changes amount, percent complete, and memo commitment changes amount.
Data Structure
D0000323 - Retrieve Budget Amount
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| szLedgerType | LT | char | NONE | NONE |
Special Input Expected
This required input parameter receives the ledger type to be used to retrieve the F0902 record.
^ |
| mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This required input parameter receives the fiscal year to be used to retrieve the F0902 record.
^ |
| szAccountId | AID | char | NONE | NONE |
Special Input Expected
This required input parameter receives the Account ID to be used to retrieve the F0902 record.
^ |
| szSubledger | SBL | char | NONE | NONE |
Special Input Expected
This required input parameter receives the subledger to be used to retrieve the F0902 record.
Significant Data Values
* - Specify this value to include all subledgers in the
retrieval
^ |
| cSubledgerType | SBLT | char | NONE | NONE |
Special Input Expected
This input parameter receives the subledger type to be used to retrieve the F0902 record. If the
subledger parameter is an '*', then this parameter should be left blank.
^ |
| mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This required input parameter receives the century to be used to retrieve the F0902 record.
^ |
| szFiscalQtr | FQ | char | NONE | NONE |
Special Input Expected
This input parameter receives the fiscal quarter to be used to retrieve the F0902 record.
^ |
| szCurrencyCode | CRCD | char | NONE | NONE |
Special Input Expected
This required input parameter receives the currency code to be used to retrieve the F0902 record.
Significant Data Values
* - Specify this value to include all currencies in the
retrieval
^ |
| mnAmountRequested | BREQ | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the requested budget amount for the key specified.
^ |
| mnAmountApproved | BAPR | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the approved budget amount for the key specified.
^ |
| mnAmountOriginal | BORG | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the final budget amount for the key specified.
^ |
| mnAmount1 | AN01 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #1 amount for the key specified.
^ |
| mnAmount2 | AN02 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #2 amount for the key specified.
^ |
| mnAmount3 | AN03 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #3 amount for the key specified.
^ |
| mnAmount4 | AN04 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #4 amount for the key specified.
^ |
| mnAmount5 | AN05 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #5 amount for the key specified.
^ |
| mnAmount6 | AN06 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #6 amount for the key specified.
^ |
| mnAmount7 | AN07 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #7 amount for the key specified.
^ |
| mnAmount8 | AN08 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #8 amount for the key specified.
^ |
| mnAmount9 | AN09 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #9 amount for the key specified.
^ |
| mnAmount10 | AN10 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #10 amount for the key specified.
^ |
| mnAmount11 | AN11 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #11 amount for the key specified.
^ |
| mnAmount12 | AN12 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #12 amount for the key specified.
^ |
| mnAmount13 | AN13 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #13 amount for the key specified.
^ |
| mnAmount14 | AN14 | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the period #14 amount for the key specified.
^ |
| mnAmtProjectedOverUnder | POU | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the budget changes amount for the key specified.
^ |
| mnPercentComplete | PC | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the percent complete for the key specified.
^ |
| mnUnitsProjectedFinal | TKER | MATH_NUMERIC | NONE | NONE |
Special Output Returned
This output parameter returns the commitment changes amount for the key specified.
^ |