Functional Description
Purpose
This function create an audit trail cache for Location Selection business function (B4600200 -
Putaway, B4600330 - Picking, and B4600340 - Replenishment). The three functions will load the Audit trail
cache with the location not selected with error message id and selected location with the quantity and
the unit of measure used.
After all the processing are completed, there are two applications (R46171 - Location Selection
Driver; and P46130 - Online Putway Reservation) will retrieve data from the cache and display it.
Technical Specification
There two cache created in this function: B4600260AUDIT and B4600260VALID. B4600260AUDIT will
contain all the locations selected and locations not selected. B4600260VALID will only contain selected
locations and it mainly used by B4600660 - Warehouse Reservation MBF.
The following are keys for both cache:
1. TYFL - AWMProcessCode
2. RQBT - RequestBatchNumber
3. RQSQ - RequestSequenceNumber
4. LNID - OrderLineNumber
5. MCU - BranchPlant
6. ITM - ShortItemNumber
7. SEQ - InstructionSequenceNumber (From F46095)
8. TQTY - AttemptQtySeq
9. LOCN - Location
D4600260A - Cache Process Audit Trail
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnRequestBatchNumber | RQBT | MATH_NUMERIC | NONE | NONE |
The batch number assigned to one set of putaway, picking, or replenishment requests. This number comes from next numbers for system
| ||||
mnRequestSequenceNumber | RQSQ | MATH_NUMERIC | NONE | NONE |
A number the system assigns to each individual putaway, picking, and replenishment request within a request batch. | ||||
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
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityAttempted | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
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
| ||||
cActionCode | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
idCacheCursor | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnNumberofKeys | CDL | MATH_NUMERIC | NONE | NONE |
The length of the user defined code. It cannot be greater than 10 characters. | ||||
cLastRecordRead | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | ERR | char | NONE | NONE |
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the
| ||||
cAWMProcessCode | TYFL | char | NONE | NONE |
A code to specify what type of movement information is being displayed. Valid values are:
1 Putaway Information
2 Picking Information
| ||||
szPrimaryItemNumber | UITM | char | NONE | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szItemDescription | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szInstructionUOM | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnPrimaryConversionFactor | CNV1 | MATH_NUMERIC | NONE | NONE |
The mathematical relationship showing the conversion between the primary and secondary units of measure. | ||||
szPrimaryUOM | UOM1 | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
mnOrderLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
cGetValidLocationOnly | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cValidLocationSelection | EV01 | char | OPT | NONE |
Valid Location Selection Flag:
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
sz2ndItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szTransactionUOM | TRUM | char | OPT | NONE |
The unit of measure you used when you entered this transaction into the system. | ||||
jdRequestedDate | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnLicensePlateNumber | STUN | MATH_NUMERIC | OPT | NONE |
A number that uniquely identifies goods in specific location detail information. Location detail contains a storage unit number if you turn on
| ||||
mnLocnDetailSeqNumber | LDSQ | MATH_NUMERIC | OPT | NONE |
The sequence number that identifies a record in the Location Detail table (F4602). The system uses this number to distinguish between the
| ||||
cTopOff | MERG | char | OPT | NONE |
A code that indicates whether you want the system to attempt to complete an incomplete unit of measure (such as a half-filled pallet) in an
| ||||
cPhase | PHAS | char | OPT | NONE |
A number that identifies which phase of 2-phase movement suggestions that the system displays.
Valid numbers are:
1 Display phase
| ||||
cInventoryInterfaceFlag | IVI | char | OPT | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
| ||||
szStagingLocation | STGP | char | OPT | NONE |
A code that specifies a warehouse location where you hold items temporarily (either physically or logically) before moving them
| ||||
szMovementInstruction | MPUT | char | OPT | NONE |
A code (system 46/type IT) that identifies a putaway table. The putaway table defines how the system selects locations for putaway. You
| ||||
cSelectedForProcess | EV05 | char | OPT | NONE |
SelectedForProcess: This is the flag to indicate that the records in the Cache are selected for
| ||||
cInstructionProcess | PUTP | char | OPT | NONE |
A user defined code (46/PC) that determines the putaway processing method. Valid values are:
P
Productivity mode. The system suggests
| ||||
mnInstructionSequence | SEQ | MATH_NUMERIC | OPT | NONE |
A number that specifies the sequence of information. | ||||
szLicensePlateNumber | LPNU | char | OPT | NONE |
A license plate number is a unique value that identifies a collection of items and/or other license plates. The license plate number is
| ||||
szParentLicensePlateNumb | PLPNU | char | OPT | NONE |
A Parent License plate number is a unique value that identifies a collection of license plates. The license plate number is typically used to
| ||||
szToLicensePlateNumber | LPNUT | char | OPT | NONE |
A to license plate number is a unique value that identifies a collection of items and/or other license plates that a transferred to a specific
| ||||
cFIFOProcessing | MODE | char | OPT | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. |
None |
None |