LoadSerialNosAssocCache

Load Serial Nos Assoc Cache

Minor Business Rule

Object Name: N3101310

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This function will load the serial number associations cache and the issued items cache from the Item
Ledger (F4111) table.  These cache are used in serial numbers processing in the Work Orders Serial
Numbers Association program (P3107E), Serialized Issued Items (P3106), and in the Work Order Completions
(P31114) program.

The association cache stores the parent to component serial number associations which are assigned in
the Serial Numbers Associations program (P3107E); P3107E is called from the Work Order Completions
(P31114) program.

The issued items cache stores serialized components which have been issued but not associated to a
parent serialized item.  This cache is used to filter Item Ledger (F4111) records for the grid in the
Issued Serialized Items application (P3106).  The LSN Associations (P3107E) application writes to this
cache when a component is "de-associated" (or deleted from through the associations application).

This function uses the cache utility function, "Cache Serial Number Associations" (B31001280) to
perform all standard cache functions (i.e. creating/terminating cache, all input/output functions).

1.3Special Logic
There is no special logic within this function.

2.Technical Specifications
2.4Processing

a)Read sequentially through the Item Ledger File (F4111) using the Order Number (DOCO) and the
Issue Document Type (DCTO) passed in as input.

b)For each record retrieved:

i)Skip the record if the Parent Item (KIT) is equal to the Component Item (ITM).
ii)Skip the record if the Component Lot Number (LOTN) is blank.
iii)Skip the record unless the F4102 Lot Process Type (SRCE) is greater than or equal to 4.

iv)At each change in the parent lot number:

(1)Call the "Calculated Serial No Seq No" (N3101340) business function to find a match
on the Order Number (DOCO) and Parent Lot Number (PLOT).
(2)If a match is found on the parent cache, retrieve the parent information from the
parent serial number cache using the "Cache, Serial Number Associations" (B3101280).

v)If the parent status is "P" (Pending), "A" (Associated) or blank call the "Cache, Serial
Number Issues" (N3101300) function to retrieve the quantity issued.

(1)If a matching parent cache record found and the qty issued is not zero:

(a)Write to the Issued Items cache if the Parent Lot is blank.
(b)Write to the Associations cache if the Parent Lot is not blank.

(2)If the parent cache was not found on the cache or the issued qty is zero:

(a)Write a deletion cache record.

c)After all the F4111 records have been processed, eliminate any duplicates which might exist
between the Issued Items and Associations cache.

i)Read the Associations cache sequentially.
ii)For each record retrieved, read the Issued Items cache to see if a matching record
exists.
iii)If an Issued Items cache record exists, delete the Issued Items duplicate record.

Data Structure

D3101310 - Load Serial Nos Assoc Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
szIssuesDocType	DCTO	char	NONE	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 reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
cSuppressErrorMsgs	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	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.
szCompletionsDocType	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
szScrapDocType	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
mnParentJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnAssocJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnIssuedJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnNoAssocLoaded	MATH01	MATH_NUMERIC	NONE	NONE
- - - Good Performance Low Value.
mnNoIssuedLoaded	MATH02	MATH_NUMERIC	NONE	NONE
- - - Good Performance High Value.
mnIssuesQtyJob	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
mnDeleteCacheJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None