UpdateBudgetAmount
Update Budget Amount
Major Business Rule
Object Name: B1400001
Parent DLL: CFIN
Location: Client/Server
Language: C
Functional Description
Purpose
This function updates the F0902(Account Balances table) requested, approved and final budget amount,
as well as the fourteen period fields. If the record does not exist, this business function will
create the F0902 record.
Setup Notes and Prerequisites
This function uses the account ID, century, fiscal year, fiscal quarter, ledger type, subledger,
subledger type and currency code to determine the F0902 record to update or create.
Technical Specification
• Use account ID, century, fiscal year, fiscal quarter, ledger type, subledger, subledger type and
currency code as the key to select the F0902 record.
• If the F0902 record exists
• Update the requested, approved, final and fourteen period amounts for that record.
• Else if record does not exist
• Create the F0902 record using the account ID, century, fiscal year, fiscal quarter, ledger type,
subledger, subledger type and currency code passed in as parameters.
^
Data Structure
D1400385 - Update 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 which will be used as part of the key for the
F0902 record to update or create.
^ |
| mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This required input parameter receives the fiscal year which will be used as part of the key for the
F0902 record to update or create.
^ |
| szAccountId | AID | char | NONE | NONE |
Special Input Expected
This required input parameter receives the Account ID which will be used as part of the key for the
F0902 record to update or create.
^ |
| szSubledger | SBL | char | NONE | NONE |
Special Input Expected
This required input parameter receives the subledger which will be used as part of the key for the
F0902 record to update or create.
^ |
| cSubledgerType | SBLT | char | NONE | NONE |
Special Input Expected
This required input parameter receives the subledger type which will be used as part of the key for
the F0902 record to update or create.
^ |
| mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This required input parameter receives the century which will be used as part of the key for the
F0902 record to update or create.
^ |
| szFiscalQtr | FQ | char | NONE | NONE |
Special Input Expected
This required input parameter receives the fiscal quarter which will be used as part of the key for
the F0902 record to update or create.
^ |
| cEveresteventpoint01 | EV01 | char | NONE | NONE |
Special Input Expected
This parameter is currently not being used.
^ |
| szCurrencyCode | CRCD | char | NONE | NONE |
Special Input Expected
This required input parameter receives the currency code which will be used as part of the key for
the F0902 record to update or create.
^ |
| mnAmount1 | AN01 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #1 amount to update.
^ |
| mnAmount2 | AN02 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #2 amount to update.
^ |
| mnAmount3 | AN03 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #3 amount to update.
^ |
| mnAmount4 | AN04 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #4 amount to update.
^ |
| mnAmount5 | AN05 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #5 amount to update.
^ |
| mnAmount6 | AN06 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #6 amount to update.
^ |
| mnAmount7 | AN07 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #7 amount to update.
^ |
| mnAmount8 | AN08 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #8 amount to update.
^ |
| mnAmount9 | AN09 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #9 amount to update.
^ |
| mnAmount10 | AN10 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #10 amount to update.
^ |
| mnAmount11 | AN11 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #11 amount to update.
^ |
| mnAmount12 | AN12 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #12 amount to update.
^ |
| mnAmount13 | AN13 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #13 amount to update.
^ |
| mnAmount14 | AN14 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the period #14 amount to update.
^ |
| cSpreadFlag | EV07 | char | NONE | NONE |
Special Input Expected
This parameter is currently not being used.
^ |
| mnAmountRetrieved | MATH01 | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This parameter is currently not being used.
^ |
| szCompany | CO | char | NONE | NONE |
Special Input Expected
This required input parameter receives the company of the account and is used when creating a new
F0902 record.
^ |
| szCostCenter | MCU | char | NONE | NONE |
Special Input Expected
This required input parameter receives the cost center of the account and is used when creating a new
F0902 record.
^ |
| szObjectAccount | OBJ | char | NONE | NONE |
Special Input Expected
This required input parameter receives the object account of the account and is used when creating a
new F0902 record.
^ |
| szSubsidiary | SUB | char | NONE | NONE |
Special Input Expected
This required input parameter receives the subsidiary of the account and is used when creating a new
F0902 record.
^ |
| mnBudgetRequested | BREQ | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the requested budget amount to update.
^ |
| mnBudgetApproved | BAPR | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the approved budget amount to update.
^ |
| mnBudgetFinal | BORG | MATH_NUMERIC | NONE | NONE |
Special Input Expected
This input parameter receives the final budget amount to update.
^ |
| szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|