About Global Trade Operational Intelligence

The Global Trade Operational Intelligence subject area allows you to access data present in Global Trade Management to create reports and data visualization projects.

The data present in the folders follow a star schema where parent child relation is maintained as in the database.

Subject Area

The Global Trade Operational Intelligence subject area has the following main sections, each catering to a different business object:

• Trade Transaction Analysis
• Restricted Party List Screening Analysis
• Declaration Analysis
• Item Analysis

Trade Transaction Analysis

The child tables included are:

• Transaction
• Transaction Code
• Transaction Conveyance
• Transaction Date
• Transaction Involved Location
• Transaction Involved Party
• Transaction Line
• Transaction Policy
• Transaction Port
• Transaction Quantity
• Transaction Reference
• Transaction Reference Number
• Transaction Remark
• Transaction Required Document
• Transaction Status
• Transaction Value

Restricted Party List Screening Analysis

The child tables included are:

• Party Screening Results
• Party Screening Comment
• Denied Party
• Party

Declaration Analysis

The child tables included are:

• Declaration Code
• Declaration Conveyance
• Declaration Involved Party
• Declaration Line
• Declaration Port
• Declaration Quantity
• Declaration Reference
• Declaration Reference Number
• Declaration Remark
• Declaration Status
• Declaration Date
• Declaration Value
• Declaration Involved Location
• Declaration Policy
• Declaration Required Document
• Declaration

Item Analysis

• Item
• Item Classification
• Item Description
• Item Origin
• Item Partner Item Join
• Item Partner Site Association
• Item Reference Number
• Item Remark
• Item Status
• Item Text
• Item UOM Conversion
• GTM Structure
• GTM Structure Component
• Country Code
• Product Classification Code
• Product Classification Type