10.3 Match Rules
The following table describes the match rules used for Trade Goods match
processing:
Table 10-2 Identifiers Used for Trade Goods Matching
| Matching Rule | Summary of Rule Logic | Example Matching Data- Goods Name | Example Matching Data- Import Country ISO from | Example Matching Data- Export Country ISO to |
|---|---|---|---|---|
| Exact goods name, Import Country ISO from, Export Country ISO to | Exact Match against goods name,Country ISO (Import Prohibition from) AND Country ISO (Export Prohibition to) columns of prohibited goods reference data | Crude Oil | CH | DN |
| Exact goods name, Import Country ISO from | Exact Match against goods name,Country ISO (Import Prohibition from) columns of prohibited goods reference data | Crude Oil | CH | CR |
| Exact goods name, Export Country ISO to | Exact Match against goods name,Country ISO (Export Prohibition to) columns of prohibited goods reference data | Crude Oil | VE | UG |
| Exact goods name | Exact Match against goods name column of prohibited goods reference data | Crude Oil | VE | UG |
| Exact goods synonym name, Import Country ISO from, Export Country ISO to | Exact Match against goods synonym name, Country ISO (Import Prohibition from) AND Country ISO (Export Prohibition to) columns of prohibited goods reference data | Oil | TW | GB |
| Exact goods synonym name, Import Country ISO from | Exact Match against goods synonym name, Country ISO (Import Prohibition from) columns of prohibited goods reference data | Oil | TW | US |
| Exact goods synonym name, Export Country ISO to | Exact Match against goods synonym name, Country ISO (Export Prohibition to) columns of prohibited goods reference data | Oil | UK | UM |
| Exact goods synonym name | Exact Match against goods synonym name column of prohibited goods reference data | Oil | UK | UM |
| Goods name in any order, Import Country ISO from, Export Country ISO to | Matches city ISO code exactly | Crude Oil Oil Crude | UR | SS |
| Goods name in any order, Import Country ISO from | Match against goodsname in any order exact Country ISO (Import Prohibition from) columns of prohibited goods reference data | Crude Oil Oil Crude | UR | SS |
| Goods name in any order, Export Country ISO to | Match against goods name in any order, exact Country ISO (Export Prohibition to) columns of prohibited goods reference data | Crude Oil Oil Crude | VN | CH |
| Goods name in any order | Match against goods name column in any order of prohibited goods reference data | Crude Oil Oil Crude | VN | CH |
| Goods name at least one word matching, Import Country ISO from, Export Country ISO to | Word match count is >0 against goods name in reference data, exact Country ISO (Import Prohibition from) AND exact Country ISO (Export Prohibition to) | Crude Oil | ZA | SW |
| Goods name at least one word matching, Import Country ISO from | Word match count is >0 against goods name in reference data, exact Country ISO (Import Prohibition from) | Crude Oil | ZA | SW |
| Goods name at least one word matching, Export Country ISO to | Word match count is >0 against goods name in reference data, exact Country ISO (Export Prohibition to) | Crude Oil | TW | GB |
| Goods name at least one word matching | Word match count is >0 against goods name in reference data | Crude Oil | TH | TJ |