Functional Description
Purpose
This function is used to validate and insert records in the Text Processor Detail Table (F007111).
Setup Notes and Prerequisites
In order for the insert to succeed, a Text Processor Header (F007101) record with the same key
attempting to use here must already exist.
Special Logic
For every record in F007101, there might be one or more records in the F007111 table. The F007101
primary key (batch number, transaction number) should be used to link these records. Use the same batch
number and transaction number from F007101 when writing related F007111 records. Also make sure you are
incrementing the line number for every additional F007111 record entered.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
GPBTmnBatchNumberIYSame as the batch number from the related F007101
primary key. Obtained from the Insert Text File Processor Header business function call.
GPTNszTransactionNumberIYSame as the transaction number from the related
F007101 primary key. Obtained from the Insert Text File Processor Header business function call.
LNIDmnLineNumberIYIncrement before calling this business function.
GPTXszTextIYText string of 1500 characers.
GPSPcProcessedFlagINUse blank.
URC1szUserReserveCodeINIt could have the User Define Code for the end of
line. Use the code from
UDC 00/TP
URRFszUserReservedReferenceIN
URDTjdUserReservedDateIN
URABmnUserReservedNumberIN
PIDszProgramIdIYProgram ID last updating record.
EV01cErrorStatusOYIf insert failed returns 1, else 0.
Related Tables
F007101Text Processor Header
F007111Text Processor Detail Table
Related Functions
B9800100Get Audit Information
Processing
Initialize Error Status = 0.
Verify that an F007101 record with the same key exists.
If F007101 record does not exist,
Set Error Status = 1.
Else,
Call Get Audit Information (B9800100).
Insert F007111 record.
If insert failed,
Set Error Status = 1.
Endif.
Endif.
D0000207B - Insert Text File Processor Detail
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnBatchNumber | GPBT | MATH_NUMERIC | REQ | INPUT |
A number that identifies a group of transactions that the system processes together. The system assigns this number using Next Numbers. | ||||
| szTransactionNumber | GPTN | char | REQ | INPUT |
A unique alphanumeric field that identifies a text batch. The transaction number is determined by the process that creates the text batch. | ||||
| szText | GPTX | char | REQ | INPUT |
A user defined name or remark. | ||||
| cProcessedFlag | GPSP | char | OPT | INPUT |
A flag that shows the current status of batches in the Text File Processor.
Valid values are:
Blank Unprocessed / Outbound
1
| ||||
| szUserReserveCode | URC1 | char | OPT | INPUT |
This is a 3 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. | ||||
| 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. | ||||
| 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. | ||||
| 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
| ||||
| cErrorStatus | EV01 | char | REQ | OUTPUT |
An option that specifies the type of processing for an event. | ||||
| mnLineNumberGeneral | LIN | MATH_NUMERIC | REQ | INPUT |
To move rapidly through a long list of journal entries, enter a line number. The system shifts the information on that line to the top of the
| ||||
| None |
| None |