Functional Description
Purpose
Base on the Index and Keys combination, fetch all records exist in F41021 (Item Location) table.
Verify if any record contain any quantity. If the quantity is not zero the ZeroQuantityFlage is set to
'0'. If all records found contain zero quantities or no record found, then ZeroQuantityFlag is set to
'1'.
Setup Notes and Prerequisites
The Short Item Number (ITM), Lot Number (LOTN), and Branch/Plant (MCU) as well as the Index and Keys
are required parameters.
Indices and Key values:
Index = 1 :
Index = 2 :
Keys = 1 : Fetch by ITM only.
Keys = 2 : Fetch by ITM and MCU.
Keys = 3 : Fethc by ITM, MCU, and LOTN.
Index = 3 :
Keys = 1 : Fetch by MCU only.
Index = 5 :
Keys = 1 : Fetch by LOTN only.
Keys = 2 : Fetch by LOTN and ITM.
Keys = 3 : Fetch by LOTN, ITM and MCU.
If the Check All Qty Zero parameter = '1', all quantity fields in the F41021 are checked to see if
they are zero.
Special Logic
Technical Specification
This function fetches the Item Location record (F41021) for the keys passed in. If any of the
following quantity fields is not equal to zero, move a '0' to the Zero Quantity Flag parameter to be
returned.
Quantities checked:
Primary Quantity On HandPQOH
Soft CommittedPCOM
Hard CommittedHCOM
Quantity On Work OrderQOWO
Quantity On Work Order ReceiptQWBO
Quantity On Back OrderPBCK
Quantity On POPREQ
Quantity Other 1OT1P
Quantity Other 2OT2P
If the Check All Qty Zero parameter = '1', if any of the following quantity fields is not equal to
zero, move a '0' to the Zero Quantity Flag parameter to be returned.
Quantities checked:
Quantity - WO Soft CommitFUN1
Quantity - Inbound WarehouseQTRI
Quantity - Outbound WarehouseQTRO
Quantity - Other Purchasing 1OT1A
Quantity - In InspectionQTIN
Quantity - In Operation 1QTO1
Quantity - In Operation 2QTO2
Quantity - On Loan to ManufactureQONL
^
D4100110 - Check For Zero Quantity
Parameters:
Data Item Data Structure DescriptionI/ORequired
ITMShort Item NumberIY
LOTNLot NumberIY
MCUBranch PlantIY
EV02IndexIY
CDLKeysIY
EV01Zero Quantity FlagON
EV02Check All Qty ZeroIN
^
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
| ||||
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. | ||||
cZeroQuantityFlag | EV01 | char | NONE | NONE |
'0' = Quantities Exist
| ||||
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
| ||||
cIndex | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnKeys | CDL | MATH_NUMERIC | NONE | NONE |
Default to 2
| ||||
cCheckAllQtyAreZero | EV02 | char | NONE | NONE |
'1' = All Qty buckets will be checked for zero
|
None |
F41021 Item Location File |