previous

MICROS-Fidelio Back Office Interface Setup

The Back Office Interface is designed to transfer your revenue information to the MICROS-Fidelio 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 MICROS-Fidelio Interface and click OK.

Translation

Select Setup>System Configuration>External>Back Office>Translate. Select Interface from the selection menu on the screen, and the translation code table for the MICROS-Fidelio Interface displays on screen.

Code

Text

Data Type

Width

BOF_CODE10

Interface user name

CHAR

20

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 MICROS-Fidelio Interface displays on screen.

Code

Text

Data Type

Width

BOF_CODE6

Account Number

NUMBER

10

Therefore, all transaction codes whose revenue will be exported to the MICROS-Fidelio Back Office system have appropriate translation for these analysis codes.

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 MICROS-Fidelio Back Office Interface.

Guest Ledger Detail Record 1

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

Detail Record 1 for Guest Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

N

BOF_REVENUE_RECORDS

 

 

Guest Ledger Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

NVL(BOF_CODE6,0)

10

NUMBER

0000000000

R

2

1

;

1

STATIC

 

R

3

1

ROUND(NVL(GUEST_LED_CREDIT,0),2)

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

ROUND(NVL(GUEST_LED_DEBIT,0),2)

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

TRX_CODE||' - '||TRX_DESC

30

CHAR

 

R

8

1

;

1

STATIC

 

R

9

1

NVL(GUEST_LED_CONTROL,0)

10

NUMBER

0000000000

R

Guest Ledger Detail Record 2

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 2 for Guest Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

TRX_DATE

nvl(GUEST_LED_CONTROL,0)<>0

Guest Ledger Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

ACCOUNT

10

STATIC

 

R

2

1

;

1

STATIC

 

R

3

1

SUM(ROUND(NVL(GUEST_LED_CREDIT,0),2))

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

SUM(ROUND(NVL(GUEST_LED_DEBIT,0),2))

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

GUEST LEDGER TOTAL

30

STATIC

 

R

8

1

;

1

STATIC

 

R

Package Ledger Detail Record 1

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 Package Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

 

nvl(PACKAGE_LED_CONTROL,0)<>0

Package Ledger Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

NVL(BOF_CODE6,0)

10

NUMBER

0000000000

R

2

1

;

1

STATIC

 

R

3

1

ROUND(NVL(PACKAGE_LED_CREDIT,0),2)

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

ROUND(NVL(PACKAGE_LED_DEBIT,0),2)

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

TRX_CODE||' - '||TRX_DESC

30

CHAR

 

R

8

1

;

1

STATIC

 

R

9

1

NVL(PACKAGE_LED_CONTROL,0)

10

NUMBER

0000000000

R

Package Ledger Detail Record 2

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 2 for Package Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

TRX_DATE

nvl(PACKAGE_LED_CONTROL,0)<>0

Package Ledger Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

ACCOUNT

10

STATIC

 

R

2

1

;

1

STATIC

 

R

3

1

SUM(ROUND(NVL(GUEST_LED_CREDIT,0),2))

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

SUM(ROUND(NVL(GUEST_LED_DEBIT,0),2))

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

GUEST LEDGER TOTAL

30

STATIC

 

R

8

1

;

1

STATIC

 

R

AR Ledger Detail Record 1

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 AR Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

 

nvl(AR_LED_CONTROL,0) <> 0

AR Ledger Detail Record 1Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

NVL(BOF_CODE6,0)

10

NUMBER

0000000000

R

2

1

;

1

STATIC

 

R

3

1

ROUND(NVL(AR_LED_CREDIT,0),2)

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

ROUND(NVL(AR_LED_DEBIT,0),2)

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

TRX_CODE||' - '||TRX_DESC

30

CHAR

 

R

8

1

;

1

STATIC

 

R

9

1

NVL(AR_LED_CONTROL,0)

10

NUMBER

0000000000

R

AR Ledger Detail Record 2

Main
Seq. No

File
Type

Record
Description

Export
File
Location

Export
File
Name

Always
Append
to File?

Table Definition

Group
By

General Condition

6

DTL

Detail Record 2 for AR Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

TRX_DATE

nvl(AR_LED_CONTROL,0)<>0

AR Ledger Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

ACCOUNT

10

STATIC

 

R

2

1

;

1

STATIC

 

R

3

1

SUM(ROUND(NVL(AR_LED_CREDIT,0),2))

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

SUM(ROUND(NVL(AR_LED_DEBIT,0),2))

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

AR LEDGER TOTAL

30

STATIC

 

R

8

1

;

1

STATIC

 

R

Deposit Ledger Detail Record 1

Main
Seq. No

File
Type

Record
Description

Export
File
Location

Export
File
Name

Always
Append
to File?

Table Definition

Group
By

General Condition

7

DTL

Detail Record for Deposit Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

 

(nvl(DEP_LED_CONTROL,0) <> 0)

Deposit Ledger Detail Record 1 Column Definition

1

1

NVL(BOF_CODE6,0)

10

NUMBER

0000000000

R

2

1

;

1

STATIC

 

R

3

1

ROUND(NVL(GUEST_LED_CREDIT,0),2)

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

ROUND(NVL(GUEST_LED_DEBIT,0),2)

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

TRX_CODE||' - '||TRX_DESC

30

CHAR

 

R

8

1

;

1

STATIC

 

R

9

1

NVL(GUEST_LED_CONTROL,0)

10

NUMBER

0000000000

R

Deposit Ledger Detail Record 2

Main
Seq. No

File
Type

Record
Description

Export
File
Location

Export
File
Name

Always
Append
to File?

Table Definition

Group
By

General Condition

8

DTL

Detail Record 2 for Deposit Ledger

c:\temp

'MF'||to_char(rev_trns_date,'MMDD')||'.TXT'

Y

BOF_REVENUE_RECORDS

TRX_DATE

nvl(DEP_LED_CONTROL,0)<>0

Deposit Ledger Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Format

Align
L/R

1

1

ACCOUNT

10

STATIC

 

R

2

1

;

1

STATIC

 

R

3

1

SUM(ROUND(NVL(DEP_LED_CREDIT,0),2))

19

NUMBER

000000000000000.00

R

4

1

;

1

STATIC

 

R

5

1

SUM(ROUND(NVL(DEP_LED_DEBIT,0),2))

19

NUMBER

000000000000000.00

R

6

1

;

1

STATIC

 

R

7

1

DEPOSIT LEDGER TOTAL

30

STATIC

 

R

8

1

;

1

STATIC

 

R