Search Posts

Fleet Setup Information (t .shr file)

Print Friendly, PDF & Email

The Fleet Setup information is taken from your fleet set up file and includes the set up information for all of your charge customers. To generate this file during End of Day, Fleet Setup Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one fleet must exist in charge customer setups.

File Naming Convention

The following table explains the naming conventions of the fleet setup data share file: #####t[md].shr

Field Definition
##### Store Number
t This character denotes that the file contains fleet setups.
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”,”ABC123″,”L”,”Joe’s Plumbing”,”15115 SW Sequoia Pkwy”,””,”97224″,”Portland”,”OR”,”503″,…

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
“1” “ABC123” “L” “Joe’s Plumbing” “15115 SW Sequoia Pkwy” “” “97224” “Portland” “OR” “503”
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
“968-8100” “” “” “” “John Doe” “B” “C” “Flt1” “” “” “” “” “” “” “”
27 28  29 30 31  32 33 34  35  36 37 38 39  40 41
 “”  “”  “” “”  “”  “”  “”  “”  “State Sales Tax” “” “”  “”  “”  “”  “”
42 43 44 45 46 47 48 49 50 51 52 …251 252
“” “” “” “” “” “” “” “” “A” “FS” “” “N” “Don’t vacuum out these vehicles”
253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268
“” “” “” “” “” “Driver’s DL#” “Y” “N” “” “” “” “” “” “” “” “”
269 270 271 272 273 274 275 …300
“” “Fleet Vehicle ID” “Y” “N” “” “” “” “”
301 302 …340
“” “” “”
341 …363 364 365 366 367 368 369 370 371 372 373 374 375 376
“” “” “2” “Y” “12/20/2018” “” “”
377 378 379 380 381 382 383 384  385  386
“fleetmanager@business.net” “billing@accountant.com” “” “” “” “” “” “” “” 0

The following chart lists and describes the contents of the (t) Fleet Setup Share file.

Num. Description Definition ISI Field Name Output Format* Quoted? Example Value General Release Version When Added
1 Store Number Store number where the file was created. inf0.store_nbr X(5) X 1 6.840
2 Fleet ID Fleet customer’s ID inarf1.cust X(10) X ABC123 6.840
3 Fleet Type Fleet type (L or N) inarf1.fleet_type X(1) X L 6.840
4 Fleet Name Full name of fleet customer inarf1.name X(30) X Joe’s Plumbing 6.840
5 Address Line 1 Line 1 of customer’s address inarf1.addr1 X(30) X 15115 SW Sequoia Pkwy 6.840
6 Address Line 2 Line 2 of customer’s address inarf1.addr2 X(30) X 6.840
7 Postal Code Address Zip/Postal code inarf1.zip X(10) X 97224 6.840
8 City Address city inarf1.city X(15) X Portland 6.840
9 State/Province Address state/province inarf1.state X(2) X OR 6.840
10 Area Code Telephone area code inarf1.areacode #4 X 503 6.840
11 Phone Number Last 7 digits of phone number inarf1.phone X(8) X 968-8100 6.840
12 DMS Account ADP account number inarf1.dms_account X(7) X 6.840
13 DMS Control 1 ADP control setting 1 inarf1.dms_ctrl X(17) X 6.840
14 DMS Control 2 ADP control setting 2 inarf1.dms_ctrl2 X(17) X 6.840
15 Fleet Contact Fleet contact name inarf1.contact X(30) X John Doe 6.840
16 Payment Type B for billed or C for cash inarf1.pmt_type X(1) X B 6.840
17 Coupon/Discount Type 1 C for coupon or D for discount inarf1.coup_disc_type X(1) X C 6.840
18 Coupon/Discount ID 1 ID of first coupon/discount attached to customer inarf1.coup_disc_id X(6) X Flt1 6.840
19 Coupon/Discount Type 2 C for coupon or D for discount inarf1.coup_disc_type2 X(1) X 6.840
20 Coupon/Discount ID 2 ID of second coupon/discount attached to customer inarf1.coup_disc_id2 X(6) X 6.840
21 Coupon/Discount Type 3 C for coupon or D for discount inarf1.coup_disc_type3 X(1) X 6.840
22 Coupon/Discount ID 3 ID of third coupon/discount attached to customer inarf1.coup_disc_id3 X(6) X 6.840
23 Coupon/Discount Type 4 C for coupon or D for discount inarf1.coup_disc_type4 X(1) X 6.840
24 Coupon/Discount ID 4 ID of fourth coupon/discount attached to customer inarf1.coup_disc_id4 X(6) X 6.840
25 Coupon/Discount Type 5 C for coupon or D for discount inarf1.coup_disc_type5 X(1) X 6.840
26 Coupon/Discount ID 5 ID of fifth coupon/discount attached to customer inarf1.coup_disc_id5 X(6) X 6.840
27 Coupon/Discount Type 6 C for coupon or D for discount inarf1.coup_disc_type6 X(1) X 6.840
28 Coupon/Discount ID 6 ID of sixth coupon/discount attached to customer inarf1.coup_disc_id6 X(6) X 6.840
29 Coupon/Discount Type 7 C for coupon or D for discount inarf1.coup_disc_type7 X(1) X 6.840
30 Coupon/Discount ID 7 ID of eighth coupon/discount attached to customer inarf1.coup_disc_id7 X(6) X 6.840
31 Coupon/Discount Type 8 C for coupon or D for discount inarf1.coup_disc_type8 X(1) X 6.840
32 Coupon/Discount ID 8 ID of ninth coupon/discount attached to customer inarf1.coup_disc_id8 X(6) X 6.840
33 Coupon/Discount Type 9 C for coupon or D for discount inarf1.coup_disc_type9 X(1) X 6.840
34 Coupon/Discount ID 9 ID of tenth coupon/discount attached to customer inarf1.coup_disc_id9 X(6) X 6.840
35 Tax Group 1 Description for tax basis 1 inf0.txgrp1 X(20) X State Sales Tax 6.840
36 Tax Exemption Number 1 Tax exemption number for tax basis 1 inarf1.tax_exempt X(15) X 6.840
37 Allow Tax Exempt 1 Allow manual tax exemption at ring out for tax basis 1 inarf1.allow_taxex X(1) X 6.840
38 Tax Group 2 Description for tax basis 2 inf0.txgrp2 X(20) X 6.840
39 Tax Exemption Number 2 Tax exemption number for tax basis 2 inarf1.tax_exempt2 X(15) X 6.840
40 Allow Tax Exempt 2 Allow manual tax exemption at ring out for tax basis 2 inarf1.allow_taxex2 X(1) X 6.840
41 Tax Group 3 Description for tax basis 3 inf0.txgrp3 X(20) X 6.840
42 Tax Exemption Number 3 Tax exemption number for tax basis 3 inarf1.tax_exempt3 X(15) X 6.840
43 Allow Tax Exempt 3 Allow manual tax exemption at ring out for tax basis 3 inarf1.allow_taxex3 X(1) X 6.840
44 Tax Group 4 Description for tax basis 4 inf0.txgrp4 X(20) X 6.840
45 Tax Exemption Number 4 Tax exemption number for tax basis 4 inarf1.tax_exempt4 X(15) X 6.840
46 Allow Tax Exempt 4 Allow manual tax exemption at ring out for tax basis 4 inarf1.allow_taxex4 X(1) X 6.840
47 Tax Group 5 Description for tax basis 5 inf0.txgrp5 X(20) X 6.840
48 Tax Exemption Number 5 Tax exemption number for tax basis 5 inarf1.tax_exempt5 X(15) X 6.840
49 Allow Tax Exempt 5 Allow manual tax exemption at ring out for tax basis 5 inarf1.allow_taxex5 X(1) X 6.840
50 Service Code Allow or Denied Setting that indicates whether the following service codes are allowed or denied inarf1.perm_type X(1) X A 6.840
51 Service Code 1 First service code defined for the Service Code Allow or Denied flag inarf1sc.serv_code X(3) X FS 6.840
52 Service Code 2-200 Service codes 2 through 200 inarf1sc.serv_code1 – inarf1sc.serv_code199 X(3) X 6.840
251 Vin Required Require VIN flag (Y or N) inarf1j.vin_req X(1) X N 6.840
252 Comment 1 Fleet comment 1 inarf1j.comm X(70) X Don’t vacuum out these vehicles 6.840
253 Comment 2 Fleet comment 2 inarf1j.comm1 X(70) X 6.840
254 Comment 3 Fleet comment 3 inarf1j.comm2 X(70) X 6.840
255 Comment 4 Fleet comment 4 inarf1j.comm3 X(70) X 6.840
256 Comment 5 Fleet comment 5 inarf1j.comm4 X(70) X 6.840
257 Comment 6 Fleet comment 6 inarf1j.comm5 X(70) X 6.840
258 Input Description 1 First input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Driver’s DL# 6.840
259 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X Y 6.840
260 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X N 6.840
261 Mask 1 Mask 1 for first input item inarf1ji.mask X(30) X 6.840
262 Mask 2 Mask 2 for first input item inarf1ji.mask1 X(30) X 6.840
263 Mask 3 Mask 3 for first input item inarf1ji.mask2 X(30) X 6.840
264 Mask 4 Mask 4 for first input item inarf1ji.mask3 X(30) X 6.840
265 Mask 5 Mask 5 for first input item inarf1ji.mask4 X(30) X 6.840
266 Mask 6 Mask 6 for first input item inarf1ji.mask5 X(30) X 6.840
267 Mask 7 Mask 7 for first input item inarf1ji.mask6 X(30) X 6.840
268 Mask 8 Mask 8 for first input item inarf1ji.mask7 X(30) X 6.840
269 Mask 9 Mask 9 for first input item inarf1ji.mask8 X(30) X 6.840
270 Input Description 2 Second input description in Set Up Charge Customers. inarf1ji.indesc X(30) X Fleet Vehicle ID 6.840
271 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X Y 6.840
272 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X N 6.840
273 Mask 1 Mask 1 for second input item inarf1ji.mask X(30) X 6.840
 274  Mask 2  Mask 2 for second input item inarf1ji.mask1 X(30) X 6.840
275 Mask 3 Mask 3 for second input item inarf1ji.mask2 X(30) X 6.840
276 Mask 4 Mask 4 for second input item inarf1ji.mask3 X(30) X 6.840
277 Mask 5 Mask 5 for second input item inarf1ji.mask4 X(30) X 6.840
278 Mask 6 Mask 6 for second input item inarf1ji.mask5 X(30) X 6.840
279 Mask 7 Mask 7 for second input item inarf1ji.mask6 X(30) X 6.840
280 Mask 8 Mask 8 for second input item inarf1ji.mask7 X(30) X 6.840
281 Mask 9 Mask 9 for second input item inarf1ji.mask8 X(30) X 6.840
282 Input Description 3 Third input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
283 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
284 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
285 Mask 1 Mask 1 for third input item inarf1ji.mask X(30) X 6.840
286 Mask 2 Mask 2 for third input item inarf1ji.mask1 X(30) X 6.840
287 Mask 3 Mask 3 for third input item inarf1ji.mask2 X(30) X 6.840
288 Mask 4 Mask 4 for third input item inarf1ji.mask3 X(30) X 6.840
289 Mask 5 Mask 5 for third input item inarf1ji.mask4 X(30) X 6.840
290 Mask 6 Mask 6 for third input item inarf1ji.mask5 X(30) X 6.840
291 Mask 7 Mask 7 for third input item inarf1ji.mask6 X(30) X 6.840
292 Mask 8 Mask 8 for third input item inarf1ji.mask7 X(30) X 6.840
293 Mask 9 Mask 9 for third input item inarf1ji.mask8 X(30) X 6.840
294 Input Description 4 Fourth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
295 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
296 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
297 Mask 1 Mask 1 for fourth input item inarf1ji.mask X(30) X 6.840
298 Mask 2 Mask 2 for fourth input item inarf1ji.mask1 X(30) X 6.840
299 Mask 3 Mask 3 for fourth input item inarf1ji.mask2 X(30) X 6.840
300 Mask 4 Mask 4 for fourth input item inarf1ji.mask3 X(30) X 6.840
301 Mask 5 Mask 5 for fourth input item inarf1ji.mask4 X(30) X 6.840
302 Mask 6 Mask 6 for fourth input item inarf1ji.mask5 X(30) X 6.840
303 Mask 7 Mask 7 for fourth input item inarf1ji.mask6 X(30) X 6.840
304 Mask 8 Mask 8 for fourth input item inarf1ji.mask7 X(30) X 6.840
305 Mask 9 Mask 9 for fourth input item inarf1ji.mask8 X(30) X 6.840
306 Input Description 5 Fifth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
307 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
308 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
309 Mask 1 Mask 1 for fifth input item inarf1ji.mask X(30) X 6.840
310 Mask 2 Mask 2 for fifth input item inarf1ji.mask1 X(30) X 6.840
311 Mask 3 Mask 3 for fifth input item inarf1ji.mask2 X(30) X 6.840
312 Mask 4 Mask 4 for fifth input item inarf1ji.mask3 X(30) X 6.840
313 Mask 5 Mask 5 for fifth input item inarf1ji.mask4 X(30) X 6.840
314 Mask 6 Mask 6 for fifth input item inarf1ji.mask5 X(30) X 6.840
315 Mask 7 Mask 7 for fifth input item inarf1ji.mask6 X(30) X 6.840
316 Mask 8 Mask 8 for fifth input item inarf1ji.mask7 X(30) X 6.840
317 Mask 9 Mask 9 for fifth input item inarf1ji.mask8 X(30) X 6.840
318 Input Description 6 Sixth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
319 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
320 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
321 Mask 1 Mask 1 for sixth input item inarf1ji.mask X(30) X 6.840
322 Mask 2 Mask 2 for sixth input item inarf1ji.mask1 X(30) X 6.840
323 Mask 3 Mask 3 for sixth input item inarf1ji.mask2 X(30) X 6.840
324 Mask 4 Mask 4 for sixth input item inarf1ji.mask3 X(30) X 6.840
325 Mask 5 Mask 5 for sixth input item inarf1ji.mask4 X(30) X 6.840
326 Mask 6 Mask 6 for sixth input item inarf1ji.mask5 X(30) X 6.840
327 Mask 7 Mask 7 for sixth input item inarf1ji.mask6 X(30) X 6.840
328 Mask 8 Mask 8 for sixth input item inarf1ji.mask7 X(30) X 6.840
329 Mask 9 Mask 9 for sixth input item inarf1ji.mask8 X(30) X 6.840
330 Input Description 7 Seventh input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
331 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
332 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
333 Mask 1 Mask 1 for seventh input item inarf1ji.mask X(30) X 6.840
334 Mask 2 Mask 2 for seventh input item inarf1ji.mask1 X(30) X 6.840
335 Mask 3 Mask 3 for seventh input item inarf1ji.mask2 X(30) X 6.840
336 Mask 4 Mask 4 for seventh input item inarf1ji.mask3 X(30) X 6.840
337 Mask 5 Mask 5 for seventh input item inarf1ji.mask4 X(30) X 6.840
338 Mask 6 Mask 6 for seventh input item inarf1ji.mask5 X(30) X 6.840
339 Mask 7 Mask 7 for seventh input item inarf1ji.mask6 X(30) X 6.840
340 Mask 8 Mask 8 for seventh input item inarf1ji.mask7 X(30) X 6.840
341 Mask 9 Mask 9 for seventh input item inarf1ji.mask8 X(30) X 6.840
342 Input Description 8 Eighth input description in Set Up Charge Customers. inarf1ji.indesc X(30) X 6.840
343 Required Flag Input description required flag (Y or N) inarf1ji.req_flag X(1) X 6.840
344 Repopulate Flag Repopulate input item response (Y or N) inarf1ji.repop X(1) X 6.840
345 Mask 1 Mask 1 for eighth input item inarf1ji.mask X(30) X 6.840
346 Mask 2 Mask 2 for eighth input item inarf1ji.mask1 X(30) X 6.840
347 Mask 3 Mask 3 for eighth input item inarf1ji.mask2 X(30) X 6.840
348 Mask 4 Mask 4 for eighth input item inarf1ji.mask3 X(30) X 6.840
349 Mask 5 Mask 5 for eighth input item inarf1ji.mask4 X(30) X 6.840
350 Mask 6 Mask 6 for eighth input item inarf1ji.mask5 X(30) X 6.840
351 Mask 7 Mask 7 for eighth input item inarf1ji.mask6 X(30) X 6.840
352 Mask 8 Mask 8 for eighth input item inarf1ji.mask7 X(30) X 6.840
353 Mask 9 Mask 9 for eighth input item inarf1ji.mask8 X(30) X 6.840
354 Note 1 Note 1 from Set Up Charge Customers inarf1n.note1 X(50) X 6.840
355 Note 2 Note 2 from Set Up Charge Customers inarf1n.note2 X(50) X 6.840
356 Note 3 Note 3 from Set Up Charge Customers inarf1n.note3 X(50) X 6.840
357 Note 4 Note 4 from Set Up Charge Customers inarf1n.note4 X(50) X 6.840
358 Note 5 Note 5 from Set Up Charge Customers inarf1n.note5 X(50) X 6.840
359 Note 6 Note 6 from Set Up Charge Customers inarf1n.note6 X(50) X 6.840
360 Note 7 Note 7 from Set Up Charge Customers inarf1n.note7 X(50) X 6.840
361 Note 8 Note 8 from Set Up Charge Customers inarf1n.note8 X(50) X 6.840
362 Note 9 Note 9 from Set Up Charge Customers inarf1n.note9 X(50) X 6.840
363 Note 10 Note 10 from Set Up Charge Customers inarf1n.note10 X(50) X 6.840
364 Number of Additional Invoices Number of invoice copies to automatically print at ring out inarf1.cp_num #2   2 6.840
365 Allow Additional Coupons/Discounts Flag to determine if coupons or discounts can be added to the invoice during invoicing inarf1.allow_coup_disc X(1) X Y 6.840
366 File Creation Date Date the file was created on System Date ##/##/#### X 11.8
367 Amount Amount value for input line 1 inarf1ji.amount #(4).#(2)   15.8
368 Amount Amount value for input line 2 inarf1ji.amount #(4).#(2)   15.8
369 Amount Amount value for input line 3 inarf1ji.amount #(4).#(2)   15.8
370 Amount Amount value for input line 4 inarf1ji.amount #(4).#(2)   15.8
371 Amount Amount value for input line 5 inarf1ji.amount #(4).#(2)   15.8
372 Amount Amount value for input line 6 inarf1ji.amount #(4).#(2)   15.8
373 Amount Amount value for input line 7 inarf1ji.amount #(4).#(2)   15.8
374 Amount Amount value for input line 8 inarf1ji.amount #(4).#(2)   15.8
375 API ID   inarf1.api_id X(40) X 15.15
376 Fleet Team ID Only contains a value if you have a fleet set up to bill through the Fleet Team interface. inarf1.ft_id #(8)   15.15
377 E-mail Address 1 E-mail address to send the fleet invoice to at cash out. inarf1.email1 X(40) X 15.15
378 E-mail Address 2 E-mail address to send the fleet invoice to at cash out. inarf1.email2 X(40) X 15.15
379 E-mail Address 3 E-mail address to send the fleet invoice to at cash out. inarf1.email3 X(40) X 15.15
380 Remit To Address Line 1 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr1 X(40) X 15.15
381 Remit To Address Line 2 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr2 X(40) X 15.15
382 Remit To Address Line 3 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr3 X(40) X 15.15
383 Remit To Address Line 4 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr4 X(40) X 15.15
384 Remit To Address Line 5 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr5 X(40) X 15.15
385 Remit To Address Line 6 Alternative address to print on the fleet invoice if you have the remit-to feature activated. inarf1.remit_addr6 X(40) X 15.15
386 Fleet Discount Fleet Discount value entered on screen 4 of Set Up Charge Customers. inarf1.fleet_discount #(4).#(4)   0 15.26

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