VIEW: CZ.CZ_IMP_END_USER#

Source

View Text - Preformatted

select END_USER_ID END_USER_ID, END_USER_ORG_ID END_USER_ORG_ID, ORIG_SYS_REF ORIG_SYS_REF, TITLE TITLE, LOGIN_NAME LOGIN_NAME, LASTNAME LASTNAME, FIRSTNAME FIRSTNAME, MI MI, ALLOWABLE_DISCOUNT ALLOWABLE_DISCOUNT, DESC_TEXT DESC_TEXT, ADDR_LINE1 ADDR_LINE1, ADDR_LINE2 ADDR_LINE2, CITY CITY, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, ZIP ZIP, COUNTRY COUNTRY, PHONE PHONE, FAX FAX, PAGER PAGER, CELLULAR CELLULAR, EMAIL_ADDR EMAIL_ADDR, 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, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, FSK_ENDUSER_1_1 FSK_ENDUSER_1_1, FSK_ENDUSER_1_EXT FSK_ENDUSER_1_EXT, FSK_USERGROUP_2_1 FSK_USERGROUP_2_1, FSK_USERGROUP_2_EXT FSK_USERGROUP_2_EXT, NAME NAME from "CZ"."CZ_IMP_END_USER"

View Text - HTML Formatted

SELECT END_USER_ID END_USER_ID
, END_USER_ORG_ID END_USER_ORG_ID
, ORIG_SYS_REF ORIG_SYS_REF
, TITLE TITLE
, LOGIN_NAME LOGIN_NAME
, LASTNAME LASTNAME
, FIRSTNAME FIRSTNAME
, MI MI
, ALLOWABLE_DISCOUNT ALLOWABLE_DISCOUNT
, DESC_TEXT DESC_TEXT
, ADDR_LINE1 ADDR_LINE1
, ADDR_LINE2 ADDR_LINE2
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, ZIP ZIP
, COUNTRY COUNTRY
, PHONE PHONE
, FAX FAX
, PAGER PAGER
, CELLULAR CELLULAR
, EMAIL_ADDR EMAIL_ADDR
, 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
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, FSK_ENDUSER_1_1 FSK_ENDUSER_1_1
, FSK_ENDUSER_1_EXT FSK_ENDUSER_1_EXT
, FSK_USERGROUP_2_1 FSK_USERGROUP_2_1
, FSK_USERGROUP_2_EXT FSK_USERGROUP_2_EXT
, NAME NAME
FROM "CZ"."CZ_IMP_END_USER"