Functional Description
Purpose
Returns the fourteen periods amounts, the prior year net postings, and balance forward for the account requested using one of four possible
secnarios. Case 1 is a specific subledger and currency code has been requested. Case 2 is a specific subledger and all currency codes have
been requested. Case 3 is all subledgers and all currency codes have been requested. Case 4 is all subledgers and a specific currency code
has been requested.
The values in the subledger and currency fields determine how the account balances will be rolled together. (An "*" will indicate all
subledgers, and/or all currencies). A blank value in either field will look for the F0902 with the key value or blank.
D0900060 - Return Account Balances Periods
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
| ||||
mnFiscalYear1 | 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 |
Special Input Expected
| ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
Special Input Expected
| ||||
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
|
None |
F0902 Account Balances |