The Batch Upload File Record Layout
The Batch Upload File Record Layout
The Batch Upload File consists of three sections namely:-
- Header
- Transaction records
- Trailer
Header Record
|
DESCRIPTION |
NOTES |
FORMAT |
VALUE |
|
Record Type |
|
N*2 |
"00" |
|
Version |
|
N*3 |
"001" |
|
Bank Code |
Identifier for the bank at which the Card Acceptor ID is valid |
N*2 |
"NN" |
|
Merchant Card Acceptor ID |
The Card Acceptor ID to use to process the batch with |
N*10 |
"NNNNNNNNNN" |
|
File Processing Date |
If this date is the current date or up to 1 calendar month old then the file will be processed on the date on which it is uploaded. If the date is up to 1 calendar month in advance of the date on which the file is uploaded, then the file will be held on the iVeri server until the specified date when it will then be processed on that specified date. |
N*8 |
"YYYYMMDD" |
|
Application ID |
Your ApplicationID allocated by iVeri |
A*36 |
"AAA…AAA" |
|
Merchant Name |
Your Merchant Name under which your ApplicationID has been registered |
A* |
"AAA…" |
Credit Card Transaction Record
|
DESCRIPTION |
NOTES |
FORMAT |
VALUE |
|
Record Type |
|
N*2 |
"01" |
|
Version |
|
N*3 |
"001" |
|
Merchant Terminal Number |
Used to group transactions together |
A*8 |
"AAAAAAAA" |
|
Merchant Reference |
Unique identifier for this invoice or credit note. NOTE: DO NOT USE ANY COMMA’s AS PART OF THIS IDENTIFIER |
A*32 |
"AAA…AAA" |
|
Transaction Code |
See Appendix B |
N*2 |
"NN" |
|
Purchase Date |
Date the invoice or credit note was raised IMPORTANT NOTE: This date must be less than or equal to the date on which the batch will actually be processed ie. The file processing date in the header record. |
N*8 |
"YYYYMMDD" |
|
Purchase Time |
Time the invoice or credit note was raised |
N*4 |
"HHMM" |
|
Amount |
Value is in cents |
N*10 |
"NNNNNNNNNN" |
|
CCNumber |
Credit Card Number NOTE: Pad with zeros from the left to fill the required field of twenty numbers |
N*20 |
"NNN...NNN" |
|
Card Start Date |
The beginning of the period for which the card is valid. If this is not available use the current month and year. |
N*6 |
"YYYYMM" |
|
Card Expiry Date |
|
N*6 |
"YYYYMM" |
|
Authorisation Code |
Pre-authorisation code if one has been obtained for this transaction |
N*6 |
"NNNNNN" Set to "000000" if it does not exist |
|
Budget Period |
The Budget period to request this authorisation to be used with. In number of months |
N*2 |
“NN” Set to "00" if it does not exist |
|
Original Merchant Reference |
The Invoice Number of the original invoice which is being refunded. This is only used for the case where a refund is being performed or in the case of a recurring transaction. Note that the format of this field must be right justified irrespective of whether it is numeric or alphanumeric. |
A*32 |
"AAA…AAA" Set to " … " (all spaces) if it does not exist. |
Trailer Record
|
DESCRIPTION |
NOTES |
FORMAT |
VALUE |
|
Record Type |
|
N*2 |
"09" |
|
Version |
|
N*3 |
"001" |
|
Total number of transactions |
|
N*6 |
"NNNNNN" |
|
Total Amount |
The simple sum of all the amounts without regard to whether it is a sale or a refund etc |
N*10 |
"NNNNNNNNNN" |