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
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 |
- otf = Original Transactions file
- dcf = Daily Confirmation file
- srf = Settlement Report file
- crf = Copy Requests file
- frf = Fraud Reports file
- cbf = Charge-Backs file
- rpf = Re-Presentments file
|
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. |