Table 115. Body Detail Data Elements for the Bill Summary Output File
|
|
|
|
|
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 ID of the consolidator, available in the Consolidator User Enrollment table. |
Bill Processing Center Number |
9 |
Varchar |
No |
The ID of the bill processing center that processes bills for this account, available in the Consolidator User Enrollment table. |
Biller ID |
32 |
Varchar |
Yes |
A unique ID for the biller, implementation-specific, available in the Consolidator User Enrollment table. |
Billing System ID |
32 |
Varchar |
No |
The ID of the billing system used in combination with account number to uniquely identify an account. |
Biller Account Number |
32 |
Varchar |
Yes |
The user account number. |
Alternate Biller Account Number |
32 |
Varchar |
Yes |
The internal biller account number, available in the Consolidator User Enrollment table. |
Biller Transaction ID |
32 |
Varchar |
No |
The biller transaction ID, sent in the enrollment input file. |
Biller User ID |
32 |
Varchar |
No |
The biller user ID, sent in the enrollment input file. |
Biller E-Bill ID |
36 |
Varchar |
Yes |
The unique ID for the bill, assigned by the biller. It is usually the invoice number on the bill. Otherwise, it is populated with amount due and bill due date. |
User First Name |
32 |
Varchar |
No |
The user's first name. |
User Last Name |
32 |
Varchar |
No |
The user's last name. |
Payment Received |
20 |
Numeric |
Yes |
The net payment received and credited to the account since the last period. |
Amount Due |
20 |
Numeric |
Yes |
The amount that must be displayed to the subscriber for payment. It can be the minimum amount due, this period's payment due, or the total account balance. |
Balance Amount |
20 |
Numeric |
No |
The account balance at the time of the closing cycle date. |
Minimum Amount Due |
20 |
Numeric |
No |
The minimum amount due. |
Previous Balance Amount |
20 |
Numeric |
No |
The previous balance amount. |
Biller Reference Text |
20 |
Varchar |
No |
Text the biller sends with the electronic bill. Invoice-like information to be sent with particular bills that must be returned to the biller for posting purposes. |
Statement Date |
20 |
Datetime |
Yes |
The timestamp when bill was created, in YYYYMMDDHHMMSSmmmmmm format. |
Next Statement Date |
20 |
Datetime |
No |
The timestamp when the bill was created, in YYYYMMDDHHMMSSmmmmmm format. |
Bill Cycle End Date |
20 |
Datetime |
No |
The timestamp when the bill period was closed. |
Payment Due Text Flag |
1 |
Char |
No |
A flag indicating to the consolidator whether the biller wants the sponsor to display Text Due Date instead of the Electronic Bill Due Date Timestamp. If the sponsor does not support Text Due Date, then it uses the Electronic Bill Due Date Timestamp. |
Bill Due Date |
20 |
Datetime |
No |
Timestamp when the bill is due. |
Text Due Date |
20 |
Datetime |
No |
When the Payment Due Text Flag value is Y, the values in this field are displayed to the user, spaces included. |
Bill Cycle Start Date |
20 |
Datetime |
No |
Timestamp when this bill was opened. |
Electronic Billing URL |
1024 |
Varchar |
No |
The URL for viewing bill details in Oracle Self-Service E-Billing. |
Bill URL Expiry Date |
20 |
Datetime |
No |
The time when the URL expires. |
Teaser Link URL |
1024 |
Varchar |
No |
The URL for the teaser ad that the subscriber can follow to receive additional information from the biller. This URL is used in conjunction with either the Teaser Ad URL or the Teaser Ad Text. The subscriber can click on either the image or text to be transferred to the biller site specified by this URL. |
Teaser Ad URL |
1024 |
Varchar |
No |
The URL where the teaser ad image is stored. This is used to display the image on the user interface. |
Teaser Ad Text |
80 |
Varchar |
No |
A text link that can be used instead of the image link. Using this text might improve performance over downloading a teaser ad image. |
E-Bill Category URL |
1024 |
Varchar |
No |
The URL associated with the ebill's category. |
E-Bill Category Text |
80 |
Varchar |
No |
The text associated with the ebill's category. |
E-Bill Magnet Type |
1 |
Char |
No |
Determines whether a customer magnet is required for this electronic bill. The values can be:
- M. Magnet has its own URL.
- Y. Magnet uses the Electronic Bill URL. (The Magnet URL must be spaces).
- N. No, a customer magnet is not required (The Magnet URL must be spaces). This is the default.
NOTE: The customer magnet feature is not supported by many sponsors. The feature is being deprecated.
|
E-Bill Magnet URL |
1024 |
Varchar |
No |
The URL (teaser ad or promotional offer) to where a subscriber is taken before making a payment. |
E-Bill Category |
2 |
Varchar |
No |
The e-bill category. Values can be spaces for a normal e-bill (the default), or 02 for an e-bill supplied by a biller to replace a previous ebill. |
Status Code |
5 |
Varchar |
No |
The status code. |
Status Message |
80 |
Varchar |
No |
The status message. |
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 |
String |
No |
For future use. |
Custom Field 9 |
20 |
String |
No |
For future use. |
End of Record |
2 |
None |
No |
For some consolidators, this field must contain the hexadecimal value 0D0A. |
