F1201VerifySerialNoProductFmy

F1201 Verify Serial Number/Product Model Uniqueness

Minor Business Rule

Object Name: N1700190

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This function verifies whether the combination of Serial Number and Product Family will be unique
across F1201 and F1217. The join of these tables is on the Asset Item Number (NUMB) field. If a matching
record with Serial Number(=Input Serial Number) and Product Family(=Input Product Family) is found, an
error condition will be set.

Setup Notes and Prerequisites

Special Logic
The SQL Statement Generated by the Table I/O Select should be in the following form:
SELECT  DISTINCT T0.FACO, T0.FANUMB, T0.FAASID, T0.FAMCU, T0.FAAN8, T1.WRMMCU, T1.WRDCTO, T1.WRKCOO,
T1.WRMCU, T1.WRPRODM FROM F1201      T0,F1217 T1 WHERE  ( T1.WRPRODM = Input Product Family AND
T0.FAASID = Input Serial Number)  AND  ( T0.FANUMB=T1.WRNUMB )  ORDER BY T0.FANUMB ASC

Technical Specification




1.If Suppress Error Message (SUPPS) <> '1' And <> '0'


2. Suppress Error Message (SUPPS) = '0'


3.End If





4.Select from V1201T using Table I/O using the following key:


5. ASID  = Serial Number (ASID)


6. PRODM= Product Family (PRODM)





7.Perform FetchNext using Table I/O.


8.If FetchNext Was Successful


9. If Suppress Error Message <> '1'


10.  Set NER Error "0775" on Serial Number (ASID)


11. End If


12. Error Code (ERRC) = '1'


13. Error Message ID (DTAI) = "0775"


14.Else


15. Error Code (ERRC) = '0'


16. Error Message ID (DTAI) = " "


17.End If


18.   Close V1201T

Data Structure

D1700190 - F1201 Verify Serial Number/Product Model Uniqueness

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

szSerialNumber ASID char OPT NONE

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.

cErrorCode ERRC char OPT NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

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.

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.

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.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSerialNumber	ASID	char	OPT	NONE
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.
cErrorCode	ERRC	char	OPT	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
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.
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.
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.