AcctLedgForeignLTMatch

Account Ledger Foreign Ledger Type Match

Minor Business Rule

Object Name: B0900059

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function was written for the Account Ledger application. The function takes the key values from
the f0911 record in the grid and does a fetch key with a different ledger type. If the function
finds that ledger type match it will pull back the amount and populate the amount in the grid.

Technical Specification



2.1Parameters:


Data Item Data Structure DescriptionI/ORequiredNotes


dctDocument TypeRequired


docDocument NumberRequired


kcoCompany KeyRequired


dgjDateRequired


ltLedger TypeRequired


extlExtension LineRequired


jelnJournal Line NumberRequired


aaAmountNot Required





2.2Related Tables 


Table Table Description





F0911Account Ledger





2.3Related Business Functions


Source NameFunction Name


None





2.4 Processing


Open the F0911 table with values form required data items (listed above).





Retrieve Matching foreign Ledger Type (F0911).





Copy in the Foreign Amount to be used in the grid.

Data Structure

D0900059 - Account Ledger Foreign Ledger Type Match

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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
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.
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.
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.
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.
szLineextensioncode	EXTL	char	NONE	NONE
Line Extension Code
mnJournalentrylineno	JELN	MATH_NUMERIC	NONE	NONE
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes.
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.

Related Functions

None

Related Tables

F0911 Account Ledger