70FA3018R00000012_Attachment_5_RCTSD_ASN_Upload_Spreadsheet_Basic_5-29-18.xls

XLS spreadsheet 127 KB Posted

Attached to
Resource and Capability Transportation Support during Disasters (RCTSD) in Puerto Rico and the US Virgin Islands
Solicitation number
70FA3018R00000012
Issued by

About this file

Written by GovTribe AI ·

This document outlines a solicitation for Resource and Capability Transportation Support during Disasters (RCTSD) in Puerto Rico and the US Virgin Islands. The Federal Emergency Management Agency is seeking proposals to provide transportation services to support disaster response and recovery efforts. Proposals are due by June 18, 2018 and must include pricing information using the provided price template. The performance work statement describes the required services, which include coordinating transportation assets and tracking shipments using the advanced shipping notice upload templates. Questions from potential offerors are due by June 1, 2018. The wage determinations appendix specifies applicable labor rates. Overall, the solicitation provides relevant details on the disaster transportation services needed, response timeline and requirements, and ancillary documents to facilitate proposal preparation for interested parties.

From the source

Attachment 5 RCTSD ASN Upload Spreadsheet Basic

View the file

Other files

File Type Posted
Amendment_2_70FA3018R00000012_RCTSD_Request_for_Proposal_(RFP)_6-5-2018.pdf PDF
Amendment__2_70FA3018R00000012_6-5-18.pdf PDF
Amendment_1_RCTSD_70FA3018R00000012_Attachment_3_RCTSD_Q&A_6-4-18.xlsx XLSX spreadsheet
Amendment__1_70FA3018R00000012_6-4-18.pdf PDF
Amendment_1_70FA3018R00000012_Attachment_1_RCTSD_Pricing_Template_6-4-18.xlsx XLSX spreadsheet
Wage Determination TXT text file
70FA3018R00000012_Attachment_3_RCTSD_Questions_and_Answers_Template_5-29-18.xlsx XLSX spreadsheet
Wage Determination TXT text file
70FA3018R00000012_Attachment_4_RCTSD_Resume_Template_5-29-18.docx DOCX document
70FA3018R00000012_Attachment_2_RCTSD_Performance_Work_Statement_5-29-18.pdf PDF
Wage Determination TXT text file
Wage Determination TXT text file
Wage Determination TXT text file
Wage Determination TXT text file
Wage Determination TXT text file
70FA3018R00000012_RCTSD_Combined_Synopsis_Solicitation_5-29-18.docx DOCX document
Wage Determination TXT text file
70FA3018R00000012_RCTSD_Request_for_Proposal_(RFP)_5-29-2018.pdf PDF
70FA3018R00000012_Attachment_1_RCTSD_Pricing_Template_5-29-18.xlsx XLSX spreadsheet
Show all 19

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

Data Definition

Field NameGroupSpreadsheet ColumnGroup IdData Sheet OrderXml Tag NameDescriptionMax Value or Max LengthFormatRequired?Sheet NameColumn NumberConditionHas ValueActionConditional FieldsConditional Error messageGroup Required (True/False)Max. OccursMax.Occurs GroupMin. Value or Min. Length
SourceHeader11Source50TEXTNHeader1N0
Action_TypeHeader12Action_Type50Create,UpdateYHeader2N0
Batch_IDHeader13Batch_ID10TEXTNHeader3N0
Reference_IDHeader14Reference_ID50TEXTNHeader4N0
User_IDHeader15User_ID50TEXTNHeader5N0
PasswordHeader16Password50TEXTNHeader6N0
Message_TypeHeader17Message_Type40TEXTYHeader7N0
Company_IDHeader18Company_ID8TEXTYHeader8N0
Purpose_CodeHeader19Purpose_Code50TEXTNHeader9N0
Msg_LocaleHeader110Msg_Locale50TEXTYHeader10N0
VersionHeader111Version20TEXTNHeader11N0
Internal_Reference_IDHeader112Internal_Reference_ID40TEXTNHeader12N0
Internal_Date_Time_StampHeader113Internal_Date_Time_Stamp50TEXTNHeader13N0
External_Reference_ID_TypeHeader114External_Reference_ID_Type40TEXTNHeader14N0
External_Reference_IDHeader115External_Reference_ID40TEXTNHeader15N0
External_Date_Time_StampHeader116External_Date_Time_Stamp50TEXTNHeader16N0
Sequence_NumberHeader117Sequence_Number50TEXTNHeader17N0
DO NumberASN318DONumber12TEXTYASN1N0
Trailer NumberASN319TrailerNumber20TEXTYASN2N0
Origin FacilityASN320OriginFacilityId20TEXTYASN3N0
Destination FacilityASN321DestinationFacilityId20TEXTYASN4N0
Estimated Delivery Date/TimeASN322EstimatedDeliveryDttm20TEXTYASN5N0
Actual Shipped Date/TimeASN323ActualShippedDttm20TEXTNASN6N0
Partner Ref NumberASN324PartnerRefNumber25TEXTNASN7N0
CO NumberASN325CONumber12TEXTNASN8N0
GPS (Truck/Trailer)ASN326GPS25TEXTNASN9N0
ShipmentASN327ShipmentId12TEXTNASN10N0
BOL NumberASN328BOLNumber50TEXTNASN11N0
Seal NumberASN329SealNumber10TEXTNASN12N0
Tractor NumberASN330TractorNumber25TEXTNASN13N0
Driver NameASN331DriverName50TEXTNASN14N0
Driver NumberASN332DriverNumber25TEXTNASN15N0
Item NameASN333ItemName25TEXTYASN16N0
Shipped Quantity (Units)ASN334ShippedQty10TEXTYASN17N0
Lot NumberASN335LotNumber25TEXTNASN18N0
Expiration DateASN336ExpirationDate10TEXTNASN19N0
ManufacturerASN337Manufacturer25TEXTNASN20N0
Asset BarcodeASN338AssetBarcode25TEXTNASN21N0
GPS (Asset)ASN339AssetGPS25TEXTNASN22N0
CommentsASN340Comments100TEXTNASN23N0
Distribution Order
Partner Reference Number
Trailer Number
Pickup Facility ID
Pickup Facility FEDAAC or Name
Actual Ship Date Time
Delivery Facility ID
Delivery City, State
Delivery Facility FEDAAC or Name
Estimated Delivery Date Time
Item Name
Shipped Qty (Units)
GPS (Truck/Trailer)
Bill of Lading Number
AsnIDTractor Number
TcAsnIDDriver Info, Carrier
TC_ASN_ID_UShipment ID
AsnTypeSeal Number
ASN_ORGN_TYPENSN
DESTINATION_TYPEGPS (Asset)
ASN_LEVELLot Number
TC_COMPANY_IDExpiration Date
ASN.BUSINESS_PARTNER_IDManufacturer
ASN_STATUSGov’t Barcode
CREATED_DTTMComments
LAST_UPDATED_DTTM
CREATED_SOURCE_TYPE
LAST_UPDATED_SOURCE_TYPE
CREATED_SOURCE
LAST_UPDATE_SOURCE
TRAILER_NUMBER
ORIGIN_FACILITY_ALIAS_ID
ORIGIN_FACILITY _ID
DESTINATION_FACILITY_ALIAS_ID
DESTINATION_FACILITY _ID
DELIVERY_START_DTTM
ACTUAL_SHIPPED_DTTM
TRACTOR_NUMBER
TC_SHIPMENT_ID
SHIPMENT_ID
DRIVER_NAME
BILL_OF_LADING_NUMBER
INBOUND_REGION_ID
OUTBOUND_REGION_ID
ASN_DETAIL_ID
TC_COMPANY_ID
ASN_ID
ASN_DETAIL_STATUS
CREATED_DTTM
LAST_UPDATED_DTTM
CREATED_SOURCE_TYPE
LAST_UPDATED_SOURCE_TYPE
CREATED_SOURCE
LAST_UPDATE_SOURCE
BUSINES_PARTNER_ID
TC_ORDER_ID
TC_ORDER_LINE_ID
SKU_ID
SKU_NAME
SHIPPED_QTY
BATCH_NBR
EXPIRE_DATE
SEAL_NUMBER
ASN_ID
SEAL_ID
SEAL_SEQUENCE

Parameter

Passwordpassword
ActionCreate
XSD_PATH
XSD_ROOT_ELEMENTtXML
DISABLE_MENU_ITEMS
UTILITY_VERSIONTALON.1.57
SPLIT_VALIDATION_TO_BASIC_n_CONDITIONAL
SERVER_INFO
UTILITY_SPLIT_COUNT1
INTERNAL_SHEET_NAMESASN
PARENT_SHEET_KEYS
SHEET_UNIQUE_KEYSASN_ID
DATA_START_ROW14
SHEET_NAMESASN
ESCAPE_COLUMNS

Header

Full Version1.0
Date & Time
Report as of:
FEMA CONTACTPARTNER CONTACT
NameName
EmailEmail
PhonePhone
Notes:
Column headers colored YELLOW are required fields and must be completed prior to returning to FEMA
SourceAction_TypeBatch_IDReference_IDUser_IDPasswordMessage_TypeCompany_IDPurpose_CodeMsg_LocaleVersionInternal_Reference_IDInternal_Date_Time_StampExternal_Reference_ID_TypeExternal_Reference_IDExternal_Date_Time_StampSequence_Number
ASNUploadCreateASNUpload11.0ASNASN111

Advanced Shipping Notice

Basic Version1.0
Date & Time
Report as of:
FEMA CONTACTPARTNER CONTACT
NameName
EmailEmail
PhonePhone
Notes:
Column titles colored YELLOW are required fields and must be completed prior to returning to FEMA
DO NumberTrailer NumberOrigin FacilityDestination FacilityEstimated Delivery Date/TimeActual Shipped Date/TimePartner Ref NumberCO NumberGPS (Truck / Trailer)Shipment IDBill of Lading NumberSeal NumberTractor NumberDriver NameDriver NumberItem NameShipped Quantity (Units)Lot NumberExpiration DateManufacturerAsset BarcodeGPS (Asset)Comments

&L&D&T&CWarning: This document is FOR OFFICIAL USE ONLY (FOUO).&R Page &P of &N

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