Daily Clear Export Technical Specifications

Energy Force Master Clear process creates a .dat file in the DD85\Interface folder

The Master Clear file is created using the following naming convention:

"PM" + Division# + YYYY + MM + DD + Total seconds for the day it ran + .dat
Ex: 5:00pm would be 61200 (17 hours *60 min per hour*60 sec per minute)

#4 — Standard

	Field Name	Attribute	Picture	Start Position	Size	Comments
1	History RRN	Numeric	9C	1	11	Unique number assigned by Energy Force
2	Record Type	Alpha	U	13	1	S – Sales, P – Payment
3	Division Number	Numeric	4	15	4	Division Number of the customer
4	Customer Number	Numeric	10	20	10	Customer Number
5	Name Field	Alpha	U35	31	35	Last Name, First Name
6	First Name	Alpha	U15	67	15	First Name
7	Last Name	Alpha	U20	83	20	Last Name
8	Billing Address 1	Alpha	U30	104	30	Billing address 1 from customer file
9	Billing address 2	Alpha	U30	135	30	Billing address 2 from customer file
10	Billing City	Alpha	U25	166	25	Billing city from customer file
11	Billing St	Alpha	U2	192	2	Billing state from customer file
12	Billing Zip Code	Alpha	#####-####A	195	10	Zip plus 4(xxxxx-xxxx) hyphen included
13	Tank Description	Alpha	12	206	12	Tank Description (House, barn, etc)
14	Tank Serial Number	Alpha	U20	219	20	Tank Serial Number
15	Ticket Number	Numeric	9	240	9	Ticket or Check Number
16	History Date	Date	MM/DD/YY	250	8	Date of Transaction
17	Driver Number	Numeric	4	259	4	Driver Number from sales posting
18	Journal Number	Numeric	7	264	7	Journal Number from sales posting
19	Voided Line Item	Logical	5	272	5	False for normal transaction, True if voided
20	Department Number	Numeric	6	278	6	Department Number from sales posting
21	Posting Reference	Alpha	U30	285	30	Department Number Description
22	General Ledger Number	Numeric	12.4	316	17	G/L code from Department Maintenance
23	Starting %	Numeric	2	334	2	At the time of delivery (sales posting)
24	Ending %	Numeric	2	337	2	At the time of delivery (sales posting)
25	Pounds Delivered	Numeric	5.2	340	8	Pounds entered in sales posting (also then converted to gallons)
26	Gallons Delivered	Numeric	N5.2	349	9	Gallons entered in sales posting
27	Quantity Parts	Numeric	N5.2	359	9	Quantity entered in sales posting (there is only a quantity or gallons for a line item)
28	Unit Price	Numeric	N5.4	369	11	Price per gallon or per quantity
29	Line Amount	Numeric	N6.2	381	10	Extended amount prior to sales tax (sales Posting)
30	Total Amount	Numeric	N6.2	392	10	Grand total with taxes applied (sales Posting)
31	Transaction Code	Numeric	2	403	2	9 – % Update to tank 11– Cash Sale to non-delivery type 2 12 – Cash Sale to delivery type 2 tank. Gallons are always involved. 13 – Charge Qty for non-gallon delivery items. Does not update K-factor. 14 – Gallon delivery to type 2 customer. Need to update K-factor and tank information. Gallons are always involved 15 – Charge to contract. K-factor and tank information does not get updated. 16 – Charge to contract. The K-factor and tank information needs updated. Gallons are always involved 17 – Meter Billed 18 – Refund on Account 19 – Transfer - This is the debit side of the transfer 21 – Regular Payments 22 – Credit Card payment 23 – Contract/Prebuy Payments 24 – Budget Payment 27 – Deposit Paid 28 – Deposits Refunded 31 – Credit
32	Interface Billing Code	Numeric	2	406	2	Applied to Department if applicable Code 80 references a CardTrol sale with the card # in column113 Code 81 – Product delivery for deferred billing Code 82 – Deferred usage billing
33	Meter RRN	Numeric	9C	409	11	Unique number assigned by Energy Force. Commas are allowed in this field.
34	Price in file at delivery	Numeric	N5.4	421	11	Price per unit in the tank file at the time of delivery
35	Location Code	Numeric	4	433	4	Location assigned to the tank
36	Posting Division	Numeric	4	438	4	Location used at time of delivery/sale - Posting Division
37	Posted to Contract	Alpha	U10	443	10	Contract number used at time of delivery for Transaction Code 15 or 16
38	Sales Tax Code 1	Numeric	4	454	4	From the sales tax code 1 maintenance file
39	Sales Tax Amount	Numeric	N5.2	459	9	Sales tax amount 1 (sales Posting, sales history line item)
40	Sales Tax Code 2	Numeric	4	469	4	From the sales tax code 2 maintenance file
41	Sales Tax Amount 2	Numeric	N5.2	474	9	Sales tax amount 2 (sales Posting, sales history line item)
42	Sales Tax Code 3	Numeric	4	484	4	From the sales tax code 3 maintenance file
43	Sales Tax Amount 3	Numeric	N5.2	489	9	Sales tax amount 3 (sales Posting, sales history line item)
44	Sales Tax Code 4	Numeric	4	499	4	From the sales tax code 4 maintenance file
45	Sales Tax Amount 4	Numeric	N5.2	504	9	Sales tax amount 4 (sales Posting, sales history line item)
46	Sales Tax Code 5	Numeric	4	514	4	From the sales tax code 5 maintenance file
47	Sales Tax Amount 5	Numeric	N5.2	519	9	Sales tax amount 5 (sales Posting, sales history line item)
48	Sales Tax Code 6	Numeric	4	529	4
49	Sales Tax Amount 6	Numeric	N5.2	534	9
50	Sales Tax Code 7	Numeric	4	544	4
51	Sales Tax Amount 7	Numeric	N5.2	549	9
52	Sales Tax Code 8	Numeric	4	559	4
53	Sales Tax Amount 8	Numeric	N5.2	564	9
54	Sales Tax Code 9	Numeric	4	574	4
55	Sales Tax Amount 9	Numeric	N5.2	579	9
56	Sales Tax Code 10	Numeric	4	589	4
57	Sales Tax Amount 10	Numeric	N5.2	594	9
58	Meter Serial Number	Alpha	U20	604	20	Serial Number for meter billing
59	Meter Type	Numeric	2	625	2	1 – Cubic Mtr, 2 – Cubic Ft mtr, 3 – 10x100 Meter, 4 – gallons
60	Cycle Code	Numeric	2	628	2	Meter Cycle Code utilized during billing
61	Current Last Billing Date	Date	MM/DD/YY	631	8	Current billing date for meter billing
62	Meter current Reading Date	Date	MM/DD/YY	640	8	Current reading date of meter billed
63	Last Meter Reading	Numeric	N7	649	8	Reading of the meter at the time of billing, negatives are allowed
64	Meter Active/Inactive	Alpha	1	658	1	A – Active or I – Inactive
65	Elevation Code	Numeric	3	660	3	Elevation Code assigned to meter
66	Meter Previous Reading Date	Date	MM/DD/YY	664	8	Previous meter reading date
67	Meter Previous Meter Reading	Numeric	N7	673	8	Previous meter reading billed. Negatives are allowed in this field
68	(meter) Cubic Amount Used	Numeric	N6.2	682	10	Current cubic amount billed
69	Meter gallons used	Numeric	N5.2	693	9	Current meter gallons billed (If there is cubic amount it is converted to gallons)
70	Meter gallons price	Numeric	N5.4	703	11	Current price per gallon billed
71	Meter Charge Amount	Numeric	N9.2	715	13	Total meter amount charged
72	Reading Type	Alpha	U	729	1	C – Customer, P – Postcard, H – Handheld, M – Modem
73	Voided item	Logical	5	731	5	True – voided, otherwise False.
74	Cu Ft Price	Numeric	N5.4	737	11	Current meter price per gallon converted to Cubic ft price per gallon for a cubic meter type
75	Discount Due Date	Date	MM/DD/YY	749	8	Discount Due Date if sale was allowed a discount calculated from the net due day(s) in the maintenance file.
76	Discount Code	Numeric	3	758	3	Discount Code applied to gallons
77	Discount Line Amount	Numeric	N5.2	762	9	Discount line amount prior to taxes
78	Total Discount Allowed	Numeric	N5.2	772	9	Total discount with sales taxes
79	Discount Taken	Logical	5	782	5	False at the time of calculating. True if applied to payment
80	Discount Tax code 1	Numeric	4	788	4	Discount Tax code 1
81	Discount Tax Amt 1	Numeric	N4.2	793	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
82	Discount Tax Code 2	Numeric	4	802	4	Discount Tax code 2
83	Discount Tax Amt 2	Numeric	N4.2	807	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
84	Discount Tax Code 3	Numeric	4	816	4	Discount Tax code 3
85	Discount Tax Amt 3	Numeric	N4.2	821	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
86	Discount Tax Code 4	Numeric	4	830	4	Discount Tax code 4
87	Discount Tax Amt 4	Numeric	N4.2	835	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
88	Discount Tax Code 5	Numeric	4	844	4	Discount Tax code 5
89	Discount Tax Amt 5	Numeric	N4.2	849	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
90	Discount Code 6	Numeric	4	858	4
91	Discount Tax Amt 6	Numeric	N4.2	863	8
92	Discount Code 7	Numeric	4	872	4
93	Discount Tax Amt 7	Numeric	N4.2	877	8
94	Discount Code 8	Numeric	4	886	4
95	Discount Tax Amt 8	Numeric	N4.2	891	8
96	Discount Code 9	Numeric	4	900	4
97	Discount Tax Amt 9	Numeric	N4.2	905	8
98	Discount Code 10	Numeric	4	914	4
99	Discount Tax Amt 10	Numeric	N4.2	919	8
100	Alternate Customer ID	Alpha	U10	928	10	Alternate Customer ID number from customer file import. Used if interface customer numbers are alpha character
101	Cash Sale Payment	Numeric	N6.2	939	10	Net payment amount for Transaction Codes 11 & 12 (Cash Sales)
102	Delivery address	Alpha	U30	950	30	Tank delivery address/Service Location address
103	Delivery city	Alpha	U25	981	25	Tank delivery city or Service Location city
104	Delivery state	Alpha	U2	1007	2	Tank delivery state or Service Location state
105	Split Bill and Cents Down Prebuy	Alpha	U1	1010	1	This field is used for 2 things: If split billing ticket, the record for the delivery to the tank is marked with a Y and the transaction code will be a 15 or 16. Otherwise, the field is blank. If a contract ticket with cents down, the credit portion of the ticket is marked with a Y with Transaction Code 31. Otherwise the field is blank.
106	Contract Bill Type	Numeric	2	1012	2	Contract Bill Type code assigned to ticket for Transaction Codes 15 and 16.
107	Budget Bill Type	Alpha	2	1015	2	If Budget is active and ticket is posted, the Bill Type will be present in this position. If non-budget, the position will display as 00.
108	PO#	Alpha	15	1018	15	Purchase Order number
109	Tank RRN #	Numeric	9	1034	9	Tank RRN number associated to delivery. If payment, field will be blank
110	Cust Div/Jrnl Num	Numeric	6	1044	6	Custom Field for interface to Mas90/Sage100 2-digit Customer Division number and last 4 digits of journal number
111	TranCD/Jrnl Num	Numeric	6	1051	6	Custom Field for interface to Mas90/Sage100 2-digit transaction code and last 4 digits of journal number
112	Total Tax Accum	Numeric	9.2	1058	13	Custom Field for interface to Mas90/Sage100 Accumulated total of taxes listed in column 20 of HLI item file
113	Card ID #	Numeric	20	1072	20	Card ID # associated with CardTrol sale
114	Tank Master RRN	Numeric	9	1093	9	Master Tank RRN that remains with the tank regardless of what customer it’s currently attached to. Typically utilized for company owned tanks
115	Truck Number	Numeric	9	1103	9	Truck assigned to delivery of pumpable product (Department Table, Gas Dept – Y)
116	Void Transaction	Alpha	1	1113	1	Will contain V if Voided Transaction

#5 — Standard (Agvance only)

Note: Unlike the Standard Daily Clear, this file is a pipe delimited and does not rely on start positions and sizes.

	Field Name	Attribute	Picture	Comments
1	History RRN	Numeric	9C	Unique number assigned by Energy Force
2	Record Type	Alpha	U	S – Sales, P – Payment
3	Division Number	Numeric	4	Division Number of the customer
4	Customer Number	Numeric	10	Customer Number
5	Name Field	Alpha	U35	Last Name, First Name
6	First Name	Alpha	U15	First Name
7	Last Name	Alpha	U20	Last Name
8	Billing Address 1	Alpha	U30	Billing address 1 from customer file
9	Billing address 2	Alpha	U30	Billing address 2 from customer file
10	Billing City	Alpha	U25	Billing city from customer file
11	Billing St	Alpha	U2	Billing state from customer file
12	Billing Zip Code	Alpha	#####-####A	Zip plus 4(xxxxx-xxxx) hyphen included
13	Tank Description	Alpha	12	Tank Description (House, barn, etc)
14	Tank Serial Number	Alpha	U20	Tank Serial Number
15	Ticket Number	Numeric	9	Ticket or Check Number
16	History Date	Date	MM/DD/YY	Date of Transaction
17	Driver Number	Numeric	4	Driver Number from sales posting
18	Journal Number	Numeric	7	Journal Number from sales posting
19	Voided Line Item	Logical	5	False for normal transaction, True if voided
20	Department Number	Numeric	6	Department Number from sales posting
21	Posting Reference	Alpha	U30	Department Number Description
22	General Ledger Number	Numeric	12.4	G/L code from Department Maintenance
23	Starting %	Numeric	2	At the time of delivery (sales posting)
24	Ending %	Numeric	2	At the time of delivery (sales posting)
25	Pounds Delivered	Numeric	5.2	Pounds entered in sales posting (also then converted to gallons)
26	Gallons Delivered	Numeric	N5.2	Gallons entered in sales posting
27	Quantity Parts	Numeric	N5.2	Quantity entered in sales posting (there is only a quantity or gallons for a line item)
28	Unit Price	Numeric	N5.4	Price per gallon or per quantity
29	Line Amount	Numeric	N6.2	Extended amount prior to sales tax (sales Posting)
30	Total Amount	Numeric	N6.2	Grand total with taxes applied (sales Posting)
31	Transaction Code	Numeric	2	9 – % Update to tank 11– Cash Sale to non-delivery type 2 12 – Cash Sale to delivery type 2 tank. Gallons are always involved. 13 – Charge Qty for non-gallon delivery items. Does not update K-factor. 14 – Gallon delivery to type 2 customer. Need to update K-factor and tank information. Gallons are always involved 15 – Charge to contract. K-factor and tank information does not get updated. 16 – Charge to contract. The K-factor and tank information needs updated. Gallons are always involved 17 – Meter Billed 18 – Refund on Account 19 – Transfer - This is the debit side of the transfer 21 – Regular Payments 22 – Credit Card payment 23 – Contract/Prebuy Payments 24 – Budget Payment 27 – Deposit Paid 28 – Deposits Refunded 31 – Credit
32	Interface Billing Code	Numeric	2	Applied to Department if applicable Code 80 references a CardTrol sale with the card # in column113 Code 81 – Product delivery for deferred billing Code 82 – Deferred usage billing
33	Meter RRN	Numeric	9C	Unique number assigned by Energy Force. Commas are allowed in this field.
34	Price in file at delivery	Numeric	N5.4	Price per unit in the tank file at the time of delivery
35	Location Code	Numeric	4	Location assigned to the tank
36	Posting Division	Numeric	4	Location used at time of delivery/sale - Posting Division
37	Posted to Contract	Alpha	U10	Contract number used at time of delivery for Transaction Code 15 or 16
38	Sales Tax Code 1	Numeric	4	From the sales tax code 1 maintenance file
39	Sales Tax Amount	Numeric	N5.2	Sales tax amount 1 (sales Posting, sales history line item)
40	Sales Tax Code 2	Numeric	4	From the sales tax code 2 maintenance file
41	Sales Tax Amount 2	Numeric	N5.2	Sales tax amount 2 (sales Posting, sales history line item)
42	Sales Tax Code 3	Numeric	4	From the sales tax code 3 maintenance file
43	Sales Tax Amount 3	Numeric	N5.2	Sales tax amount 3 (sales Posting, sales history line item)
44	Sales Tax Code 4	Numeric	4	From the sales tax code 4 maintenance file
45	Sales Tax Amount 4	Numeric	N5.2	Sales tax amount 4 (sales Posting, sales history line item)
46	Sales Tax Code 5	Numeric	4	From the sales tax code 5 maintenance file
47	Sales Tax Amount 5	Numeric	N5.2	Sales tax amount 5 (sales Posting, sales history line item)
48	Sales Tax Code 6	Numeric	4
49	Sales Tax Amount 6	Numeric	N5.2
50	Sales Tax Code 7	Numeric	4
51	Sales Tax Amount 7	Numeric	N5.2
52	Sales Tax Code 8	Numeric	4
53	Sales Tax Amount 8	Numeric	N5.2
54	Sales Tax Code 9	Numeric	4
55	Sales Tax Amount 9	Numeric	N5.2
56	Sales Tax Code 10	Numeric	4
57	Sales Tax Amount 10	Numeric	N5.2
58	Meter Serial Number	Alpha	U20	Serial Number for meter billing
59	Meter Type	Numeric	2	1 – Cubic Mtr, 2 – Cubic Ft mtr, 3 – 10x100 Meter, 4 – gallons
60	Cycle Code	Numeric	2	Meter Cycle Code utilized during billing
61	Current Last Billing Date	Date	MM/DD/YY	Current billing date for meter billing
62	Meter current Reading Date	Date	MM/DD/YY	Current reading date of meter billed
63	Last Meter Reading	Numeric	N7	Reading of the meter at the time of billing, negatives are allowed
64	Meter Active/Inactive	Alpha	1	A – Active or I – Inactive
65	Elevation Code	Numeric	3	Elevation Code assigned to meter
66	Meter Previous Reading Date	Date	MM/DD/YY	Previous meter reading date
67	Meter Previous Meter Reading	Numeric	N7	Previous meter reading billed. Negatives are allowed in this field
68	(meter) Cubic Amount Used	Numeric	N6.2	Current cubic amount billed
69	Meter gallons used	Numeric	N5.2	Current meter gallons billed (If there is cubic amount it is converted to gallons)
70	Meter gallons price	Numeric	N5.4	Current price per gallon billed
71	Meter Charge Amount	Numeric	N9.2	Total meter amount charged
72	Reading Type	Alpha	U	C – Customer, P – Postcard, H – Handheld, M – Modem
73	Voided item	Logical	5	True – voided, otherwise False.
74	Cu Ft Price	Numeric	N5.4	Current meter price per gallon converted to Cubic ft price per gallon for a cubic meter type
75	Discount Due Date	Date	MM/DD/YY	Discount Due Date if sale was allowed a discount calculated from the net due day(s) in the maintenance file.
76	Discount Code	Numeric	3	Discount Code applied to gallons
77	Discount Line Amount	Numeric	N5.2	Discount line amount prior to taxes
78	Total Discount Allowed	Numeric	N5.2	Total discount with sales taxes
79	Discount Taken	Logical	5	False at the time of calculating. True if applied to payment
80	Discount Tax code 1	Numeric	4	Discount Tax code 1
81	Discount Tax Amt 1	Numeric	N4.2	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
82	Discount Tax Code 2	Numeric	4	Discount Tax code 2
83	Discount Tax Amt 2	Numeric	N4.2	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
84	Discount Tax Code 3	Numeric	4	Discount Tax code 3
85	Discount Tax Amt 3	Numeric	N4.2	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
86	Discount Tax Code 4	Numeric	4	Discount Tax code 4
87	Discount Tax Amt 4	Numeric	N4.2	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
88	Discount Tax Code 5	Numeric	4	Discount Tax code 5
89	Discount Tax Amt 5	Numeric	N4.2	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
90	Discount Code 6	Numeric	4
91	Discount Tax Amt 6	Numeric	N4.2
92	Discount Code 7	Numeric	4
93	Discount Tax Amt 7	Numeric	N4.2
94	Discount Code 8	Numeric	4
95	Discount Tax Amt 8	Numeric	N4.2
96	Discount Code 9	Numeric	4
97	Discount Tax Amt 9	Numeric	N4.2
98	Discount Code 10	Numeric	4
99	Discount Tax Amt 10	Numeric	N4.2
100	Alternate Customer ID	Alpha	U10	Alternate Customer ID number from customer file import. Used if interface customer numbers are alpha character
101	Cash Sale Payment	Numeric	N6.2	Net payment amount for Transaction Codes 11 & 12 (Cash Sales)
102	Delivery address	Alpha	U30	Tank delivery address/Service Location address
103	Delivery city	Alpha	U25	Tank delivery city or Service Location city
104	Delivery state	Alpha	U2	Tank delivery state or Service Location state
105	Split Bill and Cents Down Prebuy	Alpha	U1	This field is used for 2 things: If split billing ticket, the record for the delivery to the tank is marked with a Y and the transaction code will be a 15 or 16. Otherwise, the field is blank. If a contract ticket with cents down, the credit portion of the ticket is marked with a Y with Transaction Code 31. Otherwise the field is blank.
106	Contract Bill Type	Numeric	2	Contract Bill Type code assigned to ticket for Transaction Codes 15 and 16.
107	Budget Bill Type	Alpha	2	If Budget is active and ticket is posted, the Bill Type will be present in this position. If non-budget, the position will display as 00.
108	PO#	Alpha	15	Purchase Order number
109	Tank RRN #	Numeric	9	Tank RRN number associated to delivery. If payment, field will be blank
110	Cust Div/Jrnl Num	Numeric	6	Custom Field for interface to Mas90/Sage100 2-digit Customer Division number and last 4 digits of journal number
111	TranCD/Jrnl Num	Numeric	6	Custom Field for interface to Mas90/Sage100 2-digit transaction code and last 4 digits of journal number
112	Total Tax Accum	Numeric	9.2	Custom Field for interface to Mas90/Sage100 Accumulated total of taxes listed in column 20 of HLI item file
113	Card ID #	Numeric	20	Card ID # associated with CardTrol sale
114	Tank Master RRN	Numeric	9	Master Tank RRN that remains with the tank regardless of what customer it’s currently attached to. Typically utilized for company owned tanks
115	Truck Number	Numeric	9	Truck assigned to delivery of pumpable product (Department Table, Gas Dept – Y)
116	Void Transaction	Alpha	1	Will contain V if Voided Transaction
117	Customer GUID	Alpha	36	Unique customer identifier between Agvance and Energy Force
118	Contract GUID	Alpha	36	Unique customer identifier that links the Energy Force contract to the Agvance Booking.

#10 — AgTrax

Energy Force version 17.243 implemented 2 changes to the AgTrax Master Clear file:

On the sale, if the customer has an Alt ID number in the Energy Force customer screen, then write the master clear to have Alt ID number in the customer number position in the export file.
There are 2 sales tax positions in the AgTrax standard import spec document. Previously, Energy Force was writing the total tax per line item in the first sales tax position. It now will split the taxes into the 2 positions. The 1st position contains the State and County taxes and the 2nd position contains all other taxes.

#12 — Standard Plus

	Field Name	Attribute	Picture	Start Position	Size	Comments
1	History RRN	Numeric	9C	1	11	Unique number assigned by Energy Force
2	Record Type	Alpha	U	13	1	S – Sales, P – Payment
3	Division Number	Numeric	4	15	4	Division Number of the customer
4	Customer Number	Numeric	10	20	10	Customer Number
5	Name Field	Alpha	U35	31	35	Last Name, First Name
6	First Name	Alpha	U15	67	15	First Name
7	Last Name	Alpha	U20	83	20	Last Name
8	Billing Address 1	Alpha	U30	104	30	Billing address 1 from Customer table
9	Billing address 2	Alpha	U30	135	30	Billing address 2 from Customer table
10	Billing City	Alpha	U25	166	25	Billing city from Customer table
11	Billing St	Alpha	U2	192	2	Billing state from Customer table
12	Billing Zip Code	Alpha	#####-####A	195	10	Zip plus 4(xxxxx-xxxx) hyphen included
13	Tank Description	Alpha	12	206	12	Tank Description (House, barn, etc)
14	Tank Serial Number	Alpha	U20	219	20	Tank Serial Number
15	Ticket Number	Numeric	9	240	9	Ticket or Check Number
16	History Date	Date	MM/DD/YY	250	8	Date of Transaction
17	Driver Number	Numeric	4	259	4	Driver Number from sales posting
18	Journal Number	Numeric	5	264	7	Journal Number from sales posting
19	Voided Line Item	Logical	5	272	5	False for normal transaction, True if voided
20	Department Number	Numeric	6	278	6	Department Number from sales posting
21	Posting Reference	Alpha	U30	285	30	Department Number Description
22	General Ledger Number	Numeric	12.4	316	17	G/L code from Department Maintenance
23	Starting %	Numeric	2	334	2	At the time of delivery (sales posting)
24	Ending %	Numeric	2	337	2	At the time of delivery (sales posting)
25	Pounds Delivered	Numeric	5.2	340	8	Pounds entered in sales posting (also then converted to gallons)
26	Gallons Delivered	Numeric	N5.2	349	9	Gallons entered in sales posting
27	Quantity Parts	Numeric	N5.2	359	9	Quantity entered in sales posting (there is only a quantity or gallons for a line item)
28	Unit Price	Numeric	N5.4	369	11	Price per gallon or per quantity
29	Line Amount	Numeric	N6.2	381	10	Extended amount prior to sales tax (sales Posting)
30	Total Amount	Numeric	N6.2	392	10	Grand total with taxes applied (sales Posting)
31	Transaction Code	Numeric	2	403	2	9 – % Update to tank 11– Cash Sale to non-delivery type 2 12 – Cash Sale to delivery type 2 tank. Gallons are always involved. 13 – Charge Qty for non-gallon delivery items. Does not update K-factor. 14 – Gallon delivery to type 2 tank. Need to update K-factor and tank information. Gallons are always involved 15 – Charge to contract. K-factor and tank information does not get updated. 16 – Charge to contract. The K-factor and tank information needs updated. Gallons are always involved 17 – Meter Billed 18 – Refund on Account 19 – Transfer - This is the debit side of the transfer 21 – Regular Payments 22 – Credit Card payment 23 – Contract/Prebuy Payments 24 – Budget Payment 27 – Deposit Paid 28 – Deposits Refunded 31 – Credit
32	Interface Billing Code	Numeric	2	406	2	Applied to Department if applicable Code 80 references a CardTrol sale with the card # in column113 Code 81 – Product delivery for deferred billing Code 82 – Deferred usage billing
33	Meter RRN	Numeric	9C	409	11	Unique number assigned by Energy Force. Commas are allowed in this field.
34	Price in file at delivery	Numeric	N5.4	421	11	Price per unit in the tank file at the time of delivery
35	Location Code	Numeric	4	433	4	Location assigned to the tank
36	Posting Division	Numeric	4	438	4	Location used at time of delivery/sale - Posting Division
37	Posted to Contract	Alpha	U10	443	10	Contract number used at time of delivery for Transaction Code 15 or 16
38	Sales Tax Code 1	Numeric	4	454	4	From the sales tax code 1 maintenance file
39	Sales Tax Amount	Numeric	N5.2	459	9	Sales tax amount 1 (sales Posting, sales history line item)
40	Sales Tax Code 2	Numeric	4	469	4	From the sales tax code 2 maintenance file
41	Sales Tax Amount 2	Numeric	N5.2	474	9	Sales tax amount 2 (sales Posting, sales history line item)
42	Sales Tax Code 3	Numeric	4	484	4	From the sales tax code 3 maintenance file
43	Sales Tax Amount 3	Numeric	N5.2	489	9	Sales tax amount 3 (sales Posting, sales history line item)
44	Sales Tax Code 4	Numeric	4	499	4	From the sales tax code 4 maintenance file
45	Sales Tax Amount 4	Numeric	N5.2	504	9	Sales tax amount 4 (sales Posting, sales history line item)
46	Sales Tax Code 5	Numeric	4	514	4	From the sales tax code 5 maintenance file
47	Sales Tax Amount 5	Numeric	N5.2	519	9	Sales tax amount 5 (sales Posting, sales history line item)
48	Sales Tax Code 6	Numeric	4	529	4	From the sales tax code 6 maintenance file
49	Sales Tax Amount 6	Numeric	N5.2	534	9	Sales tax amount 6 (sales Posting, sales history line item)
50	Sales Tax Code 7	Numeric	4	544	4	From the sales tax code 7 maintenance file
51	Sales Tax Amount 7	Numeric	N5.2	549	9	Sales tax amount 7 (sales Posting, sales history line item)
52	Sales Tax Code 8	Numeric	4	559	4	From the sales tax code 8 maintenance file
53	Sales Tax Amount 8	Numeric	N5.2	564	9	Sales tax amount 8 (sales Posting, sales history line item)
54	Sales Tax Code 9	Numeric	4	574	4	From the sales tax code 9 maintenance file
55	Sales Tax Amount 9	Numeric	N5.2	579	9	Sales tax amount 9 (sales Posting, sales history line item)
56	Sales Tax Code 10	Numeric	4	589	4	From the sales tax code 10 maintenance file
57	Sales Tax Amount 10	Numeric	N5.2	594	9	Sales tax amount 10 (sales Posting, sales history line item)
58	Meter Serial Number	Alpha	U20	679	20	Serial Number for meter billing
59	Meter Type	Numeric	2	700	2	1 – Cubic Mtr, 2 – Cubic Ft mtr, 3 – 10x100 Meter, 4 – gallons
60	Cycle Code	Numeric	2	703	2	Meter Cycle Code utilized during billing
61	Current Last Billing Date	Date	MM/DD/YY	706	8	Current billing date for meter billing
62	Meter current Reading Date	Date	MM/DD/YY	715	8	Current reading date of meter billed
63	Last Meter Reading	Numeric	N7	724	8	Reading of the meter at the time of billing, negatives are allowed
64	Meter Active/Inactive	Alpha	1	733	1	A – Active or I – Inactive
65	Elevation Code	Numeric	3	735	3	Elevation Code assigned to meter
66	Meter Previous Reading Date	Date	MM/DD/YY	739	8	Previous meter reading date
67	Meter Previous Meter Reading	Numeric	N7	748	8	Previous meter reading billed. Negatives are allowed in this field
68	Cubic Amount Used (Meter)	Numeric	N6.2	757	10	Current cubic amount billed
69	Meter gallons used	Numeric	N5.2	768	9	Current meter gallons billed (If there is cubic amount it is converted to gallons)
70	Meter gallons price	Numeric	N5.4	778	11	Current price per gallon billed
71	Meter Charge Amount	Numeric	N9.2	790	13	Total meter amount charged
72	Reading Type	Alpha	U	804	1	C – Customer, P – Postcard, H – Handheld, M – Modem
73	Meter Voided item	Logical	5	806	5	True – voided, otherwise False.
74	Cu Ft Price	Numeric	N5.4	812	11	Current meter price per gallon converted to Cubic ft price per gallon for a cubic meter type
75	Discount Due Date	Date	MM/DD/YY	824	8	Discount Due Date if sale was allowed a discount calculated from the net due day(s) in the maintenance file.
76	Discount Code	Numeric	3	833	3	Discount Code applied to gallons
77	Discount Line Amount	Numeric	N5.2	837	9	Discount line amount prior to taxes
78	Total Discount Allowed	Numeric	N5.2	847	9	Total discount with sales taxes
79	Discount Taken	Logical	5	857	5	False at the time of calculating. True if applied to payment
80	Discount Tax code 1	Numeric	4	863	4	Discount Tax code 1
81	Discount Tax Amt 1	Numeric	N4.2	868	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
82	Discount Tax Code 2	Numeric	4	877	4	Discount Tax code 2
83	Discount Tax Amt 2	Numeric	N4.2	882	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
84	Discount Tax Code 3	Numeric	4	891	4	Discount Tax code 3
85	Discount Tax Amt 3	Numeric	N4.2	896	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
86	Discount Tax Code 4	Numeric	4	905	4	Discount Tax code 4
87	Discount Tax Amt 4	Numeric	N4.2	910	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
88	Discount Tax Code 5	Numeric	4	919	4	Discount Tax code 5
89	Discount Tax Amt 5	Numeric	N4.2	924	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
90	Discount Code 6	Numeric	4	933	4	Discount Tax code 6
91	Discount Tax Amt 6	Numeric	N4.2	938	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
92	Discount Code 7	Numeric	4	947	4	Discount Tax code 7
93	Discount Tax Amt 7	Numeric	N4.2	952	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
94	Discount Code 8	Numeric	4	961	4	Discount Tax code 8
95	Discount Tax Amt 8	Numeric	N4.2	966	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
96	Discount Code 9	Numeric	4	975	4	Discount Tax code 9
97	Discount Tax Amt 9	Numeric	N4.2	980	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
98	Discount Code 10	Numeric	4	989	4	Discount Tax code 10
99	Discount Tax Amt 10	Numeric	N4.2	994	8	Discount Sales Tax Amount Calculated when calculation or the discount amount applied based on the above field Discount Taken
100	Alternate Customer ID	Alpha	U10	1003	10	Alternate Customer ID number from customer file import. Used if interface customer numbers are alpha character
101	Cash Sale Payment	Numeric	N6.2	1014	10	Net payment amount for Transaction Codes 11 & 12 (Cash Sales)
102	Delivery address	Alpha	U30	1025	30	Tank delivery address/Service Location address
103	Delivery city	Alpha	U25	1056	25	Tank delivery city or Service Location city
104	Delivery state	Alpha	U2	1082	2	Tank delivery state or Service Location state
105	Split Bill and Cents Down Prebuy	Alpha	U1	1085	1	This field is used for 2 things: If split billing ticket, the record for the delivery to the tank is marked with a Y and the transaction code will be a 15 or 16. Otherwise, the field is blank. If a contract ticket with cents down, the credit portion of the ticket is marked with a Y with Transaction Code 31. Otherwise the field is blank.
106	Contract Bill Type	Numeric	2	1087	2	Contract Bill Type code assigned to ticket for Transaction Codes 15 and 16.
107	Budget Bill Type	Numeric	2	1090	2	If Budget is active and ticket is posted, the Bill Type will be present in this position. If non-budget, the position will display as 00.
108	PO#	Alpha	15	1093	15	Purchase Order number
109	Tank RRN #	Numeric	9	1109	9	Tank RRN number associated to delivery. If payment, field will be blank
110	Cust Div/Jrnl Num	Numeric	6	1119	6	2-digit Customer Division number and last 4 digits of journal number Custom Field for interface to Mas90/Sage
111	TranCD/Jrnl Num	Numeric	6	1126	6	2-digit transaction code and last 4 digits of journal number Custom Field for interface to Mas90/Sage
112	Total Tax Accum	Numeric	9.2	1133	13	Accumulated total of taxes listed in column 20 of HLI item file Custom Field for interface to Mas90/Sage
113	Card ID #	Numeric	20	1147	20	Card ID # associated with CardTrol sale
114	Tank Master RRN	Numeric	9	1168	9	Master Tank RRN that remains with the tank regardless of what customer it’s currently attached to. Typically utilized for company owned tanks
115	Truck Number	Numeric	9	1178	9	Truck assigned to delivery of pumpable product (Department Table, Gas Dept – Y)
116	Void Transaction	Alpha	1	1188	1	V if Voided Transaction
117	Warehouse ID	Numeric	4	1190	4	Warehouse ID associated with inventory sale
118	Sales Tax Code 11	Numeric	4	604	4	From the sales tax code 11 maintenance file
119	Sales Tax Amount 11	Numeric	N5.2	609	9	Sales tax amount 11 (sales Posting, sales history line item)
120	Sales Tax Code 12	Numeric	4	619	4	From the sales tax code 12 maintenance file
121	Sales Tax Amount 12	Numeric	N5.2	624	9	Sales tax amount 12 (sales Posting, sales history line item)
122	Sales Tax Code 13	Numeric	4	634	4	From the sales tax code 13 maintenance file
123	Sales Tax Amount 13	Numeric	N5.2	639	9	Sales tax amount 13 (sales Posting, sales history line item)
124	Sales Tax Code 14	Numeric	4	649	4	From the sales tax code 14 maintenance file
125	Sales Tax Amount 14	Numeric	N5.2	654	9	Sales tax amount 14 (sales Posting, sales history line item)
126	Sales Tax Code 15	Numeric	4	664	4	From the sales tax code 15 maintenance file
127	Sales Tax Amount 15	Numeric	N5.2	669	9	Sales tax amount 15 (sales Posting, sales history line item)

Daily Clear Export Technical Specifications

#4 — Standard

#5 — Standard (Agvance only)

#10 — AgTrax

#12 — Standard Plus

Related Articles