VIEW: CZ.CZ_CONTACTS#

Source

View Text - Preformatted

select CONTACT_ID CONTACT_ID, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, SALUTATION SALUTATION, FIRSTNAME FIRSTNAME, MI MI, LASTNAME LASTNAME, SUFFIX SUFFIX, TITLE TITLE, PHONE PHONE, PRIMARY_ROLE PRIMARY_ROLE, ALT_PHONE ALT_PHONE, FAX FAX, PAGER PAGER, CELLULAR CELLULAR, EMAIL_ADDR EMAIL_ADDR, NOTE NOTE, CONTACT_HANDLE CONTACT_HANDLE, ORIG_SYS_REF ORIG_SYS_REF, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "CZ"."CZ_CONTACTS"

View Text - HTML Formatted

SELECT CONTACT_ID CONTACT_ID
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, SALUTATION SALUTATION
, FIRSTNAME FIRSTNAME
, MI MI
, LASTNAME LASTNAME
, SUFFIX SUFFIX
, TITLE TITLE
, PHONE PHONE
, PRIMARY_ROLE PRIMARY_ROLE
, ALT_PHONE ALT_PHONE
, FAX FAX
, PAGER PAGER
, CELLULAR CELLULAR
, EMAIL_ADDR EMAIL_ADDR
, NOTE NOTE
, CONTACT_HANDLE CONTACT_HANDLE
, ORIG_SYS_REF ORIG_SYS_REF
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "CZ"."CZ_CONTACTS"