|
Data dictionary stpostal - Postal codes - 7.20
1 | iso_country_code | character | X(2) | | | ? | ISO country | 2 | postal_code | character | X(8) | | | ? | Postal code | 3 | range_type | integer | >>>>>9 | | | ? | Range | 4 | house_nr_from | integer | >>>>>9 | | | ? | House number from | 5 | house_nr_thru | integer | >>>>>9 | | | ? | House number through | 6 | city_postal | character | X(60) | | | | City (postal) | 7 | city | character | X(60) | | | | City | 8 | street_postal | character | X(60) | | | | Street (postal) | 9 | street_nen | character | X(60) | | | | Street (NEN) | 10 | street | character | X(60) | | | ? | Street | 11 | council_code | character | X(8) | | | ? | Council | 12 | council_name | character | X(60) | | | | Council name | 13 | province_code | character | X(8) | | | | Province | 14 | cebuco_code | character | X(8) | | | | CeBuCo-code | 15 | iso_language_code | character | X(2) | | | ? | ISO language | 16 | euserid_cr | character | X(12) | | | | Creator | 17 | date_cr | date | 99/99/9999 | | | | Date created | 18 | time_cr | integer | >>>>>9 | | | ? | Time created | 19 | source_cr | character | x(12) | | | | Source creation | 20 | euserid_lc | character | X(12) | | | | Modifier | 21 | date_lc | date | 99/99/9999 | | | | Date last changed | 22 | time_lc | integer | >>>>>9 | | | ? | Time last changed | 23 | source_lc | character | x(12) | | | | Source last changed |
Indexesstpostal01ix - primary - unique1 | iso_country_code | character | X(2) | ISO country | 2 | postal_code | character | X(8) | Postal code | 3 | range_type | integer | >>>>>9 | Range | 4 | house_nr_from | integer | >>>>>9 | House number from | 5 | house_nr_thru | integer | >>>>>9 | House number through | 6 | iso_language_code | character | X(2) | ISO language | 7 | street | character | X(60) | Street | 8 | council_code | character | X(8) | Council |
stpostal02ix1 | iso_country_code | character | X(2) | ISO country | 2 | street | character | X(60) | Street | 3 | house_nr_from | integer | >>>>>9 | House number from | 4 | iso_language_code | character | X(2) | ISO language |
stpostal03ix1 | iso_country_code | character | X(2) | ISO country | 2 | city | character | X(60) | City | 3 | street | character | X(60) | Street | 4 | house_nr_from | integer | >>>>>9 | House number from | 5 | iso_language_code | character | X(2) | ISO language |
stpostal04ix1 | postal_code | character | X(8) | Postal code | 2 | iso_country_code | character | X(2) | ISO country | 3 | iso_language_code | character | X(2) | ISO language |
Contents > stpostal
Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
26.936.654 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|