Constraint Set Related CSV Entries DBMOD Made to Support New Constraint Set Design

To improve the ability to support Trade Incentive Program workflows, 28 Constraints have been added for constraint Set Type: TRADE INCENTIVE PROGRAM - ENTRY EXIT MATCHING. These new constraint types improve the system’s ability to identify the specific matching criteria (e.g.: Line Remark) when matching a specific pair of objects (e.g.: exit declaration to entry transaction, exit transaction to entry transaction). The new constraints are:

  • Refnum - Declaration to Declaration
  • Refnum -Declaration- Transaction
  • Refnum -Transaction- Transaction
  • Refnum -Transaction- Declaration
  • Line Refnum - Declaration Line – Declaration Line
  • Line Refnum - Declaration Line - Transaction Line
  • Line Refnum - Transaction Line - Transaction Line
  • Line Refnum - Transaction Line - Declaration Line
  • Remark -Declaration- Declaration
  • Remark -Declaration- Transaction
  • Remark -Transaction- Transaction
  • Remark -Transaction- Declaration
  • Line Remark - Declaration Line - Declaration Line
  • Line Remark - Declaration Line - Transaction Line
  • Line Remark - Transaction Line - Transaction Line
  • Line Remark - Transaction Line - Declaration Line
  • Date Flex Field - Declaration Line - Declaration Line
  • Date Flex Field - Declaration Line - Transaction Line
  • Date Flex Field - Transaction Line - Transaction Line
  • Date Flex Field - Transaction Line – Declaration Line
  • Number Flex Field - Declaration Line - Declaration Line
  • Number Flex Field - Declaration Line - Transaction Line
  • Number Flex Field - Transaction Line - Transaction Line
  • Number Flex Field - Transaction Line - Declaration Line
  • String Flex Field - Declaration Line - Declaration Line
  • String Flex Field - Declaration Line - Transaction Line
  • String Flex Field - Transaction Line - Transaction Line
  • String Flex Field - Transaction Line - Declaration Line

A new Constraint Group concept has also been introduced, wherein constraint types will be grouped together based on the matching criteria (e.g.: Item, Line Refnum) and the possible constraints for the combination of the exit-entry objects (e.g.: declaration to declaration, transaction to declaration). Types will be grouped together based on the matching criteria (e.g.: Item, Line Refnum) and the possible constraints for the combination of the exit-entry objects (e.g.: declaration to declaration, transaction to declaration). These are the new Constraint Groups:

  • Country
  • Country of Origin
  • Data Flex Field
  • Item
  • Line Refnum
  • Location
  • Number Flex Field
  • Party
  • Product Classification Code
  • Refnum
  • Remark
  • Line Remark
  • String Flex Field

To support this new feature, two new columns have been added to the GTM_CONSTRAINT_TYPE table:

  • TRANSLATION_GID
  •  GTM_CONSTRAINT_TYPE_GROUP

Business Benefit

By adding these new constraint types and constraint groups, you can now specify conditions to match declarations to declarations, declarations to transactions, transactions to transactions, and transactions to declarations under Trade Incentive Programs.

Steps to Enable

You don't need to do anything to enable this feature.