GetItemLocationRecords

Update F41021 Locations

Major Business Rule

Object Name: XF41021

Parent DLL: COPBASE

Location: Client/Server

Language: C

Data Structure

DXF41021D - GetItemLocationRecords

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
idF41021RequestHandle	GENLNG	ID	OPT	NONE
General purpose ID variable.
szCostCenter	MCU	char	OPT	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	OPT	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	OPT	NONE
The storage location from which goods will be moved.
szLot	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
mnQtyOnHandPrimary	PQOH	MATH_NUMERIC	OPT	NONE
The number of units that are physically in stock. The system displays the quantity on-hand in the primary unit of measure.
mnQtyOnHandSecondary	PQOH	MATH_NUMERIC	OPT	NONE
The number of units that are physically in stock. The system displays the quantity on-hand in the primary unit of measure.
mnProjectHardCommitPrimary	PJCM	MATH_NUMERIC	OPT	NONE
The number of units committed to a specified location and lot for a project.
mnProjectHardCommitSecondary	PJDM	MATH_NUMERIC	OPT	NONE
The number of units committed to a specified location and lot for a project.
cIndexID	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cNoRecord	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	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.

Related Functions

B9800100 Get Audit Information

Related Tables

F41021 Item Location File

UpdateF41021PrimaryLocationQty

Update F41021 Locations

Major Business Rule

Object Name: XF41021

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function adds/subtracts quantity to/from the passed quantity column for the primary location.

Setup Notes and Prerequisites
The Item Number (ITM), Branch (MCU), Quantity (UORG) and Quantity Column to Update (UPIB) are
required input parameters.

This function only updates records with a 'P' in the Primary Bin field (PBIN) in the Item Location
table (F41021).

Technical Specification

If the quantity passed in is zero, exit the function.  If the pointer to the F41021 is passed in, it
is used, otherwise the F41021 is retrieved based on the keys passed in.  If a record is found, the
quantity is added/subtracted from the quantity field to be updated (UPIB).  The Item Location table is
updated.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
idF41021RowPtr	GENLNG	ID	NONE	NONE
General purpose ID variable.
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
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.
mnQuantity	UORG	MATH_NUMERIC	NONE	NONE
The quantity of units affected by this transaction.
szQtyColToUpdate	UPIB	char	NONE	NONE
Indicates which quantity field in the Item Location table that the system updates when quantity is moved from one receipt routing operation to another. Valid values: QTTR - Quantity in Transit QTIN - Quantity in Inspection QTO1 - Quantity in User-defined Operation 1 QTO2 - Quantity in User-defined Operation 2 PQOH - Quantity on Hand PREQ - Quantity on Purchase Order
cAddOrSubtractFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cSuppressUpdate	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
mnProjectNumber	PRJM	MATH_NUMERIC	OPT	NONE
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).
mnWorkOrderNumber	DOC1	MATH_NUMERIC	OPT	NONE
The document number associated with a given document type.
idF4101RowPtr	GENLNG	ID	OPT	NONE
General purpose ID variable.
mnJobnumberA	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.

Data Structure

DXF41021A - Update Primary Location Qty

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

idF41021RowPtr GENLNG ID NONE NONE

General purpose ID variable.

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

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.

mnQuantity UORG MATH_NUMERIC NONE NONE

The quantity of units affected by this transaction.

szQtyColToUpdate UPIB char NONE NONE

Indicates which quantity field in the Item Location table that the system updates when quantity is moved from one receipt routing operation
to another. Valid values:        QTTR - Quantity in Transit        QTIN - Quantity in Inspection        QTO1 - Quantity in User-defined Operation 1
QTO2 - Quantity in User-defined Operation 2        PQOH - Quantity on Hand PREQ - Quantity on Purchase Order

cAddOrSubtractFlag EV01 char NONE NONE

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

szProgramID PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cSuppressUpdate EV02 char NONE NONE

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

mnProjectNumber PRJM MATH_NUMERIC OPT NONE

A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).

mnWorkOrderNumber DOC1 MATH_NUMERIC OPT NONE

The document number associated with a given document type.

idF4101RowPtr GENLNG ID OPT NONE

General purpose ID variable.

mnJobnumberA JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

Related Functions

B9800100 Get Audit Information

Related Tables

F41021 Item Location File

UpdateF41021SecondaryLocationQty
UpdateF41021SecondaryLocationQty

Update F41021 Locations

Major Business Rule

Object Name: XF41021

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function adds and subtracts the passed quantity to/from the passed quantity in the secondary
location.  It also updates the Lot Status and Receipt Date.

Setup Notes and Prerequisites
The Item Number (ITM), Branch (MCU), Location (LOCN), Lot (LOTN), Add/Subtract flag (EV01), Quantity
(UORG) and Quantity Column to Update (UPIB) are required input parameters.

Technical Specification

This function checks to see if the quantity passed in is zero.  If so, it exits.  The Item Location
record (F41021) is retrieved for the keys passed in.

If the record is not found, the primary location in the item location table is fetched.  The Location
and Lot fields, along with an 'S' in the Primary Bin (PBIN) fields are loaded.  The following
quantities are zeroed out: PCOM, PBCK, QTRI, QTRO, PREQ, OT1P, OT2P, HCOM, FCOM, QOWO, PQOH, FUN1, QTTR,
QTIN, QT01, QTO2, QONL and QT1A.

If the Lot Status is passed, load this parameter.  The quantity is then added or subtracted based on
the parameter passed in to the column associated with the UPIB parameter.  The Receipt date is loaded,
if passed in.

Update or add the record to the F41021.

Data Structure

DXF41021B - Update Secondary Location Qty

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

idF41021RowPtr GENLNG ID NONE NONE

General purpose ID variable.

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

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.

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.

szQtyColToUpdate UPIB char NONE NONE

Indicates which quantity field in the Item Location table that the system updates when quantity is moved from one receipt routing operation
to another. Valid values:        QTTR - Quantity in Transit        QTIN - Quantity in Inspection        QTO1 - Quantity in User-defined Operation 1
QTO2 - Quantity in User-defined Operation 2        PQOH - Quantity on Hand PREQ - Quantity on Purchase Order

cAddOrSubtractFlag EV01 char NONE NONE

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

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

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.

jdReceiptDate LRCJ JDEDATE NONE NONE

The date that the last shipment of the item was received.

szProgramID PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

cSuppressUpdate EV02 char NONE NONE

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

mnProjectNumber PRJM MATH_NUMERIC OPT NONE

A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).

mnWorkOrderNumber DOCO MATH_NUMERIC OPT 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.

idF4101RowPtr GENLNG ID OPT NONE

General purpose ID variable.

Related Functions

B9800100 Get Audit Information

Related Tables

F41021 Item Location File

VerifyAndGetItemLocation
VerifyAndGetItemLocation

Update F41021 Locations

Major Business Rule

Object Name: XF41021

Parent DLL: COPBASE

Location: Client/Server

Language: C

^

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

B9800100 Get Audit Information

Related Tables

F41021 Item Location File