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

#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.

#11 — Activant_Epicor

This interface does not support Voids in Energy Force.

The following pages describe the two record types that will be uploaded to Eagle from foreign systems as POS transactions. Each record is terminated by a newline. Header and detail records are to be passed in one file with detail record(s) following each header.

Format: COBOL notation is used. All "x" fields are considered unformatted text. Justification is usually left, but not required. "9" fields are numeric with the "v" representing an implied decimal point and "±" representing the sign ("+" or "-"). Numeric ("9") fields are right-justified, left-zero filled.
Example: 112.40 in a field with a format of 9(4)v9(3)± should be 0112400+.

Required

Five codes are used:

R — This field is required. The entire transaction will reject if this field is blank or invalid.
D— This field is will be filled with a default value if blank or invalid.
E— This field will be filled in with the current value from Eagle regardless of value in the incoming data.
B— This field is optional and may be left blank.
Z— This field is optional and will be zero if left blank.

11.13.13 Payment comments from David Watson :

If you don’t assign the + or - character the system will assume a +. The amounts would always be a + on a payment.

Be aware, the amounts always need to be justified as if the + or – is there…

9 characters for the amount and the 10^th character is a + or – or space

Header Record (H)

No.	Description	Size	Format	Req'd	Comments/Notes	Start/End	K & K
1	Record ID	1	x(01)	R	Always "H"	1-1
2	Transaction Date	8	9(08)	R	Date: MMDDYYYY of transaction. can this be master clear date? meaning when the master clear is done, not matter what the history date is, use master clear date here.	2-9	Histitem.historydate old New - Use master clear date
3	Transaction Time	6	9(06)	D	Time: HHMMSS of transaction.	10-15
4	Store Number	1	x(01)	D	Eagle (MSR) Store Number where the transactions should be posted.	16-16	Tank.location.code
5	Customer Number	6	9(06)	R	Eagle (MCR) Customer Number.	17-22	Histitem.customer number
6	Job Number	3	9(03)	D	Eagle (MCR) Customer Job Number. If customer.budget A I = A, and tank.TNK tank type code = P, then 002, otherwise 001. If histitem.transaction code – 15/16, then job no. = 003 Development - 1. if Contract trans type 15/16 and Bill type in contract file = 2, then job 002 2. If 15/16 and not bill type 3, then job 003 If bill type is not equal to 2 or 3, , then job 001, 3. If trans type 13/14, and customer.terms code = 1 or 2, then job 010, otherwise Job 1 for just a normal sale/charge 1.2.2014 1.20.14 (does not look at Budget = A/I anymore) Tank rent and trans 13 & 31 should follow same rules If budget bill type 2, then job 2, (in contracts) if bill type 3, then job 3, (in contracts) any additional contract type is Job 003 then if no contracts it looks at customer payment terms If terms code 1 or 2, then job 010, If terms 3 & 4, then job 001	23-25	Old - If customer.budget A I = A, and tank.TNK tank type code = P, then 006, otherwise 000. If histitem.transaction code – 15/16, and bill type = 3 for 100%prepaid contract, then job no. = 003 , otherwise if 15/16 trans cd and not bill type 3, then job no = 001 NEW Panhandle set up budgets as a contract with a specific bill type of 2, and then will = job 002. Meaning all budgets will be a contract bill type 2, and anytime a delivery is made to bill type 2 contract, then will = Job 002. And for Job 010 Use terms code 1&2 for PIA. The terms code would be sent in the daily customer file & updated in EF. At the time the sale is posted, they would still be a 1 or 2 as they still have monies in prepay (payment on hold). We would check if terms=1 or 2, then job 010
7	Tax Code	3	x(03)	D	Eagle (MTX) Tax Code. 11.11.13 this shd always be blank 11.25 if a credit is posted (EF 31) then tax shd be a plus per lansen.	26-28	Lansen hardcoding a 3 digit number for K&K to pass in daily clear. We will pass 3 digit if histitem.sales tax<> 0, just not = 0 use 111 for now
8	Sales Tax Rate	5	v9(5)	D	Tax rate charged.	29-33	Blank
9	Pricing Indicator	1	x(01)	D	Pricing indicator. Default is R. A=Average Cost, C=Cost, D=Discount Off Retail, G=Gross profit, L=List, M=Markup from Cost, R=Retail, Q=Retail w/o Qty Breaks, 1 - 5=Matrix Pricing.	34-34	R
10	Pricing Percent	4	v9(4)	Z	Percentage for Pricing Indicators D, G, or M.	35-38	Blank
11	Clerk	10	x(10)	D	Eagle (MUR) Clerk ID.	39-48	Blank
12	Purchase Order Number	12	x(12)	B	Required if customer requires a P.O.	49-60	Blank
13	Transaction Total	10	9(7)v9(2)	R	Total amount of transaction including the tax. Must equal sum of the detail record’s Extended Price plus the header record’s Total Sales Tax. Leave blank for orders.	61-70	Histitem.total amount
14	Sale Taxable	1	x(01)	E	"N"=Non-taxable sale. “Y”=Taxable Sale.	71-71	If histitem.sales tax is < or >0 0, then Y, otherwise N, meaning if sales tax = 0, then N.
15	Salesperson Number	2	x(02)	D	Eagle (MSL) Salesperson Code.	72-73	Histitem.driver number
16	Total Sales Tax	10	9(7)v9(2)	R	Sales Tax	74-83	Histitem.sales tax
17	* unused *	10	x(10)	B	Always Blank.	84-93	Blank
18	Instructions 1	30	x(30)	B	Special Instructions - Free format text	94-123
19	Instructions 2	30	x(30)	B	More special instructions	124-153
20	Ship-To Name	30	x(30)	B	Ship-To Name - Free format text	154-183
21	Ship-To Address 1	30	x(30)	B	Ship-To Street 1 - Free format text	184-213
22	Ship-To Address 2	30	x(30)	B	Ship-To Street 2 - Free format text	214-243
23	Ship-To Address 3	30	x(30)	B	Ship-To Street 3 - Free format text Split address line 3 as follows (15 for city, 1 blank space, 2 for state, 1 blank space, 10 for zip "12345-1234", 1 blank space. CITY (bytes 244 to 258) filler (byte 259) STATE (bytes 260 to 261) filler (byte 262) ZIP (bytes 263 to 272) filler (byte 273)	244-273
24	Reference Information	30	x(30)	B	Free format text. If Transaction Number (#33) is blank, this is moved to the POS reference field. 11.25.13 change ticket# to inv# to save spaces per lansed	274-303	EF mmddyy ticket# 9999999999 This will be EF ticket date & ticket number.Format exactly as shown below EF 100113 ticket# 1234565
25	Customer Telephone	10	x(10)	D	Customer Telephone #.	304-313
26	Customer Resale No.	19	x(19)	D	Customer Resale Number.	314-332
27	Customer ID	10	x(10)	E	Eagle (MCR) Customer Sort Name.	333-342
28	Special Order Vendor	5	x(05)	B	Eagle (MVR) Special Order Vendor Code. Valid on Special Orders only.	343-347
29	Total Deposit	10	9(7)v9(2)	Z	Valid on Orders/Special Orders Only.	348-357
30	Expected / Delivery Date	8	9(08)	D	Date: MMDDYYYY the Order will be delivered or the date the Special Order is expected to arrive. Valid on Orders/Special Orders Only.	358-365
31	Estimate Expiration Date	8	9(08)	D	Date: MMDDYYYY the estimate will expire. Valid on Estimates only.	366-373
32	Terminal Number	3	9(03)	D	Eagle terminal number. Defaults to upload terminal (PC) if blank or zero.	374-376
33	Transaction Number	8	x(08)	B	Transaction Identifier. Free format text which goes in the POS reference field. (Can’t use both field 24 & 33.)	377-384
34	Transaction Type	1	x(01)	D	Transaction Type. Assume "1" if blank. "1"=Cash Sale, "2"=Cash Credit Memo, "3"=Charge Sale, "4"=Charge Credit Memo, "5"=R.O.A. (Payment), "6"=Paid Out, "7"=Cash A Check, "8"=Open Cash Drawer, "9"=Voided Transaction, “E”=Estimate, “O”=Order, “S”=S/O. Terms 1, PIA job 010 Terms 2 PIA job 010 Terms 3,4 Job 001 11.18.13 changed to make a credit with a transaction code of 4 to report the line amounts as a positive+ not a negative based on Lansen request. The drivers will be trained to only take a payment from a PIA terms code 1 or 2 customer so we can default all payment from handhelds to job 009. They will not be posting manual payments from EF, but if the do, they would go to job 009. Even if driver takes a budget payment they will manually transfer jobs in Epicor. NOTE: Waiting for Epicor to advise, on a ROA, there will only be a header record, not a detail????? yes requires a detail record. David watson 10.2013 It was too easy… just a dead detail record (D in byte 1 and nothing else worked fine) H10302013 1038859001 5 000166563+123456 D I found this sample (attached) // adding a reference would probably be appropriate but this is the minimum requirements. There doesn’t appear to be any way to do ‘prompt payment discounts’ or ‘allowance amounts’ like a real ROA but I don’t believe you will need that functionality. H Date Store (if not “1”) Customer# / Job Trx Type “5” Tender amount in one of the fields (cash check bankcard) Mine has a Check Amount Tendered and the Check # History trans code for EF 21 = payment, 31 = credit\return, 15/16 = contract, 14 = delivery , 13 = sales/charge such as fees, parts, etc.	385-385	Will only use 1, 3,4 if histitem.transaction code = 31; then 4 If histitem.transaction code = 13-19;, then 3 If sales and Credit on same invoice and if total invoice 0 or >0 then 3, if <0 then 4. If histitem.transaction code = 11 or 12 or 21(payment), & then job 010 and send “5” for R.O.A. trans type to epicor Will not be using11/12
35	Total Cash Tendered	10	9(7)v9(2)	Z	It is not going to field 36, and payment needs to be a plus. We are now writing this to field 36 and it needs to be field 35 and the payment should be written as a positive not a negative according to lansen.	386-395	If payment only, this is amount of ROA. Which is the same as field 13. Histitem.total amount
36	Charge Tendered	10	9(7)v9(2)	Z		396-405
37	Change Given	10	9(7)v9(2)	Z		406-415
38	Total Check Tendered	10	9(7)v9(2)	Z	Note: used for "Cash A Check" too.	416-425
39	Check Number	6	9(06)	Z	Required if Check Tendered is not zero.	426-431
40	Bankcard Tendered	10	9(7)v9(2)	Z		432-441
41	Bankcard Number	16	x(16)	B	Required if Bankcard Tendered is not zero.	442-457
42	Apply-To Number	6	x(06)	B	A/R document to apply Credit/ROA to.	458-463
43	Third Party Vendor Code	2	x(02)	R	The CCITRIAD assigned code specifying the certified third party vendor product from which the import file was derived	464-465
44	Filler	16	X(16)	B	Spaces.	466-481

Detail Record (D)

No.	Description	Size	Format	Req'd	Comments/Notes	Start/End	K & K
1	Record ID	1	x(01)	R	Always "D".	1-1	D
2	Sku	14	x(14)	B	Eagle (IMU) Sku or blank for descriptor lines. Invalid Sku’s become descriptors.	2-15	Histitem.department number link to V9 dept cross.pm dept and pass V9 dept cross inventory no. If SKU blank, use Description as comment like 02 records in Agtrax
3	Item Transaction Type	1	x(01)	D	Type of item. Space = sale, "R"=return, "X"=exchange, "D"=defective return, else item is a sale. All items on a Credit Memo must be "R","D","X".	16-16	R = Discount PanHandle If transaction code in position 34 in histitem = 31, then R
4	Description	32	x(32)	D	If a description is supplied, it will be used. Otherwise, IMU description.	17-48	SKU = blank, tank.tank name SKU-blank, tank.tank serial no. Auto send both records on each delivery
5	Taxable	1	x(01)	D	“Y”=item is taxable, “ N"=item is not taxable. Defaults to Y if left blank.	49-49	If histitem.sales tax is <> 0, then Y, otherwise N, meaning if tax = 0 then N.
6	Pricing Flag (Promo/Discount).	1	x(01)	B	"D"=discount key pricing; "P"=promo key pricing; "Q"=quantity break pricing; "S"=item on promo; "*"=item is non-discountable; "1-5"=matrix pricing; Otherwise, retail priced.	50-50	Blank
7	Manual Price	1	x(01)	B	"M"=manually priced item.	51-51
8	Estimate Use Code	1	x(01)	B	Code to group like materials together. Must be blank if header’s Transaction Type is not E.	52-52
9	Trade Discount	1	x(01)	D	"Y"=trade discount can be applied to this item, else cannot be applied.	53-53
10	Discount Percent	5	v9(5)	Z	Item discount percent. Expected for "D", "P" and "Q" and Pricing. Blank or zero = none.	54-58
11	Special Order Vendor	5	x(05)	D	Not Necessary.	59-63
12	Unit Of Measure	2	x(02)	D	Not Necessary.	64-65
13	Quantity	8	9(5)v9(3)	R	Quantity of Units for the SKU.	66-73	Histitem.gallons< > 0, otherwise histitem.quantity parts
14	Unit Price	8	9(5)v9(3)	R	Price per Unit for the SKU.	74-81	Histitem.unit price
15	Extended Price	8	9(6)v9(2)	R	Price for all Units of the SKU. It is the Unit Price * Quantity, except in the case of slash pricing. It does not include tax.	82-89	Histitem.line amount
16	Unit Cost	8	9(5)v9(3)	E	Cost per Unit. (Gets overwritten with IMU current cost per MIC Cost Used in Calcs.	90-97

#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	Sales Tax Code 11	Numeric	4	604	4	From the sales tax code 11 maintenance file
59	Sales Tax Amount 11	Numeric	N5.2	609	9	Sales tax amount 11 (sales Posting, sales history line item)
60	Sales Tax Code 12	Numeric	4	619	4	From the sales tax code 12 maintenance file
61	Sales Tax Amount 12	Numeric	N5.2	624	9	Sales tax amount 12 (sales Posting, sales history line item)
62	Sales Tax Code 13	Numeric	4	634	4	From the sales tax code 13 maintenance file
63	Sales Tax Amount 13	Numeric	N5.2	639	9	Sales tax amount 13 (sales Posting, sales history line item)
64	Sales Tax Code 14	Numeric	4	649	4	From the sales tax code 14 maintenance file
65	Sales Tax Amount 14	Numeric	N5.2	654	9	Sales tax amount 14 (sales Posting, sales history line item)
66	Sales Tax Code 15	Numeric	4	664	4	From the sales tax code 15 maintenance file
67	Sales Tax Amount 15	Numeric	N5.2	669	9	Sales tax amount 15 (sales Posting, sales history line item)
68	Meter Serial Number	Alpha	U20	679	20	Serial Number for meter billing
69	Meter Type	Numeric	2	700	2	1 – Cubic Mtr, 2 – Cubic Ft mtr, 3 – 10x100 Meter, 4 – gallons
70	Cycle Code	Numeric	2	703	2	Meter Cycle Code utilized during billing
71	Current Last Billing Date	Date	MM/DD/YY	706	8	Current billing date for meter billing
72	Meter current Reading Date	Date	MM/DD/YY	715	8	Current reading date of meter billed
73	Last Meter Reading	Numeric	N7	724	8	Reading of the meter at the time of billing, negatives are allowed
74	Meter Active/Inactive	Alpha	1	733	1	A – Active or I – Inactive
75	Elevation Code	Numeric	3	735	3	Elevation Code assigned to meter
76	Meter Previous Reading Date	Date	MM/DD/YY	739	8	Previous meter reading date
77	Meter Previous Meter Reading	Numeric	N7	748	8	Previous meter reading billed. Negatives are allowed in this field
78	Cubic Amount Used (Meter)	Numeric	N6.2	757	10	Current cubic amount billed
79	Meter gallons used	Numeric	N5.2	768	9	Current meter gallons billed (If there is cubic amount it is converted to gallons)
80	Meter gallons price	Numeric	N5.4	778	11	Current price per gallon billed
81	Meter Charge Amount	Numeric	N9.2	790	13	Total meter amount charged
82	Reading Type	Alpha	U	804	1	C – Customer, P – Postcard, H – Handheld, M – Modem
83	Meter Voided item	Logical	5	806	5	True – voided, otherwise False.
84	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
85	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.
86	Discount Code	Numeric	3	833	3	Discount Code applied to gallons
87	Discount Line Amount	Numeric	N5.2	837	9	Discount line amount prior to taxes
88	Total Discount Allowed	Numeric	N5.2	847	9	Total discount with sales taxes
89	Discount Taken	Logical	5	857	5	False at the time of calculating. True if applied to payment
90	Discount Tax code 1	Numeric	4	863	4	Discount Tax code 1
91	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
92	Discount Tax Code 2	Numeric	4	877	4	Discount Tax code 2
93	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
94	Discount Tax Code 3	Numeric	4	891	4	Discount Tax code 3
95	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
96	Discount Tax Code 4	Numeric	4	905	4	Discount Tax code 4
97	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
98	Discount Tax Code 5	Numeric	4	919	4	Discount Tax code 5
99	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
100	Discount Code 6	Numeric	4	933	4	Discount Tax code 6
101	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
102	Discount Code 7	Numeric	4	947	4	Discount Tax code 7
103	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
104	Discount Code 8	Numeric	4	961	4	Discount Tax code 8
105	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
106	Discount Code 9	Numeric	4	975	4	Discount Tax code 9
107	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
108	Discount Code 10	Numeric	4	989	4	Discount Tax code 10
109	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
110	Alternate Customer ID	Alpha	U10	1003	10	Alternate Customer ID number from customer file import. Used if interface customer numbers are alpha character
111	Cash Sale Payment	Numeric	N6.2	1014	10	Net payment amount for Transaction Codes 11 & 12 (Cash Sales)
112	Delivery address	Alpha	U30	1025	30	Tank delivery address/Service Location address
113	Delivery city	Alpha	U25	1056	25	Tank delivery city or Service Location city
114	Delivery state	Alpha	U2	1082	2	Tank delivery state or Service Location state
115	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.
116	Contract Bill Type	Numeric	2	1087	2	Contract Bill Type code assigned to ticket for Transaction Codes 15 and 16.
117	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.
118	PO#	Alpha	15	1093	15	Purchase Order number
119	Tank RRN #	Numeric	9	1109	9	Tank RRN number associated to delivery. If payment, field will be blank
120	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
121	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
122	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
123	Card ID #	Numeric	20	1147	20	Card ID # associated with CardTrol sale
124	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
125	Truck Number	Numeric	9	1178	9	Truck assigned to delivery of pumpable product (Department Table, Gas Dept – Y)
126	Void Transaction	Alpha	1	1188	1	V if Voided Transaction
127	Warehouse ID	Numeric	4	1190	4	Warehouse ID associated with inventory sale