PDI Daily Sales 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. 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.
- 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 |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001111 |
PDI Tank Code |
PDI_Tank_Code TankNo |
Alphanumeric, must match the field by the same name on the Titan facility profile page. |
001 |
Fuel Grade |
Fuel_Grade ProductID |
Alphanumeric |
REGULAR UNL |
Date |
|
YYYY-MM-DD |
2023-01-01 |
Sold Volume |
Sold_Volume SalesUnits |
Number, up to two decimal places |
1000.00 |
You must also have one or both of the following:
Column Header |
Acceptable Alternate Column Headers |
Data Format |
Example Data |
|---|---|---|---|
Purchase Units Gross |
Purchase_Units_Gross PurchaseUnitsGross |
Number, up to two decimal places |
1000.00 |
Purchase Units Net |
Purchase_Units_Net PurchaseUnitsNet |
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 |
|---|---|---|---|
Beginning Inventory |
Beginning_Inventory BeginningInventoryUnits |
Number, up to two decimal places |
1000.00 |
Ending Inventory |
Ending_Inventory EndingInventoryUnits |
Number, up to two decimal places |
1000.00 |
Water Units |
Water_Units WaterUnits |
Number, up to two decimal places |
0.00 |