previous

Bass Back Office Interface Setup

The Back Office Interface is designed to transfer revenue information to the BASS Accounting System.

Interface Selection

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

Code

Text

Data Type

Width

BOF_CODE1

Amount Type

CHAR

10

Therefore, all transaction codes whose revenue will be exported to the BASS 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 that 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 BASS Back Office Interface.

Revenue Header 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

HDR

Header Record for Bass Interface

C:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

N

BOF_EXPORT_HEADER

 

 

Revenue Header Record Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

RV:

3

STATIC

R

2

1

HOTEL_CODE

5

CHAR

R

3

1

0

1

STATIC

R

4

1

1

1

STATIC

R

5

1

REV_TRNS_DATE

6

DATE

R

6

1

chr(09)||chr(43)||chr(13)||chr(10)||chr(10)

5

CHAR

R

Amount Type 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

Detail Record for Amount type

c:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

Y

BOF_STATISTIC_EXPORT

BOF_CODE1

BOF_CODE1 is not null

Amount Type Detail Record Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

01:

3

STATIC

R

2

1

1

1

STATIC

L

3

1

BOF_CODE1

10

CHAR

R

4

1

DECODE(SIGN(SUM(NET_AMOUNT)),- 1,'1','0')

1

CHAR

R

5

1

ABS(SUM(NET_AMOUNT))*100

10

NUMBER

R

6

1

CHR(09)||CHR(43)||CHR(13)||CHR(10)||CHR(10)

5

CHAR

R

Rooms Available 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

3

DTL

Detail Record for Rooms Available

c:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

Y

BOF_STATISTIC_EXPORT

 

nvl(room_avail,0)<>0

Rooms Available Detail Record Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

01:

3

STATIC

R

2

1

1

1

STATIC

L

3

1

0000000004

10

STATIC

R

4

1

DECODE(SIGN(SUM(ROOM_AVAIL)),- 1,1,0)

1

NUMBER

R

5

1

0000000000

10

STATIC

R

6

1

CHR(09)||CHR(43)||CHR(13)||CHR(10)||CHR(10)

5

CHAR

R

Rooms Occupied Single 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

4

DTL

Detail Record for Rooms Occupied Single

c:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

Y

BOF_STATISTIC_EXPORT

 

nvl(single_occ_room,0) is not null

Rooms Occupied Single Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

01:

3

STATIC

R

2

1

1

1

STATIC

L

3

1

0000000005

10

STATIC

R

4

1

DECODE(SIGN(SUM(SINGLE_OCC_ROOM)),- 1,'1','0')

1

CHAR

R

5

1

ABS(SUM(SINGLE_OCC_ROOM))

10

NUMBER

R

6

1

CHR(09)||CHR(43)||CHR(13)||CHR(10)||CHR(10)

5

CHAR

R

Multi Occupied Rooms 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

5

DTL

Detail Record for Multi Occupied Rooms

c:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

Y

BOF_STATISTIC_EXPORT

 

nvl(multi_occ_room,0)<>0

Multi Occupied Rooms Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

01:

3

STATIC

R

2

1

1

1

STATIC

L

3

1

0000000006

10

STATIC

R

4

1

DECODE(SIGN(SUM(MULTI_OCC_ROOM)),- 1,'1','0')

1

CHAR

R

5

1

ABS(SUM(MULTI_OCC_ROOM))

10

NUMBER

R

6

1

CHR(09)||CHR(43)||CHR(13)||CHR(10)||CHR(10)

5

CHAR

R

Footer Record

Main
Seq. No

File
Type

Record
Description

Export
File
Location

Export
File
Name

Always
Append
to File?

Table Definition

Group
By

General
Condition

6

TTL

Footer Record for Bass Interface

c:\temp

'REV'||to_char(rev_trns_date,'RRDDD')||'.REV'

Y

BOF_STATISTIC_EXPORT

 

 

Footer Record Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

91:

3

STATIC

 

R

2

1

DECODE(SIGN(SUM(NVL(DECODE(BOF_CODE1,NULL,0,NET_AMOUNT),0))),-1,'1','0')

1

CHAR

 

L

3

1

ABS(SUM(NVL(DECODE(BOF_CODE1,NULL,0,NET_AMOUNT),0)))*100

10

NUMBER

0000000000

R

6

1

CHR(09)||CHR(43)||CHR(13)||CHR(10)||CHR(10)

5

CHAR

 

R