6_MM-3_Att_6_-_ITV_Spreadsheet_DRAFT_20Sep.xlsx
XLSX spreadsheet 222 KB Posted
- Attached to
- Multimodal (MM)-3 Federal contract opportunity
- Solicitation number
- HTC711-19-R-W002
About this file
This document is a draft performance work statement for the Multimodal (MM)-3 federal contract opportunity issued by the Department of Defense United States Transportation Command. The draft PWS and related attachments are seeking industry feedback on requirements for providing multimodal transportation services in support of DOD missions on a global basis. Comments on the draft are requested by October 5, 2018 and should be submitted via the provided Excel spreadsheet to the listed government points of contact. No actual solicitation is currently open; this announcement constitutes a request for feedback only.
DRAFT MM-3 Attachment 6 ITV Spreadsheet
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| MM-3_RFP_Q&A's_2019.01.30.pdf | ||
| Amendment_1_-_HTC71119RW002.zip | ZIP file | |
| MM-3_Pre-Proposal_Slides_2019.01.24.pdf | ||
| MM-3_RFP.zip | ZIP file | |
| Helpful_Hints_While_Visiting_MITRE.pdf | ||
| 2018.1.8_J&A_Redacted.pdf | ||
| MM-3_Draft_PWS_Feedback_Matrix_(FBO).pdf | ||
| 4_MM-3_Att_4_-_Safety_and_Audit_Oversight_Checklist_DRAFT_20Sep.pdf | ||
| 1_MM-3_Att_1_-_Performance_Work_Statement_20Sep_DRAFT.pdf | ||
| 2_MM-3_Att_2_-_Invoicing_and_Payment_DRAFT_20Sep.pdf | ||
| 7_MM-3_Att_7_-_Prime_Vendor_DRAFT_20Sep.pdf | ||
| 8_MM-3_Att_8_-_Yubikey_DRAFT_20Sep.pdf | ||
| MM-3_Comment_Matrix.xlsx | XLSX spreadsheet | |
| 3_MM-3_Att_3_-_Ordering_Procedures_DRAFT_20Sep.pdf | ||
| 9_MM-3_Att_9_-_NIST.SP.800-171_-_POAM_DRAFT_20Sep.pdf | ||
| 5_MM-3_Att_5_-_Reports_and_Formats_DRAFT_20Sep.pdf |
Show all 16
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Export Template Customer Primary Sea/Air Carrier Sub-Contract Sea/Air Carrier Group ID Booking Number PCFN IBS TCN Commercial Bill Lading Conveyance Type Container # Container Seal # Description Consignor DODAAC Consignor Consignee DODAAC Consignee Length Width Height Booked Gross Weight (lbs) Actual Gross Weight (lbs) Cargo Available for Pickup RDD Est Cargo Pickup Date FOB Departure CHY Name ATA CHY ATD CHY ATA APOE (Carrier EDI) APOE [Code] MAWB (Master Waybill) HAWB (House Waybill) Tail ETD APOE ATD APOE Secondary Flight ETA APOD ATA APOD APOD [Code] Date Frustrated Date Un-Frustrated Frustrated Remarks AG Customs Wash Required Date Arrived Washrack Date Wash Completed Outgate APOD Invoice & Packing List Receipt Docs Submitted To US Embassy MOD Approval MOD Approval Date Documents sent to Freight Forw Freight Forwarder Receipt Conf Customs Clearance Submitted Customs Clearance Approved Transport / Escort Arrangement Date Received Cargo from APOD REMARKS Trans Discrpancy
Attachment 6 ITV Reporting - Export
Import Template
| Customer | Cargo Available for Pickup | Primary Sea/Air Carrier | Sub-Contract Sea/Air Carrier | Group ID | Booking Number | PCFN | IBS TCN | Commercial Bill Lading | Conveyance Type | Container # | Container Seal # | Description | Length (in) | Width (in) | Height (in) | BOOKED GROSS WT (lbs) | ACTUAL GROSS WT (lbs) | Consignor DODAAC | Consignor | Consignee DODAAC | Consignee | RDD | INVOICE & PACKING LIST | ||||||||||||||||||||
| RECEIPT DATE | DOCS SUBMITTED TO US EMBASSY | MOD APPROVAL (Y/N) | MOD APPROVAL | DOCUMENTS SENT TO FREIGHT FORWARDER | FREIGHT FORWARDER RECEIPT CONFIRMATION | TRANSPORT / ESCORT ARRANGEMENT (Y or N) | Vessel Name | SPOE [Code] | ATD SPOE | SPOD [Code] | ETA SPOD | ATA SPOD | Discharg Date | Receive Cargo From SPOD | Outgate SPOD | Planned Delivery Date To APOE | Actual Delivery Date to APOE | Date Frustrated | Date Un-Frustrated | Frustrated Remarks | Customs Clearance Submitted | Customs Clearance Approved | MAWB (Master Waybill) | HAWB (House Waybill) | Cargo Staged For Flight | Tail | APOE (Code) | ATA APOE | ETD APOE | ATD APOE | ETA APOD | ATA APOD | APOD (Code) | Secondary Flight | Outgate APOD | CHY Name | ATA CHY | ATD CHY | Arrival at FOB Gate | FOB In Gate | Remarks | Trans Descrepancy | |
| List of valid values in CHY List Tab |
Attachment 6 ITV Reporting - Import
CIET Business Rules - Export
| Search/Filter Criteria | Fields on Add/Update Screen | Export Field Names | Derived or Manual Entry | Comments/Questions/validation | EDI Generated | Input format | |
| X | Checkbox | Manual | |||||
| X | Customer | Manual | Modified description ofr consitancy | Varchar (20) | Notes: | ||
| Primary Sea/Air Carrier | Derived | Derived from IBS | All manual input fields optional unless as noted. | ||||
| X | Sub-Contract Sea/Air Carrier | Manual | Varchar (4) [SCAC] | Valid SCACs and ICAOs imperative for data quality | |||
| X | X | Group ID | Manual | User defined value to aid in updating and tracking records | Carrier EDI will populate report but will not display on Add/Update screens. The inclusion on the report will aid in cross referance EDI vice CIET input. | ||
| X | X | Booking Number | Derived | Derived IBS | |||
| X | x | PCFN | * Derived (counted as manual) | Derived from IBS | |||
| X | x | IBS TCN | * Derived (counted as manual) | Derived from IBS | |||
| X | X | Commercial Bill Lading | Manual | Varchar 30 | |||
| X | Conveyance Type | Manual | eg 'Air/Sea', 'Breakbulk/RORO' | Varchar (15) | |||
| X | Container # | * Derived (counted as manual) | Derived from GATES. Modified description ofr consitancy | ||||
| X | Container Seal # | Manual | Varchar (15) | ||||
| X | Description | Manual | Varchar (15) | ||||
| x | Consignor DODAAC | Derived | Modified description for consitancy | ||||
| x | Consignor | Derived | Modified description for consitancy | ||||
| x | Consignee DODAAC | Derived | Modified description for consitancy | ||||
| x | Consignee | Derived | Added to be consistant with Import | ||||
| X | Length | Manual | Required | Numeric (3) | |||
| X | Width | Manual | Required | Numeric (3) | |||
| X | Height | Manual | Required | Numeric (3) | |||
| X | Booked Gross Weight (lbs) | Derived | Derived from IBS | Numeric (6) | |||
| X | Actual Gross Weight (lbs) | Manual | Required. Added to Import to be consistant with Export | Numeric (6) | |||
| X | Cargo Available for Pickup | Manual | Date | ||||
| X | RDD | Derived | From IBS | Date | |||
| X | Est Cargo Pickup Date | Manual | Date | ||||
| X | FOB Departure | Manual | Date | ||||
| x | x | CHY Name | Manual | See CHY List Tab for available values | Picklist | ||
| x | ATA CHY | Manual | Y | Date | |||
| x | ATD CHY | Manual | Y | Date | |||
| ATA APOE | Derived | Only on Report/From Carrier EDI 315 I | |||||
| X | X | APOE [Code] | Manual | Varchar (4) [ICAO] | |||
| X | MAWB (Master Waybill) | Manual | Varchar (30) | ||||
| X | HAWB (House Waybill) | Manual | Varchar (30) | ||||
| X | Tail | Manual | Varchar (30) | ||||
| x | ETD APOE | Manual | N | Date | |||
| ATD APOE | Derived | Only on Report/From Carrier EDI 315 VD | |||||
| X | Secondary Flight | Manual | Y/N | ||||
| X | ETA APOD | Manual | Date | ||||
| ATA APOD | Derived | Only on Report/From Carrier EDI 315 VA | Date | ||||
| x | X | APOD [Code] | Manual | Varchar (4) [ICAO] | |||
| X | Date Frustrated | Manual | Date | ||||
| Date Un-Frustrated | Manual | Date | |||||
| X | Frustrated Remarks | Manual | varchar (100) | ||||
| X | AG Customs Wash Required | Manual | Y/N | ||||
| X | Date Arrived Washrack | Manual | Date | ||||
| x | Date Wash Completed | Manual | Date | ||||
| Outgate APOD | Derived | Only on Report/From Carrier EDI 315 OA | Date | ||||
| X | Invoice & Packing List Receipt | Manual | Date | ||||
| X | Docs Submitted To US Embassy | Manual | Date | ||||
| X | MOD Approval | Manual | if 'Y' then MOD Approval date required | Y/N | |||
| X | MOD Approval Date | Manual | if 'MOD Approval = Y' then date required | Date | |||
| X | Documents sent to Freight Forw | Manual | Date | ||||
| X | Freight Forwarder Receipt Conf | Manual | Date | ||||
| X | Customs Clearance Submitted | Manual | Date | ||||
| X | Customs Clearance Approved | Manual | Date | ||||
| X | Transport / Escort Arrangement | Manual | Y/N | ||||
| X | Date Received Cargo from APOD | Manual | Initiate purge rules based on date entered/update | Date | |||
| X | REMARKS | Manual | Varchar (100) | ||||
| x | Trans Discrpancy | Manual | Initiate purge rules based on date entered/update | Date |
&G
&G
CIET Business Rules - Import
| Search/Filter Criteria | Fields on Add/Update Screen | Import Field Names | Derived or Manual Entry | Comments/Questions/validation | EDI Generated | Input format | ||
| X | Checkbox | Manual | ||||||
| X | Customer | Manual | Modified description ofr consitancy | Varchar (20) | Note: | |||
| X | Cargo Available for Pickup | Manual | Date | All manual input fields optional unless as noted. | ||||
| Primary Sea/Air Carrier | Derived | Derived from IBS | Valid SCACs and ICAOs imperative for data quality | |||||
| X | Sub-Contract Sea/Air Carrier | Manual | Varchar (4) [SCAC] | Carrier EDI will populate report but will not display on Add/Update screens. The inclusion on the report will aid in cross referance EDI vice CIET input. | ||||
| X | X | Group ID | Manual | User defined value to aid in updating and tracking records | ||||
| X | X | Booking Number | Derived | Derived from IBS | ||||
| X | X | PCFN | * Derived (counted as manual) | Derived from IBS | ||||
| X | X | IBS TCN | * Derived (counted as manual) | Derived from IBS | ||||
| x | X | Commercial Bill Lading | Manual | Varchar (30) | ||||
| X | Conveyance Type | Manual | eg. 'Breakbulk'/'Breakbulk/RORO' | Varchar (15) | ||||
| X | Container # | * Derived (counted as manual) | Derived from GATES. Modified description ofr consitancy | |||||
| X | Container Seal # | Manual | Varchar (15) | |||||
| X | Description | Manual | Varchar (15) | |||||
| X | Length (in) | Manual | Required | Numeric (3) | ||||
| X | Width (in) | Manual | Required | Numeric (3) | ||||
| X | Height (in) | Manual | Required | Numeric (3) | ||||
| X | BOOKED GROSS WT (lbs) | Derived | Derived from IBS | Numeric (6) | ||||
| X | ACTUAL GROSS WT (lbs) | Manual | Required. Added to be consistant with Export | Numeric (6) | ||||
| x | Consignor DODAAC | Derived | Modified description for consitancy | |||||
| x | Consignor | Derived | Added to be consistant with Export | |||||
| x | Consignee DODAAC | Derived | ||||||
| x | Consignee | Derived | ||||||
| RDD | Derived | Only on report/ Derived from IBS | ||||||
| X | INVOICE & PACKING LIST | |||||||
| RECEIPT DATE | Manual | Date | ||||||
| X | DOCS SUBMITTED TO US EMBASSY | Manual | Date | |||||
| X | MOD APPROVAL (Y/N) | Manual | if 'Y' then MOD approval date required | Y/N | ||||
| X | MOD APPROVAL | Manual | if 'MOD Approval = Y' then date required | Date | ||||
| X | DOCUMENTS SENT TO FREIGHT FORWARDER | Manual | Date | |||||
| X | FREIGHT FORWARDER RECEIPT CONFIRMATION | Manual | Date | |||||
| X | TRANSPORT / ESCORT ARRANGEMENT (Y or N) | Manual | Y/N | |||||
| X | Vessel Name | Derived | Derived from IBS | |||||
| X | SPOE [Code] | Derived | Derived from IBS | |||||
| X | ATD SPOE | Manual | Required | Date | ||||
| X | SPOD [Code] | Derived | Derived from IBS | |||||
| ETA SPOD | Derived | Only on report/ From IBS | Date | |||||
| X | ATA SPOD | Derived | Only on Report/From Carrier EDI 315 VA | |||||
| Discharg Date | Derived | Only on Report/From Carrier EDI 315 UV | ||||||
| X | Receive Cargo From SPOD | Manual | Date | |||||
| Outgate SPOD | Derived | Only on Report/From Carrier EDI 315 OA | ||||||
| X | Planned Delivery Date To APOE | Manual | Date | |||||
| X | Actual Delivery Date to APOE | Manual | Date | |||||
| X | Date Frustrated | Manual | Date | |||||
| Date Un-Frustrated | Manual | Date | ||||||
| X | Frustrated Remarks | Manual | varchar (100) | |||||
| X | Customs Clearance Submitted | Manual | Date | |||||
| X | Customs Clearance Approved | Manual | Date | |||||
| X | MAWB (Master Waybill) | Manual | Varchar (30) | |||||
| X | HAWB (House Waybill) | Manual | Varchar (30) | |||||
| X | Cargo Staged For Flight | Manual | Date | |||||
| X | Tail | Manual | Varchar (30) | |||||
| x | X | APOE (Code) | Manual | Varchar (4) [ICAO] | ||||
| ATA APOE | Derived | Only on Report/From Carrier EDI 315 I | ||||||
| X | ETD APOE | Manual | N | Date | ||||
| ATD APOE | Derived | Only on Report/From Carrier EDI 315 VD | ||||||
| X | ETA APOD | Manual | Date | |||||
| ATA APOD | Derived | Only on Report/From Carrier EDI 315 VA | ||||||
| x | X | APOD (Code) | Manual | Varchar (4) [ICAO] | ||||
| X | Secondary Flight | Manual | Y/N | |||||
| Outgate APOD | Derived | Only on Report/From Carrier EDI 315 OA | ||||||
| x | x | CHY Name | Manual | See CHY List Tab for available values | Picklist | |||
| x | ATA CHY | Manual | Y | Date | ||||
| x | ATD CHY | Manual | Y | Date | ||||
| X | Arrival at FOB Gate | Derived | Only on Report/From Carrier EDI 315 AV | Date | ||||
| X | FOB In Gate | Manual | Required, conditional on Arrival at FOB. Initiate purge rules based on date entered/update | Date | ||||
| X | Remarks | Manual | Varchar (100) | |||||
| x | Trans Descrepancy | Manual | Initiate purge rules based on date entered/update | Date |
&G image1.png image2.png
File details come from the government source that posted it. Updated .