F41021ClearWarehouseCommitments

F41021 Clear Warehouse Commitments

Minor Business Rule

Object Name: B4101150

Parent DLL: CWARE

Location: Client/Server

Language: C

Functional Description

Purpose
To provide a common function that clears the inbound and outbound quantities from the Item
Location table (F41021) for a branch/plant and item.

Setup Notes and Prerequisites

Special Logic
The Item Location row is locked for update.

Technical Specification

Parameters
Data Item     Data Structure Description      I/O      Required     Notes
MCU           Branch/Plant                     I           Y
ITM           Short Item Number                I           Y
PID           Program ID                       I           Y        Name of calling program.
JOBN          Workstation ID                   I           N
USER          User ID                          I           N
UPMJ          Date Updated                     I           N
TDAY          Time of Day                      I           N
EV01          Error Code                       O           N        '1' = Error
DTAI          Error Message ID                 O           N

Related Tables
F41021 - Item Location

Related Business Fuctions
B9800100 - Get Audit Information

Processing
If the User ID is not passed from the calling function, call B9800100 to get audit information.
Read all rows for the branch/plant and item and set inbound and outbound quantity to zero.
If the update fails pass back an error message.
Each row should be fetched with a lock and the lock released once the row is updated.

^

Data Structure

D4101150A - F41021 Clear Warehouse Commitments

Parameters
Data Item     Data Structure Description      I/O      Required     Notes
MCU           Branch/Plant                     I           Y
ITM           Short Item Number                I           Y
PID           Program ID                       I           Y        Name of calling program.
JOBN          Workstation ID                   I           N
USER          User ID                          I           N
UPMJ          Date Updated                     I           N
TDAY          Time of Day                      I           N
EV01          Error Code                       O           N        '1' = Error
DTAI          Error Message ID                 O           N

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szBranchPlant	MCU	char	REQ	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	REQ	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
szProgramId	PID	char	REQ	NONE
Parameters Data Item Data Structure Description I/O Required Notes PID Program ID I Y Name of calling program. ^
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	OPT	NONE
The computer clock in hours:minutes:seconds.
cErrorCode	EV01	char	OPT	NONE
Parameters Data Item Data Structure Description I/O Required Notes EV01 Error Code O N '1' = Error ^
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

XF41021 Update F41021 Locations

Related Tables

F41021 Item Location File