Non-PDI BOL Fuel Deliveries File Format
Use this resource to ensure PDI exports uploaded for Inventory Reconciliation purposes are formatted correctly.
Written by Jess Hamilton
Updated at September 5th, 2024
Table of Contents
File Format
Click here to open a template csv file including the columns described below populated with sample data. Feel free to download a copy for your own use.
General Rules
- Imported files must be in .csv format.
- Any columns that do not match the accepted headers below will not be imported. Duplicate columns (ex: Site Number and Site_Number) are not supported.
- If a facility does not match what has been mapped in Titan, the data will not be imported.
Required Columns
The following columns must be included, using the format described below.
Column Header |
Acceptable Alternate Column Headers |
Data Format |
Example Value |
|---|---|---|---|
| Site Number |
Site Site ID Site_ID Site_Number |
Alphanumeric, must match the field Internal ID on the Titan facility profile lpage. | 8000100 |
Fuel Grade |
Fuel_Grade ProductID Product ID Product_ID |
Alphanumeric, must match to the field Internal Grade Name in Dropdown List Management for Substance/Product. |
REGULAR UNL |
Date |
|
YYYY-MM-DD or YYYY-MM-DD hh:mm Time is optional, but must be in 24 hour format. |
2023-01-01 |
| Gross Units |
Gross_Units Purchase_Units_Gross PurchaseUnitsGross |
Decimal, up to two decimal places | 10000.00 |
Optional Columns
You may choose to include the following optional columns.
Column Header |
Acceptable Alternate Column Header |
Data Format |
Example Data |
|---|---|---|---|
| BOL Number | BOL_Number | Integer | 100000 |
| Net Units |
Net_Units Purchase_Units_Net PurchaseUnitsNet |
Decimal, up to 2 decimal places | 1000.00 |
| Unit Descriptor | Unit_Descriptor | Alphanumeric, must be an exact match to one of the acceptable values in the next column. |
USGallons Liters ImperialGallons |