CheckForProductCalls

Check for Call, Products

Minor Business Rule

Object Name: B1700630

Parent DLL: CCRIN

Location: Client/Server

Language: C

1.Functional Description
Check if the calls exist in F1755 Customer Call Master table based on the product information.

1.1Purpose
Check if the calls exist in F1755 Customer Call Master table based on the Equipment Number, Product Model or Item Number.

1.2Setup Notes and Prerequisites

1.3Special Logic
Mode = 1 - Equipment number
Select only those records where
Equipment Number is equal to the Equip No passed in
Status is greater or equal to From Status passed in
Status is less than To Status passed in
Beginning Date is greater or eqaul to From Date
Call Number is not equal to current call number

Mode = 2 - Product Model
Select only those records where
Product Model is equal to the Prod Model
Status is greater or equal to From Status passed in
Status is less than To Status passed in
Beginning Date is greater or equal to From Date
Call Number is not equal to current call number

Select Criteria for F1755
Mode = 3 - Item Number
Select only those records where
Inventory Item Number is eqaul to Item No passed in
Status is greater or equal to From Status passed in
Status is less than To Status passed in
Beginning Date is greater or equal to From Date
Call Number is not equal to current call number

Data Structure

D1700630 - Check for Case, Products

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

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

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.

mnIdentifierShortItem ITM MATH_NUMERIC OPT 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

cMode EV01 char REQ INPUT

An option that specifies the type of processing for an event.

szFromStatus CLST char REQ INPUT

A code that specifies the status of a case.

szToStatus CLSTA char REQ INPUT

Active customer issue status.  Used as default status when user activates customer issue.

jdFromDate EFTB JDEDATE REQ INPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

mnCallNumber DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

Related Functions

None

Related Tables

F1755 Case Master

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAssetItemNumber	NUMB	MATH_NUMERIC	OPT	NONE
An 8-digit number that uniquely identifies an asset.
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.
mnIdentifierShortItem	ITM	MATH_NUMERIC	OPT	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
cMode	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
szFromStatus	CLST	char	REQ	INPUT
A code that specifies the status of a case.
szToStatus	CLSTA	char	REQ	INPUT
Active customer issue status. Used as default status when user activates customer issue.
jdFromDate	EFTB	JDEDATE	REQ	INPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
mnCallNumber	DOCO	MATH_NUMERIC	OPT	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.