Attachment E - Weekly Status Report.doc

DOC document 74 KB Posted

Attached to
Medium and Heavy Duty Trucks
Solicitation number
QMAE-T4-091003-N
Issued by

About this file

Attachment E - Weekly Status Report

View the file

Other files

File Type Posted
FBONotice_Delay_In_Award_QMAE_T4_091003_N.doc DOC document
Amendment 4 QMAE-T4-91003-N.doc DOC document
Amendment 3 QMAE-T4-09003-N.doc DOC document
Amendment 2 QMAE-T4-091003-N.doc DOC document
Solicitation Questions and Answers.doc DOC document
Pre-Proposal Conference Transcript.pdf PDF
Amendment1 QMAE-T4-091003-N.doc DOC document
PreProposal Conference UPDATE 7.22.09.doc DOC document
Pre Proposal Conference Information.doc DOC document
Attachment F8 -Schedule of Items Navistar.pdf PDF
Attachment K - Dealers Layout Form.xls XLS spreadsheet
Attachment L - Med Heavy Option Analysis Report.pdf PDF
Attachment F1- Schedule of Items Damiler.pdf PDF
Attachment A - Small Business Subcontracting Plan.doc DOC document
Attachment F6 -Schedule of Items EVI-USA.pdf PDF
Attachment F5 -Schedule of Items Boyer —
Attachment B - Proposal Checklist.doc DOC document
Attachment F3 - Schedule of Items Kenworth.pdf PDF
Attachment F7 - Schedule of Items Hino.pdf PDF
Attachment G - Fed Std 794AC.pdf PDF
Attachment F4 - Schedule of Items Smith Electric.pdf PDF
Attachment H - Fed Std 807R.pdf PDF
Attachment I - Monthly Status Report.xls XLS spreadsheet
Attachment D- AutoChoice Online Ordering Procedures.doc DOC document
Attachment C - Exceptions Spreadsheet.xls XLS spreadsheet
Attachment J - Inspection Points Template.xls XLS spreadsheet
Medium Heavy Vehicles 2010 Solicitation.doc DOC document
Attachment F2 - Schedule of Items Mack Volvo.pdf PDF
Show all 28

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

PAGE

Attachment E

WEEKLY VENDOR STATUS SUBMISSION

REQUIREMENTS

GSA Office of Motor Vehicle Management’s contracts requires vendors to submit electronic status reports on a weekly cycle which indicate the production status of all vehicles ordered.

Status information sent electronically to GSA by your firm is displayed in our on-line ordering program, AutoChoice. Customers can view the production status of orders placed against your contract.

Additionally, the status report will also be used to calculate your on-time shipment performance of against the contract time of shipment. The customer will be able to view the percentage of vehicles shipped on time by each vendor in AutoChoice. It is an avenue for customer agencies to evaluate the vendor’s performance when making a best value decision when selecting a vehicle.

Your file can be sent in either of the following two formats which are attached:

1. XLS: Send data as an EXCEL file via an email attachment to AutomotiveEDI.Partnerships@gsa.gov

2. EDI: Data collection is in X12 format (870 transaction set version 3010). Please contact Terry Koniarski at 703-605-9505 for further information in this electronic date interchange.

AUTOCHOICE STATUS Record Layout (870)

Name of Field
EXCEL File Column
Text

File Location

Field Length
Alpha or Numeric Field
Option
Relationship (see Legend on Page 4)
Description
A
1-38
38
AN
O
N1
Vehicle Order Number (VON )
B
39-46
8
N
M
N2
Vehicle Identification Number (VIN)
C
47-63
17
AN
O
N3
Filler
D
64-70
5

Do NOT fill!

Contract
E
71-75
5
AN
M
Filler
F
76-87
11

Do NOT fill!

Case Number
G
88-93
5
AN
M
Filler
H
94-115
26

Do NOT fill!

Name
I
116-150
35
AN
O
N3
Address
J
151-185
35
AN
O
N3
City
K
186-215
30
AN
O
N3
State
L
216-217
2
A
O
N3, N4
Zip
M
218-227
10
AN
O
N3, N5
Status
N
228-229
2
AN
M
N6
Status Date
O
230-239
10
AN
O
N7
Filler
P
240-241
2

Do NOT fill!

Contact Person
Q
242-276
35
AN
O
N3
Filler
R
277-278
2

Do NOT fill!

Contact Telephone Number
S
279-299
21
AN
O
N3
Filler
T
300-303
4

Do NOT fill!

Requisition Interface Record Layout Relationship Edits (Legend)

N1 : Description of vehicle

N2 : An Integer representing vehicle number – ex. If three vehicles are attached to one case, each vehicle would have a VON number of 1, 2, 3

N3 : For Dealer Delivery, enter Dealership name, location, and point-of-contact.

For CNS Delivery, put Customer delivery location and point-of-contact.

N4 : Must be a valid US State, Territory, or Armed Forces abbreviation or “XX” for Foreign Countries.

See the USPS official list of State Abbreviations (including territories and Armed Forces addresses) at http://www.usps.com/ncsc/lookups/abbreviations.html#states

N5 : Zip Codes are validated against the state field. Required unless “XX” is in the state field.

N6 : Valid status codes:

SP – Scheduled for Production

IN – In Process AN – Available Now, No Shipping Schedule

CC – Shipped

DD – Delivered

DE – Order Cancelled

N7 : Date format is YYYY-MM-DD

General Comments:

1. The ROADS Status Batch File transmitted to the Automotive Center will be an ASCII file (flat file) with a fixed Length of 303 bytes (records).

2. Column Option: O = Optional Field and M = Mandatory Field.

3. Initialize all Bytes in Filler Field with “blank spaces”.

File details come from the government source that posted it. Updated .