1. Tables and Views for Financials
  2. IBY_DIGITAL_PMT_ACCTS_INT_V

IBY_DIGITAL_PMT_ACCTS_INT_V

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

DIGITAL_PAYMENT_ACCOUNT_ID

TOKEN

TOKEN_TYPE_CODE

ALIAS

ALIAS_TYPE_CODE

BEPID

BEP_ACCOUNT_ID

USER_PROFILE_CODE

EXT_BANK_ACCOUNT_ID

PAYMENT_MODE_CODE

COUNTRY_CODE

CURRENCY_CODE

OWNER_PARTY_ID

ISSUE_DATE

EXPIRATION_DATE

MASKED_ACCOUNT_NAME

MASK_SETTING_CODE

UNMASKED_LENGTH

MAX_ALLOWED_USAGE_COUNT

CURRENT_USAGE_COUNT

CREATED_FROM

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

FINANCING_PROGRAM_ID

ACCOUNT_DISPLAY_NAME

DIGITAL_ACCOUNT_PROVIDER_REF

Query

SQL_Statement

SELECT

DigitalPaymentAccounts.DIGITAL_PAYMENT_ACCOUNT_ID DIGITAL_PAYMENT_ACCOUNT_ID,

DigitalPaymentAccounts.TOKEN TOKEN,

DigitalPaymentAccounts.TOKEN_TYPE_CODE TOKEN_TYPE_CODE,

DigitalPaymentAccounts.ALIAS ALIAS,

DigitalPaymentAccounts.ALIAS_TYPE_CODE ALIAS_TYPE_CODE,

DigitalPaymentAccounts.BEPID BEPID,

DigitalPaymentAccounts.BEP_ACCOUNT_ID BEP_ACCOUNT_ID,

DigitalPaymentAccounts.USER_PROFILE_CODE USER_PROFILE_CODE,

DigitalPaymentAccounts.EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID,

DigitalPaymentAccounts.PAYMENT_MODE_CODE PAYMENT_MODE_CODE,

DigitalPaymentAccounts.COUNTRY_CODE COUNTRY_CODE,

DigitalPaymentAccounts.CURRENCY_CODE CURRENCY_CODE,

DigitalPaymentAccounts.OWNER_PARTY_ID OWNER_PARTY_ID,

DigitalPaymentAccounts.ISSUE_DATE ISSUE_DATE,

DigitalPaymentAccounts.EXPIRATION_DATE EXPIRATION_DATE,

DigitalPaymentAccounts.MASKED_ACCOUNT_NAME MASKED_ACCOUNT_NAME,

DigitalPaymentAccounts.MASK_SETTING_CODE MASK_SETTING_CODE,

DigitalPaymentAccounts.UNMASKED_LENGTH UNMASKED_LENGTH,

DigitalPaymentAccounts.MAX_ALLOWED_USAGE_COUNT MAX_ALLOWED_USAGE_COUNT,

DigitalPaymentAccounts.CURRENT_USAGE_COUNT CURRENT_USAGE_COUNT,

DigitalPaymentAccounts.CREATED_FROM CREATED_FROM,

DigitalPaymentAccounts.CREATED_BY CREATED_BY,

DigitalPaymentAccounts.CREATION_DATE CREATION_DATE,

DigitalPaymentAccounts.LAST_UPDATED_BY LAST_UPDATED_BY,

DigitalPaymentAccounts.LAST_UPDATE_DATE LAST_UPDATE_DATE,

DigitalPaymentAccounts.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

DigitalPaymentAccounts.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

DigitalPaymentAccounts.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

DigitalPaymentAccounts.ATTRIBUTE1 ATTRIBUTE1,

DigitalPaymentAccounts.ATTRIBUTE2 ATTRIBUTE2,

DigitalPaymentAccounts.ATTRIBUTE3 ATTRIBUTE3,

DigitalPaymentAccounts.ATTRIBUTE4 ATTRIBUTE4,

DigitalPaymentAccounts.ATTRIBUTE5 ATTRIBUTE5,

DigitalPaymentAccounts.ATTRIBUTE6 ATTRIBUTE6,

DigitalPaymentAccounts.ATTRIBUTE7 ATTRIBUTE7,

DigitalPaymentAccounts.ATTRIBUTE8 ATTRIBUTE8,

DigitalPaymentAccounts.ATTRIBUTE9 ATTRIBUTE9,

DigitalPaymentAccounts.ATTRIBUTE10 ATTRIBUTE10,

DigitalPaymentAccounts.ATTRIBUTE11 ATTRIBUTE11,

DigitalPaymentAccounts.ATTRIBUTE12 ATTRIBUTE12,

DigitalPaymentAccounts.ATTRIBUTE13 ATTRIBUTE13,

DigitalPaymentAccounts.ATTRIBUTE14 ATTRIBUTE14,

DigitalPaymentAccounts.ATTRIBUTE15 ATTRIBUTE15,

DigitalPaymentAccounts.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

DigitalPaymentAccounts.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

DigitalPaymentAccounts.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

DigitalPaymentAccounts.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

DigitalPaymentAccounts.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

DigitalPaymentAccounts.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

DigitalPaymentAccounts.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

DigitalPaymentAccounts.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

DigitalPaymentAccounts.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

DigitalPaymentAccounts.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

DigitalPaymentAccounts.FINANCING_PROGRAM_ID FINANCING_PROGRAM_ID,

DigitalPaymentAccounts.ACCOUNT_DISPLAY_NAME ACCOUNT_DISPLAY_NAME,

DigitalPaymentAccounts.DIGITAL_ACCOUNT_PROVIDER_REF DIGITAL_ACCOUNT_PROVIDER_REF

FROM

iby_digital_payment_accounts DigitalPaymentAccounts