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.

Global Trade Operational Intelligence is available as a subject area under Global Trade Intelligence > Ad Hoc Query > Analysis > Global Trade Operational Intelligence.

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:

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

Transaction Analysis

The child tables included are:

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

Transaction Line

• Transaction Line
• Transaction Line Product Classification
• Transaction Line Percentage Values
• Transaction Line Assigned Licenses
• Transaction Line Other Control Screening Results
• Transaction Line Sanction Control Results
• Transaction Line Required Document
• Transaction Line Reporting Quantity
• Transaction Line User-defined Code
• Transaction Line Remarks
• Transaction Line Text Template
• Transaction Line Value
• Transaction Line Reference Numbers
• Transaction Line History
• Transaction Line Qualifications
• Transaction Line Involved Party
• Transaction Line Item Dimension
• Transaction Line Quantity
• Transaction Line Date
• Transaction Tariff Rate

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

Declaration Line

• Declaration Line
• Declaration Line History
• Declaration Line Other Control Screening Results
• Declaration Line Percentage Values
• Declaration Line Product Classification
• Declaration Line Qualifications
• Declaration Line Reference Numbers
• Declaration Line Remarks
• Declaration Line Reporting Quantity
• Declaration Line Required Document
• Declaration Line Sanction Control Results
• Declaration Line Text Template
• Declaration Line User-defined Code
• Declaration Line Value
• Declaration Line Involved Party
• Declaration Line Item Dimensions
• Declaration Line Quantity
• Declaration Line Date
• Declaration Line Tariff Rate

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