Viewing in detail the expiring cards file of a company.

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 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 Equivalence
01 Record code n2 02  
02 Card alias ans..50   vads_identifier
03 Cardholder name an..127   vads_cust_name
04 Cardholder e-mail an..127   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