Sales Orders Tab

The Sales Orders tab provides a view of various data including sales orders by:

Extended Amount by Importing Country

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Extended Amount by Importing Country

Column	Metadata Mapping
Extended Amount Base	IFNULL("- Trade Transaction Facts"."Extended Amount Base",0)
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Importer Country	"- Trade Transaction Involved Party Importer Dimensions"."Importer Country"

Extended Amount by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Extended Amount by Month of Import

Column	Metadata Mapping
Extended Amount Base	IFNULL("- Trade Transaction Facts"."Extended Amount Base",0)
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Order Date	"- Trade Transaction Order Date Period Dimensions"."Order Date"
Order Month	"- Trade Transaction Order Date Period Dimensions"."Order Month"

Extended Amount by Transport Mode

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Extended Amount by Transport Mode

Column	Metadata Mapping
Extended Amount Base	IFNULL("- Trade Transaction Facts"."Extended Amount Base",0)
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transport Mode ID	"- Trade Transaction Transport Mode Dimensions"."Transport Mode XID"

Sales Order Lines by Authorization

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Order Lines by Authorization

Column	Metadata Mapping
Authorization	"- Trade Transaction Line Dimensions"."Authorization"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Line Count	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Orders Lines by Control Code

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Order Lines by Control Code

Column	Metadata Mapping
Control Screening Code	"- Trade Transaction Line Dimensions"."Control Screening Control Code"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Line Count	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Order Lines by Exception Code

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Order Lines by Exception Code

Column	Metadata Mapping
Control Screening Exception Control Code	"- Trade Transaction Line Dimensions"."Control Screening Exception Control Code"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Line Count	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Order Lines by License Code

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Order Lines by License Code

Column	Metadata Mapping
Assigned License Code	"- Trade Transaction Line Dimensions"."Assigned License Code"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Line Count	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Orders Lines on Hold for Control Screening

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders Lines on Hold for Control Screening

Column	Metadata Mapping
Control Screening	"- Trade Transaction Line Dimensions"."Control Screening"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Sales Orders Lines on Hold for Control Screening	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Orders Lines on Hold for Product Classification

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders Lines on Hold for Product Classification

Column	Metadata Mapping
Product Classification	"- Trade Transaction Line Dimensions"."Product Classification"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Sales Orders Lines on Hold for Product Classification	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Order Lines on Hold for Restricted Party List Screening

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Order Lines on Hold for Restricted Party List Screening

Column	Metadata Mapping
Restricted Party List Screening	"- Trade Transaction Line Dimensions"."Restricted Party List Screening"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Sales Order Lines on Hold for Restricted Party List Screening	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Orders Lines on Hold for Sanction Screening

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders Lines on Hold for Sanction Screening

Column	Metadata Mapping
Sanction Country Screening	"- Trade Transaction Line Dimensions"."Sanction Country Screening"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Sales Orders Lines on Hold for Sanction Screening	"- Trade Transaction Line Facts"."Transaction Line Count"

Sales Orders by Month of Import

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders by Month of Import

Column	Metadata Mapping
Order Month	"- Trade Transaction Order Date Period Dimensions"."Order Month"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Count	"- Trade Transaction Facts"."Transaction Count"

Sales Orders by Ship To Country

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders by Ship To Country

Column	Metadata Mapping
Order Date	"- Trade Transaction Order Date Period Dimensions"."Order Date"
Ship to Country	"- Trade Transaction Involved Party Ship To Dimensions"."Ship To Country"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Count	"- Trade Transaction Facts"."Transaction Count"

Sales Orders by Transport Mode

This file is located in the catalog in /Shared Folders/GTI Reports/Sales Order Reports/Sales Orders by Transport Mode

Column	Metadata Mapping
Transport Mode ID	"- Trade Transaction Transport Mode Dimensions"."Transport Mode XID"
GTM Transaction Type GID	"- Trade Transaction Dimensions"."GTM Transaction Type GID"
Transaction Count	"- Trade Transaction Facts"."Transaction Count"