GTM Constraint Sets

This page is accessed via:

Master Data > Power Data > Configurations > Constraint Sets.
Configuration and Administration > Power Data > General> Constraint Sets.

Use this page to define screening constraints to determine which trade item structures and licenses can be assigned for transaction lines.

You can create constraints based on which multiple transaction lines will be grouped and aggregated into one declaration when you perform the Create Declarations action. You can also configure constraints to group transaction lines into a summary declaration based on date qualifiers and a daily, weekly, monthly, or yearly matching pattern.

This page can be used to set up constraints to copy over trade program information from an item to a transaction line/declaration line.

Constraints can also be configured to match a bill/invoice rule to a shipment, and for grouping bills/invoices while generating a bill/invoice.

Identification

Enter an ID in the Constraint Set ID field.
Select a constraint set type from the Constraint Set Type drop-down list. The options are:

Bill-Consolidation: Select this option to configure constraints to add a bill to a consolidated bill when you perform the Add to Consolidated Bill agent action.
Bill-Match Rule: Select this option to configure constraints to match bill rule with a shipment.
Bill Line-Grouping: Select this option to configure constraints for grouping bill lines when you perform the Generate/Adjust Bill action.
Declaration-Line Aggregation: Select this option to configure constraints for aggregating transaction lines when you perform the Create/Add to Existing Declarations action.
Declaration-Line Grouping: Select this option to configure constraints for grouping transaction lines when you perform the Create/Add to Existing Declarations action.
Invoice-Consolidation: Select this option to configure constraints to add an invoice to a consolidated invoice when you perform the Add to Consolidated Invoice agent action.
Invoice-Match Rule: Select this option to configure constraints to match the invoice rule with a shipment.
Invoice Line-Grouping: Select this option to configure constraints for grouping invoice lines when you perform the Generate/Adjust Invoice action.
Invoice Line-Aggregation: Select this option to configure constraints for aggregating invoice lines when you perform the Generate Invoice action and Approve Invoice by Line action where multiple shipment costs can match to multiple invoice lines.
Item Origin Item Str Component - Match: Select this option to configure constraints to lookup item origin on an item structure component.
Trade Incentive Program - Entry Exit Matching: Select this option to configure constraints to match an import line to an export line.
Trade Value Item Str Component - Match: Select this option to configure constraints to lookup item trade value on an item structure component.
Trade Value Item Structure - Match: Select this option to configure constraints to lookup item trade value on an item structure.
Transaction Line - Lookup Trade Item Structure: Select this option to configure constraints to determine the item structure while performing the Qualify for Trade Agreement action.
Transaction-Line Country of Origin Lookup: Select this option to configure constraints to search and assign a country of origin to a trade transaction line when you perform the action Look Up Country of Origin.
Transaction-Line Item Structure Assignment: Select this option to configure constraints for assigning trade item structures to a transaction line.
Transaction-Line License Determination: Select this option to configure constraints for determining the license for a transaction line.
Transaction-Line Qualification Lookup: Select this option to configure constraints on a trade transaction line while performing the Qualify for Trade Agreement action.
Transaction-Line Trade Program Lookup: Select this option to configure constraints to copy information from an item to a transaction line/declaration line when you perform the action Look Up Trade Program.

If the domain in which this constraint set will be active from the Domain Name drop-down list.
If needed, enter additional information about the constraint set in the Description field.
Click Constraints to move to the next tab.

Constraints

Select a constraint from the Constraint ID drop-down list. The corresponding description will be displayed in the Description field, including what the constraint accomplishes.
Click Save. You can record multiple criteria. Remember to click Save after entering each criterion.
Click Constraint Details to move to the next tab.

Note: For the constraint set type TRADE INCENTIVE PROGRAM - ENTRY EXIT MATCHING, constraints are grouped under groups like Date Flex Field, Line Reference Number, Line Remark, Number Flex Field, Reference Number, Remark, and String Flex Field. You can select multiple constraints from one group. These constraints will be displayed under one Constraint Group in the Constraint Details tab page.

Constraint Details

Use any additional fields to identify what must be matched, e.g. Product Classification Type or Qualifier ID. If you want to map qualifiers from transaction lines while grouping/aggregation, you can select corresponding target qualifiers on the declaration to be created.

You can enter multiple types. Remember to click Save after entering each one.

Note: You can group transaction lines with matching date qualifiers on a daily, weekly, monthly, or yearly basis.
For this, select the combination of a constraint set type of DECLARATION-LINE GROUPING and constraint ID of DATE.
On the Constraint Details page, select the source and target date qualifiers to be mapped.
Select the appropriate option from the Matching Pattern drop-down list. For example, if you select the MONTHLY option, transaction lines with same date qualifiers and same month will be grouped together.
If you select the matching pattern as WEEKLY, then select a day from the First Day of Week drop-down list to indicate the starting day of the week. This will help in determining whether the transaction lines fall within the same week. For Summary Declaration, use weekly, monthly, or yearly option.

Note: The Match Type drop-down list is available only when the selected constraint set type is TRANSACTION-LINE ITEM STRUCTURE ASSIGNMENT, TRADE INCENTIVE PROGRAM - ENTRY EXIT MATCHING, BILL-MATCH RULE, or INVOICE-MATCH RULE. Select All or One Of to match all or only one of the additional input respectively.

Note: When you use BILL-CONSOLIDATION or INVOICE-CONSOLIDATION constraint set type, you can add bills/invoices to consolidated bill/invoice based on a date using the constraint type Bill-Date/Invoice-Date. On the Constraint Details page, select the Date field, which specifies the date field for the standard bill/invoice. Select the Target Date field, which specifies the date field for the consolidated bill/invoice. The value of these fields will be used for matching.
Select the appropriate Matching Pattern drop-down list option to add bills/invoices to a consolidated bill or invoice.
For example:
- If you select the DAILY option, bills/invoices will be added to a consolidated bill/invoice having the same invoice date.
- If you select the MONTHLY option, bills/invoices will be added to a consolidated bill/invoice having the date within the same month.
- If you select the WEEKLY option, select a day from the First Day of Week drop-down list to indicate the starting day of the week. If the First Day of Week is not provided then the default is Monday. This will determine whether the bill/invoice needs to be added to a consolidated bill/invoice having the date within the same week.

Following are the constraints available for the bill-consolidation:

Constraint	Function	Additional Input
Bill-Date	Matches Bill based on the selected date.	Date - Invoice Date Target Date - Invoice Date Matching Pattern - Daily - Monthly - Weekly First Day of Week Note: The field First Day of Week is only considered when you select the Matching Pattern field as Weekly.
Bill-Involved Party	Matches Bill based on values of the selected involved party qualifiers.	Involved Party Qualifier
Bill-Refnum	Matches Bill based on values of the selected reference number qualifiers.	Reference Number Qualifier
Bill-Service Provider	Matches Bill based on the service provider.	n/a

Following are the constraints available for the bill-match rule and invoice-match rule:

Constraint	Function	Additional Input
Shipment Incoterm	Matches selected value of Incoterm with the Incoterm value associated with Shipment.	Incoterm
Shipment Involved Parties	Matches Involved Party values of the selected Involved Party Qualifiers with the respective Involved Party values associated with the Shipment.	Involved Party Qualifier, Contact
Shipment Number Flex Attribute	Matches value of number flex attribute with the respective flex attribute of the Shipment.	Number Flex Field, Value
Shipment Refnum	Matches value of given reference number qualifier with the respective reference number of the Shipment.	Shipment Reference Number Qualifier, Value
Shipment String Flex Attribute	Matches value of string flex attribute with the respective string attribute of the Shipment.	String Flex Field, Value

Following are the constraints available for bill-line grouping:

Constraint	Function	Additional Input
Bill Line - Accessorial Code	Groups Bill Lines based on Accessorial Code.	n/a
Bill Line - Cost Type	Groups Bill Lines based on Cost Type.	n/a
Bill Line - Currency	Groups Bill Lines based on currency type.	n/a
Bill Line - Date Flex Fields	Groups Bill Lines based on the selected Date Flex Fields.	Date Flex Fields
Bill Line - Involved Parties	Groups lines based on values of the selected Involved Party Qualifiers provided on the lines.	Involved Party Qualifier
Bill Line - Number Flex Fields	Groups Bill Lines based on the selected Number flex attribute.	Number Flex Fields
Bill Line - Payment Method	Groups Bill Lines based on the Payment Method Code.	n/a
Bill Line - Refnums	Groups Bill Lines based on reference numbers corresponding to the selected Reference Number Qualifiers provided on the lines.	Reference Number Qualifier
Bill Line - Remarks	Groups Bill Lines based on remark texts corresponding to the selected Remark Qualifiers provided on the lines.	Remark Qualifier
Bill Line - String Flex Fields	Groups Bill Lines based on the selected String Flex Fields.	String Flex Fields

Following are the constraints available for the invoice-consolidation:

Constraint	Function	Additional Input
Invoice-Date	Matches Invoice based on values of the selected date.	Date - Invoice Date Target Date - Invoice Date Matching Pattern - Daily - Monthly - Weekly First Day of Week Note: The field First Day of Week is only considered when you select the Matching Pattern field as Weekly.
Invoice-Involved Party	Matches Invoice based on values of the involved party qualifier.	Involved Party Qualifier
Invoice-Refnum	Matches Invoice based on values of the reference number qualifier.	Reference Number Qualifier
Invoice-Service Provider	Matches Invoice based on values of the service provider.	n/a

Following are the constraints available for invoice-line grouping:

Constraint	Function	Additional Input
Invoice Line - Accessorial Code	Groups Invoice Lines based on Accessorial Code.	n/a
Invoice Line - Cost Type	Groups Invoice Lines based on Cost Type.	n/a
Invoice Line - Currency	Groups Invoice Lines based on currency type.	n/a
Invoice Line - Date Flex Fields	Groups Invoice Lines based on the selected Date Flex Fields.	Date Flex Fields
Invoice Line - Involved Parties	Groups lines based on values of the selected Involved Party Qualifiers provided on the lines.	Involved Party Qualifier
Invoice Line - Number Flex Fields	Groups Invoice Lines based on the selected Number flex attribute.	Number Flex Fields
Invoice Line - Payment Method	Groups Invoice Lines based on the Payment Method Code.	n/a
Invoice Line - Refnums	Groups Invoice Lines based on reference numbers corresponding to the selected Reference Number Qualifiers provided on the lines.	Reference Number Qualifier
Invoice Line - Remarks	Groups Invoice Lines based on remark texts corresponding to the selected Remark Qualifiers provided on the lines.	Remark Qualifier
Invoice Line - Service Provider	Groups Invoice Lines based on the service provider associated with the shipments (including secondary charges) of Shipment Group.	n/a
Invoice Line - String Flex Fields	Groups Invoice Lines based on the selected String Flex Fields.	String Flex Fields

Following are the constraints available for invoice-line aggregation:

Constraint	Function	Additional Input
Invoice Line - Accessorial Code	Groups Invoice Lines based on Accessorial Code.	Accessorial Code Note: The application will only aggregate lines based on the selected accessorial codes provided in the Accessorial Codes field. If you don't select any accessorial code, all lines will be aggregated based on all the matching accessorial codes.
Invoice Line - Cost Type	Groups Invoice Lines based on Cost Type.	n/a
Invoice Line - General Ledger Code	Groups Invoice Lines based on General Ledger Code.	n/a
Invoice Line - Payment Method Code	Groups Invoice Lines based on Payment Method Code.	n/a

Following are the constraints available for declaration-line aggregation:

Constraint	Function	Additional Input
Date Flex Fields	Matches Transaction Lines based on values of the selected Date Flex Fields.	Date Flex Fields
Incoterm	Matches Transaction Lines based on Incoterms defined on the line or its header.	n/a
Involved Parties	Matches Transaction Lines based on values of the selected Involved Party Qualifiers provided on the lines and their headers.	Involved Party Qualifier
Line Controls	Matches the control codes between two transaction lines.	n/a
Line Country of Origin	Matches the countries of origin between two transaction lines.	n/a
Line Dates	Matches transaction lines based on dates provided on the lines and header.	Date Qualifier
Line Product Classifications	Matches the classification codes between two transaction lines.	Product Classification Type
Line Reference Numbers	Matches reference numbers corresponding to selected reference qualifiers between transaction lines.	Reference Number Qualifier
Line Remarks	Matches remark texts corresponding to selected remark qualifiers between transaction lines.	Remark Qualifier
Line Trade Program	Matches transaction lines based on trade program provided on the lines.	n/a
Number Flex Fields	Matches Transaction Lines based on values of the selected Number Flex Fields.	Number Flex Fields
String Flex Fields	Matches Transaction Lines based on values of the selected String Flex Fields.	String Flex Fields
User-defined Categories	Matches Transaction Lines based on user-defined codes and user-defined types corresponding to the selected User-defined Category provided on the lines. Note: It is suggested that you configure any user-defined category only once. Configuring same category more than once might not give desirable grouping/aggregation results.	Category
User-defined Types	Matches Transaction Lines based on user-defined codes corresponding to the selected User-defined Types provided on the lines and their headers.	Type

Following are the constraints available for declaration-line grouping:

Constraint	Function	Additional Input
Border Transport Mode	Matches Transaction Lines based on transport mode, conveyance flag and conveyance name provided on Transaction headers.	n/a
Date Flex Fields	Matches Transaction Lines based on values of the selected Date Flex Fields.	Date Flex Fields
Dates	Matches Transaction Lines based on values of the selected Date Qualifiers provided on Transaction headers.	Date Qualifier
Incoterm	Matches Transaction Lines based on Incoterms defined on the line or its header.	n/a
Involved Parties	Matches Transaction Lines based on values of the selected Involved Party Qualifiers provided on the lines and their headers.	Involved Party Qualifier
Line Reference Numbers	Matches Transaction Lines based on reference numbers corresponding to the selected Reference Number Qualifiers provided on the lines.	Reference Number Qualifier
Line Remarks	Matches Transaction Lines based on remark texts corresponding to the selected Remark Qualifiers provided on the lines.	Remark Qualifier
Line Trade Program	Matches transaction lines based on trade program provided on the lines.	n/a
Number Flex Fields	Matches Transaction Lines based on values of the selected Number Flex Fields.	Number Flex Fields
Ports	Matches Transaction Lines based on IDs of the selected Port Qualifiers provided on corresponding Transaction headers.	Port Qualifier
Reference Numbers	Matches Transaction Lines based on reference numbers corresponding to the selected Reference Number Qualifiers provided on the Transaction headers.	Reference Number Qualifier
Remarks	Matches Transaction Lines based on remark texts corresponding to the selected Remark Qualifiers provided on the Transaction headers.	Remark Qualifier
String Flex Fields	Matches Transaction Lines based on values of the selected String Flex Fields.	String Flex Fields
User-defined Categories	Matches Transaction Lines based on user-defined codes and user-defined types corresponding to the selected User-defined Category provided on the lines. Note: It is suggested that you configure any user-defined category only once. Configuring same category more than once might not give desirable grouping/aggregation results.	Category
User-defined Types	Matches Transaction Lines based on user-defined codes corresponding to the selected User-defined Types provided on the lines and their headers.	Type

Following are the constraints available to look up item origin on an item structure component:

Constraint	Function	Additional Input
Item Origin STR Component - Inventory Org	Matches Inventory Organization on each Item Origin with Inventory Organization on Trade Item Structure Component	n/a
Item Origin STR Component - Lot Number	Matches Lot Number on each Item Origin with the selected String Flex Fields on Item Structure Component.	Item Origin String Flex Fields, Item Structure Component String Flex Fields
Item Origin STR Component - Partner	Matches Partner on each Item Origin with Partner on Trade Item Structure Component.	n/a
Item Origin STR Component - Partner Site	Matches Partner Site on each Item Origin with Partner Site on Trade Item Structure Component	n/a
Item Origin STR Component - Serial Number	Matches Serial Number on each Item Origin with the selected String Flex Fields on Item Structure Component.	Item Origin String Flex Fields, Item Structure Component String Flex Fields

Following are the constraints available to look up trade value on an item structure component:

Constraint	Function	Additional Input
Trade Value STR Component - Inventory Org	Matches Inventory Organization on each Trade Value with Inventory Organization on Trade Item Structure Component	n/a
Trade Value STR Component - Lot Number	Matches Lot Number on each Trade Value with the selected String Flex Fields on Item Structure Component.	Item Structure Component String Flex Fields
Trade Value STR Component - Partner	Matches Partner on each Trade Value with Partner on Trade Item Structure Component.	n/a
Trade Value STR Component - Partner Site	Matches Partner Site on each Trade Value with Partner Site on Trade Item Structure Component.	n/a
Trade Value STR Component - Serial Number	Matches Serial Number on each Trade Value with the selected String Flex Fields on Item Structure Component.	Item Structure Component String Flex Fields

Following are the constraints available to match import and export lines:

Constraint	Function	Additional Input
COUNTRY	Matches each Entry Line to Exit Line based on countries of involved parties.	Entry Involved Party Exit Involved Party
COUNTRY OF ORIGIN	Matches each Entry Line to Exit Line based on countries of origin provided on the Line.	n/a
Constraint Group: DATE FLEX FIELD
DECLARATION LINE TO DECLARATION LINE	Matches each Entry Declaration Line to Exit Declaration Line based on values of the selected Date Flex Fields	Entry Date Attribute Exit Date Attribute
DECLARATION LINE TO TRANSACTION LINE	Matches each Entry Declaration Line to Exit Transaction Line based on values of the selected Date Flex Fields	Entry Date Attribute Exit Date Attribute
TRANSACTION LINE TO DECLARATION LINE	Matches each Entry Transaction Line to Exit Declaration Line based on values of the selected Date Flex Fields	Entry Date Attribute Exit Date Attribute
TRANSACTION LINE TO TRANSACTION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected Date Flex Fields	Entry Date Attribute Exit Date Attribute
ITEM	Matches Item ID on each Entry Line with Item ID on Exit Line	n/a
Constraint Group: LINE REFERENCE NUMBER
DECLARATION LINE TO DECLARATION LINE	Matches each Entry Declaration Line to Exit Declaration Line based on values of the selected Reference Number Qualifiers.	Entry Line Reference Number Qualifier Exit Line Reference Number Qualifier
DECLARATION LINE TO TRANSACTION LINE	Matches each Entry Declaration Line to Exit Transaction Line based on values of the selected Reference Number Qualifiers.	Entry Line Reference Number Qualifier Exit Line Reference Number Qualifier
TRANSACTION LINE TO DECLARATION LINE	Matches each Entry Transaction Line to Exit Declaration Line based on values of the selected Reference Number Qualifiers.	Entry Line Reference Number Qualifier Exit Line Reference Number Qualifier
TRANSACTION LINE TO TRANSACTION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected Reference Number Qualifiers.	Entry Line Reference Number Qualifier Exit Line Reference Number Qualifier
Constraint Group: LINE REMARK
DECLARATION LINE TO DECLARATION LINE	Matches each Entry Declaration Line to Exit Declaration Line based on values of the selected Remark Text Qualifiers.	Entry Line Remark Qualifier Exit Line Remark Qualifier
DECLARATION LINE TO TRANSACTION LINE	Matches each Entry Declaration Line to Exit Transaction Line based on values of the selected Remark Text Qualifiers.	Entry Line Remark Qualifier Exit Line Remark Qualifier
TRANSACTION LINE TO DECLARATION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected Remark Text Qualifiers.	Entry Line Remark Qualifier Exit Line Remark Qualifier
TRANSACTION LINE TO TRANSACTION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected Remark Text Qualifiers.	Entry Line Remark Qualifier Exit Line Remark Qualifier
LOCATION	Matches Involved Party Locations on the each Entry Line with Involved Locations on Exit Line locations.	Entry Involved Party Exit Involved Party
Constraint Group: NUMBER FLEX FIELD
DECLARATION LINE TO DECLARATION LINE	Matches each Entry Declaration Line to Exit Declaration Line based on values of the selected Number Flex Fields	Entry Number Attribute Exit Number Attribute
DECLARATION LINE TO TRANSACTION LINE	Matches each Entry Declaration Line to Exit Transaction Line based on values of the selected Number Flex Fields	Entry Number Attribute Exit Number Attribute
TRANSACTION LINE TO DECLARATION LINE	Matches each Entry Transaction Line to Exit Declaration Line based on values of the selected Number Flex Fields	Entry Number Attribute Exit Number Attribute
TRANSACTION LINE TO TRANSACTION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected Number Flex Fields	Entry Number Attribute Exit Number Attribute
PARTY	Matches each Entry Line to Exit Line based on Involved Parties.	Entry Involved Party Exit Involved Party
PRODUCT CLASSIFICATION CODE	Matches Classification type and code on each Entry Line with Item on Exit Line	Product Classification Type Digit Level
Constraint Group: REFERENCE NUMBER
DECLARATION TO DECLARATION	Matches parent of each Entry Declaration Line to parent of Exit Declaration Line based on values of the selected Reference Number Qualifiers.	Entry Reference Number Qualifier Exit Reference Number Qualifier
DECLARATION TO TRANSACTION	Matches parent of each Entry Declaration Line to parent of Exit Transaction Line based on values of the selected Reference Number Qualifiers.	Entry Reference Number Qualifier Exit Reference Number Qualifier
TRANSACTION TO DECLARATION	Matches parent of each Entry Transaction Line to parent of Exit Declaration Line based on values of the selected Reference Number Qualifiers.	Entry Reference Number Qualifier Exit Reference Number Qualifier
TRANSACTION TO TRANSACTION	Matches parent of each Entry Transaction Line to parent of Exit Transaction Line based on values of the selected Reference Number Qualifiers.	Entry Reference Number Qualifier Exit Reference Number Qualifier
Constraint Group: REMARK
DECLARATION TO DECLARATION	Matches parent of each Entry Declaration Line to parent of Exit Declaration Line based on values of the selected Remark Text Qualifiers.	Entry Remark Qualifier Exit Remark Qualifier
DECLARATION TO TRANSACTION	Matches parent of each Entry Declaration Line to parent of Exit Transaction Line based on values of the selected Remark Text Qualifiers.	Entry Remark Qualifier Exit Remark Qualifier
TRANSACTION TO DECLARATION	Matches parent of each Entry Transaction Line to parent of Exit Declaration Line based on values of the selected Remark Text Qualifiers.	Entry Remark Qualifier Exit Remark Qualifier
TRANSACTION TO TRANSACTION	Matches parent of each Entry Transaction Line to parent of Exit Transaction Line based on values of the selected Remark Text Qualifiers.	Entry Remark Qualifier Exit Remark Qualifier
Constraint Group: STRING FLEX FIELD
DECLARATION LINE TO DECLARATION LINE	Matches each Entry Declaration Line to Exit Declaration Line based on values of the selected String Flex Fields	Entry String Attribute Exit String Attribute
DECLARATION LINE TO TRANSACTION LINE	Matches each Entry Declaration Line to Exit Transaction Line based on values of the selected String Flex Fields	Entry String Attribute Exit String Attribute
TRANSACTION LINE TO DECLARATION LINE	Matches each Entry Transaction Line to Exit Declaration Line based on values of the selected String Flex Fields	Entry String Attribute Exit String Attribute
TRANSACTION LINE TO TRANSACTION LINE	Matches each Entry Transaction Line to Exit Transaction Line based on values of the selected String Flex Fields	Entry String Attribute Exit String Attribute

Following are the constraints available to look up trade value on an item structure:

Constraint	Function	Additional Input
Trade Value - Inventory Org	Matches Inventory Organization on each Trade Value with Inventory Organization on Trade Item Structure.	n/a
Trade Value - Lot Number	Matches Lot Number on each Trade Value with the selected String Flex Fields on Item Structure.	Item Structure String Flex Fields
Trade Value - Partner	Matches Partner on each Trade Value with Partner on Trade Item Structure.	n/a
Trade Value - Partner Site	Matches Partner Site on each Trade Value with Partner Site on Trade Item Structure.	n/a
Trade Value - Serial Number	Matches Serial Number on each Trade Value with the selected String Flex Fields on Item Structure.	Item Structure String Flex Fields

Following are the constraints available for trade item structure lookup:

Constraint	Function	Additional Input
LINE ITEM STR - DATE FLEX FIELD	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Structure.	Transaction Line Date Flex Fields Structure Date Attribute
LINE ITEM STR - DATE QUALIFIER	Checks Dates corresponding to selected Date Qualifiers on the Transaction Line with the Effective and Expiration Date on Item Structure.	Date Qualifier
LINE ITEM STR - INVENTORY ORG	Matches the Involved Party corresponding to selected Involved Party Qualifier on the Transaction Line with Inventory Organization on Item Structure. Please select only one Party Qualifier.	Inventory Organization
LINE ITEM STR - NUMBER FLEX FIELD	Matches selected Number Flex Fields on Transaction Line with the selected Number Flex Fields on Item Structure.	Structure Number Attribute
LINE ITEM STR - PARTNER	Matches the Involved Party corresponding to selected Involved Party Qualifier with Partner on Item Structure. Please select only one Party Qualifier.	Partner
LINE ITEM STR - PARTNER SITE	Matches the Location of the Party Site of selected Involved Party Qualifier with the Location of the Partner Site on Item Structure. Please select only one Party Qualifier.	Partner Site
LINE ITEM STR - REFNUM	Matches Reference Numbers corresponding to selected Refnum Qualifiers on each Transaction Line with Reference Numbers corresponding to selected Refnum Qualifiers on Item Structure.	Transaction Line Reference Number Qualifier
LINE ITEM STR - REMARK	Matches Remark Texts corresponding to selected Remark Qualifiers on each Transaction Line with Remark Texts corresponding to selected Remark Qualifiers on Item Structure.	Remark Qualifier
LINE ITEM STR - STRING FLEX FIELD	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Structure.	Structure String Attribute

Following are the constraints available for country of origin lookup:

Constraint	Function	Additional Input
LINE ITEM ORIGIN - DATE FLEX FIELD	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Origin.	Transaction Line Date Flex Fields Origin Date Flex Fields
LINE ITEM ORIGIN - DATE QUALIFIER	Checks Dates corresponding to selected Date Qualifiers on the Transaction Line with the Effective and Expiration Date on Item Origin.	Date Qualifier
LINE ITEM ORIGIN - INVENTORY ORG	Matches the Involved Party corresponding to selected Involved Party Qualifier on the Transaction Line with Inventory Organization on Item Origin. Please select only one Party Qualifier.	Inventory Organization
LINE ITEM ORIGIN - NUMBER FLEX FIELD	Matches selected Number Flex Fields on Transaction Line with the selected Number Flex Fields on Item Origin.	Transaction Line Number Flex Fields Origin Number Flex Fields
LINE ITEM ORIGIN - PARTNER	Matches the Involved Party corresponding to selected Involved Party Qualifier with Partner on Item Origin. Please select only one Party Qualifier.	Partner
LINE ITEM ORIGIN - PARTNER SITE	Matches the Location of the Party Site of selected Involved Party Qualifier with the Location of the Partner Site on Item Origin. Please select only one Party Qualifier.	Partner Site
LINE ITEM ORIGIN - STRING FLEX FIELD	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Origin.	Transaction Line String Flex Fields Origin String Flex Fields

Following are the constraints available for trade item structure:

Constraint	Function	Additional Input
Involved Party	Matches Involved Parties corresponding to selected Involved Party Qualifiers on each Transaction Line with Involved Parties corresponding to selected Involved Party Qualifiers on Trade Item Structure Assignment. If Involved Party details are missing on Trade Transaction Line(s), it uses Involved Party defined on the Trade Transaction.	Party Qualifier
Line Classification Code	Matches Product Classification Code on each Transaction Line with Product Classification Code on Trade Item Structure Assignment.	Product Classification Type
Line Commodity	Matches Commodity ID defined within Item on each Transaction Line with Commodity ID defined within Item on Trade Item Structure Assignment.	n/a
Line Item	Matches Item ID on each Transaction Line with Item ID on Trade Item Structure Assignment.	n/a
Line Refnum	Matches Reference Numbers corresponding to selected Refnum Qualifiers on each Transaction Line with Reference Numbers corresponding to selected Refnum Qualifiers on Trade Item Structure Assignment.	Transaction Line Reference Number Qualifier
Line Remark	Matches Remark Texts corresponding to selected Remark Qualifiers on each Transaction Line with Remark Texts corresponding to selected Remark Qualifiers on Trade Item Structure Assignment.	Remark Qualifier
User-defined Code Profile	Matches User-Defined Code Profile on each constraint set with selected User-Defined Code Profile corresponding to Trade Item Structure Assignment.	User-Defined Code Profile

Following are the constraints available for license:

Constraint	Function	Additional Input
License Involved Parties	Matches Involved Parties corresponding to selected Involved Party Qualifiers on Transaction and each Transaction Line with Involved Parties corresponding to selected Involved Party Qualifiers on License.	Involved Party Qualifier
License Line Commodity	Matches Commodity ID on the Item on each Transaction Line with Commodity ID on License Line.	n/a
License Line Item	Matches Item ID on each Transaction Line with Item ID on License Line.	n/a
License Line Item Remarks	Matches Remark Texts corresponding to selected Remark Qualifiers on the Item on each Transaction Line with Remark Texts corresponding to selected Remark Qualifiers on the Item on the License Line.	Remark Qualifier
License Line Product Classifications	Matches Classification Code on the Item on each Transaction Line with Product Classification Matching Formula on License Line.	n/a
License Line Reference Numbers	Matches Reference Numbers corresponding to selected Reference Number Qualifiers on each Transaction Line with Reference Numbers corresponding to selected Reference Number Qualifiers on License Line.	Reference Number Qualifier
License Line Remarks	Matches Remark Texts corresponding to selected Remark Qualifiers on each Transaction Line with Remark Texts corresponding to selected Remark Qualifiers on License Line.	Remark Qualifier
License Line User-defined Commodity	Matches User-Defined Commodity ID on the Item on each Transaction Line with User-Defined Commodity ID on License Line.	n/a
License Ports	Matches Ports corresponding to selected Port Qualifiers on Transaction with Ports corresponding to selected Port Qualifiers on License.	Port Qualifier
License Reference Numbers	Matches Reference Numbers corresponding to selected Reference Number Qualifiers on each Transaction with Reference Numbers corresponding to selected Reference Number Qualifiers on License.	Reference Number Qualifier
License Region Countries	Matches Involved Party Locations and Involved Locations on the Transaction and Transaction Line with Region/Country on the License for the selected Qualifiers.	Involved Party Qualifier
License Remarks	Matches Remark Texts corresponding to selected Remark Qualifiers on each Transaction with Remark Texts corresponding to selected Remark Qualifiers on License.	Remark Qualifier
License User-Defined Categories	Matches User-Defined codes corresponding to the selected User-Defined Category on Transaction and Transaction Line with User-Defined codes corresponding to selected User-Defined Category on License.	Category
License User-Defined Types	Matches User-Defined Type corresponding to the selected User-Defined Category on each Transaction and Transaction Line with User-Defined Types corresponding to selected User-Defined Category on License.	Type

Following are the constraints available for transaction line qualification lookup:

Constraint	Function	Additional Input
COUNTRY OF MANUFACTURE	Matches Country Of Manufacture on Transaction Line with Country Of Manufacture on Item Origin.	n/a
DATE QUALIFIER	Checks Dates corresponding to selected Date Qualifiers on the Transaction Line with the Effective and Expiration Date on Item Origin and/or Item Trade Program.	Date Qualifier
INVENTORY ORGANIZATION	Matches the Involved Party corresponding to selected Involved Party Qualifier on the Transaction Line with Inventory Organization on Item Origin. Please select only one Party Qualifier.	Inventory Organization
ORIGIN DATE FLEX FIELD	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Origin.	Transaction Line Date Flex Fields Origin Date Flex Fields
ORIGIN STRING FLEX FIELD	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Origin.	Transaction Line String Flex Fields Origin String Flex Fields
PARTNER	Matches the Involved Party corresponding to selected Involved Party Qualifier with Partner on Item Origin. Please select only one Party Qualifier.	Partner
PARTNER SITE	Matches the Location of the Party Site of selected Involved Party Qualifier with the Location of the Partner Site on Item Origin. Please select only one Party Qualifier.	Partner Site
QUALIFICATION DATE FLEX FIELD	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Trade Program.	Transaction Line Date Flex Fields Qualification Date Flex Fields
QUALIFICATION NUMBER FLEX FIELD	Matches selected Number Flex Fields on Transaction Line with the selected Number Flex Fields on Item Trade Program.	Transaction Line Number Flex Fields Qualification Number Flex Fields
QUALIFICATION REFERENCE NUMBER	Matches the Reference Numbers corresponding to the selected Reference Number Qualifiers on the Transaction Line with the Reference Numbers corresponding to the selected Reference Number Qualifiers on Item Qualification.	Transaction Line Reference Number Qualifier Item Qualification Reference Number Qualifier
QUALIFICATION REMARK	Matches the Remarks corresponding to the selected Remark Qualifiers on the Transaction Line with the Remarks corresponding to the selected Remark Qualifiers on Item Qualification.	Transaction Line Remark Qualifier Item Qualification Remark Qualifier
QUALIFICATION STRING FLEX FIELD	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Trade Program.	Transaction Line String Flex Fields Qualification String Flex Fields

Following are the constraints available for trade program lookup:

Constraint	Function	Additional Input
Country of Manufacture	Matches Country Of Manufacture on Transaction Line with Country Of Manufacture on Item Origin.	n/a
Date Qualifier Note: It is mandatory to configure this constraint for the Trade Program Lookup functionality. If you don’t add this constraint, the system will fetch the expired trade programs too for the transaction line.	Checks Dates corresponding to selected Date Qualifiers on the Transaction Line with the Effective and Expiration Date on Item Origin and/or Item Trade Program.	Date Qualifier
Inventory Organization	Matches the Involved Party corresponding to selected Involved Party Qualifier on the Transaction Line with Inventory Organization on Item Origin. Please select only one Party Qualifier.	Inventory Organization
Origin Date Flex Field	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Origin.	Date Flex Fields
Origin Number Flex Field	Matches selected Number Flex Fields on Transaction Line with the selected Number Flex Fields on Item Origin.	Number Flex Fields
Origin String Flex Field	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Origin.	String Flex Fields
Partner	Matches the Involved Party corresponding to selected Involved Party Qualifier with Partner on Item Origin. Please select only one Party Qualifier.	Partner
Partner Site	Matches the Location of the Party Site of selected Involved Party Qualifier with the Location of the Partner Site on Item Origin. Please select only one Party Qualifier.	Partner Site
Qualification Date Flex Field	Matches selected Date Flex Fields on Transaction Line with the selected Date Flex Fields on Item Trade Program.	Date Flex Fields
Qualification Number Flex Field	Matches selected Number Flex Fields on Transaction Line with the selected Number Flex Fields on Item Trade Program.	Number Flex Fields
Qualification Reference Number	Matches the Reference Numbers corresponding to the selected Reference Number Qualifiers on the Transaction Line with the Reference Numbers corresponding to the selected Reference Number Qualifiers on Item Qualification.	Reference Number Qualifier
Qualification Remark	Matches the Remarks corresponding to the selected Remark Qualifiers on the Transaction Line with the Remarks corresponding to the selected Remark Qualifiers on Item Qualification.	Remark Qualifier
Qualification String Flex Field	Matches selected String Flex Fields on Transaction Line with the selected String Flex Fields on Item Trade Program.	String Flex Fields

GTM Constraint Sets

Identification

Constraints

Constraint Details

Related Topics