Perfect Gallon Meter Sales and BOL Deliveries File Import Specifications
Use this resource to ensure files uploaded for Inventory Reconciliation purposes are formatted correctly.
Written by Jess Hamilton
Updated at September 18th, 2024
Table of Contents
File Format
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 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 |
Data Format |
Example Value |
|---|---|---|
| Internal ID | Alphanumeric, must match the field by the same name on the Titan facility profile page. | 001111 |
| Tank Internal ID | Alphanumeric, must match the field by the same name on the Titan tank page. | 001 |
| Delivery Date |
Date Time: YYYY-MM-DDThh:mm:ssTZD This timestamp may identify the local date and time of delivery + offset to GMT OR may identify the UTC time clearly showing zero offset. |
2023-12-31T23:59:59+1000 OR 2023-12-31T13:59:59+0000 |
| BOL Number | Alphanumeric | REC123 |
Substance Product |
Alphanumeric, must match to the field Internal Grade Name in Dropdown List Management for Substance/Product. |
REGULAR UNL |
| Gross Units | Decimal, up to two decimal places | 10000.00 |
| Net Units | Number, up to two decimal places | 1000.00 |