LocationStatusUpdate

Location Status Update

Major Business Rule

Object Name: B4100100

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function updates all of the Item Location records (F41021) with the lot status passed in.

Setup Notes and Prerequisites
The Short Item Number (ITM), Lot Number (LOTN), Branch/Plant (MCU) and Lot Status (LOTS) are required
parameters.

Special Logic

Technical Specification
This function fetches all Item Location records (F41021) for the Short Item Number, Branch/Plant and
Lot Number passed in and loads the lot status passed in into the lot status field in the Item Location
record and updates the Item Location record.

Edits:
1.) Call GetAuditInfo and store the information retruned
2.) Fetch the Item Location(F41021) records by 3 keys (ITM,MCU,LOTN)
(only retrieve a partial table containing the parameters listed above)

Need to read every record in the file equal to the key.
For every record found do the following:
Load the GetAuditInfo fields into the corrisponding Item Location
fields
Load the Lot Status passed in into the Item Location lot status field
Update the record.

^

Data Structure

D4100100 - Location Status Update

Parameters:
Data Item Data Structure DescriptionI/ORequired
ITMmnShortItemNumberI
LOTNszLotNumberI
MCUszBranchPlantI
LOTScLotStatusI

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szLotNumber	LOTN	char	NONE	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
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.
cLotStatus	LOTS	char	NONE	NONE
A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes indicate that the lot is on hold. You can assign a different status code to each location in which a lot resides on Item/Location Information or Location Lot Status Change.

Related Functions

B9800100 Get Audit Information

Related Tables

F41021 Item Location File