UpdateCallWorkflowMessage

Update Maintenance Request Workflow Message

Minor Business Rule

Object Name: N1701120

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this is to update the F01131 and F01133 with appropriate information pertinent to the
call. The key to these tables is the SERK. This will update the F98865 with escalation date/time
based on SERK - Message ID. This will update the SERK for further reference to the F1755. This will have
different processing for reopened calls.

Data Structure

D1701120 - Update Case Workflow Message

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

mnCallNumber DOCO MATH_NUMERIC REQ INPUT

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.

cCallRecordType STAW char REQ INPUT

A user-defined code (00/WS) that indicates the approval status.

szContactName2 WHO2 char REQ INPUT

The name of the caller, customer, or other contact.

szPhoneNumber PH1 char REQ INPUT

A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can
use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first
segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone
number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.

jdDateUpdated UPMJ JDEDATE REQ INPUT

The date that specifies the last update to the file record.

mnTimeLastUpdated UPMT MATH_NUMERIC REQ INPUT

The time that specifies when the program executed the last update to this record.

szNameAlpha ALPH char REQ INPUT

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

jdDateBeginningEffective 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.

mnMessageReceiver AN8 MATH_NUMERIC OPT NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

szPriority PRIOR char OPT NONE

The values that indicate the severity of the customer issue.

mnAssignee AN8 MATH_NUMERIC OPT NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnResponseTime RSTM MATH_NUMERIC OPT NONE

The guaranteed time during which service will be completed, as provided by a service contract, from the time that a provider logs a
maintenance request or work order. This unit of time relates to the service type in the Service Contract Services table (F1725). Enter the response
time in hours.

jdDateCommitment CDATE JDEDATE OPT NONE

The commitment date that the system calculates for returning the maintenance request or work order.

mnCommitTime CTIME MATH_NUMERIC OPT NONE

The duration specified in minutes, that were committed to the customer. For example:  A commitment to call back in 3 hours would have a
commit time entry of 180 (minutes).

mnCallQueue CALLQ MATH_NUMERIC OPT NONE

The address number of the case provider group. To resolve customer problems, the system or a person can assign case to provider
groups. A provider group might be that of a specific service person, or it might be a group that is used to monitor and assign requests to the
provider groups of service personnel.

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

mnKeyValueSerialNumber SERK MATH_NUMERIC OPT NONE

A key identification number used internally to identify a composite key structure.  The actual key items must be stored in another file and
given this serial number.  This is to avoid repeating a very large key structure with repeating data items.

cReopenCall EV01 char OPT NONE

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

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnCallNumber	DOCO	MATH_NUMERIC	REQ	INPUT
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.
cCallRecordType	STAW	char	REQ	INPUT
A user-defined code (00/WS) that indicates the approval status.
szContactName2	WHO2	char	REQ	INPUT
The name of the caller, customer, or other contact.
szPhoneNumber	PH1	char	REQ	INPUT
A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.
jdDateUpdated	UPMJ	JDEDATE	REQ	INPUT
The date that specifies the last update to the file record.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	REQ	INPUT
The time that specifies when the program executed the last update to this record.
szNameAlpha	ALPH	char	REQ	INPUT
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
jdDateBeginningEffective	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.
mnMessageReceiver	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szPriority	PRIOR	char	OPT	NONE
The values that indicate the severity of the customer issue.
mnAssignee	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnResponseTime	RSTM	MATH_NUMERIC	OPT	NONE
The guaranteed time during which service will be completed, as provided by a service contract, from the time that a provider logs a maintenance request or work order. This unit of time relates to the service type in the Service Contract Services table (F1725). Enter the response time in hours.
jdDateCommitment	CDATE	JDEDATE	OPT	NONE
The commitment date that the system calculates for returning the maintenance request or work order.
mnCommitTime	CTIME	MATH_NUMERIC	OPT	NONE
The duration specified in minutes, that were committed to the customer. For example: A commitment to call back in 3 hours would have a commit time entry of 180 (minutes).
mnCallQueue	CALLQ	MATH_NUMERIC	OPT	NONE
The address number of the case provider group. To resolve customer problems, the system or a person can assign case to provider groups. A provider group might be that of a specific service person, or it might be a group that is used to monitor and assign requests to the provider groups of service personnel.
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnKeyValueSerialNumber	SERK	MATH_NUMERIC	OPT	NONE
A key identification number used internally to identify a composite key structure. The actual key items must be stored in another file and given this serial number. This is to avoid repeating a very large key structure with repeating data items.
cReopenCall	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szOrderType	DCTO	char	OPT	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szCompanyKeyOrderNo	KCOO	char	OPT	NONE
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to assign a next number. In this case, you probably would not use the order company to locate the document.