Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Billing Insight > Customizing the Payment Consolidator Integration Module > Default File Formats for Payment Consolidation >

Bill Summary Acknowledgement Input File Format

This topic describes the default format of the bill summary acknowledgement file that Oracle Billing Insight is preconfigured to use.

The data elements in the file header record for the consolidator response file are the same as those shown in Table 87.

The data elements in the batch header record for the consolidator response file are the same as those shown in Table 88.

Table 98 shows the body detail data elements in the default format of the consolidator response input file.

Table 98. Body Detail Data Elements for the Bill Summary Acknowledgement Output File
Data Element
Length
Type
Required by the API
Description

Detail Record Type

4

Num

No

A number indicating this is the detail record type.

Action Type

10

Varchar

No

The type of action, for example:

  • ADD. When the consolidator sends a record to activate bill payment service.
  • CHG. If the biller later sends a change regarding the service holder's current information, such as a change to the service address.

Consolidator ID

32

Varchar

Yes

The name of the consolidator.

Biller ID

32

Varchar

Yes

The unique ID for the biller, implementation-specific.

Account Number

32

Varchar

No

The user account number.

Alternate Biller Account Number

32

Varchar

No

The biller internal account number.

Bill Processing Center ID

9

Varchar

No

The ID for the bill processing center that processes bills for this account.

Biller E-Bill ID

36

Varchar

Yes

The unique ID for the bill, assigned by biller.

Status Code

5

Varchar

No

This field is defined by the consolidator and sent in the output file.

Status Message

80

Varchar

No

This field is defined by the consolidator and sent in the output file.

Custom Field 1

255

Varchar

No

For future use.

Custom Field 2

255

Varchar

No

For future use.

Custom Field 3

255

Varchar

No

For future use.

Custom Field 4

255

Varchar

No

For future use.

Custom Field 5

1024

Varchar

No

For future use.

Custom Field 6

1

Char

No

For future use.

Custom Field 7

1

Char

No

For future use.

Custom Field 8

20

Datetime

No

For future use.

Custom Field 9

20

Datetime

No

For future use.

End of Record

2

None

No

For some consolidators, this field must contain the hexadecimal value 0D0A.

    
Implementation Guide for Oracle Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.