This table provides an association between a given FRU and postcode patterns, thus allowing the different geographies to use different matching algorithms.

Table Definition

Field	Type	Default	Nullable
fru_no	number(4)
pattern_no	number(2)

Keys

unique (fru_no, pattern_no)

foreign key (fru_no) references sp058_responsibility_units (resp_unit_no)

foreign key (pattern_no) references sp046_postcode_patterns (pattern_no)

Column Descriptions

Field	Description
fru_no	Identifies the FRU
pattern_no	Identifies the postcode pattern expression

Browser not supported