Column |
---|
|
Groups |
Column |
---|
|
ADDRESS | | Field Length | | | |
---|
ID | NUMBER | 22 | N | | Primary key | TITLE | VARCHAR2 | 20 | | | With 10.3.1 to add title column to Address table | CODE | VARCHAR2 | 128 | Y | | | COMPANY | VARCHAR2 | 1020 | Y | | | FIRST_NAME | VARCHAR2 | 240 | Y | | | LAST_NAME | VARCHAR2 | 240 | Y | | | CITY | VARCHAR2 | 128 | Y | | | ZIP | VARCHAR2 | 128 | Y | | | PHONE | VARCHAR2 | 128 | Y | | | FAX | VARCHAR2 | 128 | Y | | | EMAIL | VARCHAR2 | 512 | Y | | | STREET | VARCHAR2 | 1024 | Y | | | STREET_NUMBER | VARCHAR2 | 48 | Y | | | STREET_UNIT | VARCHAR2 | 48 | Y | | | FLOOR | VARCHAR2 | 48 | Y | | | FLOOR_UNIT | VARCHAR2 | 128 | Y | | | COUNTY | VARCHAR2 | 128 | Y | | | COUNTRY | VARCHAR2 | 128 | Y | | | STREET_CODE | VARCHAR2 | 128 | Y | | | ADDRESS_CODE | VARCHAR2 | 128 | Y | | | CO | VARCHAR2 | 255 | Y | | | STATUS_ID | NUMBER | 22 | Y | | | ADDRESS_CHECK_DATE | DATE | 7 | Y | | | ADDRESS_PROOF | NUMBER | 22 | Y | | | COORDINATE_X | VARCHAR2 | 128 | Y | | | COORDINATE_Y | VARCHAR2 | 128 | Y | | | COMMENTS | VARCHAR2 | 4000 | Y | | | DIRECTION | VARCHAR2 | 40 | Y | | | ZIP_EXT | VARCHAR2 | 40 | Y | | | ADDRESS_STATE | VARCHAR2 | 40 | Y | | | STREET_UNIT_TYPE | VARCHAR2 | 1000 BYTEBYTES | Y | | With 9.9 | STREET_TYPE | VARCHAR2 | 1000 BYTEBYTES | Y | | With 9.9 | BUILDING | VARCHAR2 | 1000 BYTEBYTES | Y | | With 9.9 | ADDRESS1 | VARCHAR2 | 150 BYTES | | | With 10.3.1 | ADDRESS2 | VARCHAR2 | 150 BYTES | | | With 10.3.1 |
|
Column |
---|
|
|
|