CheckItemLocation

Check Item Location

Major Business Rule

Object Name: B4000200

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
Check for existence of Item Location Row in the Item Location Table (F41021).

Technical Specification

Check for exitence of Item Location Row in the Item Location Table (F41021). The key used to

retrieve the Row will be based on the Index number and Number of Keys sent in. The following keys are

currently established in this program.

Index = 1

Keys 1 means fetch by Item Number only.

Keys 2 means fetch by Item Number and Branch Plant.

Keys 3 means fetch by Item Number, Branch Plant, and Location

Keys 4 means fetch by Item Number, Branch Plant, Location, and Lot

Index = 3

Keys 2 means fetch by BranchPlant and Location.

Index = 4

Keys 3 means fecth Item Number, BranchPlant, and Primary Bin.

Error messages wil be passed back based on the call type.

Call Type = 1 : Validate that the record exists, if not give an error and return a (1) in the Error

Code.

Call Type = 2 : Validate if records does not exist, if record exist then give an error and return a

(1) in the Error Code.

If a ReturnCode flag is a (1), the pointer to the record found will be returned in the

ItemLocationRecord, otherwise ItemLocationRecord will be NULL.

Retrievals:

Retrieves the Item Location Table (F41021) using the key as specified in the 'Keys'/'Index'

parameters.

Returns:

If ReturnFLag is 1 then returns a GENLNG pointer to the F41021 data structure, otherwise pointer is

NULL and no data structure is created.

If CallType is '2' (check for non-existance of record), then set error 3804.

If call type is '1' and Fetch has failed then set error number 0678.

If the requestID to the table F41021 fails then set the error code 0002. (Change 05/95)

Change 05/95

If the requestid fails then use message number 3143 instead of message number 0002.

When the Index is '4' and the Keys parameter is set to '3', then retrieve the primary lot and

location. If the fetch has been successful then move the value of the lot and location found into the

ER data structure to be returned to the calling application. (Whether the GENLNG pointer to the

F41021 data structure is passed back remains unchanged and is dependant on the ReturnRecord code.)

Added standard message handling. The error message ID is sent back to the application. If the

SuppressErrorMessage has been set to '1' then the jdeSetGBRError is NOT used.

Data Structure

DXF41021C - Verify And Get Item Location

Parameter Name Data Item Data Type Req/Opt I/O/Both

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.

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

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

mnIndex CDL MATH_NUMERIC NONE NONE

The length of the user defined code. It cannot be greater than 10 characters.

mnKeys CDL MATH_NUMERIC NONE NONE

The length of the user defined code. It cannot be greater than 10 characters.

cCallType EV01 char NONE NONE

An option that specifies the type of processing for an event.

cReturnRecord EV03 char NONE NONE

A radio button that specifies the level at which trace/track result is to be displayed.  Select the Detail to display all transactions except IB, IX,
and IZ types.  Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.

idItemLocationRecord GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMessages 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.

cLPSwitch EV01 char OPT NONE

An option that specifies the type of processing for an event.

cLPExist EV01 char OPT NONE

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

F41021 Item Location File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
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
szLocation	LOCN	char	NONE	NONE
The storage location from which goods will be moved.
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.
mnIndex	CDL	MATH_NUMERIC	NONE	NONE
The length of the user defined code. It cannot be greater than 10 characters.
mnKeys	CDL	MATH_NUMERIC	NONE	NONE
The length of the user defined code. It cannot be greater than 10 characters.
cCallType	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cReturnRecord	EV03	char	NONE	NONE
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX, and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.
idItemLocationRecord	GENLNG	ID	NONE	NONE
General purpose ID variable.
cSuppressErrorMessages	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.
cLPSwitch	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cLPExist	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.