/
sp060_ru_postcode_patterns
Document toolboxDocument toolbox

sp060_ru_postcode_patterns

Owned by Jason Andrew
Oct 02, 2024

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_nonumber(4) (error)
pattern_nonumber(2) (error)

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

FieldDescription
fru_noIdentifies the FRU 
pattern_noIdentifies the postcode pattern expression