GetCashForecastColumnAmounts

Get Cash Forecast Column Amounts

Minor Business Rule

Object Name: B0900188

Parent DLL: CFIN

Location: Client/Server

Language: C

Data Structure

D0900188 - Get Cash Forecast Column Amounts

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCashType	CSHTYP	char	REQ	INPUT
A unique 10-character value identifying a source of cash inflow or outflow, such as open invoices, open vouchers, or bank accounts. This name must exist in User Defined Codes 09\|CT.
jdBasedOnDate	BSDATE	JDEDATE	REQ	INPUT
In cash forecasting, the date that a data refresh was performed on.
szBankAID	BNKAID	char	OPT	BOTH
A number that the system assigns to general ledger accounts in the Account Master table (F0901) to uniquely identify them.
szCurrencyCodeBase	BCRC	char	OPT	BOTH
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the domestic side of the transaction.
jdBeginDate	BEGDATE	JDEDATE	OPT	BOTH
The beginning date from which information will be displayed.
jdEndingDate	ENDDATE	JDEDATE	OPT	BOTH
The ending date that information will be displayed for.
szNodeRevalCurr	NDCRCD	char	OPT	BOTH
A currency that cash forecast amounts for this cash type will be stored in (F09522). If revaluation is necessary for cash forecast amounts when data is being refreshed, the exchange rates used in calculating the revalued amount will be retrieved corresponding to the refresh based on date.
mnTotalNodeAmount	NDAA	MATH_NUMERIC	OPT	BOTH
A revalued amount in a different currency than the actual amount.
szSourceSystem	SRCSYS	char	OPT	INPUT
The accounting system that contains the source table to be used when extracting cash forecasting information for a cash type. Valid values are: 03B Accounts Receivable System (for cash types involving open A/R invoices). 04 Accounts Payable System (for cash types involving A/P open vouchers). 09 General Ledger System (for cash types involving balances for G/L bank accounts).
cBankStmtBalanceMode	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnBalanceOnBaseDate	NDAA	MATH_NUMERIC	OPT	BOTH
A revalued amount in a different currency than the actual amount.
mnAutoBankStmtNumber	BSTN	MATH_NUMERIC	OPT	OUTPUT
The statement number assigned by the bank for the bank account.
jdAutoBankStmtDate	STMD	JDEDATE	OPT	OUTPUT
The From and Thru dates specify the range of dates you would like to use to view records in the Bank Statement Detail section of the form.
cFirstPassForAcct	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
nNoDisplayDecimalsBankAmt	INT01	integer	OPT	INPUT
Number of Days in Future to Query for Responses Due.
nNoDisplayDecimalsNodeAmt	INT01	integer	OPT	INPUT
Number of Days in Future to Query for Responses Due.
cCurrencyConversionMethod	CRCM	char	OPT	INPUT
A value that specifies which method to use when converting from one currency to another. Valid values are: Y Multiplier method. The system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount. Z Divisor method. The system divides the foreign amount by the divisor exchange rate to calculate the domestic amount.

Related Functions

B0900190 Get Auto Bank Statement Closing Balance

Related Tables

F09522 Cash Forecast Data