RetrieveInstallBaseBySerialNumbe

Retrieve Equipment Master By Serial Model

Minor Business Rule

Object Name: N1702030

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function will check to see if a given serial number and product model exist in the Installed Base. If so, it will return related information.

Processing
Move blanks to error message id

V1201T.Select using Serial Number and Product Model
V1201T.FetchNext

If found record then return the following fields:

Short Asset Number
Unit Number
Description
Short Item Number
Branch/Plant
Lot
Product Family
Environment
Customer Number
Site Number
Intalled Base Cat Code 01-10
Default Business Unit
Equipment Status

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSerialNumber	ASID	char	REQ	INPUT
A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track assets by the manufacturer's serial number. You are not required to use a serial number to identify an asset. Every serial number that you enter must be unique.
szProductModel	PRODM	char	REQ	INPUT
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.
mnAssetShortItemNumber	NUMB	MATH_NUMERIC	OPT	OUTPUT
An 8-digit number that uniquely identifies an asset.
szUnitNumber	APID	char	OPT	OUTPUT
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is typically the serial number.
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.
mnInventoryItemShortItem	ITM	MATH_NUMERIC	OPT	OUTPUT
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
szItemBranchPlant	MCU	char	OPT	OUTPUT
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.
szLot	LOTN	char	OPT	OUTPUT
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
szProductFamily	PRODF	char	OPT	OUTPUT
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax.
mnCustomerAddressNumber	AN8	MATH_NUMERIC	OPT	OUTPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnSiteAddressNumber	LANO	MATH_NUMERIC	OPT	OUTPUT
The address book number for the lessor, renter, or lending institution.
szIBCategoryCode01	ZE01	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode02	ZE02	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode03	ZE03	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode04	ZE04	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode05	ZE05	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode07	ZE07	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode06	ZE06	char	OPT	OUTPUT
A user defined reporting code for equipment. Enter a value from UDC 17/B6.
szIBCategoryCode08	ZE08	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode09	ZE09	char	OPT	OUTPUT
A user defined reporting code for equipment.
szIBCategoryCode10	ZE10	char	OPT	OUTPUT
A user defined reporting code for equipment.
szDefaultBusinessUnit	MCU	char	OPT	OUTPUT
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.
szEquipmentStatus	EQST	char	OPT	OUTPUT
A user defined code (12/ES) that identifies the equipment or disposal status of an asset, such as available, down, or disposed.
szErrorMessageID	DTAI	char	OPT	OUTPUT
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.
cSuppressErrorMessage	SUPPS	char	OPT	INPUT
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.
szProductComponent	PRODC	char	OPT	OUTPUT
The components that make an equipment number or components associated with a customer site.
szCountry	CTR	char	OPT	OUTPUT
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system uses the country code for data selection and address formatting.
szPrimaryAssetNumber_ASII	ASII	char	OPT	OUTPUT
An identification code that represents an asset. You enter the identification code in one of the following formats: 1 Asset number (a computer-assigned, 8-digit, numeric control number) 2 Unit number (a 12-character alphanumeric field) 3 Serial number (a 25-character alphanumeric field) Every asset has an asset number. You can use unit number and serial number to further identify assets. If this is a data entry field, the first character you enter indicates whether you are entering the primary (default) format that is defined for your system, or one of the other two formats. A special character (such as / or *) in the first position of this field indicates which asset number format you are using. You assign special characters to asset number formats on the fixed assets system constants form.