IBY_CREDITCARD_V

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

INSTRID

CARD_OWNER_ID

CCNUMBER

CC_NUMBER_HASH1

CC_NUMBER_HASH2

EXPIRYDATE

FINAME

ACCTTYPE

CHNAME

INSTRNAME

OWNERTYPE

OWNERID

INSTRBUF

ENCRYPTED

Query

SQL_Statement

SELECT c.instrid, c.card_owner_id, c.ccnumber, c.cc_number_hash1, c.cc_number_hash2, c.expirydate, c.finame, null, c.chname, c.instrname, null, null, c.description instrbuf, c.encrypted FROM iby_creditcard c