CheckForPreviousCustomerCalls

Check for Previous Customer Maintenance Requests

Minor Business Rule

Object Name: B1700620

Parent DLL: CCRIN

Location: Client/Server

Language: C

1.Functional Description
Check if the previous customer calls exist in F1755 Customer Call Master.

1.1Purpose
Check if the previous calls exist in F1755 Customer Call Master table using the customer number, status, beginning date and call number.

1.2Setup Notes and Prerequisites

1.3Special Logic
Select Criteria for F1755
Select only those records where
Customer Number is equal to Customer Number 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 Calculated from date using number of days.
Call Number is not equal to Call Number passed in

Data Structure

D1700620 - Check For Previous Case, Customer

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

mnCustomerAddressNumber AN8C MATH_NUMERIC OPT NONE

The address book number of the person who coordinates new hire reporting for your organization.

szFromStatus CLST char OPT NONE

A code that specifies the status of a case.

szToStatus CLSTA char OPT NONE

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

jdFromDate EFTB JDEDATE OPT NONE

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
mnCustomerAddressNumber	AN8C	MATH_NUMERIC	OPT	NONE
The address book number of the person who coordinates new hire reporting for your organization.
szFromStatus	CLST	char	OPT	NONE
A code that specifies the status of a case.
szToStatus	CLSTA	char	OPT	NONE
Active customer issue status. Used as default status when user activates customer issue.
jdFromDate	EFTB	JDEDATE	OPT	NONE
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.