F41021AccumulatePQOHByCostLevel

F41021 Accumulate PQOH by Cost Level

Major Business Rule

Object Name: B4101360

Parent DLL: CINV

Location: Client/Server

Language: C

Functional Description

Purpose

This function will accumulate the quantity on hand from Item Location (F41021) and store it in the
Cache.  First it will try to retrieve the record from the cache, if the record does not exist in the
cache, then it will retrieve and accumulate the PQOH from F41021.

The keys for retrieve record as followed:
Cost Level 1:  Retrieve F41021 with Short Item Number Only.  Retrieving the cache with Short Item
Number, blank Branch/Plant, blank location and blank lot number.
Cost Level 2:  Retrieve F41021 with Short Item Number and Branch/Plant.  Retrieve cache with Short
Item Number, Branch/Plant, and Blank location and Lot Number.
Cost Level 3:  Retrieve F41021 with Short Item Number, Branch/Plant, Location, and Lot Number.
Retrieve cache with Short Item Number, Branch/Plant, location, and Lot Number.

Technical Specification

Data Structure

D4101360A - F41021 Accumulate PQOH by Cost Level

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode_ACTN	ACTN	char	OPT	NONE
A code that specifies the action that is performed. Valid values are: A Add C Change
mnJobNumber_JOBS	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
szComputerID_CTID	CTID	char	OPT	NONE

mnShortItemNumber_ITM	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
szBranchPlant_MCU	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.
szLocation_LOCN	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szLotNumber_LOTN	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
cInventoryCostLevel_CLEV	CLEV	char	OPT	NONE
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level
mnAccumulatedQtyOnHand_PQOH	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.
cErrorCode_ERRC	ERRC	char	OPT	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).

Related Functions

None

Related Tables

F41021 Item Location File