Reconcilliation flow
Reconciliation File records
H1 record - Identifies the header 1 record
| distributor_id
| |
H1;93827495
H2 record - Identifies the header 2 record
| reporting period (start)
| |
| | reporting period (end)
| | |
H2;2011-11-01;2011-11-03
H3 record - Identifies the header 3 record
| invoice id (if recon is sent with invoice)
| | invoice currency
| | | total invoice amount
| | | |
H3;90045466/06.11.2011;EUR;500.00
D record - Indicates the detail record
| Distributor order id
| | Utc offset
| | | Order date and time
| | | | Distributor id
| | | | | Retailer id
| | | | | | Shop id
| | | | | | | Terminal id
| | | | | | | | Customer identification type
| | | | | | | | | Delivery type
| | | | | | | | | | Country code
| | | | | | | | | | | Face value
| | | | | | | | | | | | Product id
| | | | | | | | | | | | | Serial
| | | | | | | | | | | | | | Order status
| | | | | | | | | | | | | | | Error code
| | | | | | | | | | | | | | | |
D;93837;-60;2011-10-12 22:25:23;0000006938;304;506;309;NONE;RETURN;DE;10.00;304;6954286854268596;DELIVERED;0
F record - Identifies the footer record (End of File)
| number of lines (including this record)
| |
EOF;56
Full example
H1;93827495
H2;2011-11-01;2011-11-3
H3;90045466/06.11.2011;EUR;500.00
D;93837;-60;2011-10-12 22:25:23;0000006938;304;506;309;NONE;RETURN;DE;10.00;304;6954286854268596;DELIVERED;0
EOF;56