F4100InsertAndUpdate

F4100 Insert And Update

Major Business Rule

Object Name: B4100880

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
To insert and update rows into F4100.  If a flag is sent in when updating, all fields will be
overwritten with the data dictionary default values.

Setup Notes and Prerequisites
It is assumed that the branch sent into the function has already been validated by the application
calling the business function.

Special Logic
None

Technical Specifications
Fetch from F4100 with the Branch and Location sent in.

If row exists and Mode is equal to '1'  or the row does not exist, call Get Data Dictionary
Definition (B9800420) for each of the following columns from F4100 to retrieve their default value:
STY1Group - Location Dimension
CGRPGroup - Location Characteristics
LHLDHold Code - Location
LLDLLevel of Detail - Location
FREZFreeze Rule
NETANettable Allocatable Code
LCODCode - Location Tax Status
MMTHMove Method Code
EQTYContainer Code
CTNFCarton Recommendation (Y/N)
MCNTMix Containers (Y/N)
MLOTMix Date/Lots (Y/N)
STAGStaging Location (Y/N)
PCNFStorage Confirmation Required (Y/N)
KCNFRetrieval Confirmation Required (Y/N)
APUTAllow Putaway (Y/N)
APIKAllow Pick (Y/N)
ARPLAllow Replenishment (Y/N)
STGPStaging Location - Putaway
STGKStaging Location - Putaway
STGRStaging Location - Replenishment
URCDUser Reserved Code
URRFUser Reserved Reference
OT1YPotency Control
OT2YGrad Control
MNUKPercentage - Minimum Pick
MNUPPercentage - Minimum Putaway
MITMMaximum Number of Items
WSQPSequence Code - Putaway
WSQQSequence Code - Picking
WSQRSequence Code - Replenishment
DISXLatitude
DISYLongitude
DISZHeight
URDTUser Reserved Date
URATUser Reserved Amount
URABUser Reserved Number

Call Get Audit Information (B9800100).  Assign the values sent back as follows:
User ID=>LMUSER
Work Station ID=>LMJOBN
Date Updated=>LMUPMJ
Time of Day=>LMTDAY
Program ID passed in=>LMPID

Assign the values for Ailse, Bin, Location Code 3 - Location Code 10 passed in to the corresponding
columns in F4100.

For the Aisle, Bin and Location Code 3 - Location Code 10 passed in :
If LAxx is not equal to blank
1.  Call Get Data Dictionary Definition to retrieve the UDC Record Type and System Code.
2.  If the UDC Record Type and System Code are not equal to blank, call Update UDC
   (B9800150).  Pass in the System Code and Record Type from the data dictionary, LAxx as
   the UDC value and the Description, and the Program ID passed in to this function.

Insert or Update F4100.

^

Data Structure

D4100880 - F4100 Insert And Update

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
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 storage area within a warehouse or yard.
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 width, depth, and height can be readily measured.
szLocationCode3	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. o To use as a general reporting code for location information.
szLocationCode4	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. o To use as a general reporting code for location information.
szLocationCode5	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. o To use as a general reporting code for location information.
szLocationCode6	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. o To use as a general reporting code for location information.
szLocationCode7	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. o To use as a general reporting code for location information.
szLocationCode8	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. o To use as a general reporting code for location information.
szLocationCode9	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. o To be used as a general reporting code for location information.
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. o To be used as a general reporting code for location information.
cOverridewithDDDefaults	MODE	char	NONE	NONE
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
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 Set Server program (XT4914).
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.

Related Functions

B9800100 Get Audit Information
B9800150 Update and Right Justify User Defined Codes Value
B9800420 Get Data Dictionary Definition

Related Tables

F4100 Location Master