IBY_PURCHASECARD_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
INSTRID CCNUMBER EXPIRYDATE FINAME ACCTTYPE CHNAME INSTRNAME SUBTYPE INSTRBUF ENCRYPTED

Query

SQL_Statement
SELECT c.instrid, c.ccnumber, c.expirydate, c.finame, y.accttype, c.chname, c.instrname, c.subtype, c.description instrbuf, c.encrypted from iby_creditcard c, iby_pmt_instr_uses_all h, iby_accttype y where c.instrid = h.instrument_id and h.instrument_type = 'PURCHASECARD' and c.accttypeid = y.accttypeid