A7 - Upload Spreadsheet - CFS 2022_shipments_template.xlsx

2022 Commodity Flow Survey

A7 - Upload Spreadsheet - CFS 2022_shipments_template.xlsx

OMB: 0607-0932

Document [xlsx]
Download: xlsx | pdf
Shipment_ID Shipment_Date Shipment_Value Shipment_Weight Product_Description Multiple_Products Temperature_Control HAZMAT_Code Domestic_City_Name Domestic_State_Abbrev Domestic_ZIP_Code Domestic_Transport_Mode Domestic_Transport_Writein Export_City_Name Export_Country_Name Export_Postal_Code Export_Transport_Mode Export_Transport_Writein
Your internal identifier (e.g. Invoice # or Shipment #) for this shipment. Date of the shipment (mm/dd/yyyy).

Make sure to report for the specified reporting period.
The dollar value in whole dollars for 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).
Estimates acceptable.
Weight of shipment, in pounds.

Estimates acceptable.
The product or commodity description as stored in your electronic records.

In the case of multiple products or commodities in the same shipment, provide the description of the heaviest product or commodity.
Are there are multiple products or commodities in this shipment?

Y/N
Is the product or commodity reported climate controlled or temperature controlled?

This could be via a climate-controlled or temperature-controlled vehicle, container, or special packaging.

Y/N
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.
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.
State abbreviation of U.S. destination (2 character).

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.

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.
Provide all modes of transportation used to deliver this shipment to the U.S. destination in sequence used.

Do not include an export mode of transport.
Do not use commas, dashes, or spaces to separate each mode.

Modes:
1 - Parcel, U.S.P.S., or courier
2 - Company-owned truck
3 - For-hire truck
4 - Railroad
5 - Inland water
L - Great Lakes
6 - Deep sea
7 - Pipeline
8 - Air
9 - Other mode
0 - Unknown
C - Customer pick-up
If Domestic_Transport_Mode = 9 or 0

Specify the domestic mode of transportation used.
City of foreign destination.

Only respond if the shipment is an export.
Country of foreign destination.

Only respond if the shipment is an export.
Postal code of foreign destination.

Only respond if the shipment is an export.
Provide one mode of transport to foreign destination.

Only respond if the shipment is an export.

Modes:
1 - Parcel, U.S.P.S., or courier
2 - Company-owned truck
3 - For-hire truck
4 - Railroad
L - Great Lakes
6 - Deep sea
7 - Pipeline
8 - Air
0 - Unknown

(5 is intentionally missing)
If Export_Transport_Mode = 0

Specify the export mode of transportation used.

Only respond if the shipment is an export.

123-1 02/07/2022 224,235 44,840 Propane Y Y 1978 Los Angeles CA 90045 246
Beijing China 100000 6

402-H 02/07/2022 1,375 50,125 Sulfuric acid Y N 1830 Newark NJ 07105-0866 24






7845-1 02/08/2022 120 2 Footwear N N
Houston TX 77005 C






924-C 02/11/2022 1,500 15 Hydrochloric acid N N 1789 Blaine WA 98230 3
Vancouver Canada V6C 3

375-A 02/11/2022 1,250,000 15,000,000 Bituminous coal N N
Sheridan WY 82801 9 Conveyor belt
























File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy