Column |
---|
|
Groups |
Column |
---|
|
ADDRESS | | | Field Length | | | | 1 |
---|
ID | NUMBER | 22 | N | | Primary key2 | TITLE | VARCHAR2 | 20 | | | With 10.3.1 to add title column to Address table | CODE | VARCHAR2 | 128 | Y | | | 3 | COMPANY | VARCHAR2 | 1020 | Y | | | 4 | FIRST_NAME | VARCHAR2 | 240 | Y | | 5 | LAST_NAME | VARCHAR2 | 240 | Y | | 6 | CITY | VARCHAR2 | 128 | Y | | 7 | ZIP | VARCHAR2 | 128 | Y | | | 8 | PHONE | VARCHAR2 | 128 | Y | | | 9 | FAX | VARCHAR2 | 128 | Y | | | 10 | EMAIL | VARCHAR2 | 512 | Y | | | 11 | STREET | VARCHAR2 | 1024 | Y | | 12 | STREET_NUMBER | VARCHAR2 | 48 | Y | | | 13 | STREET_UNIT | VARCHAR2 | 48 | Y | | | 14 | FLOOR | VARCHAR2 | 48 | Y | | | 15 | FLOOR_UNIT | VARCHAR2 | 128 | Y | | 16 | COUNTY | VARCHAR2 | 128 | Y | | 17 | COUNTRY | VARCHAR2 | 128 | Y | | 18 | STREET_CODE | VARCHAR2 | 128 | Y | | | 19 | ADDRESS_CODE | VARCHAR2 | 128 | Y | | | 20 | CO | VARCHAR2 | 255 | Y | | 21 | STATUS_ID | NUMBER | 22 | Y | | 22 | ADDRESS_CHECK_DATE | DATE | 7 | Y | | 23 | ADDRESS_PROOF | NUMBER | 22 | Y | | | 24 | COORDINATE_X | VARCHAR2 | 128 | Y | | | 25 | COORDINATE_Y | VARCHAR2 | 128 | Y | | | 26 | COMMENTS | VARCHAR2 | 4000 | Y | | 27 | DIRECTION | VARCHAR2 | 40 | Y | | 28 | ZIP_EXT | VARCHAR2 | 40 | Y | | 29 | ADDRESS_STATE | VARCHAR2 | 40 | Y | | | 30 | STREET_UNIT_TYPE | VARCHAR2 | 1000 BYTE | Y | | With 9.9 | 31 | STREET_TYPE | VARCHAR2 | 1000 BYTE | Y | | With 9.932 | BUILDING | VARCHAR2 | 1000 BYTE | Y | | With 9.9 |
|
Column |
---|
|
|
|