GetItemPrice

Base Price Item

Major Business Rule

Object Name: XF4106

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function retrieves the Item Price record (F4106) for an Item based on the Price Level.

Setup Notes and Prerequisites
The Item Number (ITM), Branch (MCU) and Price Level (PLEV) are required input parameters.

Technical Specification

This function retrieves the F4106 for an Item based on the Price Level passed in.  If the Price Level
= 1,  Key = 1  :  Short Item Number only.  If the Price Level = 2, Key = 2 : Short Item Number and
Branch/Plant.  If the Price Level = 3,
Key = 4 : Short Item Number, Branch/Plant, Location, and Lot Number.  If the Call Type = 1 : If
record is not found give an error.  If the Call Type = 2 : If record is found give an error.  If the
ReturnItemPriceRecord = '1' :  If record is found, return the pointer into ReturnItemPriceRecord.

Data Structure

DXF4106A - Get Item Price

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.

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.

cPriceLevel 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

mnItemPrice UPRC MATH_NUMERIC NONE NONE

The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
(F4106).

cReturnBasePriceRecord EV01 char NONE NONE

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

idBasePriceRecordPtr GENLNG ID NONE NONE

General purpose ID variable.

cErrorCode ERR char NONE NONE

The Data Field Error Code field is simply a generic data field to pass an error condition flag.  This field is one of the fields that make up the
external parameter data structure of the Data Dictionary Server.

cCallType EV02 char NONE NONE

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

Related Functions

None

Related Tables

F4106 Item Base Price File

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.
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.
cPriceLevel	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
mnItemPrice	UPRC	MATH_NUMERIC	NONE	NONE
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table (F4106).
cReturnBasePriceRecord	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
idBasePriceRecordPtr	GENLNG	ID	NONE	NONE
General purpose ID variable.
cErrorCode	ERR	char	NONE	NONE
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the external parameter data structure of the Data Dictionary Server.
cCallType	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.