Exhibit E_Detail Report_18 Jun09.pdf

HTC711-09-R-0022

PERFORMANCE WORK STATEMENT – EXHIBIT E

19-JUN-09

EXHIBIT E

DETAIL REPORT REQUIRED DATA ELEMENT FIELDS

Standardized File Format and File Naming conventions:

1. The data file submitted by the carrier shall contain records for each shipment DELIVERED in the month being reported.

2. A shipment is identified by a unique shipment identifier and may contain multiple pieces.

3. ASCII pipe | delimited file (See example of Shipment Information Data File below).

4. Fields shall be sequenced according to the tables provided below.

5. First row shall be the standard header row identifying the field names. The first field does not have a delimiter in front and the last field does not have a delimiter at the end.

6. Each record must have end of record marker or a line feed.

7. There shall not be a text qualifier (example |test| or |”test”|)

8. If there is no data for a particular field then leave blank and use a delimiter to represent field.

9. If the data type of a field is numeric/date then only place valid data types. (e.g. Pickup Date; do not place “Unavailable”).

10. File name shall be in the following format with an underscore separating each data element:

a. Year – identifies year of delivery (2009)

b. Month – identifies month of delivery (05 = MAY)

c. Carrier’s SCAC – Associates file to the Carrier

d. Program Type – Identifies Program Type (T = THEATER EXPRESS Program Identifier)

e. File Type – identifies type of data contained in file (SI = Shipment Information)

f. Submission date - date file was created and/or sent (20090603 = 03 JUN 2009)

g. Example: 200905_XXXX_T_SI_20090603.txt represents shipment information files for deliveries made in May 2009. The XXXX is a place holder for the prime contractor carrier SCAC.

Example of Shipment Information Data File:

In this example the Prime Contractor Carrier SCAC of the company is SMPL, and the file was submitted 8-JUN-2009 for the month of MAY 2009.

File Name: 200905_SMPL_T_SI_20090608.txt

Records: 2 records with a header record being the field names

File Info: File is saved in ASCII format using a pipe between each field.

Prime_Carrier_SCAC|Sub_Carrier_SCAC|Air_Bill_Number|AMD_Number|Pallet_Positions|Charged_Weight|Unit_Price|Shipment_Cost|Origin_ICAO|Des tination_ICAO|Pickup_Date|Remarks

SMPL||11111111|ABC9151010|11|BAH1BX|10695|1.70|18181.50|OTBH|ORTL|5/16/2009 14:54|5/18/2008 15:09|

SMPL||11111112|ABC9151015|6|SDA3LB|20910|0.53|11082.30|ORBD|ORSH|5/16/2009 17:11|5/21/2008 17:09|Consignee not able to receipt, delivery delayed 24 hours as authorized by AMD

Handling of Corrections and No Data:

1. Provide the original dataset with the corrected records

2. Follow the same naming convention making sure the Submission Date equals the date correction is being submitted

3. Provide an email stating there was no movement for the month when no movement was made

Data File Table Legend:

Field Seq: Field Sequence, used to show the sequence of the fields.

Req CD: Requirement Code, used to show the contract requirement of each field.

R = “Required” – must provide data for this field W/A = Shall provide information “When Applicable”, otherwise leave this field blank

Field Heading: Field Name, name associated with each field. This name shall be used in each file as the first row.

Description: Field Description, used to explain the field name and provide small sample of data.

Data Type: Field Data Type, used to show the type of data that should be provided.

Special Instructions: Field Special Instructions to assist carrier with additional information about data field.

Shipment Information (SI) Data File

FIELD

SEQ

REQ

CD FIELD HEADING DESCRIPTION DATA TYPE SPECIAL INSTRUCTIONS

1 R Prime_Carrier_SCAC

Standard Carrier Alpha Code for the Prime contractor (e.g. CMJONES Airlines = CMJS) Reference EDI 214 B1003

VARCHAR(4)

2 W/A Sub_Carrier_SCAC

Standard Carrier Alpha Code for the sub-contractor carrier (e.g. CMJONES Airlines = CMJS) Reference EDI 214 MS301

VARCHAR(4) Field is only required if a subcontractor carrier transports the shipment

3 R Air_Bill_Number

(AWB/HAWB) The number printed on each shipping document that identifies a shipment. This number is used to track each shipment from its origin to destination. (e.g. 22985195) Reference EDI 214 B1005

VARCHAR(25)

This number must be unique to each record in the detail report provided. Carrier’s unique tracking number. [Primary Key of the Table]

4 R AMD_Number

Identifies unique tracking number assigned by AMD or other DoD unit responsible for contract execution.

(e.g. ABC9151010)

VARCHAR(15) Government unique tracking number. Currently referred to as AMD Mission #.

5 R Pallet_Positions Equals the number of pallet positions contained in the shipment. (e.g. 2, 6) INTEGER

6 R Charged_Weight The total charged weight of the shipment Reference EDI 214 AT803 DECIMAL(10,1) All weights are in Pounds. Equals the gross weight sum of all pallets in shipment.

7 R Unit_Price

This represents the inclusive price per pound bid, which when multiplied by the Charged_Weight determines the shipment cost to AMC.

CURRENCY/

DECIMAL(10,2)

Do not include “$” in data submission. Must be in US Dollars. (e.g. 2,367.86)

Shipment Information (SI) Data File

FIELD

SEQ

REQ

CD FIELD HEADING DESCRIPTION DATA TYPE SPECIAL INSTRUCTIONS

8 R Shipment_Cost

(Cost to AMC) The net charge of the shipment (Gross Freight Charges – Discounts + Accessorial) in USD. This amount is based on sales not revenue.

CURRENCY/

DECIMAL(10,2)

Do not include “$” in data submission. Must be in US Dollars. (e.g. 2,367.86)

9 R Origin_ICAO Represents ICAO 4 character aerial port codes. VARCHAR(4)

Exception: use DDKS to represent the Defense Distribution Depot Kuwait, Southwest Asia, this code is not found in the ICAO listing.

10 R Destination_ICAO Represents ICAO 4 character aerial port codes. VARCHAR(4)

Exception: use DDKS to represent the Defense Distribution Depot Kuwait, Southwest Asia, this code is not found in the ICAO listing.

11 R Pickup_Date

The date/time stamp when the package was pickup by the carrier from the shipper/government representative. (e.g.

06/20/2007 09:23) Reference EDI 214 AT705, AT706

DATETIME Date and Time Format MM/DD/YYYY HH:MM.

12 R Delivery_Date

The date/time stamp when the package was successfully delivered to government customer/representative.

(e.g. 06/21/2007 10:23) Reference EDI 214 AT705, AT706

DATETIME Date and Time Format MM/DD/YYYY HH:MM.

13 W/A Remarks Brief Explanation of Issues Reference EDI 214 K101, K102 VARCHAR(255)

Definitely required when there is a delay / extension authorized by the government. To explain cause and effect for delay.

Additional Information: Report is required monthly, no later than the 10th business day of each month following the month of delivery.

File Name Example: 200905_XXXX_T_SI_20090608.txt represents Shipment Information for deliveries made in May 09, which was provided on Jun 08, 2009.

The XXXX is a place holder for the prime contractor carrier SCAC.