F4816TableIO

F48165 Table IO

Minor Business Rule

Object Name: N1701210

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This NER is used to perform either an Inquiry or an Add to the F48165 table (Call / Order Knowledge Base). On an Inquiry it returns all fields, and
on an Add it enters all fields. The Data Structure contains all fields from the table.

Setup Notes and Prerequisites

Six parameters are required:

• ACTN - Action Code (A to Add, I to Inquire)
• DOCO - Document Number
• DCTO - Document Type
• RCK5 - Sequence Number
• KNLT - Knowledge Type
• UKID - Knowledge Base ID

Data Structure

D1701210 - F48165 Table IO

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

cActionCode_ACTN ACTN char REQ INPUT

A code that specifies the action that is performed. Valid values are: A Add C Change

cSuccessful_ERRC ERRC char OPT OUTPUT

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

mnDocumentNumber_DOCO DOCO MATH_NUMERIC REQ BOTH

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.

szOrderType_DCTO DCTO char REQ BOTH

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

mnSequenceNumber_RCK5 RCK5 MATH_NUMERIC REQ BOTH

This field is used to create a unique key within a file.  If you are using a program which will allow you to resequence the records, we
recommend you use one of the following data dictionary items:  DSS5, DSS7, DSS9.

cKnowledgeType_KNLT KNLT char REQ BOTH

A code that associates a type of action with the Failure Analysis record. Valid values are: Failure Analysis Resolution All

mnKnowledgeBaseID_UKID UKID MATH_NUMERIC REQ BOTH

This field is a unique number used to identify a record in a file.

szCreatedByUser_CRTU CRTU char OPT BOTH

The address book number of the user who created this record.

jdCreationDate_CADT CADT JDEDATE OPT BOTH

The date that the record was created.

szWorkStationId_JOBN JOBN char OPT BOTH

The code that identifies the work station ID that executed a particular job.

szProgramID_PID PID char OPT BOTH

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.

mnTimeLastUpdated_UPMT UPMT MATH_NUMERIC OPT BOTH

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

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode_ACTN	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
cSuccessful_ERRC	ERRC	char	OPT	OUTPUT
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).
mnDocumentNumber_DOCO	DOCO	MATH_NUMERIC	REQ	BOTH
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.
szOrderType_DCTO	DCTO	char	REQ	BOTH
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
mnSequenceNumber_RCK5	RCK5	MATH_NUMERIC	REQ	BOTH
This field is used to create a unique key within a file. If you are using a program which will allow you to resequence the records, we recommend you use one of the following data dictionary items: DSS5, DSS7, DSS9.
cKnowledgeType_KNLT	KNLT	char	REQ	BOTH
A code that associates a type of action with the Failure Analysis record. Valid values are: Failure Analysis Resolution All
mnKnowledgeBaseID_UKID	UKID	MATH_NUMERIC	REQ	BOTH
This field is a unique number used to identify a record in a file.
szCreatedByUser_CRTU	CRTU	char	OPT	BOTH
The address book number of the user who created this record.
jdCreationDate_CADT	CADT	JDEDATE	OPT	BOTH
The date that the record was created.
szWorkStationId_JOBN	JOBN	char	OPT	BOTH
The code that identifies the work station ID that executed a particular job.
szProgramID_PID	PID	char	OPT	BOTH
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.
mnTimeLastUpdated_UPMT	UPMT	MATH_NUMERIC	OPT	BOTH
The time that specifies when the program executed the last update to this record.