This function uses the Commitment Method (CMGL) passed in to retrieve records from the Item Location
Table (F41021). You can call this function in Initialization, Read and Close modes. The
Initialization mode will initialize the hRequest to the F41021 table, the fetch and return the first record from
the table. In Read mode, the next F41021 record will be fetched and returned. Finally, in Close mode,
no fetching will be performed but the hRequest and the F41021 pointer will be freed. This function
will optionally calculate and return the total quantity available for the item location retrieved
D4000780 - GetItmLocByCommitment
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnItemNumber | 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
| ||||
szBranch | 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
| ||||
cProcessMode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCommitmentMethod | CMGL | char | NONE | NONE |
A code that indicates the method that the system uses to commit lot items from inventory. Valid codes are:
1 The normal commitment
| ||||
cLotProcessing | SRCE | char | NONE | NONE |
A code that indicates whether lot or serial number is assigned. Lot and serial number processes use the Lot Master table (F4108).
Valid
| ||||
jdAsOfDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
cCrossBranchBoundaries | FLD1 | char | NONE | NONE |
An option that determines how the system commits inventory to a work order, and specifies the inventory location to which commitments are
| ||||
idF41021hRequest | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
idF41021RecordPtr | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
idF4108hRequest | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cReturnAvailableQty | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szUnitOfMeasure | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnQuantityavailability | QAVAL | MATH_NUMERIC | NONE | NONE |
A number that indicates the quantity that is available.
For example, the available quantity might consist of the on-hand quantity minus
| ||||
cSuppressErrorMessage | 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,
| ||||
szErrorMessage | 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
| ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
mnQuantitySoftCommitted | PCOM | MATH_NUMERIC | NONE | NONE |
The number of units soft committed to sales orders or work orders in the primary units of measure. | ||||
cSelectIfHCOMLTPQOH | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
cLotMasterValidate | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
mnQuantityOnHand | 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. | ||||
mnDaysPastExpiration | EXDP | MATH_NUMERIC | OPT | NONE |
The number of days allowed before expiration for an item where it still can be used or sold to a specific customer. When negative, this
| ||||
szFromGrade | FRGD | char | OPT | NONE |
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item.
The system displays a warning message if
| ||||
szThruGrade | THGD | char | OPT | NONE |
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item.
The system displays a warning message if
| ||||
mnFromPotency | FRMP | MATH_NUMERIC | OPT | NONE |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
| ||||
mnThruPotency | THRP | MATH_NUMERIC | OPT | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
szItemMasterSecondaryUOM | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szInputSecondaryUOM | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
cDualPickingProcessOption | DPPO | char | OPT | NONE |
An option that determines for a dual unit of measure item whether the system uses the primary or secondary unit of measure for the following
| ||||
cCommitmentDateMethod | CMDM | char | OPT | NONE |
A user defined code (H40/CD) that specifies which date the system uses to commit inventory when an item is committed by date. The
| ||||
cCallingApplication | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
jdWorkOrderStartDate | DATE01 | JDEDATE | OPT | NONE |
Event point for JDE Date. | ||||
jdWorkOrderRequestDate | DATE01 | JDEDATE | OPT | NONE |
Event point for JDE Date. | ||||
cMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szTransUnitOfMeasure | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szLotGroup | LOTGRP | char | OPT | NONE |
Lot Group is the name of a user defined list of allowed non-blank lot status codes. Entry of a Lot Group name in the Processing Option will
| ||||
szOrderType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
cLPNMasterSwitch | LPNM | char | OPT | NONE |
A code that indicates whether you want the system to use License Plate Numbers or not.
Valid Codes are
0 No, do not use the License
|
B4000520 Get Item UoM Conversion Factor | ||||
B4101220 Calculate Availability |
F41021 Item Location File | ||||
F4108 Lot Master |