Header and Trailer Fields
BIN Sponsor reports contain both header and trailer fields.
Header Fields
Each of the reports contain the same header fields.
|
No |
Field Name |
Description |
Field Definition |
|---|---|---|---|
|
1 |
Record Type |
The type of record as HEADER'. |
char(6)
|
|
2 |
Processor Name |
The name of the processor. |
varchar(20) |
|
3 |
Report Name |
The name of the report, such as Customers, CardAccount, Transactions, TxnSummary or Lookup. |
varchar(20)
|
|
4 |
File Date |
The date in which the file containing the report was received from the processor. This is in the YYYYMMDD format. |
varchar(8) |
|
5 |
Run Date Begin |
Date in which the run date begins. This is in the format of YYYYMMDD. |
varchar(8) |
|
6 |
Run Date End |
Date in which the run date ends. This is in the format of YYYYMMDD. |
varchar(8) |
|
7 |
File Delimiter |
Delimiter or pipe for separating fields. |
char(1)
|
Trailer Fields
The trailer fields are similar for all the reports. These are defined as follows:
Customers
|
No |
Field Name |
Description |
Field Definition |
|---|---|---|---|
|
1 |
Record Type |
The type of record as TRAILER' |
char(7) |
|
2 |
Number of records |
The number of records in the file that excludes the trailer. |
int |
|
3 |
Total Accounts Balance |
The total value from the Account Balance fields in the file. |
decimal(9,2) |
CardAccount
|
No |
Field Name |
Description |
Field Definition |
|---|---|---|---|
|
1 |
Record Type |
The type of record as TRAILER' |
char(7) |
|
2 |
Number of records |
The number of records in the file that excludes the trailer. |
int |
Transactions
|
No |
Field Name |
Description |
Field Definition |
|---|---|---|---|
|
1 |
Record Type |
The type of record as TRAILER' |
char(7) |
|
2 |
Number of records |
The number of records in the file that excludes the trailer. |
int |
|
3 |
Earliest Transaction Date |
The earliest transaction date in the file. This is in the format of YYYYMMDD. |
varchar(8) |
|
4 |
Latest Transaction Date |
The latest transaction date in the file. This is in the format of YYYYMMDD. |
varchar(8) |
|
5 |
Total Credit Amount |
The total credits in the current file. |
decimal(9,2) |
|
6 |
Total Debit Amount |
The total debits in the current file. |
decimal(9,2) |
|
7 |
Total Outstanding Liabiility |
The total debits in the program. |
decimal(9,2) |