A4 - 2022 CFS Shipments upload spreadsheet columns document

2022 Commodity Flow Survey

A4 - 2022 CFS Shipments upload spreadsheet columns document

OMB: 0607-0932

Document [docx]
Download: docx | pdf


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, in pounds.

Product_Description

(PRODUCT_DESCRIPTION)

The product description as stored in your electronic records. In the case of multiple products in the same shipment, provide the description of the heaviest product. Mixed freight categories are also available for some of the commodity groups.

Multiple_Products

(MULTIPLE_PRODUCTS)

Are there multiple products or commodities in this shipment? Yes or No

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_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.


File Typeapplication/vnd.openxmlformats-officedocument.wordprocessingml.document
AuthorRichard S Williamson (CENSUS/EMD FED)
File Modified0000-00-00
File Created2022-03-28

© 2024 OMB.report | Privacy Policy