IBY_DIGITAL_PAYMENT_ACCOUNTS_

The IBY_DIGITAL_PAYMENT_ACCOUNTS table stores the information about digital or virtual payment accounts. IBY_DIGITAL_PAYMENT_ACCOUNTS_ is the audit table for IBY_DIGITAL_PAYMENT_ACCOUNTS.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_DIGITAL_PMT_ACCTS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, DIGITAL_PAYMENT_ACCOUNT_ID

Columns

Name Datatype Length Precision Not-null Comments
DIGITAL_PAYMENT_ACCOUNT_ID NUMBER 18 Yes Digital payment account identifier.
TOKEN VARCHAR2 150 Substitute token for the digital instrument or account.
TOKEN_TYPE_CODE VARCHAR2 30 Payment token type. Values are from the lookup type ORA_IBY_TOKEN_TYPES.
ALIAS VARCHAR2 150 Alias representing the digital payment account.
ALIAS_TYPE_CODE VARCHAR2 30 Alias type. Values are from the lookup type ORA_IBY_DGTL_ACCT_ALIAS_TYPES.
BEPID NUMBER 18 Issuing payment system identifier.
BEP_ACCOUNT_ID NUMBER 18 Payment system account used to create the digital payment account.
USER_PROFILE_CODE VARCHAR2 30 Process profile code used to create the digital payment account.
EXT_BANK_ACCOUNT_ID NUMBER 18 Foreign key reference to external bank account.
PAYMENT_MODE_CODE VARCHAR2 30 Payment mode. Values are from the lookup type ORA_IBY_PAYMENT_MODE.
COUNTRY_CODE VARCHAR2 2 Country code of the digital account.
CURRENCY_CODE VARCHAR2 15 Currency code of the digital account.
OWNER_PARTY_ID NUMBER 18 Owner party of the digital payment account.
ISSUE_DATE DATE Issuing date for the digital payment account.
EXPIRATION_DATE DATE Expiration date for the digital payment account.
MASKED_ACCOUNT_NAME VARCHAR2 150 Masked account name for display purposes.
MASK_SETTING_CODE VARCHAR2 30 Mask setting. Values are from the lookup type IBY_INSTRUMENT_MASK_SETTINGS.
UNMASKED_LENGTH NUMBER 9 Number of characters displayed unmasked.
MAX_ALLOWED_USAGE_COUNT NUMBER 9 Maximum allowed usage count for the digital payment instrument.
CURRENT_USAGE_COUNT NUMBER 9 Current usage count of the digital payment instrument.
CREATED_FROM VARCHAR2 30 Oracle internal use only. Indicates the program or UI from which this row is created.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
FINANCING_PROGRAM_ID NUMBER 18 Financing program for which the digital account record is created.
ACCOUNT_DISPLAY_NAME VARCHAR2 150 User-specified display name for the digital account.
DIGITAL_ACCOUNT_PROVIDER_REF VARCHAR2 150 External reference for the digital account provided by the provider platform.
ALIAS2 VARCHAR2 150 Alias representing the digital payment account.
ALIAS3 VARCHAR2 150 Alias representing the digital payment account.
ALIAS4 VARCHAR2 150 Alias representing the digital payment account.
ALIAS5 VARCHAR2 150 Alias representing the digital payment account.
PRIMARY_ALIAS_CODE VARCHAR2 30 Stores the primary alias column name.
REMIT_ADVICE_ID_TYPE_CODE VARCHAR2 30 Separate remittance advice identifier code. Values are from the lookup type ORA_IBY_DGTL_ACCT_SRA_TYPE.
REMIT_ADVICE_IDENTIFIER1 VARCHAR2 150 Identifier for separate remittance advice.
REMIT_ADVICE_IDENTIFIER2 VARCHAR2 150 Identifier for separate remittance advice.
REMIT_ADVICE_IDENTIFIER3 VARCHAR2 150 Identifier for separate remittance advice.
REMIT_ADVICE_IDENTIFIER4 VARCHAR2 150 Identifier for separate remittance advice.
REMIT_ADVICE_IDENTIFIER5 VARCHAR2 150 Identifier for separate remittance advice.
DIGITAL_ACCT_PROVIDER_REF_CODE VARCHAR2 30 Digital account provider reference code. Values are from the lookup type ORA_IBY_DGTL_ACCT_PROVIDER_REF.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
IBY_DIGITAL_PMT_ACCTS_N1_ Non Unique Default EXT_BANK_ACCOUNT_ID
IBY_DIGITAL_PMT_ACCTS_N2_ Non Unique IBY_DIGITAL_PMT_ACCTS_N2_ BEPID, PAYMENT_MODE_CODE
IBY_DIGITAL_PMT_ACCTS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, DIGITAL_PAYMENT_ACCOUNT_ID