Declarations - Imports Tab

The Declarations - Imports tab provides a view of various data including:

Import declarations by
- month of import
- declaration type
Import declaration lines by
- month of import
- declaration type
Customs value base by
- month of import
- declaration type
Cost Breakdown by
- month of import
- declaration type

Cost Breakdown by Declaration Type

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Cost Breakdown by Declaration Type

Column	Metadata Mapping
GTM Declaration Type GID	"- Declaration Dimensions"."GTM Declaration Type GID"
Assist Freight Base	"- Declaration Facts"."Assist Freight Base"
Assist Value Base	"- Declaration Facts"."Assist Value Base"
Bank Fee Base	"- Declaration Facts"."Bank Fee Base"
Brokerage Fee Base	"- Declaration Facts"."Brokerage Fee Base"
Buying Commission Base	"- Declaration Facts"."Buying Commission Base"
Charges Base	"- Declaration Facts"."Charges Base"
Customs Value Base	"- Declaration Facts"."Customs Value Base"
Domestic Inland Freight Base	"- Declaration Facts"."Domestic Inland Freight Base"
Dutiable International Freight Base	"- Declaration Facts"."Dutiable International Freight Base"
Duty Base	"- Declaration Facts"."Duty Base"
Excise Tax Base	"- Declaration Facts"."Excise Tax Base"
Foreign Inland Freight Base	"- Declaration Facts"."Foreign Inland Freight Base"
Freight Base	"- Declaration Facts"."Freight Base"
Handling Base	"- Declaration Facts"."Handling Base"
Harbor Maintenance Fees Base	"- Declaration Facts"."HMF Base"
Insurance Base	"- Declaration Facts"."Insurance Base"
International Freight Base	"- Declaration Facts"."International Freight Base"
Interest Base	"- Declaration Facts"."Interest Base"
Letter of Credit Base	"- Declaration Facts"."Letter of Credit Base"
License Fee Base	"- Declaration Facts"."License Fee Base"
Loading Base	"- Declaration Facts"."Loading Base"
Marketing Fee Base	"- Declaration Facts"."Marketing Fee Base"
Merchandise Processing Fee Base	"- Declaration Facts"."MPF Base"
Other Base	"- Declaration Facts"."Other Base"
Other Tax Base	"- Declaration Facts"."Other Tax Base"
Packing Fee Base	"- Declaration Facts"."Packing Fee Base"
Selling Commission Base	"- Declaration Facts"."Selling Commission Base"
Storage Fee Base	"- Declaration Facts"."Storage Fee Base"
Value Added Tax Base	"- Declaration Facts"."VAT Base"
Tax Base	"- Declaration Facts"."Tax Base"
Unloading Base	"- Declaration Facts"."Unloading Base"

Cost Breakdown by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Cost Breakdown by Month of Import

Column	Metadata Mapping
Import Month	"- Declaration Import Date Period Dimensions"."Import Month"
Assist Freight Base	"- Declaration Facts"."Assist Freight Base"
Assist Value Base	"- Declaration Facts"."Assist Value Base"
Bank Fee Base	"- Declaration Facts"."Bank Fee Base"
Brokerage Fee Base	"- Declaration Facts"."Brokerage Fee Base"
Buying Commission Base	"- Declaration Facts"."Buying Commission Base"
Charges Base	"- Declaration Facts"."Charges Base"
Customs Value Base	"- Declaration Facts"."Customs Value Base"
Domestic Inland Freight Base	"- Declaration Facts"."Domestic Inland Freight Base"
Dutiable International Freight Base	"- Declaration Facts"."Dutiable International Freight Base"
Duty Base	"- Declaration Facts"."Duty Base"
Excise Tax Base	"- Declaration Facts"."Excise Tax Base"
Foreign Inland Freight Base	"- Declaration Facts"."Foreign Inland Freight Base"
Freight Base	"- Declaration Facts"."Freight Base"
Handling Base	"- Declaration Facts"."Handling Base"
Harbor Maintenance Fees Base	"- Declaration Facts"."HMF Base"
Insurance Base	"- Declaration Facts"."Insurance Base"
International Freight Base	"- Declaration Facts"."International Freight Base"
Interest Base	"- Declaration Facts"."Interest Base"
Letter of Credit Base	"- Declaration Facts"."Letter of Credit Base"
License Fee Base	"- Declaration Facts"."License Fee Base"
Loading Base	"- Declaration Facts"."Loading Base"
Marketing Fee Base	"- Declaration Facts"."Marketing Fee Base"
Merchandise Processing Fee Base	"- Declaration Facts"."MPF Base"
Other Base	"- Declaration Facts"."Other Base"
Other Tax Base	"- Declaration Facts"."Other Tax Base"
Packing Fee Base	"- Declaration Facts"."Packing Fee Base"
Selling Commission Base	"- Declaration Facts"."Selling Commission Base"
Storage Fee Base	"- Declaration Facts"."Storage Fee Base"
Value Added Tax Base	"- Declaration Facts"."VAT Base"
Tax Base	"- Declaration Facts"."Tax Base"
Unloading Base	"- Declaration Facts"."Unloading Base"

Customs Value by Declaration Type

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Customs Value by Declaration Type

Column	Metadata Mapping
GTM Declaration Type GID	"- Declaration Dimensions"."GTM Declaration Type GID"
Customs Value	IFNULL("- Declaration Facts"."Customs Value Base",0)

Customs Value by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Customs Value by Month of Import

Column	Metadata Mapping
Import Month	"- Declaration Import Date Period Dimensions"."Import Month"
Customs Value	IFNULL("- Declaration Facts"."Customs Value Base",0)

Import Declaration by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Import Declaration by Month of Import

Column	Metadata Mapping
Import Month	"- Declaration Import Date Period Dimensions"."Import Month"
Declaration Count	"- Declaration Facts"."Declaration Count"

Import Declaration Lines by Declaration Type

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Import Declaration Lines by Declaration Type

Column	Metadata Mapping
GTM Declaration Type GID	"- Declaration Line Dimensions"."GTM Declaration Type GID"
Declaration Line Count	"- Declaration Line Facts"."Declaration Line Count"

Import Declaration Lines by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Import Declaration Lines by Month of Import

Column	Metadata Mapping
Import Month	"- Declaration Line Import Date Period Dimensions"."Import Month"
Declaration Line Count	"- Declaration Line Facts"."Declaration Line Count"

Import Declarations by Declaration Type

This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Imports/Import Declarations by Declaration Type

Column	Metadata Mapping
GTM Declaration Type GID	"- Declaration Dimensions"."GTM Declaration Type GID"
Declaration Count	"- Declaration Facts"."Declaration Count"