Viewing in detail the expiring cards file of a company
Expiring card files have the following structure:
- A header record containing task information.
- A variable number of records containing information about tokens and possible recurrences close to expiration.
- A trailer record that allows to verify the consistency of the transmitted file.
For applicable fields, the field name corresponding to the field name used in the payment page form is proposed.
Naming of common files
The name of reporting files should follow conservative guidelines and must provide 4 pieces of information all separated by the point character.
| Nomenclature | Description |
|---|---|
| YYYYMM | Represents the date when the file was generated. Example: 201810 |
| EXP_CARDS | Generic name indicating exported cards. |
| ENS | Name of the company (ENS = Abbreviation of Company's name). Example: My-Company |
| z | Letter "z" takes either the value "T" for a file in TEST mode, or "P" for a file in PRODUCTION mode. |
Filename example : 201810.EXP_CARDS.MA-ENS.T.csv
Header record
| Pos. | Description | Format | Possible values | Equivalence |
|---|---|---|---|---|
| 01 | Record code | n2 | 00 | |
| 02 | File type | EXP_CARDS | ||
| 03 | Environment | a1 | T or P Equivalent field: vads_ctx_mode | |
| 04 | Creation date | n8 | Task start date | |
| 05 | Time of creation | n6 | Task start time |
Details record
| Pos. | Description | Format | Possible values |
|---|---|---|---|
| 01 | Record code | n2 | 02 |
| 02 | Card alias | ans..50 | Ex : 4766113933f945c88bab9324ca08d990 Equivalent field: vads_identifier |
| 03 | Cardholder name | an..127 | E.g.: Axel Kant Equivalent field: vads_cust_name |
| 04 | Cardholder e-mail | an..127 | Ex : kant@e-mail.com Equivalent field: vads_cust_email |
| 05 | Card exp. date | n8 | YYYYMMDD |
| 06 | The number of not terminated recurrences associated with this token | n..6 | The recurrences detail can be found in the corresponding shop file |
End record
| Pos. | Description | Format | Possible values |
|---|---|---|---|
| 01 | Record code | n2 | 01 |
| 02 | Total number of transmitted detail records | n..6 | |
| 03 | End date of processing | n8 | YYYYMMDD |
| 04 | End time of processing | n6 | HHMMSS |
Example of a file
00;EXP_CARDS;T;20180622;162639 02;0cbb70b8f9634f2ebdb10674a8e3af4f;Dupont Durant;Durant@e-mail.com;20180722;0 02;86d73ae99c38423fbba535d04acd2314;Axel Kant;kant@e-mail.com;20180722;0 01;6;20180622;162639