DeleteAlternateDescriptions

Misc. Item Master Validation Functions

Minor Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function deletes all alternate descriptions in Item Alternate Descriptions Table (F4101D) that
are related to the obsolete item master record.

Technical Specification



Retrievals:





1) Use the Request and Fetch functions to fetch and delete all related F4101D records.





Returns:





1) Set idReturnCode to CONTINUE_GBR.

Data Structure

D4000040A - Verify Existance Of Vendor Information

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

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships

F4101GetItemNumberFromNextNumber

Misc. Item Master Validation Functions

Major Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Data Structure

D4000171 - Get Item Number From Next Number

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnIdentifiershortitem	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

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships

ValidateAgainstBlankItemNumber

Misc. Item Master Validation Functions

Minor Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Data Structure

D4000040B - Validate Against Blank Item Number

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnIdentifiershortitem	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
szIdentifier2nditem	LITM	char	NONE	NONE
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A 25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
szIdentifier3rditem	AITM	char	NONE	NONE
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item numbers are as follows: 1. Item Number (short) - An 8-digit, computer-assigned item number. 2. 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number. In addition to these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships

VerifyExistenceOfF4104Records

Misc. Item Master Validation Functions

Minor Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This business function verifies the existence of any related item cross reference records in the Item
Cross Reference Table (F4104) before deleting an item. If a record is found, this function will
issue an error (0286) and return a 'Y' in the error code. You can use this function to check for item
specific records in F4104.

Setup Notes and Prerequisites

Special Logic

Technical Specification




Retrievals:





1) Use the Request and Fetch functions to locate the F4104 records.  Limit the number of columns to 

select to just the short item number.





Returns:





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

Data Structure

D4000040A - Verify Existance Of Vendor Information

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

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships

VerifyExistenceOfVendorInfo

Misc. Item Master Validation Functions

Minor Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose

This business function verifies the existence of any vendor information in the Vendor Information
File (F43090) before deleting an item. If a record is found, this function will issue an error (0286)
and return a 'Y' in the error code. You can use this function to check for item specific records in the
F43090.

Technical Specification




Retrievals:





1) Use the Request and Fetch functions to locate the F43090 records.  Limit the number of columns to 

select to just the short item number.





Returns:





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

Data Structure

D4000040A - Verify Existance Of Vendor Information

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

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships

VerifyPurchasePriceLevelChanges

Misc. Item Master Validation Functions

Minor Business Rule

Object Name: B4000040

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This business function issues an error (4394), if the old purchasing price level is greater than the
new purchasing price level, and there are existing records in the Supplier Price File (F41061).

Technical Specification




Edits:





1) If the old price level is greater than the new price level, search for a record in the F41061 

using item number as the key.  If record is found, issue an error.





Retrievals:





1) Use the Request and Fetch functions to locate the F41061 records.  Limit the number of columns to 

select to just the key field.





Returns:





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

Data Structure

D4100434 - Verify Purchase Price Level Changes

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
cOldSalesPriceLevel	PPLV	char	NONE	NONE
A code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Valid codes are: 1 Use the supplier/item price from the Purchase Price table (F41061). 2 Use the supplier/item/branch price from the Purchase Price table (F41061). 3 Use the inventory cost from the Inventory Cost table (F4105). This cost is based on the inventory cost level and the purchasing cost method you specify for the item. The first two codes are applicable only if you set up supplier costs in the Procurement system. If you do not set up supplier costs, the system uses the inventory cost as the default for the purchase order.
cNewSalesPriceLevel	PPLV	char	NONE	NONE
A code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Valid codes are: 1 Use the supplier/item price from the Purchase Price table (F41061). 2 Use the supplier/item/branch price from the Purchase Price table (F41061). 3 Use the inventory cost from the Inventory Cost table (F4105). This cost is based on the inventory cost level and the purchasing cost method you specify for the item. The first two codes are applicable only if you set up supplier costs in the Procurement system. If you do not set up supplier costs, the system uses the inventory cost as the default for the purchase order.

Related Functions

None

Related Tables

F4101 Item Master
F4101D Item Master - Alternative Description
F4104 Item Cross Reference File
F41061 Supplier Price/Catalog File
F43090 Supplier/Item Relationships