|
|
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 - unique| 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 | iso_language_code | character | X(2) | ISO language | | 7 | street | character | X(60) | Street | | 8 | council_code | character | X(8) | Council |
stpostal02ix| 1 | 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 |
stpostal03ix| 1 | 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 |
stpostal04ix| 1 | 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 |
|
|