Attachment C - Weekly Status Report Template DHS ICE.doc
DOC document 60 KB Posted
- Attached to
- Trucks and Truck Tractors Wheeled
- Solicitation number
- QMAA-AT-100010-N
- Issued by
-
GSA Federal Acquisition Service
About this file
Attachment C - Weekly Status Report Template DHS ICE
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment F - Questions and Answers.xls | XLS spreadsheet | |
| QMAA-AT-100010-N 0002.doc | DOC document | |
| DHS ICE MCV Purchase Description with Amendment 0001.docx | DOCX document | |
| Attachment E - Delivery Locations DHS ICS.doc | DOC document | |
| Attachment B - Proposal Checklist DHS ICE.doc | DOC document | |
| DHS Ice Solicitation.doc | DOC document | |
| Attachment A - Exceptions Spreadsheet DHS ICE.xls | XLS spreadsheet | |
| Attachment D - Subcontracting Plan DHS ICE.doc | DOC document | |
| Attachment A - Exceptions Spreadsheet DHS ICE Draft.xls | XLS spreadsheet | |
| DHS Ice Solicitation Final.doc | DOC document | |
| Attachment B - Proposal Checklist DHS ICE Draft.doc | DOC document | |
| Attachment D - Subcontracting Plan DHS ICE.doc | DOC document | |
| Attachment E - Delivery Locations DHS ICS Draft.doc | DOC document | |
| Attachment C - Weekly Status Report Template DHS ICE.doc | DOC document |
Show all 14
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 C
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 .