MfgJournalEntryErrorCache

Manufacturing Journal Entry Error Cache

Minor Business Rule

Object Name: B3104290

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of this function is to perform all caching functionality for the Manufacturing Journal Entry Error Cache.  The Manufacturing Journal
Entry Error Cache is used by the Manufacturing Journal Entries UBE (R31802A) to cache all journal entry error records in order to print these records
on the report output.

Setup Notes and Prerequisites
The ManufacturingJournalEntryErrorCache function must be called with cMode = 0 in order to create an instance of the cache before any other
caching functionality can be performed.  In addition, the cache must be called with cMode = 4 after all desired caching functionality has been performed in
order to terminate the cache.

Business Function Paramenters:
1.  cMode - Indicates the desired processing.
     Valid modes include:
0 = Create an instance of the cache
1 = Add a record to cache
2 = Read a record from cache
4 = Terminate the cache
2.  szCacheJobNumber - A unique job number that can be combined with business function object name to create a unique cache name.
3.   idhCursor - A cursor pointing to a particular record in the cache.  The cursor is passed back from the function when the cReturnPointer
parameter is set to '1' and should be passed into the function for a sequential read of the cache.
4.   szBatchType - A member of the cache and part of the cache key.
5.   mnBatch Number - A member of the cache and part of the cache key.
6.   jdBatch Date - A member of the cache.
7.   szGLAccountNumber - A member of the cache and part of the cache key.
8.   jdGLDate - A member of the cache.
9.   szDocumentType - A member of the cache and part of the cache key.
10.  szGLCategory - A member of the cache.
11.  szCostType - A member of the cache and part of the cache key.
12.  szErrorType - A member of the cache and part of the cache key.
13.  szErrorDescription - A member of the cache and part of the cache key.
14.  szCostType - A member of the cache and part of the cache key.
15.  szErrorMessageID - The error message ID returned from the business function when an error occurs during processing.  This ID is
    returned regardless of the value in the cSuppressErrorMessage parameter.
16.  cSuppressErrorMessage - A value of '1' indicates that errors encountered during processing should not be set in the message center.
17.  mnAAINumber - A member of the cache and part of the cache key.

Technical Specifications
Cache Structure:
szBatchType
  mnBatchNumber
  szGLAccountNumber
  mnAAINumber
  szDocumentType
  szGLCategory
  szCostType
  szErrorType
szErrorDescription
  szErrorMessageID
  szCacheJobNumber
  jdBatchDate
  jdGLDate
Cache Key:
                szBatchType
  mnBatchNumber
  szGLAccountNumber
  mnAAINumber
  szDocumentType
szGLCategory
  szCostType
  szErrorType

Data Structure

D3104290 - Manufacturing Journal Entry Error Cache

Parameter Name Data Item Data Type Req/Opt I/O/Both

cMode EV01 char OPT NONE

An option that specifies the type of processing for an event.

szCacheJobNumber JOBN char OPT NONE

The code that identifies the work station ID that executed a particular job.

idhCursor GENLNG ID OPT NONE

General purpose ID variable.

szBatchType ICUT char OPT NONE

A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded.

mnBatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

jdBatchDate DBT JDEDATE OPT NONE

The date of the batch.  If you leave this field blank, the system uses the current date.

szGLAccountNumber 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
number (business unit.object.subsidiary or flex format).   o  Third G/L number (maximum of 25 digits).   o  Account ID number. The number is eight
digits long.     o  Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of
an account number. The first character of the account number indicates its format. You define the account format in the General Accounting
constants.

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
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.

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
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

szGLCategory GLPT char OPT NONE

A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
you do not want to specify a class code, you can enter **** (four asterisks) in this field. You can use automatic accounting instructions (AAIs) to
predefine classes of automatic offset accounts for the Inventory Management, Procurement, and Sales Order Management systems. You
might assign G/L class codes as follows:    IN20   Direct Ship Orders    IN60   Transfer Orders    IN80   Stock Sales The system can generate
accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries
similar to the following:         Sales-Stock (Debit) xxxxx.xx    A/R Stock Sales (Credit) xxxxx.xx    Posting Category: IN80             Stock Inventory
(Debit) xxxxx.xx    Stock COGS (Credit) xxxxx.xx The system uses the class code and the document type to find the AAI.

szCostType COST char OPT NONE

A code that designates each element of cost for an item. Examples of the cost object types are:   o  A1  Purchased raw material   o  B1
Direct labor routing rollup   o  B2  Setup labor routing rollup   o  C1  Variable burden routing rollup   o  C2  Fixed burden routing rollup   o  Dx  Outside
operation routing rollup   o  Xx  Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type
Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The
system then associates these cost components with one of six user defined summary cost buckets.

szErrorType A202 char OPT NONE

szErrorDescription DS80 char OPT NONE

A free-form text field for comments or memoranda.

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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cSuppressErrorMessage EV01 char OPT NONE

An option that specifies the type of processing for an event.

mnAAINumber ANUM MATH_NUMERIC OPT NONE

A number used to specify sequence and retrieve accounting information.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szCacheJobNumber	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
idhCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
szBatchType	ICUT	char	OPT	NONE
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction. Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded.
mnBatchNumber	ICU	MATH_NUMERIC	OPT	NONE
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
jdBatchDate	DBT	JDEDATE	OPT	NONE
The date of the batch. If you leave this field blank, the system uses the current date.
szGLAccountNumber	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 number (business unit.object.subsidiary or flex format). o Third G/L number (maximum of 25 digits). o Account ID number. The number is eight digits long. o Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of an account number. The first character of the account number indicates its format. You define the account format in the General Accounting constants.
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 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.
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 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
szGLCategory	GLPT	char	OPT	NONE
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If you do not want to specify a class code, you can enter **** (four asterisks) in this field. You can use automatic accounting instructions (AAIs) to predefine classes of automatic offset accounts for the Inventory Management, Procurement, and Sales Order Management systems. You might assign G/L class codes as follows: IN20 Direct Ship Orders IN60 Transfer Orders IN80 Stock Sales The system can generate accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries similar to the following: Sales-Stock (Debit) xxxxx.xx A/R Stock Sales (Credit) xxxxx.xx Posting Category: IN80 Stock Inventory (Debit) xxxxx.xx Stock COGS (Credit) xxxxx.xx The system uses the class code and the document type to find the AAI.
szCostType	COST	char	OPT	NONE
A code that designates each element of cost for an item. Examples of the cost object types are: o A1 Purchased raw material o B1 Direct labor routing rollup o B2 Setup labor routing rollup o C1 Variable burden routing rollup o C2 Fixed burden routing rollup o Dx Outside operation routing rollup o Xx Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user defined summary cost buckets.
szErrorType	A202	char	OPT	NONE

szErrorDescription	DS80	char	OPT	NONE
A free-form text field for comments or memoranda.
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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cSuppressErrorMessage	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnAAINumber	ANUM	MATH_NUMERIC	OPT	NONE
A number used to specify sequence and retrieve accounting information.