This chapter contains the following topics:
External systems can use a variety of methods to send data to the interoperability interface tables. One method is to write the data to a flat file. If you use this method, the system converts the flat file to the interface table. For the system to convert data from the flat file to the interface table, you must identify the transaction using this information:
Transaction type, which is a unique description that identifies the transaction.
A direction indicator (inbound or outbound).
Record types, which indicate the sort of information that is exchanged between JD Edwards EnterpriseOne and external systems.
Tables, which are the sources or destinations of the transaction.
You can set a processing option to start the transaction process automatically when the conversion completes successfully. The transaction process copies the data from the interface tables to the application tables. JD Edwards EnterpriseOne applications can access the data from these tables.
When you set up flat file cross-reference information, you must specify the record types. Record types indicate the sort of information that is exchanged between the JD Edwards EnterpriseOne system and external systems, such as addresses, header or detail transactions, text, or additional information.
You can review hard-coded record types in user-defined code (UDC) 00/RD. The system uses these codes to identify the forms from which the system stores information for outbound documents and to which the system stores information for inbound documents.
To identify the transactions that the system uses in the flat file cross-reference, you can add codes or transaction types to UDC 00/TT. You use the transaction types to identify whether the information exchange is inbound or outbound, and to identify the corresponding applications and versions. You must set up transaction types before you define data export controls and flat file cross-reference information.
You define the export information for outbound transactions only. To set up data export controls properly, you must indicate the transaction, document type, batch application or function, and version from which the external system retrieves information from the interface tables.
You can define export controls based on either of these two options:
Based On | Description |
---|---|
Function Name and Library | Specify a vendor-specific function name and library to identify the external custom program that accesses the JD Edwards EnterpriseOne interface tables. |
UBE (universal batch engine) or batch processor | Specify a vendor-specific outbound batch processor that accesses the JD Edwards EnterpriseOne interface tables. |
Before you can convert a flat file, you must provide a cross-reference from the flat file fields to the interface table fields. When you exchange data between this system and an external system, you use flat file cross-reference information for these conditions:
Inbound transactions for which the external system cannot write data to the interface tables in the required format for this system.
In this case, the external system can write the data to a specific flat file for each transaction and record type.
Outbound transactions for which this system cannot write data to the interface tables in the format that is required by the external system.
In this case, this system can write the data to a specific flat file for each transaction and record type.
The process for setting up flat file cross-references for interoperability is identical to that for EDI (electronic data interchange) interface tables.
This section lists prerequisites and discusses how to:
Set up data export controls.
Set up the flat file cross-reference.
Before you complete the tasks in this section:
Ensure that the flat file is a comma-delimited ASCII text (flat) file to which the workstation has read and write access.
Ensure that the data conforms to the required format.
On the appropriate drives on the computer or network, set up the folders for the flat files.
Access the Data Export Control Revisions form.
Figure 2-1 Data Export Control Revisions form
Specify a code to identify a specific type of transaction. Values are stored in UDC 00/TT.
Enter a code to identify the type of document that you are exporting.
Specify a vendor-specific outbound batch processor that accesses the JD Edwards EnterpriseOne interface tables.
Specify the version of the outbound batch processor.
Specify a vendor-specific function name to identify the external custom program that accesses the JD Edwards EnterpriseOne interface tables.
Specify the library for the function.
Enter 1 to process an added transaction record or enter 0 if the transaction should not be processed as an added transaction record.
Enter 1 to process an updated transaction record or enter 0 if the transaction should not be processed as an update.
Enter 1 to process a deleted transaction record or enter 0 if the transaction should not be processed as a deleted transaction record.
Enter 1 to process an inquiry of a transaction record or enter 0 if the transaction should not be processed as an inquiry.
Enter 1 to export the transaction record to a flat file or enter 0 if you do not want to export the transaction record to a flat file.
Enter 1 to export the transaction record to an external database or enter 0 if you do not want to export the transaction record to an external database.
Enter 1 to export the transaction record to an external API or enter 0 if you do not want to export the transaction record to an external API.
Enter 1 if you want to execute the batch job immediately.
Note: You should complete either the UBE Name and Version fields or the Function Name and Function Library fields. |
Access the Flat File Cross-Reference form.
Figure 2-2 Flat File Cross-Reference form
Specify a code to identify a specific type of transaction. Values are stored in UDC 00/TT.
Enter 1 for an inbound transaction or 2 for an outbound transaction.
Enter the name of the flat file, including the directory path where the flat file exists.
Specify an identifier used to mark EDI transaction records as header and detail information. This is an EDI function only. Values are stored in UDC 00/RD.
Enter the number of a specific table to identify the source or destination of the information. For example, the Account Master table name is F0901.