eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CZ.CZ_IMP_CONTACT#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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