Global Trade Intelligence
Declarations - Exports Tab
The Declarations - Exports tab provides a view of various data including:
- Export declarations by
- Export declaration lines by
- Extended Amount by
- Cost Breakdown by
Cost Breakdown by Declaration Type
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Cost Breakdown by Declaration Type
|
Column |
Metadata Mapping |
|---|---|
|
GTM Declaration Type GID |
"- Declaration Dimensions"."GTM Declaration Type GID" |
|
Extended Amount Base |
"- Declaration Facts"."Extended Amount Base" |
|
Bank Fee Base |
"- Declaration Facts"."Bank Fee Base" |
|
Brokerage Fee Base |
"- Declaration Facts"."Brokerage Fee Base" |
|
Charges Base |
"- Declaration Facts"."Charges Base" |
|
Domestic Inland Freight Base |
"- Declaration Facts"."Domestic Inland Freight Base" |
|
Foreign Inland Freight Base |
"- Declaration Facts"."Foreign Inland Freight Base" |
|
Excise Tax Base |
"- Declaration Facts"."Excise Tax Base" |
|
Handling Base |
"- Declaration Facts"."Handling Base" |
|
Freight Base |
"- Declaration Facts"."Freight Base" |
|
Insurance Base |
"- Declaration Facts"."Insurance Base" |
|
International Freight Base |
"- Declaration Facts"."International Freight Base" |
|
Loading Base |
"- Declaration Facts"."Loading Base" |
|
Marketing Fee Base |
"- Declaration Facts"."Marketing Fee Base" |
|
Other Base |
"- Declaration Facts"."Other 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" |
|
Unloading Base |
"- Declaration Facts"."Unloading Base" |
Cost Breakdown by Month of Export
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Cost Breakdown by Month of Export
|
Column |
Metadata Mapping |
|---|---|
|
Export Month |
"- Declaration Export Date Period Dimensions"."Export Month" |
|
Extended Amount Base |
"- Declaration Facts"."Extended Amount Base" |
|
Bank Fee Base |
"- Declaration Facts"."Bank Fee Base" |
|
Brokerage Fee Base |
"- Declaration Facts"."Brokerage Fee Base" |
|
Charges Base |
"- Declaration Facts"."Charges Base" |
|
Domestic Inland Freight Base |
"- Declaration Facts"."Domestic Inland Freight Base" |
|
Foreign Inland Freight Base |
"- Declaration Facts"."Foreign Inland Freight Base" |
|
Excise Tax Base |
"- Declaration Facts"."Excise Tax Base" |
|
Handling Base |
"- Declaration Facts"."Handling Base" |
|
Freight Base |
"- Declaration Facts"."Freight Base" |
|
Insurance Base |
"- Declaration Facts"."Insurance Base" |
|
International Freight Base |
"- Declaration Facts"."International Freight Base" |
|
Loading Base |
"- Declaration Facts"."Loading Base" |
|
Marketing Fee Base |
"- Declaration Facts"."Marketing Fee Base" |
|
Other Base |
"- Declaration Facts"."Other 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" |
|
Unloading Base |
"- Declaration Facts"."Unloading Base" |
Export Declaration Lines by Declaration Type
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Export 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" |
Export Declaration Lines by Month of Import
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Export Declaration Lines by Month of Import
|
Column |
Metadata Mapping |
|---|---|
|
Export Month |
"- Declaration Line Export Date Period Dimensions"."Export Month" |
|
Declaration Line Count |
"- Declaration Line Facts"."Declaration Line Count" |
Export Declarations by Month of Import
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Export Declarations by Month of Import
|
Column |
Metadata Mapping |
|---|---|
|
Export Month |
"- Declaration Export Date Period Dimensions"."Export Month" |
|
Declaration Count |
"- Declaration Facts"."Declaration Count" |
Export Declarations by Declaration Type
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Export Declarations by Declaration Type
|
Column |
Metadata Mapping |
|---|---|
|
GTM Declaration Type GID |
"- Declaration Line Dimensions"."GTM Declaration Type GID" |
|
Declaration Count |
"- Declaration Facts"."Declaration Count" |
Extended Amount by Declaration Type
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Extended Amount by Declaration Type
|
Column |
Metadata Mapping |
|---|---|
|
GTM Declaration Type GID |
"- Declaration Dimensions"."GTM Declaration Type GID" |
|
Extended Amount Base |
IFNULL("- Declaration Facts"."Extended Amount Base",0) |
Extended Amount by Month of Export
This file is located in the catalog in /Shared Folders/GTI Reports/GTI Declaration Reports/Exports/Extended Amount by Month of Export
|
Column |
Metadata Mapping |
|---|---|
|
Export Month |
"- Declaration Export Date Period Dimensions"."Export Month" |
|
Extended Amount Base |
IFNULL("- Declaration Facts"."Extended Amount Base",0) |
Related Topics
If you have any questions or comments about this documentation page, please Contact Oracle Documentation. 