EDILockboxControlDataUpdate

EDI Lockbox Control Data Revisions Update

Minor Business Rule

Object Name: N47CTL

Parent DLL: CFIN

Location: Client/Server

Language: NER

Data Structure

D47CTL - EDI Lockbox Control Data Revisions

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCompanyKeyEdiOrder	EKCO	char	REQ	INPUT
Company - Key (EDI - Document Key Co)
mnEdiDocumentNumber	EDOC	MATH_NUMERIC	REQ	INPUT
The document number that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order number assigned at order entry time (DOCO).
szEdiDocumentType	EDCT	char	REQ	INPUT
The document type that is assigned by the transmitter in an EDI transaction. In a non EDI environment, this would be consistent with the order type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on.
mnEdiLineNumber	EDLN	MATH_NUMERIC	REQ	INPUT
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.
szDepositNumber	DEPN	char	REQ	INPUT
Deposit Number.
mnLineNumber	LNID	MATH_NUMERIC	REQ	INPUT
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 it.
mnSequenceNumber2	SEQN	MATH_NUMERIC	REQ	INPUT
A number used to organize the table into a logical group for online viewing and reporting.
cEverestEventPoint01	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
cEDIType	EDTY	char	OPT	INPUT
The identifier used to mark EDI transaction records as header and detail information. This is an EDI function only.
mnEDISeq	EDSQ	MATH_NUMERIC	OPT	INPUT
An identifier that is used to assign the relative position within the header or detail information of an EDI transaction-- for example, H01, H02, D01, and so on.
cEdiSuccessfullyProcess	EDSP	char	OPT	INPUT
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
szEdiBatchNumber	EDBT	char	OPT	INPUT
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.
szEdiTransactionSet	EDST	char	OPT	INPUT
The qualifier used to identify a specific type of EDI transaction.
szEdiTranslationFormat	EDFT	char	OPT	INPUT
The qualifier used to identify a specific mapping structure used to process both inbound and outbound EDI transactions. This does not apply to non-EDI transactions.
jdEdiTransmissionDate	EDDT	JDEDATE	OPT	INPUT
The specific date that an EDI transaction was either transmitted or received.
cEdiSendRcvIndicator	EDER	char	OPT	INPUT
Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are: S Send R Receive B Both
mnEdiDetailLinesProcess	EDDL	MATH_NUMERIC	OPT	INPUT
The number of detail lines transmitted in an EDI transaction. This is the total number of lines on a per order basis, number of lines included on an invoice, and so on.
szTradingPartnerId	PNID	char	OPT	INPUT
Field used in an EDI transaction to identify the party that is trading document with you.
szUserReservedCode	URCD	char	OPT	INPUT
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
jdUserReservedDate	URDT	JDEDATE	OPT	INPUT
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedAmount	URAT	MATH_NUMERIC	OPT	INPUT
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedNumber	URAB	MATH_NUMERIC	OPT	INPUT
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
szUserReservedReference	URRF	char	OPT	INPUT
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future.
szUserId	USER	char	REQ	INPUT
The code that identifies a user profile.
szProgramId	PID	char	REQ	INPUT
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.
szWorkStationId	JOBN	char	REQ	INPUT
The code that identifies the work station ID that executed a particular job.
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.

Related Functions

None

Related Tables

None