InsertSupplierItemRelationshipRo

Insert Supplier Item Relationship Row

Major Business Rule

Object Name: B4300290

Parent DLL: CDIST

Location: Client/Server

Language: C

Functional Description

Purpose
To add a row to the Supplier/Item Relationships table if one does not exist. Update the F43090 with
UODR and AODR if the Suppress Update Flag allows.

Special Logic

This bsfn returns ER_ERROR is a matching record is found.

Technical Specification

2.4Processing

If the StockingType is 'N' then the access key is AN8 and LITM.
If the StockingType is not 'N' then the access key is MCU, AN8 and ITM.

Ensure that the record DOES NOT already exist in the table.

If the record already exists and Updates Allowed flag is not a '1', then exit with no add or update.

If the record does not exist then

Use a (???) data dictionary API to retrieve the default values for LTQP, DAYE and DAYL.
If the data dictionary default for LTQP is zero then assign 100 to it.

If the stocking type is blank then retrieve the default from the data dictionary.

If the branch/plant is required (Stocking type < > 'N') and is blank, then set error number
0003 and exit the business function.

If the Units ordered or Amount ordered is passed in, add to UODR and AODR in the F43090.

Insert a row in the table F43090 if no errors.

If the record does exist and theUpdates Allowed flag is a '1',
Update the Units ordered or Amount ordered in the F43090.

Data Structure

D4300290 - Insert Supplier Item Relationship Row

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szBranchPlant	MCU	char	NONE	NONE
Special Input Expected Only mandatory when the stocking type is not equal to 'N'ab ^
mnSupplier	AN8	MATH_NUMERIC	NONE	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
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
szSecondItemNumber	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.
szThirdItemNumber	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.
jdEffectiveDate	CEFJ	JDEDATE	NONE	NONE
Special Input Expected Defaults to current system date if left blankab ^
jdExpirationDate	CXPJ	JDEDATE	NONE	NONE
Special Input Expected Defaults to last day of year specified in the data item CENTCHGab ^
cStockingType	STKT	char	NONE	NONE
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking types are hard-coded and you should not change them: 0 Phantom item B Bulk floor stock C Configured item E Emergency/corrective maintenance F Feature K Kit parent item N Nonstock The first character of Description 2 in the user defined code table indicates if the item is purchased (P) or manufactured (M).
mnUnitsOrdered	UODR	MATH_NUMERIC	NONE	NONE
Special Input Expected Units ordered from purchase order entry in primary unit of measureab ^
mnAmountOrdered	AODR	MATH_NUMERIC	NONE	NONE
Special Input Expected Amount ordered from purchase order entryab ^
cSuppressUpdate	EV01	char	NONE	NONE
Special Input Expected 1 = Update the F43090ab ^
cLevelPurchasingPrice	PPLV	char	OPT	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

B4000630 Verify Effective Dates

Related Tables

F43090 Supplier/Item Relationships