1.Functional Description
1.1Purpose
This function will update the Parent Lot number on the Item Ledger (F4111) table from the
associations assigned in the Serial Number Associations application (P3107).
• Serialized components which are being "de-associated" from the previously assigned parent lot are
stored in the LSN Deletion cache updated in P3107. This cache is processed first. The F4111 records
with the matching Item Number (ITM), Branch/Plant (MCU), Location (LOCN), Lot Number (LOTN), Parent Item
(KIT), Parent Branch/Plant (MMCU), Parent Location (LOCN), and Parent Lot (PLOT) will have the Parent
Lot changed to spaces if the Program Id on the Item Ledger record. is "P31123" (R31123), "P31113", or
"P31420" (R31420).
• After deletions are process, the new associations are updated on the Item Ledger table (F4111). All
records on the associations cache (with an "Associated" status) are processed. The F4111 records with
the matching Item Number (ITM), Branch/Plant (MCU), Location (LOCN), Lot Number (LOTN), Parent Item
(KIT), Parent Branch/Plant (MMCU), Parent Location (LOCN), and Parent Lot (PLOT) will have the Parent
Lot changed to spaces if the Program Id on the Item Ledger record. is "P31123" (R31123), "P31113", or
"P31420" (R31420).
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
Process "Deletes":
1)Read the LSN Deletion cache sequentially; for each record read:
"Deletion" cache record:
ii)ITM Component Item Number
iii)MCU Component Branch/Plant
iv)PLOT Parent Lot Number
v)ITM Parent Item Number
vi)MMCU Parent Branch/Plant
ii)Skip records if the Component Item Number = Parent Item Number.
iii)Skip records if the Order Number (DOCO) does not match the Order Number passed in as
input.
record.
Process "Associations":
2)Read the Parent LSN cache sequentially; skip records which do not have a status of "A" (i.e.
"Associated"). For each cache record selected:
record. For each record selected:
the "Association" cache record:
(2)ITM Component Item Number
(3)MCU Component Branch/Plant
ii)Skip records if the Component Item Number = Parent Item Number.
iii)Skip records if the Order Number (DOCO) does not match the Order Number passed in as
input.
iv)For each record selected from the F4111 table, update the Parent Lot number from the value on
the Parent LSN Cache record and audit information (TDAY, USER, UPMJ, JOB)'85.."P31114"
D3101400 - F4111 Update Parent Lot Associations
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnDocumentOrderInvoiceE | 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,
| ||||
| mnDeletionCacheJob | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
| mnParentCacheJob | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
| mnAssocCacheJob | 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
| ||||
| None |
| None |