previous

MAS90 Back Office Interface Setup

The MAS90 Back Office Interface is designed to send across all transactions for the Guest Ledger, Deposit Ledger, AR Ledger, and Package Ledger.

Interface Selection

Select Setup>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 MAS90 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 MAS90 Interface displays on screen.

Code

Text

Data Type

Width

BOF_CODE1

Account Number

CHAR

10

BOF_CODE2

GL Account Number

CHAR

10

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

Revenue Records Configuration

Select Setup>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 MAS90 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 for Guest Ledger

c:\temp

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

N

BOF_REVENUE_RECORDS

 

(nvl(GUEST_LED_CONTROL,0) <> 0 and BOF_CODE1 is not null)

Guest Ledger Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

NVL(BOF_CODE1,' ')

10

CHAR

R

2

1

DECODE(GUEST_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(GUEST_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

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

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

Y

BOF_REVENUE_RECORDS

 

(nvl(GUEST_LED_CONTROL,0)<>0 and BOF_CODE2 is not null)

Guest Ledger Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

nvl(BOF_CODE2,' ')

10

CHAR

R

2

1

DECODE(GUEST_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(GUEST_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Deposits 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 Deposits

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(DEP_LED_CONTROL,0) <> 0 and BOF_CODE1 is not null)

Deposits Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

NVL(BOF_CODE1,' ')

10

CHAR

R

2

1

DECODE(DEP_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(DEP_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Deposits 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 Deposits

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(DEP_LED_CONTROL,0)<>0 and BOF_CODE2 is not null)

Deposits Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

nvl(BOF_CODE2,' ')

10

CHAR

R

2

1

DECODE(DEP_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(DEP_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Accounts Receivables 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 Accounts Receivables

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(AR_LED_CONTROL,0) <> 0 and BOF_CODE1 is not null)

Accounts Receivables Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

NVL(BOF_CODE1,' ')

10

CHAR

R

2

1

DECODE(AR_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(AR_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Accounts Receivables 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 Accounts Receivables

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(AR_LED_CONTROL,0)<>0 and BOF_CODE2 is not null)

Accounts Receivables Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

nvl(BOF_CODE2,' ')

10

CHAR

R

2

1

DECODE(AR_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(AR_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Packages 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 Packages

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(PACKAGE_LED_CONTROL,0) <> 0 and BOF_CODE1 is not null)

Packages Detail Record 1 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

NVL(BOF_CODE1,' ')

10

CHAR

R

2

1

DECODE(PACKAGE_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(PACKAGE_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R

Packages 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 Packages

c:\temp

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

Y

BOF_REVENUE_RECORDS

 

(nvl(PACKAGE_LED_CONTROL,0)<>0 and BOF_CODE2 is not null)

Packages Detail Record 2 Column Definition

Order

Seq.

Column Name

Length

Data
Type

Align
L/R

1

1

nvl(BOF_CODE2,' ')

10

CHAR

R

2

1

DECODE(PACKAGE_LED_CONTROL_FLAG,'D','- ','+')

1

CHAR

R

3

1

ABS(PACKAGE_LED_CONTROL)

13

NUMBER

R

4

1

TRX_DATE

8

DATE

R

5

1

TRX_DESC

20

CHAR

R