Functional Description
Purpose
Retrieve the Location Master record (F4100) with Branch/Plant and Location passed in.
Setup Notes and Prerequisites:
None
Special Logic:
None
Processing
Validate F4100RecordPointer is being passed in. If it is passed in, return the data back to the
data structures without retrieving any records.
IfF4100RecordPtr is not zero
Exit the program
End
Retrieve F4100 record if the F4100RecordPtr is not passed in.
Retrieve Location Master (F4100) with the following:
Case Index = 1
Key= 2:LMMCU, LMLOCN
Key= 2:LMMCU, LMWSQP
Key= 3:LMMCU, LMWSQP, LMLOCN
Key= 2:LMMCU, LMWSQQ
Key= 3:LMMCU, LMWSQQ, LMLOCN
Key= 2:LMMCU, LMWSQR
Key= 3:LMMCU, LMWSQR, LMLOCN
Key= 2:LMMCU, LMCGRP
Key= 2:LMMCU, LMPZON
Set an Error "4371"
Ifrecord does not exit OR LastRecordRead equals '1'
IfMultipleRetrieve equals '1' AND FirstTime Retrieving record OR
End
Exit Program
If Reocord exist
Return the F4100 Data to Parameter list
IfMultipleRetrieve equals '1'
End
^
D4100240B - F4100 Verify And Get Location Master
Parameters:
Data Item Data Structure DescriptionI/ORequired
SUPPSSuppress ErrorIN
DTAIError Message IDON
ERRCErrorCodeON
CDLIndexIN
CDLKeysIN
EV01Call TypeIN
EV01Multiple RetrieveIN
EV01Last Record ReadI/ON
GENLNGOpenTableHandleI/ON
EV01ReturnRecordPtrIN
GENLNGF4100RecordPtrON
MCUBranch/PlantIY
LOCNLocationI/ON
AISLAisleON
BINBinON
LA03Location Code 3ON
LA04Location Code 4ON
LA05Location Code 5ON
LA06Location Code 6ON
LA07Location Code 7ON
LA08Location Code 8ON
LA09Location Code 9ON
LA10Location Code 10ON
LLDLLevel Of DetailON
STY1Location Dimension GroupON
CGRPLocation Characteristic GroupI/ON
LHLDLocation Hold CodeON
FREZFreeze RuleON
NETANettable Allocatable CodeON
MNUPMinimum Putaway PercentON
MNUKMinimum Pick PercentON
LCODLocation Tax CodeON
MMTHCommitment MethodON
EQTYContainer CodeON
CTNFCartonize FlagON
MCNTAllow Mix Container ON
MLOTAllow Mix LotON
MITMMaximum Number Of Item AllowON
STAGStaging Location FlagON
LVERVerification CodeON
PCNFPutaway Confirmation RequiredON
KCNFPicking Confirmation RequiredON
APUTAllow PutawayON
APIKAllow PickingON
ARPLAllow ReplenishON
PZONPutaway ZoneI/ON
KZONPicking ZoneON
ZONRReplenish ZoneON
STGPPutaway Staging LocationON
STGKPicking Staging Location ON
STGRReplenish Staging LocationON
WSQPPutaway Sequence NumberI/ON
WSQQPicking Sequence NumberI/ON
WSQRReplenish Sequence NumberI/ON
DISXLattitudeON
DISYLongitudeON
DISZHeightON
OT1YPotency ControlON
OT2yGrade ControlON
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cSuppressErrorMessage | SUPPS | char | NONE | NONE |
'1' = Error will not be set on
| ||||
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
| ||||
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
| ||||
cCallType | EV01 | char | NONE | NONE |
'1' = Set an Error when Record not found.
| ||||
mnIndex | CDL | MATH_NUMERIC | NONE | NONE |
Default will be '1'
| ||||
mnKeys | CDL | MATH_NUMERIC | NONE | NONE |
Default will be '2'
| ||||
cMultipleRetrieve | EV01 | char | NONE | NONE |
'1' = Multiple records will be return and Open table handle (HREQUEST) is to be returned as well.
| ||||
cLastRecordRead | EV01 | char | NONE | NONE |
1' = Last record has been retrieved from F4100
| ||||
idOpenTableHandle | GENLNG | ID | NONE | NONE |
Required as an Input/Output when Multiple retrieve is set to '1'
| ||||
cReturnRecordPtr | EV01 | char | NONE | NONE |
'1' = F4100 Record Pointer is to be returned.
| ||||
idF4100RecordPtr | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
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
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szAisle | AISL | char | NONE | NONE |
A code that identifies a location in a warehouse. This code is used in conjunction with a bin and lot identifier, to indicate a specific, tangible
| ||||
szBin | BIN | char | NONE | NONE |
A specific storage location within a warehouse or store. The system uses the bin with an aisle location to identify a storage area whose
| ||||
szLocationCode03 | LA03 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode04 | LA04 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode05 | LA05 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode06 | LA06 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode07 | LA07 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode08 | LA08 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode09 | LA09 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
szLocationCode10 | LA10 | char | NONE | NONE |
A code that the system uses for one of two purposes:
o To identify a specific location within a Branch/Plant as part of the location identifier.
| ||||
cLevelOfDetail | LLDL | char | NONE | NONE |
A code that summarizes or classifies locations and provides a hierarchy of locations for review purposes. For example, you can assign
| ||||
szLocationDimensionGroup | STY1 | char | NONE | NONE |
A code (system 46/type LD) that identifies a group of locations that share the same dimensions. A location dimension group defines the
| ||||
szLocationCharacteristics | CGRP | char | NONE | NONE |
A code (system 46/type LC) that identifies a group of locations that share the same characteristics. A location characteristics group defines
| ||||
szLocationHoldCode | LHLD | char | NONE | NONE |
Reserved for future use. | ||||
cFreezeRule | FREZ | char | NONE | NONE |
A code that indicates what putaway restrictions you want to place on a location during the pick process.
Valid codes are:
Blank No freeze.
| ||||
cNettableAllocatable | NETA | char | NONE | NONE |
This is a code used to inform the MPS/MRP system as to the status of the inventory at this location.
Allowable values are:
1 Nettable and
| ||||
mnMinimumPutawayPercentage | MNUP | MATH_NUMERIC | NONE | NONE |
The minimum percentage of the total location capacity that you want the system to use during putaway. You specify a minimum putaway
| ||||
mnMinimumPickPercentage | MNUK | MATH_NUMERIC | NONE | NONE |
The minimum percentage of the total location capacity that you want the system to use during picking. If you use this minimum percentage,
| ||||
szLocationTaxCode | LCOD | char | NONE | NONE |
A code (system 46/type LT) that indicates whether the location contains tax-paid inventory (in-bond vs. duty paid). If an item has an
| ||||
szCommitmentMethod | MMTH | char | NONE | NONE |
The preferred method used to move goods through a warehouse. | ||||
szContainerCode | EQTY | char | NONE | NONE |
A code (46/EQ) that identifies a storage container or a shipping carton. A storage container can be an open container where items are
| ||||
cCartonizeFlag | CTNF | char | NONE | NONE |
A code that indicates whether the system recommends shipping cartons when it picks from this location.
Valid codes are:
Y Yes,
| ||||
cAllowMixContainers | MCNT | char | NONE | NONE |
A code that indicates whether you want to allow more than one type of storage container for an item to be stored in the location. Valid codes
| ||||
cAllowMixLot | MLOT | char | NONE | NONE |
A code that indicates how you want the system to assign items to a location. | ||||
mnMaximumNumberOfItemsAllow | MITM | MATH_NUMERIC | NONE | NONE |
A number that specifies the maximum number of different items that can be stored in this location at one time.
Enter a number from 1 to 99. If
| ||||
cStagingLocationFlag | STAG | char | NONE | NONE |
A code that indicates whether the location is a staging location, where you hold items temporarily before moving them somewhere else.
| ||||
szVerificationCode | LVER | char | NONE | NONE |
A two-character code that uniquely identifies a location. The Movement Confirmations program uses the code that you enter to verify that
| ||||
cPutawayConfirmationRequired | PCNF | char | NONE | NONE |
A Y in this field will indicate putaway confirmation must take place when the goods are physically put into the location. | ||||
cPickingConfirmationRequired | KCNF | char | NONE | NONE |
A Y in this field will indicate retrieval confirmation must take place when the goods are physically removed from the location. | ||||
cAllowPutaway | APUT | char | NONE | NONE |
A code that indicates whether the location is valid for putaway selection.
Valid codes are:
Y Yes, use this location for putaway
N No, do
| ||||
cAllowPicking | APIK | char | NONE | NONE |
A code that indicates whether this location is valid for picking.
Valid codes are:
Y Yes, use this location for picking
N No, do not use this
| ||||
cAllowReplenishment | ARPL | char | NONE | NONE |
A code that indicates whether you allow replenishment from a location. | ||||
szPutawayZone | PZON | char | NONE | NONE |
A code (system 46/type ZN) that identifies areas in the warehouse where goods are put away or stored. | ||||
szPickingZone | KZON | char | NONE | NONE |
A code (system 46/type ZN) that identifies an area from which items are picked for shipment. | ||||
szPutawayStagingLocation | STGP | char | NONE | NONE |
A code that specifies a warehouse location where you hold items temporarily (either physically or logically) before moving them
| ||||
szPickingStagingLocation | STGK | char | NONE | NONE |
A code that specifies a warehouse location where you hold items temporarily (either physically or logically) before moving them
| ||||
szReplenishStagingLocation | STGR | char | NONE | NONE |
A code that specifies a warehouse location where you hold items temporarily (either physically or logically) before moving them
| ||||
mnPutawaySequence | WSQP | MATH_NUMERIC | NONE | NONE |
A number that you assign to a location to determine its place in the putaway sequence. Putaway is the movement of inventory to storage
| ||||
mnPickingSequence | WSQQ | MATH_NUMERIC | NONE | NONE |
A number that you assign to a location to determine its place in the picking sequence. Picking is the movement of inventory from storage to
| ||||
mnReplenishSequence | WSQR | MATH_NUMERIC | NONE | NONE |
A number that you assign to a location to determine its place in the replenishment sequence. Replenishment is the movement of inventory
| ||||
mnLattitudeCoordinate | DISX | MATH_NUMERIC | NONE | NONE |
The X or latitude coordinate of a location in the warehouse. The system can use latitude, longitude, and height as a tiebreaker when
| ||||
mnLongitudeCoordinate | DISY | MATH_NUMERIC | NONE | NONE |
The Y or longitude coordinate of a location in the warehouse. The system can use latitude, longitude, and height as a tiebreaker when
| ||||
mnHeightCoordinate | DISZ | MATH_NUMERIC | NONE | NONE |
The Z or height coordinate of a location in the warehouse. The system can use latitude, longitude, and height as a tiebreaker when
| ||||
cPotencyControl | OT1Y | char | NONE | NONE |
A code that indicates whether you control the item by potency. | ||||
cGradeControl | OT2Y | char | NONE | NONE |
A code that indicates whether you control the item by grade. | ||||
szReplenishmentZone | ZONR | char | NONE | NONE |
A code (system 46/type ZN) that identifies replenishment zones, which are areas in the warehouse from which items are retrieved to
|
None |
F4100 Location Master |