Functional Description
Purpose
This function retrieves fields out of the Lot Master record (F4108) with Short Item Number,
Branch/Plant, and Lot Number.
Setup Notes and Prerequisites
Special Logic
Technical Specification
Processing
1) Call GetLotMasterByLotNumber(B4000610)
Index = 1
Keys = 3
Call Type = 1
Return the GENLNG
2) Return the fields listed above as output parameters.
D4100150 - Get Lot Master Fields
Parameters:
Data Item Data Structure DescriptionI/ORequired
LOTGLot GradeON
LOTPLot PotencyON
LDSCLot DescriptionON
MMEJExpiration DateON
LOTSLot StatusON
RLOTSupplier LotON
LOTNLot NumberIY
ITMShort Item NumberIY
MCUBranch/PlantIY
LOT1Memo Lot 1ON
LOT2Memo Lot 2ON
LOT3Memo Lot 3ON
UA04User Defined DateON
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szGrade | LOTG | char | NONE | NONE |
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following:
A1 Premium
| ||||
mnPotency | LOTP | MATH_NUMERIC | NONE | NONE |
A code that indicates the potency of the lot expressed as a percentage of active or useful material (for example, the percentage of alcohol
| ||||
szLotDescription | LDSC | char | NONE | NONE |
A brief description of a specific lot. | ||||
jdExpirationDate | MMEJ | JDEDATE | NONE | NONE |
The date on which a lot of items expires.
The system automatically enters this date if you have specified the shelf life days for the item on
| ||||
cLotStatus | 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
| ||||
szVendorLotNumber | RLOT | char | NONE | NONE |
The supplier's lot number for the item. | ||||
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
| ||||
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
| ||||
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. | ||||
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szMemoLot1 | LOT1 | char | NONE | NONE |
A higher classification or grouping of serial number or lot processed items,maintained within the Lot Master (F4108). | ||||
szMemoLot2 | LOT2 | char | NONE | NONE |
A higher classification or grouping of memo lot 1 maintained within the lot master (F4108). | ||||
szMemoLot3 | LOT3 | char | NONE | NONE |
A higher classification or grouping of memo lot 2 and memo lot 1 maintained within the lot master (F4108). | ||||
jdDateUserDefinedDat004 | UA04 | JDEDATE | NONE | NONE |
The last date that a particular activity occurred. You determine the type of activity that the category represents (for example, inventory
| ||||
jdBasedOnDate | BODJ | JDEDATE | OPT | NONE |
The date that the system uses in conjunction with the shelf life days to calculate the lot expiration date. You can enter this date during
| ||||
jdOnHandDate | OHDJ | JDEDATE | OPT | NONE |
The date when a lot is considered to be on hand in a branch/plant. The system determines the on-hand date by using the transaction date
| ||||
jdLotEffectivityDate | DLEJ | JDEDATE | OPT | NONE |
The date on which a lot becomes available. The system uses this date for availability and commitment processing to indicate that the lot is
| ||||
jdSellByDate | SBDJ | JDEDATE | OPT | NONE |
The date by which a lot should be completely sold. The system uses this date as a "through" date for commitment processing. The system
| ||||
jdBestBeforeDate | BBDJ | JDEDATE | OPT | NONE |
The last date on which the products in a lot should be consumed. The system calculates the date by retrieving the value from the Best
| ||||
jdUserLotDate1 | U1DJ | JDEDATE | OPT | NONE |
A date that the system can use as a through date for commitment processing. The system stores this date in the Lot Master table (F4108). If
| ||||
jdUserLotDate2 | U2DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to the Lot Expiration
| ||||
jdUserLotDate3 | U3DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
| ||||
jdUserLotDate4 | U4DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
| ||||
jdUserLotDate5 | U5DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
| ||||
mnCostWorkOrderNumber | DOC1 | MATH_NUMERIC | OPT | NONE |
The document number associated with a given document type. | ||||
cLotReusableFlag | LOTR | char | OPT | NONE |
A code that specifies whether a lot is reusable. Valid values are: 0 Not reusable 1 Reusable |
B4000610 Get Lot Master By Lot Number |
F4108 Lot Master |