CacheTransactionsForGLBudgetCkg

CacheTransactionsForGLBudgetChecking

Minor Business Rule

Object Name: B1400014

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

Functional Description

Purpose
This function will cache the unposted entries in the F0911 for a particular account number. It was
created for the R14115, G/L Budget Checking Report.

The cache items may be added, deleted or inquiry.
Technical Specification



2.1Parameters:


Data Item Data Structure DescriptionI/ORequiredNotes


 ActionCode2Required                        


 LineNumber                        


AIDAccountId                      


AAAmountField                       


LTLedgerType                     


DGYJDateForGLandVoucherJULIA          


DOCDocVoucherInvoiceE                


DOCTDocumentType                   


KCOCompanyKey                     





2.2Related Tables 


Table Table Description


F0911Account Ledger





2.3Related Business Functions


Source NameFunction Name


jdeCacheAdd


jdeCacheTerminateAll


jdeCacheFetch


jdeCacheCloseCursor


jdeCacheUpdate


jdeCacheDelete





2.4 Processing


Check action code. 


If action code is equal to "A", add,  copy the values from the F0911 to the cache. 





If the action code is equal to "I", inquiry, fetch the records in the existing cache. 





If the action code is equal to "D", delete, use jdeCacheTerminateAll to delete all the cache items.

Data Structure

D1400014 - CacheTransactionsForGLBudgetChecking

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode2	ACTN	char	NONE	NONE
A code that specifies the action that is performed. Valid values are: A Add C Change
mnLineNumber	LNID	MATH_NUMERIC	NONE	NONE
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
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.
mnAmountField	AA	MATH_NUMERIC	NONE	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
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 can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
jdDateForGLandVoucherJULIA	DGJ	JDEDATE	NONE	NONE
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.
mnDocVoucherInvoiceE	DOC	MATH_NUMERIC	NONE	NONE
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are: Accounts Payable o Original document - voucher o Matching document - payment Accounts Receivable o Original document - invoice o Matching document - receipt Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents: deductions, unapplied receipts, chargebacks, and drafts.
szDocumentType	DCT	char	NONE	NONE
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
szCompanyKey	KCO	char	NONE	NONE
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document.

Related Functions

None

Related Tables

None