GetInventoryExtensionInformation

Get Inventory Extension Information

Minor Business Rule

Object Name: N1700430

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
To default in the Product Family, Product Model and any Disposition Codes according to the Inventory Item Number.

Setup Notes and Prerequisites
This NER should not be run if the ITM being passed in is blank.

Special Logic

Technical Specifications

Parameters:
Data Item Data Structure DescriptionI/OReqNotes
ITMInventoryItemNumberIY
MMCUBranch/PlantIN
PRODMProductModelON
PRODFProductFamilyON
DCD1DispositionCode1ON
DCD2DispositionCode2ON
DCD3DispositionCode3ON
DCD4DispositionCode4ON
DCD5DispositionCode5ON
SUPPSSuppressErrorMessagesIN1 = Suppress Warning Message from being
set.
DTAIErrorMessageIDON
MCUZCostCenterAlternativeON
RTRNDReturnableFlagON
RPRBLRepairableFlagON
CCOSTCSMSCostTypeON

2.2Related Tables
Table Table Description
F4117Item Master - Customer Service Extension
F41171Item Branch Master - Customer Service Extension

2.3Related Business Functions
Source NameFunction Name

2.4Processing

If BF szBranchPlant is equal to
   F4117.FetchSingle
          BFmnInventoryItemNumber =  TK Item Number - Short
          BFszProductModel <- TK Product Model
          BFszProductFamily <- TK Product Family
          BFszDispositionCode1 <- TK Disposition Code 1
          BFszDispositionCode2 <- TK Disposition Code 2
          BFszDispositionCode3 <- TK Disposition Code 3
          BFszDispositionCode4 <- TK Disposition Code 4
          BFszDispositionCode5 <- TK Disposition Code 5
BFcReturnableFlag <- TK ReturnableFlag
          BFcRepairableFlag <- TK RepairableFlag
          BFszCSMSCostType <- TK CSMS Cost Component

Else
   F41171.FetchSingle
          BFmnInventoryItemNumber =  TK Item Number - Short
          BFszBranchPlant =  TK Branch
          BFszProductModel <- TK Product Model
          BFszProductFamily <- TK Product Family
          BFszDispositionCode1 <- TK Disposition Code 1
          BFszDispositionCode2 <- TK Disposition Code 2
          BFszDispositionCode3 <- TK Disposition Code 3
          BFszDispositionCode4 <- TK Disposition Code 4
BFcReturnableFlag <- TK ReturnableFlag
          BFcRepairableFlag <- TK RepairableFlag
          BFszCSMSCostType <- TK CSMS Cost Component
End If
If SV File_IO_Status is not equal to CO SUCCESS
   If BF cSuppressErrorMessage is not equal to "1"
      Set NER Error("085L", BF mnInventoryItemNumber)
   End If
   BF szErrorMessageID = "085L"
End If

Data Structure

D1700430 - Get Inventory Extension Information

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

mnInventoryItemNumber ITM MATH_NUMERIC REQ INPUT

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 MMCU char REQ INPUT

A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

szProductModel PRODM char OPT NONE

A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.

szProductFamily PRODF char OPT NONE

A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.

szDispositionCode1 DCD1 char OPT NONE

A user defined disposition code.

szDispositionCode2 DCD2 char OPT NONE

A user defined disposition code.

szDispositionCode3 DCD3 char OPT NONE

A user defined disposition code.

szDispositionCode4 DCD4 char OPT NONE

A user defined disposition code.

szDispositionCode5 DCD5 char OPT NONE

A user defined disposition code.

cSuppressErrorMessage SUPPS char OPT NONE

A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.        0 = allow
runtime error message handling.        1 = suppress runtime error message handling.

szErrorMessageID DTAI char OPT 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.

szCostCenterAlternative MCUZ char OPT NONE

Identifies a separate entity within a business for which you wish to track costs, for example, a warehouse location, job, project, work center,
or branch/plant. The business unit field is alphanumeric. You can assign a business unit to a voucher, invoice, fixed asset, and so forth, for
responsibility reporting.  The system provides reports of open A/P and A/R by business unit, for example, to track equipment by responsible
department. Business Unit Security can prevent you from inquiring on business units for which you have no authority.

cReturnableFlag RTRND char OPT NONE

This is a flag that is used to indicate if the item is returnable.

cRepairableFlag RPRBL char OPT NONE

Use this flag to indicate that the item is repairable.

szCSMSCostType CCOST char OPT NONE

A code that designates the item being costed. Examples would be:    A1   Material    B1   Labor    X1   Freight    X2   Travel

cEligibleSupplierRecovery SRYN char OPT NONE

A code that specifies whether a work order or a warranty claim is eligible as a source for a supplier recovery claim.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnInventoryItemNumber	ITM	MATH_NUMERIC	REQ	INPUT
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	MMCU	char	REQ	INPUT
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
szProductModel	PRODM	char	OPT	NONE
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.
szProductFamily	PRODF	char	OPT	NONE
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.
szDispositionCode1	DCD1	char	OPT	NONE
A user defined disposition code.
szDispositionCode2	DCD2	char	OPT	NONE
A user defined disposition code.
szDispositionCode3	DCD3	char	OPT	NONE
A user defined disposition code.
szDispositionCode4	DCD4	char	OPT	NONE
A user defined disposition code.
szDispositionCode5	DCD5	char	OPT	NONE
A user defined disposition code.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	DTAI	char	OPT	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.
szCostCenterAlternative	MCUZ	char	OPT	NONE
Identifies a separate entity within a business for which you wish to track costs, for example, a warehouse location, job, project, work center, or branch/plant. The business unit field is alphanumeric. You can assign a business unit to a voucher, invoice, fixed asset, and so forth, for responsibility reporting. The system provides reports of open A/P and A/R by business unit, for example, to track equipment by responsible department. Business Unit Security can prevent you from inquiring on business units for which you have no authority.
cReturnableFlag	RTRND	char	OPT	NONE
This is a flag that is used to indicate if the item is returnable.
cRepairableFlag	RPRBL	char	OPT	NONE
Use this flag to indicate that the item is repairable.
szCSMSCostType	CCOST	char	OPT	NONE
A code that designates the item being costed. Examples would be: A1 Material B1 Labor X1 Freight X2 Travel
cEligibleSupplierRecovery	SRYN	char	OPT	NONE
A code that specifies whether a work order or a warranty claim is eligible as a source for a supplier recovery claim.