SHELL
The data record is in the TXT format prescribed – see the description of the structure and the data sample.
From the introductory sentence of the file, we take the following into the fuel card transaction:
|
Attribute Name |
|
Length |
Position Value |
example |
|
File No. |
|
7 |
43-49 |
0340711 |
Furthermore, we only process transactions of the DC and DN types.
DCs are fuel card transactions.
DN is for processing a sentence that does not relate to a specific fuel card and is not populated in fuel card transactions, but relates to a purchase invoice (e.g. discount for the whole). Non-card transactions are always assumed to be in the local currency.
Import SHELL
DC Transaction
|
Attribute Name |
|
Length |
Position Value |
example |
|
Invoice No. |
|
9 |
1-10 |
1615662587 |
|
Type 1 |
|
1 |
12-12 |
"D" - always |
|
Type 2 |
|
1 |
13-13 |
"C" |
|
Date of Occurrence |
File Date |
10 |
28-37 |
31-05-2019. |
|
Country Code |
Country Code |
2 |
90-91 |
SK |
|
Fuel Card No. |
Fuel Card No. |
19 |
117-135 |
710103011003000000 |
|
License plate |
Licence Plate No. |
16 |
176-191 |
AEO 33 45 |
|
Date |
Transaction Date |
10 |
196-205 |
21-06-2019 |
|
Time |
Transaction Time |
5 |
206-210 |
10:54 |
|
Petrol Station No. |
Petrol Station No. |
4 |
213-216 |
0002010 |
|
Instead of a gas station |
Instead of a gas station |
30 |
217-246 |
Prague |
|
Product Code |
Product Code |
5 |
270-274 |
0003 |
|
Product Name |
Product Name |
30 |
423-452 |
Super |
|
Quantity |
Quantity |
10 |
278-287 |
42.40 |
|
Currency |
Currency |
3 |
387-389 |
CZK |
|
VAT Rate |
VAT Rate |
6 |
345-350 |
16,00% |
|
Unit Price Incl. VAT |
Unit Price Incl. VAT |
8 |
288-295 |
21.2500 |
|
Total Price Incl. VAT |
Total Price Incl. VAT |
11 |
412-422 |
901.00 |
|
VAT |
VAT |
11 |
401-411 |
|
|
Price Total Incl. VAT(LCY) |
Price Total Incl. VAT(LCY) |
11 |
376-386 |
546.13 |
|
State KM |
State KM |
6 |
264-269 |
123698 |
DN Transactions:
|
Attribute Name |
|
Length |
Position Value |
example |
|
Invoice No. |
|
9 |
1-10 |
1615662587 |
|
Type 1 |
|
1 |
12-12 |
"D" - always |
|
Type 2 |
|
1 |
13-13 |
"N" |
|
Date of Occurrence |
|
10 |
28-37 |
31-05-2019. |
|
Country Code |
Country Code |
2 |
90-91 |
SK |
|
Date |
Transaction Date |
10 |
111-120 |
21-06-2019 |
|
Product Code |
Product Code |
5 |
123-127 |
|
|
Currency |
Currency |
3 |
141-143 |
CZK |
|
VAT Rate |
VAT Rate |
6 |
135-140 |
21,00% |
|
VAT |
VAT |
11 |
155-165 |
1,47 |
|
Unit Price Incl. VAT |
Unit Price Incl. VAT |
11 |
166-176 |
8,45 |
|
Total Price Incl. VAT |
Total Price Incl. VAT |
8 |
166-176 |
8,45 |
|
Price Total Incl. VAT (LCY) |
Total Price Incl. VAT |
11 |
166-176 |
8,45 |
|
Fuel Card No. |
Fuel Card No. |
19 |
213-231 |
|
|
Description |
Description |
|
268-300 |
|
Document: SHELL_File.structure Shell in ENG.docx
Sample data: Shell_OC.TXT
Non-card transaction: SHELL003_CZ_DN.txt