Interoperability Quick Reference Guide

Purpose of Document

You can use the interoperability interface tables to interface with EnterpriseOne applications. These interoperability interface documents contain information such as the fields you are required to use for specific transactions into and out of EnterpriseOne.

Distribution
Financial
HR Payroll
Inventory/Logistics
Manufacturing

For *.chm file format refer attachment (Interoperability Interface Tables)

Overview

Interoperability information can be accessed,

• Either through P47002 - Flat File Cross-Reference
• Or through P90701/P90701A - Interoperability Event Definition

There are 2 different categories which can be defined for column DRIN (Direction Indicator),

• Inbound only: Verify report
• Outbound only: Verify Interop tab in the application you are working on

In implementing interface, possible methods can be,

• RTE
• XAPI
• Business Services
• Z File Interface
• EDI (Electronic Document Interface). Available list can be found at <Document 659847.1> - E1: 47: EDI Quick Reference Guide.

so choose most suitable interface in your environment

Distribution

Financial

HR and Payroll

Inventory / Logistics

Manufacturing

Control Columns

Control columns are transient columns that exist for the purpose of identifying or controlling the transaction during the interface processing. They generally do not represent any of the actual business data or transaction that you are getting from EnterpriseOne, and generally they do not correspond to columns in the permanent source table.

Additional Information

• For a given sales order, the values in the first three columns (EDUS, EDBT and EDTN) will match the values in the first three columns of the corresponding records in the detail table and the tag table. That is header and detail relationship is conformed by these columns.
• JDEERR is moved from Manufacturing to Distribution.
• In general line number in transaction file repeats EDLN not LNID
• TNAC (Transaction Action Code) can be implement different in interoperability. As <Document 1265902.1> - E1: BSFN: Master Business Function in EnterpriseOne reads there are MBF for Master File and MBF for Transaction File. For both cases action code is determined as defined in UDC 00/TA - Transaction Action by getting the first character of 'Description 02' column. Most commonly,
• I - Inquiry
• A - Add
• C - Change, R - Replace (Add and then delete), U - Update
• D - Delete

Interactive Applications Triggering Interop Outbound

In case you have records for JDEREC then you can look for the processing option of P03B0190.

Additional Knowledge Documents

<Document 625454.1> - E1: 43: Inbound Purchase Order Interoperability
<Document 658970.1> - E1: 17: Installed Base Record Interoperability in Releases 8.9 and Above
<Document 1086062.1> E1: 03B: How To - Outbound Interoperability for Accounts Receivable
<Document 663048.1> - E1: 04: How To Setup Store and Forward Voucher Processing
<Document 664757.1> - E1: 09: How To F0911Z1 processing
<Document 625452.1> - E1: 41: Inbound Cycle Count Interoperability

<Document 1340092.1> E1: 41: Inbound Inventory Item Cost Interoperability (R4105Z1 / R41052 / F4105Z1)
<Document 625451.1> - E1: 41: How to Create Item Master and Item B/P Records Using Interoperability
<Document 659204.1> - E1: 46: Functionality of F4611Z1
<Document 625453.1> - E1: 30: Inbound Bill of Material Interoperability
<Document 627800.1> - E1: 36: P3460 Forecasting
<Document 1056372.1> E1: 42: Outbound Sales Interoperability

<Document 1160238.1> - E1: 31: R30161Z1I Kanban Processing Interoperability
<Document 625648.1> - E1: 43: Receipt Routing Interoperability
<Document 841740.1> - E1: 30: Routing Master Table F3003Z1
<Document 660276.1> - E1: 31: R31123Z1I Super Backflush Interoperability
<Document 1169386.1> - E1: 31: R0007Z1I Shop Floor Calendar Interoperability
<Document 882032.1> - E1: 31: R31122Z1 Work Order Time Entry Interoperability
<Document 629428.1> - E1: 31: How to Import Work Orders into JDE?
<Document 1169303.1> - E1: 31: R31113Z1I Work Order Inventory Issues Interoperability
<Document 629428.1> - E1: 31: How to Import Work Orders into JDE?
<Document 626068.1> - E1: 12: Uploading Fixed Assets Records Using Interoperability (Internal Only)
<Document 1151860.1> - E1: 31: R31114Z1I Work Order Completions Interoperability

<Document 1334253.1> - E1: Interop: FAQ on R00460
<Document 1347858.1> - E1: INTEROP: List of application with Interop Tab
<Document 859763.1> E1: SS: F986113 Subsystem Job Master Table Contains Multiple Records for R00460, R42950 and R09801

<Document 1334242.1> - E1: 40: Interoperability JDEIL and Inventory Transaction
<Document 1342363.1> - E1:31: How to implement Work Order Extraction through R00460 in P480
<Document 1340092.1> - E1: 41: Inbound Inventory Item Cost Interoperability (R4105Z1 / R41052 / F4105Z1)

<Document 1406473.1> - E1: 04: How To Set Up EFT Payments, Interoperability Outbound Payments and Run Payment Register (P04571, R04572T1, R04572T2, P0457, P0457D, P0400297, R04576)

<Document 1473954.1> - E1: 03B: How To Use Batch Invoice Processing In EnterpriseOne Accounts Receivable (P03B11Z1, R03B11Z1A, R03B11Z1P) [Video]