sp060_ru_postcode_patterns
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
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 |
Â
Â