PDI BOL Fuel Deliveries File Format
Use this resource to ensure BOL exports from PDI uploaded for Inventory Reconciliation purposes are formatted correctly.
Written by Jess Hamilton
Updated at July 27th, 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: Gross Units and Purchase_Units_Gross) are not supported.
- If a facility or tank code 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 |
|---|---|---|---|
PDI Facility Code |
PDI_Facility_Code Site Site ID Site_ID Site Number Site_Number |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001111 |
PDI Tank Code |
PDI_Tank_Code TankNo Tank No Tank_No |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001 |
Date |
|
YYYY-MM-DD or YYYY-MM-DD HH:MM |
2023-01-01 |
Gross Units |
Gross_Units Purchase_Units_Gross PurchaseUnitsGross |
Number, up to two decimal places |
1000.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 | |
Fuel Grade |
Fuel_Grade ProductID Product ID Product_ID |
Alphanumeric |
REGULAR UNL |
| Net Units |
Net_Units Purchase_Units_Net PurchaseUnitsNet |
Number, up to two decimal places | 1000.00 |
| Unit Descriptor | Unit_Descriptor | Alphanumeric. Must be one of the accepted values listed in the next column. |
USGallons Liters ImperialGallons |