Concorde Back Office Interface Setup

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

Interface Selection

Select Setup>System Configuration>External>Back Office>Interface. Right mouse button click on the interface name to display the Change Interface button. Selecting it displays a pop-up box with all available interfaces. Select the Concorde Interface and click 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 Concorde Interface displays on screen.

Code	Text	Data Type	Width
BOF_CODE1	Account Number	CHAR	8

The configuration Account Number field can be used to setup Account Numbers related to each OPERA transaction code. Therefore, all transaction codes whose revenue will be exported to the Concorde Back Office system 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.

City Ledger Records Configuration

Select Setup>System configuration>External>Back Office>Define Records>City Ledger Records. As part of SID data the city ledger 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 Concorde Back Office Interface.

City Ledger 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	City Ledger Record	c:\temp	'J'||to_char(City_trns_date,'rrmmdd')||'.REV'	N	BOF_CITYLED_RECORDS

City Ledger Detail Column Definition

Order	Seq.	Column Name	Length	Data Type	Format	Align L/R
1	1	DEPARTURE	8	DATE	RRRRMMDD	L
2	1	ROOM	8	CHAR		L
3	1	TRAVEL_AGENT_VOUCHER	10	CHAR		L
4	1	TRX_CODE	24	CHAR		L
5	1	ACCOUNT_NAME	30	CHAR		R
6	1	FULL_NAME	30	CHAR		R
7	1	ADDRESS1	30	CHAR		R
8	1	ADDRESS2	30	CHAR		R
9	1	CITY	30	CHAR		R
10	1	ZIP	10	CHAR		R
11	1	COUNTRY	3	CHAR		R
12	1	TRX_AMOUNT	10	NUMBER	9999999D00	L

City Ledger Credit Card 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
2	DTL	City Ledger Credit Card Records	c:\temp	'J'||to_char(city_trns_date,'rrmmdd')||'.REV'	Y	BOF_REVENUE_RECORDS		tc_subgroup = 'PAY100'

City Ledger Credit Card Detail Column Definition

Order	Seq.	Column Name	Length	Data Type	Align L/R
1	1	TRX_DATE	8	DATE	R
2	1	TRX_CODE	104	CHAR	L
3	1	GROSS_AMOUNT	174	NUMBER	L
4	1	DECODE(SIGN(GROSS_AMOUNT),- 1,SUBSTR(SIGN(GROSS_AMOUNT),1,1),' ')	2	CHAR	L