Functional Description
Purpose
This business function will return the 14 individual period, annual budget, prior year balance, and
prior year net posting 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
budget, approved budget amount, and final budget amount.
D1400013 - Return Budget and Period Amounts Rollup
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szAccountId | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
szFiscalQtr | FQ | char | NONE | NONE |
A data field reserved for future use. | ||||
szLedgerType | LT | char | NONE | NONE |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
szSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnAmtBeginningBalancePY | APYC | MATH_NUMERIC | NONE | NONE |
The cumulative prior year-end balance. The system uses this amount as the beginning balance for balance sheet and job cost
| ||||
mnAmountNetPosting001 | AN01 | MATH_NUMERIC | NONE | NONE |
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting002 | AN02 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting003 | AN03 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting004 | AN04 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting005 | AN05 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting006 | AN06 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting007 | AN07 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting008 | AN08 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting009 | AN09 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting010 | AN10 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting011 | AN11 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting012 | AN12 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting013 | AN13 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmountNetPosting014 | AN14 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnAmtPriorYrNetPost | APYN | MATH_NUMERIC | NONE | NONE |
The prior year-end net postings. The system uses this number for profit and loss statement comparisons.
NOTE: Do not confuse this
| ||||
mnBudgetRequested | BREQ | MATH_NUMERIC | NONE | NONE |
A code that specifies the ledger type with which to track amounts in the Account Balances table (F0902). Valid values are:
| ||||
mnBudgetApproved | BAPR | MATH_NUMERIC | NONE | NONE |
This field tracks the following amounts in the Account Balances file (F0902):
Ledger type - BA/BU. Approved Budget from Budget by
| ||||
mnAmtOriginal | BORG | MATH_NUMERIC | NONE | NONE |
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902). |
None |
F0902 Account Balances |