Daily Clear Export Technical Specifications

Reference Documentation: Daily Clear History Transaction File Technical Specifications.

Scope: Provide customer daily sales processed in Energy Force for import into an external accounting system.

Technical: Provides a fixed width file for import. The file generated starts with PM and then the division number, month, day and time with extension of .dat. Dates have slashes and credit amounts will be indicated with a negative in from of the amount. Dollar Amounts will not have a dollar symbol.

Reason for Modification: Addition of Positions 115 & 116

Details of Modification: Position 115 added for the export of truck number associated to delivery gallons. Position 116 indicates if line-item entry has been voided with a V.

Date of Modification: January 2021

Version: 1.0

Approved: January 2021

	Field Name	Attribute	Picture	Start Position	Size	Comments
1	History RRN	Numeric	9C	1	11	Unique number assigned by SSI
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 +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. Needs 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 amt 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 tate
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 & 16.
107	Budget Bill Type	Alpha	2	1015	2	If Budget = 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 a V if Voided Transaction

Daily Clear Export Technical Specifications

Related Articles