LoadParentSerialNosCache

Load Parent Serial Nos Cache

Minor Business Rule

Object Name: N3101320

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This function will load the parent serial number associations cache from the WO Serial Numbers
(F3105) table. This cache is used in serial numbers processing in the Work Orders Serial Numbers
Association program (P3107) and in the Work Order Completions (P31114) program. This cache stores the Work
Order Serial Numbers which have been assigned through the "Assign WO Serial Numbers" (P3105) application
and stored on the WO Serial Numbers (F3105) table.

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 WO Serial Numbers (F3105) using the Order Number (DOCO) ,
Document Type (DCTO), and Branch/Plant passed in as input.

b)For each record retrieved:

(1)Determine the parent's completion status by calling "Calculate Serial No Completion Qty"

(N3101350).

(2)Determine if the parent already exists in the cache with a status of "Associated" by calling
"Cache, Process Serial Nos Associations" (B3101280). If the parent is in "associated" status,
retain this value and do not change it when updating.
(3)Delete any existing cache record for the line number.

(3)Write a new cache record using "Cache Process Serial Number Associations" (B3101280) with
the following values from the retrieved F3105 record:

• Order Number (DOCO)
• Order Type (DCTO)
• Branch Plant (MCU)
• Parent Lot (F4111 PLOT)
• Parent Location (LOCN)
• Sequence Number (LINS)

c)After all F3105 records have been processed, deleted any "leftover" cache records, i.e. cache
records greater than the last line number written in step b above.

Data Structure

D3101320 - Load Parent Serial Nos 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.
szOrderType	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
szBranchPlant	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szCompleteionsDocType	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.
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.
mnParentItemShort	KIT	MATH_NUMERIC	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
mnNoCacheWritten	MATH01	MATH_NUMERIC	NONE	NONE
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None