1.Functional Description
1.1Purpose
This business function stores and retrieves detailed journal entries created by Manufacturing Journal
Entries (R31802) in Summarized Reporting mode.
1.2Setup Notes and Prerequisites
None.
1.3Special Logic
None.
2.Technical Specifications
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
JOBSJob NumberIYKey to cache
AIDAccount IdI/OKey to cache
DOCOOrder NumberI/O
DCTDocument TypeI/O
DOCDocument NumberI/O
DCTOOrder TypeI/O
DGJGL DateI/O
COCompanyI/O
DL01Account DescriptionI/O
EXAExplanationI/O
EXRRemarkI/O
ANIAccount NumberI/O
SBLSubledgerI/O
SBLTSubledgerTypeI/O
AACreditI/O
AADebitI/O
LTLedger TypeI/O
EV01Suppress Error MessagesI
DTAIError Message IDO
EV01ModeIY'1' = Add/update
'2' = Read
'3' = Terminate
cache
EV01Error CodeO'0' = no errors
'1' = error
'2' = end of cache records
GENLNGCache PointerI/ORead Mode only. Returned after first
call. Must pass in to retrieve subsequent
cache records.
2.2Related Tables
None
2.3Related Business Functions
None
2.4Processing
The following actions will be performed by the business function:
Add Mode:
1. Adds input parameters to cache.
2. If add fails, debit and credit amounts are accumulated for duplicate key values (Job Number and
Account ID). Cache is updated by input parameters and accumulated debit/credit amounts.
Read Mode:
1.Record is fetched from cache using Job Number and Account Id (if not blank).
2.If fetch is successful, record is loaded to output parameters.
3.If sequential fetch fails, error code = '2' (end of records in cache). Cache is terminated.
Terminate Cache Mode:
1.Cache is terminated.
If any errors occur, the function will return '1' in the Error Code field, and '0' if there are no
errors.
D3101710 - Manufacturing Journal Entries Report Cache Data Structure
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szAccountId | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szDocumentType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnDocumentNumber | DOC | MATH_NUMERIC | OPT | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szOrderType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
jdGLDate | DGJ | JDEDATE | OPT | 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
| ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szAccountDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szExplanation | EXA | char | OPT | NONE |
A description, remark, explanation, name, or address. | ||||
szRemark | EXR | char | OPT | NONE |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
| ||||
szAccountNumber | ANI | char | OPT | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
szSubledger | SBL | char | OPT | 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 | OPT | 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
| ||||
mnCredit | AA | MATH_NUMERIC | OPT | 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
| ||||
mnDebit | AA | MATH_NUMERIC | OPT | 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
| ||||
szLedgerType | LT | char | OPT | 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
| ||||
cSuppressErrorMessages | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idCachePointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnJournalEntryLineNo | JELN | MATH_NUMERIC | OPT | 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. | ||||
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
|
None |
None |