Functional Description
Purpose
To retrieve data from the Item Location File (F41021) using the Pointer to the F41021 Record.
Setup Notes and Prerequisites
None
Special Logic
None
Technical Specification
Edits:
1.0. If DS F41021 Pointer is not equal to NULL, return requested information from F41021.
Retrievals:
1)Item Location (F41021)
Primary Location - PBIN(out)
Lot Number- LOTN(out)
Business Unit- MCU(out)
Item Number- ITM(out)
Lot Status Code- LOTS(out)
Location- LOCN(out)
Qty On Hand- PQOH(out)
Qty on Purchase Order- PREQ(out)
Qty On Backorder- PBCK(out)
Qty Soft Committed- PCOM(out)
Qty Hard Committed- HCOM(out)
Qty On Future Commit- FCOM(out)
Qty WO Hard Commit- QOWO(out)
Units - In Transit- QTTR(out)
Units - In Inspection- QTIN(out)
Units - In Operation 1- QTO1(out)
Units - In Operation 2- QTO2(out)
Qty 1 - Other- OT1P(out)
Qty 2 - Other- OT2P(out)
Qty - Other Purchasing 1- OT1A(out)
Category - G/L- GLPT(out)
LastReceiptDate- LRCJ(out)
Returns:
1.) If the pointer to the F41021 record is not sent, return error '0002' (Record Invalid).
2.) If the Item Location Record is found, return the information from the record.
D4100280 - Get Item Location Detail
Parameters:
Data Item Data Structure DescriptionI/ORequired
GENLNGidF41021PointerI
EV01SuppressErrorMessagesI
PBINPrimaryLocationO
LOTNLotNumberO
MCUBusinessUnitO
ITMItemNumberShortO
DTAIErrorMessageIdO
LOTSLotStatusCodeO
LOCNLocationO
PQOHQtyOnHandO
PREQQtyOnPurchaseOrderO
PBCKQtyOnBackOrderO
PCOMQuantitySoftCommittedO
HCOMQtyHardCommittedO
FCOMQtyOnFutureCommitO
QOWOQuantityWOHardCommitO
QTTRUnitsInTransitO
QTINUnitsInInspectionO
QT01UnitsInOperation1O
QT02UnitsInOperation2O
OT1PQty1OtherO
OT2PQty2OtherO
OT1AQtyOtherPurchasing1O
GLPTGlCategoryO
FUN1WorkOrderSoftCommitO
QWBOQuantityOnReceiptO
LRCJLastReceiptDateO
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
idF41021Pointer | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cPrimaryLocation | PBIN | char | NONE | NONE |
A code that indicates whether this is the primary or secondary location for this item within this stocking location. Valid values are:
P Primary
| ||||
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. | ||||
szBusinessUnit | 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
| ||||
mnItemNumberShort | 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
| ||||
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
| ||||
cLotStatusCode | 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
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
mnQtyOnHand | PQOH | MATH_NUMERIC | NONE | NONE |
The number of units that are physically in stock. The system displays the quantity on-hand in the primary unit of measure. | ||||
mnQtyOnPurchaseOrder | PREQ | MATH_NUMERIC | NONE | NONE |
The number of units specified on the purchase order in primary units of measure. | ||||
mnQtyOnBackOrder | PBCK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in primary units of measure. | ||||
mnQuantitySoftCommitted | PCOM | MATH_NUMERIC | NONE | NONE |
The number of units soft committed to sales orders or work orders in the primary units of measure. | ||||
mnQtyHardCommitted | HCOM | MATH_NUMERIC | NONE | NONE |
The number of units committed to a specific location and lot. | ||||
mnQtyOnFutureCommit | FCOM | MATH_NUMERIC | NONE | NONE |
The quantity on sales order whose requested shipment date is beyond the standard commitment period that has been specified in the
| ||||
mnQuantityWOHardCommit | QOWO | MATH_NUMERIC | NONE | NONE |
The number of units hard committed to work orders in the primary unit of measure. | ||||
mnUnitsInTransit | QTTR | MATH_NUMERIC | NONE | NONE |
The quantity currently in transit from the supplier. | ||||
mnUnitsInInspection | QTIN | MATH_NUMERIC | NONE | NONE |
The quantity currently being inspected. This quantity has been received, but is not considered on hand. | ||||
mnUnitsInOperation1 | QT01 | MATH_NUMERIC | NONE | NONE |
Quantity field in the Batch Receiver Destination Quantity table (F4012Z) that is used to process multiple ship to locations. This function is
| ||||
mnUnitsInOperation2 | QT02 | MATH_NUMERIC | NONE | NONE |
Quantity field in the Batch Receiver File - Destination Quantity (F4012Z) that is used to process multiple ship to locations. This is only a
| ||||
mnQty1Other | OT1P | MATH_NUMERIC | NONE | NONE |
The first of two quantities that can be specified as additional offsets (subtractions from on-hand) in the determination of quantities available
| ||||
mnQty2Other | OT2P | MATH_NUMERIC | NONE | NONE |
The second of two quantities that can be specified as additional offsets (subtractions from on-hand) in the determination of quantities
| ||||
mnQtyOtherPurchasing1 | OT1A | MATH_NUMERIC | NONE | NONE |
The quantity that appears on documents such as bid requests, which are not formal commitments to buy on the part of your organization. | ||||
szGlCategory | GLPT | char | NONE | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
mnWorkOrderSoftCommit | FUN1 | MATH_NUMERIC | NONE | NONE |
The number of units soft committed to Work Orders in the primary unit of measure. | ||||
mnQuantityOnReceipt | QWBO | MATH_NUMERIC | NONE | NONE |
The number of units on work orders in primary units of measure. | ||||
jdLastReceiptDate | LRCJ | JDEDATE | NONE | NONE |
The date that the last shipment of the item was received. | ||||
mnQuantityOnLoanToManfacturing | QONL | MATH_NUMERIC | OPT | NONE |
mnQuantityInboundWarehouse | QTRI | MATH_NUMERIC | OPT | NONE |
A quantity in the primary unit of measure that you expect to add to the location detail after you confirm a putaway or replenishment
| ||||
mnQuantityOutboundWarehouse | QTRO | MATH_NUMERIC | OPT | NONE |
A quantity in the primary unit of measure that you expect to remove from the location after you confirm a picking or replenishment
| ||||
mnFutureUseQuantity | QTY1 | MATH_NUMERIC | OPT | NONE |
Quantity for future use in the Item Location file (F4102). | ||||
mnFutureUseQuantity2 | QTY2 | MATH_NUMERIC | OPT | NONE |
Quantity for future use in the Item Location file (F4102). | ||||
mnProjectHardCommitted | PJCM | MATH_NUMERIC | OPT | NONE |
The number of units committed to a specified location and lot for a project. | ||||
mnSecondaryQtyHardCommitted | HCMS | MATH_NUMERIC | OPT | NONE |
The number of units (expressed in the secondary unit of measure) that are hard-committed to a specific location and lot. | ||||
mnSecondaryProjectHardCommit | PJDM | MATH_NUMERIC | OPT | NONE |
The number of units committed to a specified location and lot for a project. | ||||
mnSecondaryQtySoftCommitted | SCMS | MATH_NUMERIC | OPT | NONE |
The number of units (expressed in the secondary unit of measure) that are soft-committed to sales orders or work orders. | ||||
mnSecondaryQtyInbound | SIBW | MATH_NUMERIC | OPT | NONE |
A quantity in the secondary unit of measure that you expect to add to the location detail after you confirm a putaway or replenishment
| ||||
mnSecondaryQtyOutbound | SOBW | MATH_NUMERIC | OPT | NONE |
The quantity (expressed in the secondary unit of measure) that you expect to remove from the location after you confirm a picking
| ||||
mnSecondaryQtyOnHand | SQOH | MATH_NUMERIC | OPT | NONE |
The number of units on hand in secondary units of measure. | ||||
mnSecondaryQtyOnWOReceipt | SQWO | MATH_NUMERIC | OPT | NONE |
The number of units, expressed in the secondary unit of measure, that are specified on the work order. | ||||
mnSecondaryQtyOnPO | SREQ | MATH_NUMERIC | OPT | NONE |
The number of units, expressed in the secondary unit of measure, that are specified on the purchase order. | ||||
mnSecondaryQtyWOHardCommitted | SWHC | MATH_NUMERIC | OPT | NONE |
The number of units, expressed in the secondary unit of measure, that are hard-committed to work orders. | ||||
mnSecondaryQtyWOSoftCommitted | SWSC | MATH_NUMERIC | OPT | NONE |
The number of units, expressed in the secondary unit of measure, that are soft-committed to work orders. |
None |
F41021 Item Location File |