DuplicateUOMConversionsRecords

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function duplicates all Item Unit of Measure conversion records (F41002) from one item to
another.

Setup Notes and Prerequisites
The From Short Item Number (ITM) and To Short Item Number (ITM) are required parameters.  The Branch
parameters are optional.

Special Logic

Technical Specification

This function duplicates all F41002 records from an item or item/branch combination to another item
or item/branch combination.  If only the item is specified in the parameters, this function fetches all
F41002 records for the From Item Number.  All records for the key will be copied from the From Item
to the To Item.

Edits:

1) The branch/plant parameter is optional.  Therefore, only use it in the search key if it is
non-blank.

Retrievals:

1) If only the item is specified, search for a record in F41002 using just the item number.
2) If both the item number and Branch are specified, search for a record with both fields as the key.
3) Use the Request and Fetch functions to locate the base price records.  You will need to fetch all
the columns in the table in order to duplicate the whole record to the add.
4) There may be more one record in the F41002 that is associated with the search key.  Therefore, set
up a search loop to retrieve all related records.
5) Fro every record retrieved, change the key fields to the values in the "To" parameters and add the
record to the table.

Returns:

1) Set idReturnCode to CONTINUE_GBR.

Data Structure

D4100060D - Duplicate UOM Conversions Records

Data Item Data Structure DescriptionI/ORequired
ITMToShortItemNumberIN
MCUFromBranchPlantIN
MCUToBranchPlantI N
ITMFromShortItemNumberIN

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnFromShortItemNumber	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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szFromBranchPlant	MCU	char	NONE	NONE
The branch/plant parameter is optional. Therefore, only use it in the search key if it is non-blank. ^
mnToShortItemNumber	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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szToBranchPlant	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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File
F3460 Forecast File
F41002 Item Units of Measure Conversion Factors
F4105 Item Cost File
F4106 Item Base Price File

VerifyCostLevelChanges

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function validates to see if the old cost level is greater than the new cost level.  Also, if
records exist in the Item Cost Table (F4105), an error is issued.

Setup Notes and Prerequisites
The Short Item Number (ITM) is a required parameter.  You may pass in the Old Cost Level (CLEV) and
the New Cost Level (CLEV) if you wish to have them validated.

Special Logic

Technical Specification

This function checks to see if the old cost level is greater than the new cost level.  If so, the
function Verify Existance of Unit Cost (B4100060) is called to determine if any cost records exist.  If
so, an error is issued.

Edits:

If the old cost level is greater than the new cost level, use the business function,
VerifyExistenceOfUnitCost, to determine if any cost records exist for this item.  If record is found, issue an error.
Call VerifyExistenceOfUnitCost with the call type set to '1'.

Retrievals:

Returns:

1) If a record is found, set on error message '3755' and set idReturnCode to CONTINUE_GBR.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnShortItemNumber_1	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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
cOldCostLevel	CLEV	char	NONE	NONE
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level
cNewCostLevel	CLEV	char	NONE	NONE
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level

Data Structure

D4100060B - Verify Cost Level Changes

Data Item Data Structure DescriptionI/ORequired
ITMIdentifierShortItemIY
CLEVOldCostLevelIY
CLEVNewCostLevelIY

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnShortItemNumber_1 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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

cOldCostLevel CLEV char NONE NONE

A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes
are:    1   Item level    2   Item/Branch level    3   Item/Branch/Location level

cNewCostLevel CLEV char NONE NONE

A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes
are:    1   Item level    2   Item/Branch level    3   Item/Branch/Location level

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyExistenceOfBasePrice
VerifyExistenceOfBasePrice

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function verifies the existence of any related base price records in the Base Price Table
(F4106).

Setup Notes and Prerequisites
You must pass in the Short Item Number (ITM), Branch/Plant (MCU), Location (LOCN) and Lot Number
(LOTN). The Index should be set to '1'.  The following keys are currently used:
Keys = '1'Fetch by Item Number only.
Keys = '2'  Fetch by Item Number and Branch/Plant.
Keys = '3'  Fetch by Item Number, Branch/Plant and Location.
Keys = '4'  Fetch by Item Number, Branch/Plant, Location and Lot Number.

If Call Type = '1', the function validates that the record exists, and if not, returns a '1' in the
Error Code.
If Call Type = '2', the function validates that the record does not exist, and if one does, issues an
error and returns a '1' in the Error Code.

If the Return Code = '1' the pointer to the record found will be returned in the Base Price Record
parameter.

You may place a '1' in the Suppress Error Message parameter if you wish to suppress any error
messages from occuring.

Special Logic

Technical Specification

This function retrieves the Base Price Record (F4106) based on the Index/Keys combination passed in.
If the Call Type = '1' and the fetch fails, an error is set on.  If the Call Type = '2' and the
record is found, an error is set on.  If the Return Flag = '1', and a record is found, the pointer to the
F4106 will be returned.

Retrievals:
Retrieves the Base Price Table (F4106) using the key as specified in the 'Keys'/'Index' parameters.

Returns:
If  ReturnFlag is 1 then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

If CallType is '2' (check for non-existance of record), then set error 0286.

If call type is '1' and Fetch has failed then set error number 0002.

If the requestID to the table F4106 fails then set the error code 0002.

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr ON
GENLNGidPtrToF4106Record ON
EV01cSuppressErrorMsgIN
DTAIszErrorMsgID ON

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

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
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.

cCallType CT01 char NONE NONE

Error messages wil be passed back based on the call type.
Call Type = 1 : Validate that the record exists, if not give    an error and return a (1) in the
Error Code.
Call Type = 2 : Validate if records does not exist, if record    exist then give an error and return
a (1) in the Error    Code.

^

cErrorCode ERRC char NONE NONE

Verify the existence of any related base price records in the Base Price Table (F4106) before
deleting an item.  If any base price records in the Base Price Table (F4106) exist that are related to the
item, this function will issue an error (0286) and return a '1' in the error code.
^

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nKeys INT01 integer NONE NONE

Keys 1 means fetch by Item Number only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^

cReturnPtr EV01 char NONE NONE

If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^

idPtrToF4106Record GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMsg EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMsgID 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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyExistenceofForecast
VerifyExistenceofForecast

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr ON
GENLNGidPtrToF4106Record ON
EV01cSuppressErrorMsgIN
DTAIszErrorMsgID ON

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

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
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.

cCallType CT01 char NONE NONE

Error messages wil be passed back based on the call type.
Call Type = 1 : Validate that the record exists, if not give    an error and return a (1) in the
Error Code.
Call Type = 2 : Validate if records does not exist, if record    exist then give an error and return
a (1) in the Error    Code.

^

cErrorCode ERRC char NONE NONE

Verify the existence of any related base price records in the Base Price Table (F4106) before
deleting an item.  If any base price records in the Base Price Table (F4106) exist that are related to the
item, this function will issue an error (0286) and return a '1' in the error code.
^

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nKeys INT01 integer NONE NONE

Keys 1 means fetch by Item Number only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^

cReturnPtr EV01 char NONE NONE

If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^

idPtrToF4106Record GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMsg EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMsgID 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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyExistenceOfUnitCost
VerifyExistenceOfUnitCost

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function verifies the existence of any related cost records in the Item Cost Table (F4105).

Setup Notes and Prerequisites
You must pass in the Short Item Number (ITM).  The Branch/Plant parameter is optional.  If the Call
Type = '1', any error messages will be suppressed.

Special Logic

Technical Specification
This function fetches the F4105 table with the Item Number and/or Branch/Plant passed in.  The
Branch/Plant is used in the fetch only if it is non-blank.  If a record is found in the F4105 an error code
is returned.  If the Call Type is blank, the error message will be suppressed.

Edits:

The branch/plant parameter is optional.  Therefore, only use it in the search key if it is non-blank.

Retrievals:

1) If only the item is specified, search for a record in F4105 using just the item number.
2) If both the item number and Branch/Plant are specified, search for a record with both fields as
the key.
3) Use the Request and Fetch functions to locate the base price records.  Limit the number of columns
to select to just the key field(s).

Returns:

1) If a record is found, set on error message '0286' only if the Call Type is blank.  The number of
fields to highlight should be consistent with the number of search keys.
2) Set idReturnCode to CONTINUE_GBR.

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr ON
GENLNGidPtrToF4106Record ON
EV01cSuppressErrorMsgIN
DTAIszErrorMsgID ON

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

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
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.

cCallType CT01 char NONE NONE

Error messages wil be passed back based on the call type.
Call Type = 1 : Validate that the record exists, if not give    an error and return a (1) in the
Error Code.
Call Type = 2 : Validate if records does not exist, if record    exist then give an error and return
a (1) in the Error    Code.

^

cErrorCode ERRC char NONE NONE

Verify the existence of any related base price records in the Base Price Table (F4106) before
deleting an item.  If any base price records in the Base Price Table (F4106) exist that are related to the
item, this function will issue an error (0286) and return a '1' in the error code.
^

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nKeys INT01 integer NONE NONE

Keys 1 means fetch by Item Number only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^

cReturnPtr EV01 char NONE NONE

If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^

idPtrToF4106Record GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMsg EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMsgID 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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyItemAsComponentInBOM
VerifyItemAsComponentInBOM

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
Use this function to verify that the item is not a component item in the Bill of Materials (F3002).
This function  should be called prior to deleting an item from the Item Master or Item Branch file..
If a record is found, this function will issue an error (0286) and return a 'Y' in the error code.

Setup Notes and Prerequisites
The Short Item Number (ITM) is a required parameter.

Special Logic

Technical Specification
This function fetches the Bill of Materials table (F3002) with the Component Item Number (IXITM) as
the key.  If a record is found, an error is issued and an error code is returned.

Retrievals:

1) Search for a record in F3002 using the Component Item Number (IXITM) as the search key.
2) Use the Request and Fetch functions to locate the BOM records.  Limit the number of columns to
select to just the key field.

Returns:

1) If a record is found, set on error message '0286'.
2) Set idReturnCode to CONTINUE_GBR.

^

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr ON
GENLNGidPtrToF4106Record ON
EV01cSuppressErrorMsgIN
DTAIszErrorMsgID ON

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

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
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.

cCallType CT01 char NONE NONE

Error messages wil be passed back based on the call type.
Call Type = 1 : Validate that the record exists, if not give    an error and return a (1) in the
Error Code.
Call Type = 2 : Validate if records does not exist, if record    exist then give an error and return
a (1) in the Error    Code.

^

cErrorCode ERRC char NONE NONE

Verify the existence of any related base price records in the Base Price Table (F4106) before
deleting an item.  If any base price records in the Base Price Table (F4106) exist that are related to the
item, this function will issue an error (0286) and return a '1' in the error code.
^

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nKeys INT01 integer NONE NONE

Keys 1 means fetch by Item Number only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^

cReturnPtr EV01 char NONE NONE

If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^

idPtrToF4106Record GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMsg EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMsgID 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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyItemAsParentInBOM
VerifyItemAsParentInBOM

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
Use this function to verify that the item is not a parent item in the Bill of Materials (F3002). This
function  should be called prior to deleting an item from the Item Master or Item Branch file..  If a
record is found, this function will issue an error (0286) and return a 'Y' in the error code.

Setup Notes and Prerequisites
You must pass in the Short Item Number (ITM) as a parameter.

Special Logic

Technical Specification
This function searches the Bill of Material Table (F3002) to see if a record exists for the Parent
Item Number (IXKIT).  The Short Item Number passed in is used as the key for the Parent Item Number in
the fetch.  If a record is found, an error is issued and an error code is returned.

Retrievals:

1) Search for a record in F3002 using the Parent Item Number (IXKIT) as the search key.
2) Use the Request and Fetch functions to locate the BOM records.  Limit the number of columns to
select to just the key field.

Returns:

1) If a record is found, set on error message '0286'.
2) Set idReturnCode to CONTINUE_GBR.

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr ON
GENLNGidPtrToF4106Record ON
EV01cSuppressErrorMsgIN
DTAIszErrorMsgID ON

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

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
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.

cCallType CT01 char NONE NONE

Error messages wil be passed back based on the call type.
Call Type = 1 : Validate that the record exists, if not give    an error and return a (1) in the
Error Code.
Call Type = 2 : Validate if records does not exist, if record    exist then give an error and return
a (1) in the Error    Code.

^

cErrorCode ERRC char NONE NONE

Verify the existence of any related base price records in the Base Price Table (F4106) before
deleting an item.  If any base price records in the Base Price Table (F4106) exist that are related to the
item, this function will issue an error (0286) and return a '1' in the error code.
^

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

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.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nKeys INT01 integer NONE NONE

Keys 1 means fetch by Item Number only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^

cReturnPtr EV01 char NONE NONE

If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^

idPtrToF4106Record GENLNG ID NONE NONE

General purpose ID variable.

cSuppressErrorMsg EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMsgID 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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifySalesPriceLevelChanges
VerifySalesPriceLevelChanges

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function validates to see if the old sales price level is greater than the new sales price
level.  Also, if records exist in the Base Price Table (F4106), an error is issued.

Setup Notes and Prerequisites
The Short Item Number (ITM) is a required parameter.  You may pass in the Old Sales Price Level
(PLEV) and the New Sales Price Level (PLEV) if you wish to have them validated.

Special Logic

Technical Specification

This function checks to see if the old sales price level is greater than the new sales price level.
If so, the function Verify Existance of Base Price (B4100060) is called to determine if any base price
records exist.  If so, an error is issued. Call VerifyExistenceOfBasePrice with the call type set to
'1'.

Retrievals:

Returns:

1) If a record is found, set on error message '4186' and set idReturnCode to CONTINUE_GBR.

Data Structure

D4100060C - Verify Sales Price Level Changes

Data Item Data Structure DescriptionI/ORequired
ITM Short Item NumberIY
PLEV Old Sales Price LevelIY
PLEV New Sales Price LevelIY
^

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnShortItemNumber_2 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
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

cOldSalesPriceLevel PLEV char NONE NONE

A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or
different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes
are:    1   Item level    2   Item/Branch level    3   Item/Branch/Location level

cNewSalesPriceLevel PLEV char NONE NONE

A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or
different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes
are:    1   Item level    2   Item/Branch level    3   Item/Branch/Location level

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

ber only.
Keys 2 means fetch by Item Number and Branch Plant.
Keys 3 means fetch by Item Number, Branch Plant, and Location
Keys 4 means fetch by Item Number, Branch Plant, Location, and     Lot

^
cReturnPtrEV01charNONENONE
If  ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is
NULL and no data structure is created.

^
idPtrToF4106RecordGENLNGIDNONENONE
General purpose ID variable.
cSuppressErrorMsgEV01charNONENONE
An option that specifies the type of processing for an event.
szErrorMsgIDDTAIcharNONENONE
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.

Related Functions

None

Related Tables

F3002 Bill of Material Master File

F3460 Forecast File

F41002 Item Units of Measure Conversion Factors

F4105 Item Cost File

F4106 Item Base Price File

VerifyExistenceOfUnitCost
VerifyExistenceOfUnitCost

Item Master Specific Business Functions

Minor Business Rule

Object Name: B4100060

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function verifies the existence of any related cost records in the Item Cost Table (F4105).

Setup Notes and Prerequisites
You must pass in the Short Item Number (ITM).  The Branch/Plant parameter is optional.  If the Call
Type = '1', any error messages will be suppressed.

Special Logic

Technical Specification
This function fetches the F4105 table with the Item Number and/or Branch/Plant passed in.  The
Branch/Plant is used in the fetch only if it is non-blank.  If a record is found in the F4105 an error code
is returned.  If the Call Type is blank, the error message will be suppressed.

Edits:

The branch/plant parameter is optional.  Therefore, only use it in the search key if it is non-blank.

Retrievals:

1) If only the item is specified, search for a record in F4105 using just the item number.
2) If both the item number and Branch/Plant are specified, search for a record with both fields as
the key.
3) Use the Request and Fetch functions to locate the base price records.  Limit the number of columns
to select to just the key field(s).

Returns:

1) If a record is found, set on error message '0286' only if the Call Type is blank.  The number of
fields to highlight should be consistent with the number of search keys.
2) Set idReturnCode to CONTINUE_GBR.

Data Structure

D4100060A - Verify Existence Of Base Price

Data Item Data Structure DescriptionI/ORequired
MCU        Branch/PlantIY
CT01Call Type - 1IY
ERRCErrorCodeON
LOCNLocation IY
LOTNLotNumber IY
INT01nIndex IY
ITMIdentifierShortItem IY
INT01nKeysIY
EV01cReturnPtr

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
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 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.
cCallType	CT01	char	NONE	NONE
Error messages wil be passed back based on the call type. Call Type = 1 : Validate that the record exists, if not give an error and return a (1) in the Error Code. Call Type = 2 : Validate if records does not exist, if record exist then give an error and return a (1) in the Error Code. ^
cErrorCode	ERRC	char	NONE	NONE
Verify the existence of any related base price records in the Base Price Table (F4106) before deleting an item. If any base price records in the Base Price Table (F4106) exist that are related to the item, this function will issue an error (0286) and return a '1' in the error code. ^
szLocation	LOCN	char	NONE	NONE
The storage location from which goods will be moved.
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.
nIndex	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
nKeys	INT01	integer	NONE	NONE
Keys 1 means fetch by Item Number only. Keys 2 means fetch by Item Number and Branch Plant. Keys 3 means fetch by Item Number, Branch Plant, and Location Keys 4 means fetch by Item Number, Branch Plant, Location, and Lot ^
cReturnPtr	EV01	char	NONE	NONE
If ReturnPtr is 1, then returns a GENLNG pointer to the F4106 data structure, otherwise pointer is NULL and no data structure is created. ^
idPtrToF4106Record	GENLNG	ID	NONE	NONE
General purpose ID variable.
cSuppressErrorMsg	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMsgID	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.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnShortItemNumber_2	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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
cOldSalesPriceLevel	PLEV	char	NONE	NONE
A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level
cNewSalesPriceLevel	PLEV	char	NONE	NONE
A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level