JD Edwards Back Office Interface Setup

The Back Office Interface is designed to transfer your revenue information to the JD Edwards Back Office System.

Interface Selection

Select Setup>System Configuration>External>Back Office>Interface. By right mouse clicking on the interface name OPERA displays a pop up box with all available interfaces. Select the JD Edwards Interface and select OK.

Translation Tables

Select Setup>System configuration>External>Back Office>Translate. Select Transaction Codes from the selection menu on the screen and the translation code table for the JD Edwards Interface displays on screen. The internal analysis codes (translations) for the JD Edwards Interface is set up as follows. These translations will be used in the JD Edwards BackOffice Interface export.

Code	Text	Data Type	Width
BOF_CODE1	Account No	CHAR	13

Therefore, all transaction codes whose revenue will be exported to the JD Edwards Back Office system would have appropriate translation for these analysis codes.

Transaction Codes Configuration

Select Setup>System Configuration>External>Back Office>Configuration>Transaction Codes. After setting the translation codes, the Transaction Codes entry in the configuration menu can be selected from the selection menu on the screen. An overview of all transaction codes is now displayed on the screen. By double clicking the transaction code, Account Numbers which are appropriate for that particular transaction code can be entered.

Revenue Records Configuration

Select Setup>System Configuration>External>Back Office>Define Records>Revenue Records. As part of SID data the revenue record configuration is already set up for the user. The record definitions on the screen define the different records in the export. A double click on one of the entries will display a pop up box with the record details.

Following is the export setup for the JD Edwards Back Office Interface.

Revenue Detail Record

Main Seq. No	File Type	Record Description	Export File Location	Export File Name	Always Append to File?	Table Definition	Group By	General Condition
1	DTL	Jd Edward Export	c:\temp	'jdedward.txt'	N	BOF_REVENUE_RECORDS

Revenue Detail Record Column Definition

Order	Seq.	Column Name	Column Length	Data Type	Format	Align L/R
1	1	BOF_CODE1	13	CHAR		L
2	1	TRX_DATE	8	DATE	MMDDYY	L
3	1	TRX_DATE	5	DATE	MM	L
4	1	TRX_DATE	5	DATE	YY	L
5	1	DAILY REPORT SUMMARY	25	STATIC		L
6	1	TRX_DESC	30	CHAR		L
7	1	GROSS_AMOUNT	18	NUMBER	9999999999999D00	L