3.3 File Structure
For Original Transaction file type (.otf):
File Header
Batch Header
Transaction
Additional Data
Transaction
…
Batch Trailer
Batch Header
Transaction
…
Batch Trailer
…
File Trailer
For Daily Confirmations (.dcf) & Settlement Report (.srf) file types:
File Header
Batch Header
Transaction
Transaction
…
Batch Trailer
Batch Header
Transaction
…
Batch Trailer
…
File Trailer
For all other file types: (except .csv and files with no file extension)
File Header
Transaction / Data Line
Transaction / Data Line
…
File Trailer
Example: [40320901.otf]
903520012014-03-2005.55.50901otfTEST3.3.1
962345670710100112345678902014-03-20Merchant Name 25byteslongMerchant CityIS5999840
05V450744******0016 0000000025508402014-03-2098765440796700012017
97234567071010011234567890000001000000000002550
98352001000001
3.3.1 - File Header
Field Name | Length | Comment |
---|---|---|
Transaction Code | 2 | 90 = File Header Record |
Processor ID | 6 | as assigned by Rapyd |
Processing Date | 10 | YYYY-MM-DD - UTC (Coordinated Universal Time) |
Processing Time | 8 | hh.mm.ss - UTC (hh in 24h format, i.e. 00-23) |
File ID | 3 | e.g. 001, 002 (or 901, 902 for TEST clearing files) |
File Type | 3 |
|
Processing Option | 4 | Contains PROD or TEST |
File Version | 5 | 3.3.1 – indicates current file version |
3.3.2 - File Trailer (Depends on File Type)
3.3.2.1 - Common for all data files:
Field Name | Length | Comment |
---|---|---|
Transaction Code | 2 | 98 = File Trailer Record |
Processor ID | 6 | as assigned by Rapyd |
3.3.2.2 - + for File Type otf, dcf & srf:
Field Name | Length | Comment |
---|---|---|
Batch Count | 6 | i.e. 000005 |
3.3.2.3 - + for File Type crf, frf:
Field Name | Length | Comment |
---|---|---|
Transaction Count | 6 | i.e. 000055 |
3.3.2.4 - + for File Type cbf, rpf:
Field Name | Length | Comment |
---|---|---|
Transaction Count | 6 | i.e. 000055 |
Total Amount | 15 | 2 decimals are implied, left zero filled. Attention: This is the sum of all transactions regardless of transaction code. |