MarginMaintPriceUpdate

Margin Maint Price Update

Major Business Rule

Object Name: X4078

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function update the Base Price table (F4106) for margin maintenance.

Setup Notes and Prerequisites
All input parameters are required.  The Sales Base Price Level (PLEV) and Unit of Measure (UOM1) are
needed from the Item Master table (F4101).  The Margin Maintenance needs to be passed from the Item
Branch table (F4102).

Technical Specification

All input parameters are loaded into the F4106 fields.  The F4106 table is read to find the last
record written based on the key ITM, MCU, LOCN, LOTN, AN8, ICID, CRCD, UOM and EXDJ.  If the appropriate
date range is found, Margin Maintenance is multiplied by the unit cost passed in, creating the new
price.  This new price is loaded into the price field (UPRC) in the F4106 and the update then takes place.

Data Structure

DX4078 - Margin Maint Price Update

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

cSalesBasePriceLevel 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

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.

mnUnitCost UNCS MATH_NUMERIC NONE NONE

The amount per unit, derived by dividing the total cost by the unit quantity.

szPrimaryUnitOfMeasure UOM1 char NONE NONE

A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
(each) or KG (kilogram).

jdEffectiveDate EFTJ JDEDATE NONE NONE

The date when a transaction, contract, obligation, preference, or policy rule becomes effective.

mnMarginMaintenance MMPC MATH_NUMERIC NONE NONE

This field is used as a method to automatically maintain a desired margin. If a value is entered in this field, every purchase order receipt will
add the margin percentage to the item's cost, if the costing method is 1, 2, or 6, in order to generate a new list price. For example:  Item cost =
56.00, and Margin Maintenance % = 20, then the new list price will be as follows: 56 * ( 1 + .20 ) = 67.20

szCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

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.

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

Related Tables

F4106 Item Base Price File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cSalesBasePriceLevel	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
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.
mnUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
szPrimaryUnitOfMeasure	UOM1	char	NONE	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA (each) or KG (kilogram).
jdEffectiveDate	EFTJ	JDEDATE	NONE	NONE
The date when a transaction, contract, obligation, preference, or policy rule becomes effective.
mnMarginMaintenance	MMPC	MATH_NUMERIC	NONE	NONE
This field is used as a method to automatically maintain a desired margin. If a value is entered in this field, every purchase order receipt will add the margin percentage to the item's cost, if the costing method is 1, 2, or 6, in order to generate a new list price. For example: Item cost = 56.00, and Margin Maintenance % = 20, then the new list price will be as follows: 56 * ( 1 + .20 ) = 67.20
szCurrencyCode	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
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.
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.