F48163TableIO

F48163 Table Update

Minor Business Rule

Object Name: N1701190

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Functional Description

Purpose
This NER is used to perform either an Inquiry, an Add, or a Change  to the F48162 table (Knowledge Base Tree). On an Inquiry it returns all fields,
and on an Add it enters all fields. The Change action updates the Knowledge Base ID field, only.  The Data Structure contains all fields from the
table.

Setup Notes and Prerequisites
Two parameters are required:

• ACTN - Action Code (A to Add, C to Change, I to Inquire)
• UKID - Child Key ID
•

Technical Specification

/
/    Variables
/
/
/    Edit Action Code
/
If BF cActionCode = A,C,I
    BF cSuccessful = 1
Else
    BF cSuccessful = 0
End
/
If BF cSuccessful  =  1
    If BF cActionCode  =  A
        F48163.Insert
           If SV File_IO_Status  =  Error
               BF cSuccessful  =  0
           EndIF
     EndIf

/
If BF cActionCode = C
F48163.Update

      If SV File_IO_Status  =  Error
           BF cSuccessful  =  0
   EndIF
  EndIf
/
If BF cActionCode  =  I

       F48163.Fetch Single
         If SV File_IO_Status  =  Error
            BF cSuccessful  =  0
         EndIF
      EndIf
EndIF

Data Structure

D1701190 - F48163 Table Update

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

mnChildKeyID_UKID UKID MATH_NUMERIC OPT BOTH

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

mnParentKeyID_PUKID PUKID MATH_NUMERIC OPT BOTH

A unique number that the system uses to identify a record in a file.

mnKBCodeID_UK01 UK01 MATH_NUMERIC OPT BOTH

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

szKBaseTreeName_KBTNM KBTNM char OPT BOTH

The name of the Failure Analysis Tree. A Failure Analysis Tree is a hierarchical organization of codes selected from the Failure Analysis
Codes table (F48161).

mnKnowledgeBaseID_UK02 UK02 MATH_NUMERIC OPT BOTH

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

szCreatedByUser_USER CRTU char OPT BOTH

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

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.

jdDateUpdated_UPMJ UPMJ JDEDATE OPT BOTH

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

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_EV01	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).
mnChildKeyID_UKID	UKID	MATH_NUMERIC	OPT	BOTH
This field is a unique number used to identify a record in a file.
mnParentKeyID_PUKID	PUKID	MATH_NUMERIC	OPT	BOTH
A unique number that the system uses to identify a record in a file.
mnKBCodeID_UK01	UK01	MATH_NUMERIC	OPT	BOTH
This field is a unique number used to identify a record in a file.
szKBaseTreeName_KBTNM	KBTNM	char	OPT	BOTH
The name of the Failure Analysis Tree. A Failure Analysis Tree is a hierarchical organization of codes selected from the Failure Analysis Codes table (F48161).
mnKnowledgeBaseID_UK02	UK02	MATH_NUMERIC	OPT	BOTH
This field is a unique number used to identify a record in a file.
szCreatedByUser_USER	CRTU	char	OPT	BOTH
The address book number of the user who created this record.
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.
jdDateUpdated_UPMJ	UPMJ	JDEDATE	OPT	BOTH
The date that specifies the last update to the file record.
mnTimeLastUpdated_UPMT	UPMT	MATH_NUMERIC	OPT	BOTH
The time that specifies when the program executed the last update to this record.