Data Import Formats
- Lango: Language and translation manager
- Monika Dluhošová
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