2.2. Attachment 7 -ASN Upload Spreadsheet RCTSD Hawaii.xls

210 KB Posted

Attached to
Resource and Capability Transportation Support during Disasters (RCTSD) Hawaii Islands
Solicitation number
70FB7021R00000004
Issued by

About this file

Written by GovTribe AI ·

This document provides details for the Resource and Capability Transportation Support during Disasters (RCTSD) Hawaii Islands solicitation. The Federal Emergency Management Agency Region IX is seeking transportation support and additional Initial Response Resources commodities for the Hawaiian Islands, including life supporting and sustaining items such as water, meals, cots, tarps, plastic sheeting, blankets, sandbags, generators, and fuel. Vendors must submit questions by June 14, 2021 and Phase I proposals by June 24, 2021. Phase II details are to be determined. Amendment 0001 extends the Phase I due date to July 1, 2021 and provides an updated pricing structure and answers to vendor questions.

View the file

Other files

File Type Posted
2.2 Attachment #6-SF-364 Report of Discrepancy.pdf PDF
2.2 Attachment #3 QASP - RCTSD Hawaii.pdf PDF
2.2 Attachment #1 Hawaii Price CLIN Structure.xlsx XLSX spreadsheet
2.2. Attachment 8 Question and Answer Template.xlsx XLSX spreadsheet
2.2 Attachment #4- Report of Survey.pdf PDF
2.2 Attachment #2 PWS RCTSD-Hawaii 03-10-2021.pdf PDF
2.2.1 Solicitaion RCTSD- Hawaii 70FB7021R00000004.pdf.pdf PDF
2.2 Attachment# 5-SF-91 Accident Report Form.pdf PDF

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

Password0
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

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
DO NumberTrailer NumberOrigin FacilityDestination FacilityEstimated Delivery Date/TimeActual Shipped Date/TimePartner Ref NumberCO NumberGPS (Truck / Trailer)ShipmentBOL 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 .