F31122Z1UpdateRecords

F31122Z1 Update Records

Minor Business Rule

Object Name: N3101990

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.1Purpose
This function will update records in F31122Z1 with a "Y" or "N" in the SZEDSP
field. Only records that have the same EDUS, EDBT, EDTN, and have the line number
between EDLN and LINN will be updated.

2.4Processing
F31122Z1.Open
If SV File_IO_Status is equal to CO SUCCESS
  F31122Z1.Select
  F31122Z1.Fetch Next
  While SV File_IO_Status is equal to CO SUCCESS
    If VA evt_szTransactionType_TYTN=BF szTypeTransaction
    & VA evt_cDirectionIndicator_DRIN=BF cDirectionIndicator
    & VA evt_mnEDILineNumber_EDLN>=BF mnEdiLineNumberFrom
    & VA evt_mnEDILineNumber_EDLN<=BF mnEdiLineNumberThru
      F31122Z1.Update
    End If
    F31122Z1.Fetch Next
  End While
Else
  BF cErrorCode = "1"
End If
F31122Z1.Close

^

Data Structure

D3101990 - F31122Z1 Update Records

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEdiUserId	EDUS	char	OPT	NONE
The source of the transaction. This can be a user ID, a workstation, the address of an external system, a node on a network, and so on. This field helps identify both the transaction and its point of origin.
szEdiBatchNumber	EDBT	char	OPT	NONE
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft transactions for each control (user) batch number it finds.
szEdiTransactNumber	EDTN	char	OPT	NONE
The number that an Electronic Data Interchange (EDI) transmitter assigns to a transaction. In a non-EDI environment, you can assign any number that is meaningful to you to identify a transaction within a batch. It can be the same as a J.D. Edwards document number.
mnEdiLineNumberFrom	EDLN	MATH_NUMERIC	OPT	NONE
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any order type), an invoice pay item, a journal entry line number, and so on.
cDirectionIndicator	DRIN	char	OPT	NONE
A code that indicates whether the transaction is inbound or outbound.
cEdiSuccessfullyProcess	EDSP	char	OPT	NONE
An option that indicates whether a record has been successfully processed. Depending on the application, the system updates the EDSP field in a table with one of the following values: 1 Successfully processed Blank (or N or 0) Not processed
szTypeTransaction	TYTN	char	OPT	NONE
The qualifier used to identify a specific type of transaction.
mnLineNumberThru	LINN	MATH_NUMERIC	OPT	NONE
A number that identifies multiple occurrences (such as line numbers on a purchase order or other document). Generally, the system assigns this number,but in some cases you can override a system-assigned number.
mnDocumentOrderInvoiceE	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.
cErrorCode	ERRC	char	OPT	NONE
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).
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.
szUserID	USER	char	OPT	NONE
The code that identifies a user profile.
jdDateUpdated	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	OPT	NONE
The computer clock in hours:minutes:seconds.
szComputerID	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.

Related Functions

None

Related Tables

None