Understanding the Text File Processor

The Text File Processor is a tool that is used to convert JD Edwards EnterpriseOne data to text files in the formats that are required by external entities, such as banks or government agencies.

To use the Text File Processor to create a text file, you must run one of the programs that has been set up to populate the Text Processor Header table (F007101) and Text Process Detail Table (F007111). These programs populate the text processor tables:

  • IDEP/IRIS Interface (R0018I3).

    (Intrastat Data Entry Package/Interactive Registration of the International Trade Statistics)

  • SEMDEC Interface - VAT EC Sales List (R0018I4).

    (Single European Market Declaration)

  • Draft Remittance File Format AEB 19 - Spain (R74S6729).

    (AsociaciĆ³n EspaƱola de Banca [Spanish Bank Association])

  • Draft Remittance File Format AEB 32 - Spain (R74S6722).

  • Draft Remittance File Format AEB 58 - Spain (R74S6728).

When you run any of these programs or any other programs that populate the text processor tables, the system creates a text batch in the text processor tables with the information that the program generates. For example, all of the information that is required for the IDEP/IRIS Intrastat declaration is stored as one text batch.

Text batches are stored in these tables:

  • Text Processor Header (F007101)

  • Text Processor Detail Table (F007111)

The F007101 table stores information about the extraction of information for an external system, such as information about the processes that populated the table and information about the creation of the text file. The F007111 table stores the text for the text file.

When you export or import text in the Text File Processor, the system uses the seventh field from Next Numbers System 00.

You use the Copy Text function in the Text File Processor to copy the information from the text batch to a flat file that can be copied to disk or other media, and then submitted to the appropriate entity. When you use the Copy Text function, you can specify the location and filename for the flat file that is created.