Attachment_D-_Weekly_Status _Report.pdf
PDF 85 KB Posted
- Attached to
- Transit Buses Solicitation QMAE-CY-110303-N
- Solicitation number
- QMAE-CY-110303-N
- Issued by
-
GSA Federal Acquisition Service
About this file
Attachment D weekly status report
View the file
Other files
Show all 39
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
Solicitation QMAE-CY-110303-N
Attachment D
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.
The status report will also be used to calculate your on-time shipment performance of against the contract time of shipment to evaluate contract performance.
Your file must be sent in either of the following in the following format which is attached:
XLS: Send data as an EXCEL file via an email attachment to the Contract Specialist and COR.
WEEKLY STATUS Record Layout
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!
(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 state Foreign Countries.
N5 : Required unless not applicable.
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. Column Option: O = Optional Field and M = Mandatory Field.
2. Initialize all Bytes in Filler Field with “blank spaces”.
File details come from the government source that posted it. Updated .