New Search
Award SummaryPage 17 of 33 <br />personnel. <br /> <br /> <br />If FTP is not desired by the Participant, then the Voyager Fleet Commander Online system is <br /> <br />another method by which to get weekly transaction detail. The transaction detail report <br /> <br />will allow the Participant to customize and drill down into transactional data and create <br /> <br />customized reports using all 93 data elements that are available. Participants can also <br /> <br />define the column appearance, naming, sort order, and date range. <br /> <br /> <br />Contractor shall provide comprehensive account information through an electronic file <br /> <br />layout that enables the Participant to map to any accounting software in an ASCII or Excel <br /> <br />file format. <br /> <br /> <br /> <br />4.3.2 The State of Oregon currently uses the following fuel systems: <br /> <br /> <br />Gas Boy <br /> <br />Fuelforce System by Multiforce Systems Corp. <br /> <br /> <br />4.3.3 The reports shall comply with the following requirements: <br /> <br /> <br />A. RECORD LAYOUT <br /> <br />The file must be in an ASCII Tab-Delimited format. <br /> <br /> <br />CHAR(n) = Character field with a length of n <br /> <br />Num(2) = Numeric field with 2 decimal places <br /> <br />DateTime = Date and Time in format of mm/dd/yyyy hh:mm <br /> <br />Integer = Whole number without decimal places <br /> <br /> <br />FIELD FIELD NAME FIELD TYPE REQUIRED DATA <br /> <br /> <br />1. Vehicle License No. CHAR (9) Complete License Number <br /> <br />2. PIN CHAR (6) Unique to each vehicle <br /> <br />3. Gas Gallons Num (2) Gallons of Gas <br /> <br />4. Gas Cost Num (2) Cost of Gas <br /> <br />5. Odometer Num (6) Odometer Reading <br /> <br />6. Oil Quarts Integer Number of Quarts <br /> <br />7. Labor Cost Num (2) Minor Labor Cost <br /> <br />8. Misc. Cost Num (2) Wipers, bulbs, etc. <br /> <br />9. Gas Vendor Name Char (8) Name of Gas Company <br /> <br />10. Gas Vendor Address Actual Fueling Site Address <br /> <br />11. Transaction Data Date and Time of Purchase <br /> <br />12. Fuel Type Char (4) Grade and Type of Fuel <br /> <br />13. Billing Date Char (4) Month and Year of Billing <br /> <br />(can be changed <br /> <br />to mm/dd/yyyy) <br /> <br />14. Vehicle maintenance cost & type <br /> <br />15. Emergency services cost and type <br /> <br /> <br />The preferred types of file transfer are as followed: <br /> <br />1. The file accessible on the Vendors web site available to download. <br /> <br />2. A file attachment through email. <br /> <br />3. A CD-ROM formatted to IBM compatible. <br /> <br /> <br /> <br />Contractor must establish daily, weekly, monthly ASCII or Excel transaction files for the <br /> <br />Participant's choice. <br /> <br /> <br />4.4 VOLUME SALES REPORT ("VSR") TO SPO <br /> <br /> <br />4.4.1 Contractor shall submit a VSR not later than fifteen (15) days after the end of each <br /> <br />calendar quarter, which contains (i) complete and accurate details of the Gross Receipts <br /> <br />for the quarter just ended and (ii) such other information as SPO may informally request. <br /> <br />Contractor shall send a Volume Sales Report each quarter, whether or not there are <br /> <br />reportable sales. <br /> <br /> <br />4.4.2 Contractor shall provide the following information on the VSR: <br /> <br /> <br />RFP item number <br /> <br />Recycled/non-recycled content <br /> <br />Customer name <br /> <br />Separately identify State Agencies &ORCPP <br /> <br />List each state Participant separately <br />https://orpin.oregon.gov/open.dll/showDocSummary?sessionID=1921160&disID=985529&docTy...6/10/2008 <br /> <br />