Search Posts

Invoice Information (b .shr file)

Print Friendly, PDF & Email

This information is taken from your invoicing files and it shows your daily invoicing activities. It corresponds directly with the information you enter into your POS system on the Invoicing and Cashier screens. The employee ID and reason code for appropriate transactions will also be exported. To generate this file during End of Day, Invoice Information must be set to Y in getdata (see Setting Up Data Sharing) and an invoice must be cashed out for today’s date.

File Naming Convention

The following table explains the naming conventions of the invoice information data share file: #####b[md].shr

Field Definition
##### Store Number
b This character denotes that the file contains invoice information.
m This character denotes the month. The characters range from a to l and are as follows:

a = January d = April g = July j = October
b = February e = May h = August k = November
c = March f = June i = September l = December
d This character denotes the day. The characters range from a to z and 1 to 5 and are as follows:

a = 1 e = 5 i = 9 m = 13 q = 17 u = 21 y = 25 3 = 29
b = 2 f = 6 j = 10 n = 14 r = 18 v = 22 z = 26 4 = 30
c = 3 g = 7 k = 11 o = 15 s = 19 w = 23 1 = 27 5 = 31
d = 4 h = 8 l = 12 p = 16 t = 20 x = 24 2 = 28

File Contents

The following is an example of an actual record in what is known as “comma-delimited” format. This means that the information you entered in each field in this POS system record is separated by a comma.

“1”,”98012300087933″,”01/23/98″,”87933″,””,”0″,”8″,”0″,”2″,”8″,”10″,…

We have numbered the fields in the following record in order to explain them more clearly to you. Each bolded number indicates one field.

Note: Some of the fields contained in this file are for internal system processing only and may not be useful to you.

 

1 2 3 4 5 6 7 8 9 10 11 12 13
“1” “98012300087933” “01/23/1998” “87933” “” “0” “8” “0” “2” “8” “10” “6” “MP”
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
“AJ” “BH” “MP” “5” “0” “0” “0” “0” “1” “1” “1” “0” “1” “0” “0” “0” “0” “0”
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
“0” “0” “0” “0” “-1” “-1” “0” “0” “0” “0” “0” “0” “0” “36.98” “0” “26.48” “10.5”
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
“1.32” “0.09” “0” “0” “0” “0” “0” “0” “0” “0” “38.39” “0” “0” “” “” “” “” “”
67 68 69 70 71 72 73 74 75 76 77 78 79
“ROB101 L” “Y” “1” “1” “94020” “75695” “” “Y” “AR-PAT558” “” “” “” “”
80 81 82 83 84 85 86 87 88 89
“Declined Service” “ISI” “0” “0” “0” “0” “0” “1” ”XXXXXXXXXXXX4375” “123”
90 91 92 93 94 95 96 97 98 99 100 101 102
“” “12.00” “XXXXXXXXXXXX2397” “123” “” “22.50” “” “” “” “0” “” “” “”

 

103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
“0” “” “” “” “0” “38.00” “27.50” “0” “0” “0” “S” “-1” “FFS” “1” “11/15/2009”

 

118 119 120 121 122 123 124 125 126 127
“09” “32” “46” “11/15/2009” “09” “52” “34” “Driver’s Name” “John Doe” “LicenseNum”
128 129 130 131 132 133 134
“1234567” “Driver’s Birthdate” “03/15/1975” “Vehicle Color” “Blue” “FleetID Num” “5635799”
135 136 137 138 139 140 141 142 143 144 145 146
“Driver Phone” “800-922-3099” “” “” “” “” “Y” “” “” “” “” “BIL”
147 148 149 150 150 151 152 153 154 155 156 157 158
“” “TOM” “” “BOB” “” “SKQQHG0113” “GENERAL”” “” “” “” “” “” “”
159 160 161 162 163 164 165 166 167 168 169 170 171
“” “” “” “” “” “” “” “” “” “” “” “” “”
172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188
“” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “”
189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205
“” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “”
206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222
“ “” “” “” “” “” “” “” “” “” “” “” “” “” “” “” “”
223 224 225 226 227 228 229 230 231 232 233 234
“” “” “” “” “ROB101” “L” “” “” “” “03/15/1975” “Y” “650000.00”
Num. Description Definition ISI Field Name Output Format* Quoted? Example Value General Release Version When Modified
1 Store Number Store number that generated the invoice. inf0.store_nbr #(5) X 1 6.830
2 Invoice Transaction Number The transaction number of the invoice. inf1.trannnumber #(14) X 98012300087933 6.830
3 Date The date the invoice was created. inf1.date ##/##/#### X 1/ 23/1998 6.830
4 Invoice Number The number of the printed invoice. inf1.invoice #(8) X 87933 6.830
5 Gift Certificate/Card ID The tracking number for a gift certificate used on this invoice. inf1.gcrtid X(16) X  6.830
6 Department Number Unused inf1.dept #(4) X 0  6.830
7 Start Hour The hour when servicing begins. inf1.starthh #(2) X 8  6.830
8 Start Minute The minute when servicing begins. inf1.startmm #(2) X 0  6.830
9 Start Second The second when servicing begins. inf1.startss #(2) X 2  6.830
10 End Hour The hour when the vehicle is finished being serviced. inf1.endhh #(2) X 8  6.830
11 End Minute The minute when a vehicle is finished being serviced. inf1.endmm #(2) X 10  6.830
12 End Second The second when a vehicle is finished being serviced. inf1.endss #(2) X 6  6.830
13 Employee 1 The ID of the employee assigned to position 1 for an invoice. inf1.empl1 X(10) X MP  6.830
14 Employee 2 The ID of the employee assigned to position 2 for an invoice. inf1.empl2 X(10) X AJ  6.830
15 Employee 3 The ID of the employee assigned to position 3 for an invoice. inf1.empl3 X(10) X BH  6.830
16 Employee 4 The ID of the cashier who cashed out the invoice. inf1.empl4 X(10) X MP  6.830
17 Checkpoint Code The ID of the checkpoint set being used for an invoice. inf1.chkpt_code #(2) X 5  6.830
18 Checkpoint Response 1 The numeric value of the response for checkpoint 1. inf1.chkresp #(2) X 0  6.830
19 Checkpoint Response 2 The numeric value of the response for checkpoint 2. inf1.chkresp1 #(2) X 0  6.830
20 Checkpoint Response 3 The numeric value of the response for checkpoint 3. inf1.chkresp2 #(2) X 0  6.830
21 Checkpoint Response 4 The numeric value of the response for checkpoint 4. inf1.chkresp3 #(2) X 0  6.830
22 Checkpoint Response 5 The numeric value of the response for checkpoint 5. inf1.chkresp4 #(2) X 1  6.830
23 Checkpoint Response 6 The numeric value of the response for checkpoint 6. inf1.chkresp5 #(2) X 1  6.830
24 Checkpoint Response 7 The numeric value of the response for checkpoint 7. inf1.chkresp6 #(2) X 1  6.830
25 Checkpoint Response 8 The numeric value of the response for checkpoint 8. inf1.chkresp7 #(2) X 0  6.830
26 Checkpoint Response 9 The numeric value of the response for checkpoint 9. inf1.chkresp8 #(2) X 1  6.830
27 Checkpoint Response 10 The numeric value of the response for checkpoint 10. inf1.chkresp9 #(2) X 0  6.830
28 Checkpoint Response 11 The numeric value of the response for checkpoint 11. inf1.chkresp10 #(2) X 0  6.830
29 Checkpoint Response 12 The numeric value of the response for checkpoint 12. inf1.chkresp11 #(2) X 0  6.830
30 Checkpoint Response 13 The numeric value of the response for checkpoint 13. inf1.chkresp12 #(2) X 0  6.830
31 Checkpoint Response 14 The numeric value of the response for checkpoint 14. inf1.chkresp13 #(2) X 0  6.830
32 Checkpoint Response 15 The numeric value of the response for checkpoint 15. inf1.chkresp14 #(2) X 0  6.830
33 Checkpoint Response 16 The numeric value of the response for checkpoint 16. inf1.chkresp15 #(2) X 0  6.830
34 Checkpoint Response 17 The numeric value of the response for checkpoint 17. inf1.chkresp16 #(2) X 0  6.830
35 Checkpoint Response 18 The numeric value of the response for checkpoint 18. inf1.chkresp17 #(2) X 0  6.830
36 Checkpoint Response 19 The numeric value of the response for checkpoint 19. inf1.chkresp18 #(2) X -1  6.830
37 Checkpoint Response 20 The numeric value of the response for checkpoint 20. inf1.chkresp19 #(2) X -1  6.830
38 Notes The numeric value of the response for a comment. inf1.note #(2) X 0  6.830
39 Notes The numeric value of the response for a comment. inf1.note1 #(2) X 0  6.830
40 Notes The numeric value of the response for a comment. inf1.note2 #(2) X 0  6.830
41 Notes The numeric value of the response for a comment. inf1.note3 #(2) X 0  6.830
42 Notes The numeric value of the response for a comment. inf1.note4 #(2) X 0  6.830
43 Notes The numeric value of the response for a comment. inf1.note5 #(2) X 0  6.830
44 Notes The numeric value of the response for a comment. inf1.note6 #(2) X 0  6.830
45 Invoice Gross Amount The gross amount of the invoice. inf1.gross #(6).#(2) X 36.98  22.4
46 Invoice Warranty Amount The total warranty amount of the invoice. inf1.warr #(6).#(2) X 0 22.4
47 Taxable The taxable amount under the user defined parameters for tax 1. inf1.taxbl #(6).#(2) X 26.48 22.4
48 Nontaxable The nontaxable amount under the user defined parameters for tax 1. inf1.nontx #(6).#(2) X 10.5 22.4
49 Invoice Tax 1 The total amount on the invoice for tax 1. inf1.tax1 #(6).#(2) X 1.32 22.4
50 Invoice Tax 2 The total amount on the invoice for tax 2. inf1.tax2 #(6).#(2) X 0.09 22.4
51 Invoice Tax 3 The total amount on the invoice for tax 3. inf1.tax3 #(6).#(2) X 0 22.4
52 Invoice Tax 4 The total amount on the invoice for tax 4. inf1.tax4 #(6).#(2) X 0 22.4
53 Invoice Tax 5 The total amount on the invoice for tax 5. inf1.tax5 #(6).#(2) X 0 22.4
54 Invoice Gift Redemption Amount The dollar value of the gift certificate/card applied to an invoice. inf1.giftcert #(6).#(2) X 0 22.4
55 Invoice Cash Amount The total amount of cash applied to an invoice. inf1.cash #(6).#(2) X 0 22.4
56 Invoice Check 1 Amount The check amount tendered for an invoice. inf1.check #(6).#(2) X 0 22.4
57 Invoice Check 2 Amount The travelers check amount tendered for an invoice. inf1.check2 #(6).#(2) X 0 22.4
58 Invoice Credit Card Amount The total amount charged to the customer’s credit card for an invoice. inf1.crcard #(6).#(2) X 0 22.4
59 Invoice Charge Amount The total amount charged to a fleet customer for an invoice. inf1.charge #(6).#(2) X 38.39 22.4
60 Invoice Check 1 Number The check number of the tendered check. inf1.chknum X(11) X 0  6.830
61 Invoice Check 2 Number Unused inf1.chk2num #(12) X 0  6.830
62 Credit Card Code The code identifying the type of credit card. inf1.crcode X(4) X  6.830
63 Credit Card Number The number of the customer’s credit card being applied to an invoice. inf1.crcardnum X(19) X  6.830
64 Credit Card Approval The expiration date of the credit card being applied to the invoice. inf1.crcardexp X(5) X  6.830
65 Credit Card Approval The approval code returned for the credit card being applied to an invoice. inf1.crcardaprvl X(10) X  6.830
66 Gift Certificate Type The inventory ID of a gift certificate/card used on the invoice. inf1.gc_type X(10) X  6.830
67 Charge ID The Charge Customer’s ID, if applicable. inf1.chgnum X(10) X ROB101 L  6.830
68 Repeat Customer Flag indicating that this was a repeat customer. inf1.repeat X(1) X Y  6.830
69 Bay Number The number of the bay that completed the invoiced services. inf1.bay #(2) X 1  6.830
70 Till Number The number of the till used to cash out an invoice. inf1.till #(2) X 1  6.830
71 Odometer The odometer reading of the vehicle being serviced. inf1.miles #(8) X 94020  6.830
72 Invoice Work Order Number The number of the work order as generated by the POS system. inf1.wo# #(8) X 75695  6.830
73 Process Code Codes for the processes shown in the chart below:

A Abort

D Delete

H Hold

M Midday Till Closing

N No Sale

O Work Order

Q Quick Sale

R Reprint

V Void

C Refund

(blank) Regular or manual invoice

Note: By default, the following codes will be available:

Q Quick Sale

V Void

(blank) Regular or manual invoice

If you wish to receive all codes, answer Y to Include all processed codes on the Data Sharing Setup screen.

 inf1.processed X(1) X  22.6
74 Include in Store Ticket Average Indicates whether or not the invoice is a store ticket. inf1.sta X(1) X Y  6.830
75 Vehicle ID The ID of the vehicle that generated the invoice. inf1.vehid X(13) X AR-PAT558  6.830
76 Driver’s License Number The driver’s license number of the customer. inf1.chkdrlic X(25) X  6.830
77 Gender Indicates the gender of the customer that initiated the invoice. inf1.gender X(1) X  6.830
78 Gift Sales Dollar amount of gift sales on the invoice. inf1.gcsales #(6).#(2) X 22.4
79 System Date The system date on which the transaction was processed. This date will be populated for transactions with processed codes Q, V, (blank). inf1.system_date ##/##/#### X  6.830
80 Reason entered The reason for the declined service. inf1.po X(20) X Declined Service  6.830
81 Employee ID The employee ID is entered for this transaction. inf1.empl4 X(10) X ISI  6.830
82 Tax Exempt Number 1 Tax exempt number (if any) used for tax 1 on the invoice. inf1.taxexmptnum X(15) X 0  6.830
83 Tax Exempt Number 2 Tax exempt number (if any) used for tax 2 on the invoice. inf1.taxexmptnum2 X(15) X 0  6.830
84 Tax Exempt Number 3 Tax exempt number (if any) used for tax 3 on the invoice. inf1.taxexmptnum3 X(15) X 0  6.830
85 Tax Exempt Number 4 Tax exempt number (if any) used for tax 4 on the invoice. inf1.taxexmptnum4 X(15) X 0  6.830
86 Tax Exempt Number 5 Tax exempt number (if any) used for tax 5 on the invoice. inf1.taxexmptnum5 X(15) X 0  6.830
87 Number of invoice pages Number of pages that the invoice spans inf1.num_pages #(1) X 1  6.830
88 Masked Gift Card #1 First (masked) GC # redeemed on the invoice. inf1.gccardnum X(19) X XXXXXXXXXXXX4375  6.830
89 Gift Card #1 Approval Approval code of first GC redeemed on the invoice. inf1.gccardaprvl X(10) X 123  6.830
90 Gift Card #1 Reference Number Reference number for this GC transaction. inf1.gccardref X(10) X  6.830
91 Gift Card #1 Available Balance Available balance remaining on GC after the charge inf1.gcavailbal #(6.2) X 12.00 22.4
92 Masked Gift Card #2 Second (masked) GC # redeemed on the invoice. inf1.gccardnum2 X(19) X XXXXXXXXXXXX2397  6.830
93 Gift Card #2 Approval Approval code of second GC redeemed on the invoice. inf1.gccardaprvl2 X(10) X 123  6.830
94 Gift Card #2 Reference Number Reference number for this GC transaction. inf1.gccardref2 X(10) X  6.830
95 Gift Card #2 Available Balance Available balance remaining on GC after the charge inf1.gcavailbal2 #(6.2) X 22.50 22.4
96 Masked Gift Card #3 Third (masked) GC # redeemed on the invoice. inf1.gccardnum3 X(19) X  6.830
97 Gift Card #3 Approval Approval code of third GC redeemed on the invoice. inf1.gccardaprvl3 X(10) X  6.830
98 Gift Card #3 Reference Number Reference number for this GC transaction. inf1.gccardref3 X(10) X  6.830
99 Gift Card #3 Available Balance Available balance remaining on GC after the charge. inf1.gcavailbal3 #(6.2) X 0 22.4
100 Masked Gift Card #4 Fourth (masked) GC # redeemed on the invoice. inf1.gccardnum4 X(19) X  6.830
101 Gift Card #4 Approval Approval code of fourth GC redeemed on the invoice. inf1.gccardaprvl4 X(10) X  6.830
102 Gift Card #4 Reference Number Reference number for this GC transaction. inf1.gccardref4 X(10) X  6.830
103 Gift Card #4 Available Balance Available balance remaining on GC after the charge. inf1.gcavailbal4 #(6.2) X 0 22.4
104 Masked Gift Card #5 Fifth (masked) GC # redeemed on the invoice. inf1.gccardnum5 X(19) X  6.830
105 Gift Card #5 Approval Approval code of fifth GC redeemed on the invoice. inf1.gccardaprvl5 X(10) X  6.830
106 Gift Card #5 Reference Number Reference number for this GC transaction. inf1.gccardref5 X(10) X  6.830
107 Gift Card #5 Available Balance Available balance remaining on GC after the charge. inf1.gcavailbal5 #(6.2) X 0 22.4
108 Gift Card #1 Charge Amount The amount charged on GC 1 inf1.giftcard1 #(6.2) X 38.00 22.4
109 Gift Card #2 Charge Amount The amount charged on GC 2 inf1.giftcard2 #(6.2) X 27.50 22.4
110 Gift Card #3 Charge Amount The amount charged on GC 3 inf1.giftcard3 #(6.2) X 0 22.4
111 Gift Card #4 Charge Amount The amount charged on GC 4 inf1.giftcard4 #(6.2) X 0 22.4
112 Gift Card #5 Charge Amount The amount charged on GC 5 inf1.giftcard5 #(6.2) X 0 22.4
113 Credit Card Flag “S” – Swiped, “M” – Manual, “N” – User Entered Approval inf1.cc_flag X(1) X S  6.830
114 Club Program Visit Count Change The number used to reverse the Visit Count if the invoice is voided. inf1.club_inc #(2) X -1  6.830
115 Club Program ID Club Program ID associated with invoice. inf1.club_id X(10) X FFS  6.830
116 Club Program Visits Club Program visits at the time of this invoice. inf1.club_visits #(2) X 1  6.830
117 Work Order Creation Date The date the work order was created. inf1.wo_start_date ##/##/#### X 11/15/2009  6.830
118 Work Order Creation Hour inf1.wo_start_hh #(2) X 09  6.830
119 Work Order Creation Minute These three separate fields are the time at which the work order was created. For any vehicle being entered at the Greeter Station and new vehicles being entered at the Bay Invoicing Station, it is the time at which the user hits the [Enter] key on the “OK to Continue” message just after entering the Vehicle ID. For an existing vehicle being entered from the Bay Invoicing Station, it is the time after the user hits the [Enter] key to go from the Vehicle Information screen to the first ESM screen. inf1.wo_start_mm #(2) X 32  6.830
120 Work Order Creation Second inf1.wo_start_ss #(2) X 46  6.830
121 Invoice Cash Out Date The date the invoice was cashed out. inf1.ringout_date ##/##/#### X 11/15/2009  6.830
122 Invoice Cash Out Hour The hour the invoice was cashed out. inf1.ringout_hh #(2) X 09  6.830
123 Invoice Cash Out Minute The minute the invoice was cashed out. inf1.ringout_mm #(2) X 52  6.830
124 Invoice Cash Out Second The second the invoice was cashed out. inf1.rintout_ss #(2) X 34  6.830
125 Fleet Input Description 1 First input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Driver’s Name  6.830
126 Fleet Input Description Response 1 Response entered during invoicing. inf1j.entry X(30) X John Doe  6.830
127 Fleet Input Description 2 Second input description in Set Up Charge Customers. inarf1ji.indesc X(30) X LicenseNum  6.830
128 Fleet Input Description Response 2 Response entered during invoicing. inf1j.entry1 X(30) X 1234567  6.830
129 Fleet Input Description 3 Third input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Driver’s Birthdate  6.830
130 Fleet Input Description Response 3 Response entered during invoicing. inf1j.entry2 X(30) X 03/15/1975  6.830
131 Fleet Input Description 4 Fourth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Vehicle Color  6.830
132 Fleet Input Description Response 4 Response entered during invoicing. inf1j.entry3 X(30) X Blue  6.830
133 Fleet Input Description 5 Fifth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X FleetID Num  6.830
134 Fleet Input Description Response 5 Response entered during invoicing. inf1j.entry4 X(30) X 5635799  6.830
135 Fleet Input Description 6 Sixth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Driver Phone  6.830
136 Fleet Input Description Response 6 Response entered during invoicing. inf1j.entry5 X(30) X 800-922-3099  6.830
137 Fleet Input Description 7 Seventh input description in Set Up Charge Customers. inarf1ji.indesc X(30) X  6.830
138 Fleet Input Description Response 7 Response entered during invoicing. inf1j.entry6 X(30) X  6.830
139 Fleet Input Description 8 Eighth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X  6.830
140 Fleet Input Description Response 8 Response entered during invoicing. inf1j.entry7 X(30) X 6.830
141 Email Opt In Response entered on marketing popup during invoicing or cashiering inf1.email_opt_in X(1) X Y 11.2
142 Position 1 UID The UID of the employee assigned to position 1 on the invoice. hrfp.employee_uid X(20) X 11.2
143 Position 2 UID The UID of the employee assigned to position 2 on the invoice. hrfp.employee_uid X(20) X 11.2
144 Position 3 UID The UID of the employee assigned to position 3 on the invoice. hrfp.employee_uid X(20) X 11.2
145 Cashier UID The UID of the employee assigned to cashier on the invoice hrfp.employee_uid X(20) X 11.2
146 Employee ID Position 4 The employee ID for position 4 entered for this transaction. inf1.empl5 X(10) X BIL 11.7
147 Position 4 UID The UID of the employee assigned to position 4 on the invoice. hrfp.employee_uid X(20) X 11.7
148 Employee ID Position 5 The employee ID for position 5 entered for this transaction. inf1.empl6 X(10) X TOM 11.7
149 Position 5 UID The UID of the employee assigned to position 5 on the invoice. hrfp.employee_uid X(20) X 11.7
150 Employee ID Position 6 The employee ID for position 6 entered for this transaction. inf1.empl7 X(10) X BOB 11.7
151 Position 6 UID The UID of the employee assigned to position 6 on the invoice. hrfp.employee_uid X(20) X 11.7
152 Tire DOT# 1 The tire DOT# entered during invoicing. inf1dot.dot X(15) X SKQQHG0113 11.14
153 Tire Brand 1 The tire brand chosen during invoicing inf1dot.brand X(12) X GENERAL 11.14
154 Tire DOT# 2 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
155 Tire Brand 2 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
156 Tire DOT# 3 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
157 Tire Brand 3 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
158 Tire DOT# 4 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
159 Tire Brand 4 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
160 Tire DOT# 5 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
161 Tire Brand 5 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
162 Tire DOT# 6 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
163 Tire Brand 6 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
164 Tire DOT# 7 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
165 Tire Brand 7 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
166 Tire DOT# 8 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
167 Tire Brand 8 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
168 Tire DOT# 9 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
169 Tire Brand 9 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
170 Tire DOT# 10 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
171 Tire Brand 10 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
172 Tire DOT# 11 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
173 Tire Brand 11 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
174 Tire DOT# 12 The tire DOT# entered during invoicing. inf1dot.dot X(15) X 11.14
175 Tire Brand 12 The tire brand chosen during invoicing inf1dot.brand X(12) X 11.14
176 Vehicle Unique ID Vehicle Unique ID used by ISI Central vehicle sharing mkf1.unique_id #(14) X 15.4
177 Transaction Type Code #1 Transaction Type Code #1 inf1cc2.trans_type X(4) X 15.11
178 Card Type Code #1 The identifying code set up for the credit card network (e.g. Visa, MasterCard) for card #1. inf1cc2.card_type X(4) X 15.11
179 Amount #1 The dollar amount charged to card #1. inf1cc2.amount #(6.2) X 22.4
180 Date #1 The date card #1 was charged. inf1cc2.date ##/##/#### X 15.11
181 Hour #1 The hour when card #1 was charged. inf1cc2.hh #(2) X 15.11
182 Minute #1 The minute when card #1 was charged. inf1cc2.mm #(2) X 15.11
183 Second #1 The second when card #1 was charged. inf1cc2.ss #(2) X 15.11
184 Method of Entry #1 Method of Entry #1 inf1cc2.method X(1) X 15.11
185 Approval Code #1 The approval code for card #1. inf1cc2.approval X(10) X 15.11
186 Last 4 of Card #1 Last 4 digits of card #1. inf1cc2.last4 X(4) X 15.11
187 Transaction Type Code #2 Transaction Type Code #2 inf1cc2.trans_type X(4) X 15.11
188 Card Type Code #2 The identifying code set up for the credit card network (e.g. Visa, MasterCard) for card #2. inf1cc2.card_type X(4) X 15.11
189 Amount #2 The dollar amount charged to card #2. inf1cc2.amount #(6.2) X 22.4
190 Date #2 The date card #2 was charged. inf1cc2.date ##/##/#### X 15.11
191 Hour #2 The hour when card #2 was charged. inf1cc2.hh #(2) X 15.11
192 Minute #2 The minute when card #2 was charged. inf1cc2.mm #(2) X 15.11
193 Second #2 The second when card #2 was charged. inf1cc2.ss #(2) X 15.11
194 Method of Entry #2 Method of Entry #2 inf1cc2.method X(1) X 15.11
195 Approval Code #2 The approval code for card #2. inf1cc2.approval X(10) X 15.11
196 Last 4 of Card #2 Last 4 digits of card #5. inf1cc2.last4 X(4) X 15.11
197 Transaction Type Code #3 Transaction Type Code #3 inf1cc2.trans_type X(4) X 15.11
198 Card Type Code #3 The identifying code set up for the credit card network (e.g. Visa, MasterCard) for card #3. inf1cc2.card_type X(4) X 15.11
199 Amount #3 The dollar amount charged to card #3. inf1cc2.amount #(6.2) X 22.4
200 Date #3 The date card #3 was charged. inf1cc2.date ##/##/#### X 15.11
201 Hour #3 The hour when card #3 was charged. inf1cc2.hh #(2) X 15.11
202 Minute #3 The minute when card #3 was charged. inf1cc2.mm #(2) X 15.11
203 Second #3 The second when card #3 was charged. inf1cc2.ss #(2) X 15.11
204 Method of Entry #3 Method of Entry #3 inf1cc2.method X(1) X 15.11
205 Approval Code #3 The approval code for card #3. inf1cc2.approval X(10) X 15.11
206 Last 4 of Card #3 Last 4 digits of card #3. inf1cc2.last4 X(4) X 15.11
207 Transaction Type Code #4 Transaction Type Code #4 inf1cc2.trans_type X(4) X 15.11
208 Card Type Code #4 The identifying code set up for the credit card network (e.g. Visa, MasterCard) for card #4. inf1cc2.card_type X(4) X 15.11
209 Amount #4 The dollar amount charged to card #4. inf1cc2.amount #(6.2) X 22.4
210 Date #4 The date card #4 was charged. inf1cc2.date ##/##/#### X 15.11
211 Hour #4 The hour when card #4 was charged. inf1cc2.hh #(2) X 15.11
212 Minute #4 The minute when card #4 was charged. inf1cc2.mm #(2) X 15.11
213 Second #4 The second when card #4 was charged. inf1cc2.ss #(2) X 15.11
214 Method of Entry #4 Method of Entry #4 inf1cc2.method X(1) X 15.11
215 Approval Code #4 The approval code for card #4. inf1cc2.approval X(10) X 15.11
216 Last 4 of Card #4 Last 4 digits of card #4. inf1cc2.last4 X(4) X 15.11
217 Transaction Type Code #5 Transaction Type Code #5 inf1cc2.trans_type X(4) X 15.11
218 Card Type Code #5 The identifying code set up for the credit card network (e.g. Visa, MasterCard) for card #5. inf1cc2.card_type X(4) X 15.11
219 Amount #5 The dollar amount charged to card #5. inf1cc2.amount #(6.2) X 22.4
220 Date #5 The date card #5 was charged. inf1cc2.date ##/##/#### X 15.11
221 Hour #5 The hour when card #5 was charged. inf1cc2.hh #(2) X 15.11
222 Minute #5 The minute when card #5 was charged. inf1cc2.mm #(2) X 15.11
223 Second #5 The second when card #5 was charged. inf1cc2.ss #(2) X 15.11
224 Entry Method #5 Method of Entry #5 inf1cc2.method X(1) X 15.11
225 Approval Code #5 The approval code for card #5. inf1cc2.approval X(10) X 15.11
226 Last 4 of Card #5 Last 4 digits of card #5. inf1cc2.last4 X(4) X 15.11
227 Fleet ID The charge customer’s ID, if applicable inf1.fleet_id X(9) X “ROB101” 15.15
228 Fleet Type The type of charge customer, if vehicle is attached to a fleet. L local

N national

 inf1.fleet_type X(1) X “L” 15.15
229 Txt2pay Status The status of the txt2pay payment request. inf1.t2p_status X(1) X 22.1
230 Txt2pay UID A UID for the invoice when using txt2pay tender inf1.uid X(36) X 22.1
231 Original Transaction Number Original transaction number of refunded invoice orig_tran #(14) X 98012300087933 22.6
232 Start Date The date when servicing begins. inf1.startdate ##/##/#### X ##/##/#### 22.6
233 Event Created Flag This flag signals a successful publish of that event evt_created X(1) X “‘Y” 22.8
234 Change Due Change due when an invoice is cashed out inf1.change #(6.2) X 650000.00 22.9

* The Output Format column uses X to represent string fields and # to represent numeric fields. E.g. X(5) represents a string up to five characters in length. #(14) represents a number up to 14 digits in length.