A3 2027 CFS Shipments upload spreadsheet columns document

Status: Original and derived artifacts are available for this document.

Download: docx | pdf | html


Column Header
More Information
Location_ID
(LOCATION_ID) 
Included If a consolidated reporter
The ID of the location where this shipment originated. Must be a location ID that you provided earlier.  Only needed if a consolidated reporter.
Shipment_ID
(SHIPMENT_ID)
Your internal identifier (e.g. Invoice # or Shipment #) for this shipment.
Shipment_Date  
(SHIPMENT_DATE)
Date of Shipment (MM/DD/YYYY)  
Shipment_Value
(SHIPMENT_VALUE)
The dollar value of the entire shipment as stored in your electronic records. The value should not include freight charges or excise taxes, i.e., report the net selling value, Freight On Board plant (FOB plant)
Shipment_Weight
(SHIPMENT_WEIGHT)
Shipment Weight:  Weight of shipments. 
Shipment_Weight_Units
(SHIPMENT_WEIGHT_Units)
The unit of measurement for the reported shipment weight.
Shipment_Weight_Units_Writein
(SHIPMENT_WEIGHT_UNITS_WRITEIN) 
If Shipment_Weight_Units was Other or Unknown: specify the unit of measurement for shipment weight used.
Product_Description
(PRODUCT_DESCRIPTION)
The product or commodity description for the shipment. Provide a general description of the type of product being shipped, delivered, or picked up. Do not enter item numbers, SKUs, product codes, trade name or catalog numbers. In the case of multiple products or commodities in the same shipment, provide the description of the heaviest product or commodity.  
Temperature_Control
(TEMPERATURE_CONTROL_FLAG)
Is the product or commodity reported is climate controlled or temperature controlled?  This could be via a temperature-controlled vehicle, container, or special packaging.   Yes or No
HAZMAT_Code
(HAZMAT_CODE)
Provide the 4-digit UN or NA HAZMAT code number for the hazardous good being shipped. For a shipment with multiple commodities or products, if the heaviest item in the shipment is not a HAZMAT, but other commodities in the shipment are HAZMAT, the HAZMAT_Code should be blank.
Domestic_Street_Address
(DOMESTIC_STREET_ADDRESS)
Street address of the U.S. destination. For exports, provide U.S. Port of Exit if known. For customer pickup, use the customer’s address on file, or use origin street address if the final destination is unknown.
Domestic_City_Name
(DOMESTIC_CITY_NAME)
City of U.S. destination. For exports, provide U.S. Port of Exit if known. For customer pickup, use the customer’s address on file, or use origin city if final destination city is unknown.
Domestic_State_Abbrev
(DOMESTIC_STATE_ABBREV)
State abbreviation of U.S. destination. For exports, provide U.S. Port of Exit if known. For customer pickup, use the customer’s address on file, or use origin state if final destination state is unknown.
Domestic_ZIP_Code
(DOMESTIC_ZIP_CODE)
ZIP Code of the U.S. destination. For exports, provide U.S. Port of Exit if known. For customer pickup, use the customer’s address on file, or use origin ZIP Code if the final destination ZIP Code is unknown. Enter a 5- or 9-digit ZIP Code.
Domestic_Transport_Modes
(DOMESTIC_TRANSPORT_MODES)
Provide all modes of transport to U.S. destination.   Enter all modes used in the sequence in which the modes are used.  Do not include the export mode of transport.  Do not use commas, dashes, or spaces to separate each mode.
Domestic_Transport_Wrtin
(DOMESTIC_TRANSPORT_WRITEIN)
If Domestic_Transport_Modes = 9 or 0,  specify the domestic mode of transportation used.
Export_City_Name
(EXPORT_CITY_NAME)
City of Foreign Destination.   Only respond if the shipment is an export         
Export_Country_Name
(EXPORT_COUNTRY_NAME)
Country of Foreign Destination.   Only respond if the shipment is an export         
Export_Postal_Code_Name
(EXPORT_POSTAL_CODE)
Postal code of Foreign Destination.   Only respond if the shipment is an export.        
Export_Transport_Mode
(EXPORT_TRANSPORT_MODE)
Provide mode of transport to Foreign destination.  Only respond if the shipment is an export.  
Export_Transport_Wrtin
(EXPORT_TRANSPORT_WRITEIN)
If Export_Transport_Mode = 0,  specify the domestic mode of transportation used.  Only respond if the shipment is an export.