1. Tables and Views for Financials
  2. IBY_EXT_BANK_ACCT_CHANGE_HIST

IBY_EXT_BANK_ACCT_CHANGE_HIST

This table contains the history of external bank account verification and other related updates.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

IBY_EXT_BANKACCT_CHNG_HIST_PK

EXT_BANK_ACCT_CHANGE_HIST_ID

Columns

Name Datatype Length Precision Not-null Comments
EXT_BANK_ACCT_CHANGE_HIST_ID NUMBER 18 Yes Change history identifier for the external bank account.
BANK_ACCOUNT_ENTITY_TYPE_CODE VARCHAR2 30 Indicates the source of EXT_BANK_ACCOUNT_ID. Values are from lookup ORA_IBY_BANKACCT_ENTITY_TYPE.
PREV_BANK_ACCT_CHANGE_HIST_ID NUMBER 18 Last change request identifier.
EXT_BANK_ACCOUNT_ID NUMBER 18 Yes External bank account identifier.
BANK_ACCT_VERIF_STATUS_CODE VARCHAR2 30 Yes Bank account verification status. Values are from lookup ORA_IBY_BANKACCT_VERIF_STATUS.
PROVIDER_VERIF_RESPONSE_CODE VARCHAR2 30 Bank account verification response code retuned by the validation service provider.
PROVIDER_VERIF_RESPONSE_MSG VARCHAR2 255 Bank account verification response message retuned by the validation service provider.
INTERNAL_ACCT_VERIF_RESP_CODE VARCHAR2 30 Internal translatable response code. Value are from lookup ORA_IBY_INTRNL_BA_VERIF_RESP.
VERIFICATION_REQ_REFERENCE_ID VARCHAR2 80 Reference identifier for the request shared with the validation service provider.
COUNTRY_CODE VARCHAR2 2 Yes Country code of the bank account.
CURRENCY_CODE VARCHAR2 15 Currency code for the bank account.
BRANCH_ID NUMBER 18 Bank branch identifier for the bank account.
BANK_ID NUMBER 18 Bank identifier associated with the bank branch.
BANK_ACCOUNT_NUM VARCHAR2 100 Complete external bank account number.
BANK_ACCOUNT_NUM_HASH1 VARCHAR2 64 Hash of the external bank account number.
BANK_ACCOUNT_NUM_HASH2 VARCHAR2 64 Hash of the salted bank account number.
MASKED_BANK_ACCOUNT_NUM VARCHAR2 100 Masked bank account number used for display.
BA_MASK_SETTING VARCHAR2 30 Current bank account masking setting. Values are from lookup IBY_INSTRUMENT_MASK_SETTING.
BA_UNMASK_LENGTH NUMBER 2 Count of visible digits in the masked external bank account number.
IBAN VARCHAR2 50 International bank account number.
IBAN_HASH1 VARCHAR2 64 Hash of the international bank account number.
IBAN_HASH2 VARCHAR2 64 Hash of the salted international bank account number.
PAYMENT_SYSTEM_ACCOUNT_ID NUMBER 18 Payment system account identifier for the validation service provider.
MASKED_IBAN VARCHAR2 50 Masked international bank account number used for display.
CHECK_DIGITS VARCHAR2 30 Check digits. Used in bank account format for error detection.
BANK_ACCOUNT_TYPE VARCHAR2 25 Bank account type. Values are from lookup IBY_BANKACCT_TYPES.
ACCOUNT_CLASSIFICATION VARCHAR2 30 Bank account classification code.
ACCOUNT_SUFFIX VARCHAR2 30 Bank account suffix used to represent the account type.
AGENCY_LOCATION_CODE VARCHAR2 30 Code associated with the agency location.
PAYMENT_FACTOR_FLAG VARCHAR2 1 Indicates whether this is a payment factor bank account.
FOREIGN_PAYMENT_USE_FLAG VARCHAR2 1 Indicates whether this bank account can be used for foreign payments. If the value is N, it'd be automatically implied that this account is for domestic payments.
EXCHANGE_RATE_AGREEMENT_NUM VARCHAR2 80 Exchange rate agreement number.
EXCHANGE_RATE_AGREEMENT_TYPE VARCHAR2 80 Type of the exchange rate agreement.
EXCHANGE_RATE NUMBER Represents the rate of exchange.
HEDGING_CONTRACT_REFERENCE VARCHAR2 20 Reference code for the hedging contract.
SECONDARY_ACCOUNT_REFERENCE VARCHAR2 30 Account number reference such as the building society roll number.
ENCRYPTED_FLAG VARCHAR2 1 Indicates whether the payment instrument is encrypted.
BA_NUM_SEC_SEGMENT_ID NUMBER 18 Bank account number security identifier.
IBAN_SEC_SEGMENT_ID NUMBER 18 Security identifier for the international bank account number.
BANK_ACCOUNT_NAME VARCHAR2 80 Name assigned to the external bank account.
BANK_ACCOUNT_NAME_ALT VARCHAR2 320 Alternate name assigned to the bank account.
SHORT_ACCT_NAME VARCHAR2 30 Short name assigned to the bank account.
DESCRIPTION VARCHAR2 240 Description associated with the bank account.
BANK_ACCOUNT_NUM_ELECTRONIC VARCHAR2 100 Bank account number used in electronic files, if different from the written form.
BA_NUM_ELEC_SEC_SEGMENT_ID NUMBER 18 Electronically-formatted bank number security segment identifier.
SALT_VERSION NUMBER 2 Algorithm version used for encrypting the bank account number.
BANK_BRANCH_PARTY_FLAG VARCHAR2 1 Indicates whether this bank account is associated with any bank and branch created in Trading Community Architecture (TCA). If the value is Yes or Null, then the bank and branch information is stored in TCA and the corresponding PARTY_IDs are stored in BANK_ID and BRANCH_ID columns. If the value is No, then the bank and branch information is stored directly in the columns BANK_NAME, BANK_NUMBER, BANK_BRANCH_NAME, BRANCH_NUMBER, and EFT_SWIFT_CODE.
BANK_NAME VARCHAR2 360 Name of bank where payee has a bank account.
BANK_NUMBER VARCHAR2 30 Code or identifier issued to bank by banking regulatory authority.
BANK_BRANCH_NAME VARCHAR2 360 Name of the bank branch where payee has bank account.
BRANCH_NUMBER VARCHAR2 30 Bank branch number. This is known as routing transit number in US and Canada.
EFT_SWIFT_CODE VARCHAR2 30 SWIFT code for bank or bank branch.
VAT_BANK_ACCOUNT_ID NUMBER 18 Local currency VAT account to which the VAT amount is paid for foreign currency invoices.
ORIGIN_APPLICATION_ID NUMBER Application used to create or update the bank account record.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATED_FROM VARCHAR2 30 Program or UI from which this row is created. Oracle internal use only.
START_DATE DATE Date of bank account activation.
END_DATE DATE Date of bank account deactivation.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
CREATION_DATE TIMESTAMP Yes 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.
STATUS_CODE VARCHAR2 30 Indicates if the change history record is in draft status or has been publishes into the main table.
ORIGINAL_VERIF_STATUS_CODE VARCHAR2 30 Used to preserve the original bank account verification status code value when the status was manually overridden. Values are from lookup ORA_IBY_BANKACCT_VERIF_STATUS.
VERIFICATION_REQUEST_TIMESTAMP TIMESTAMP Date and time when the bank account verification request to the service provider was initiated.
VERIFICATION_RESP_TIMESTAMP TIMESTAMP Date and time when the bank account verification response from the service provider was received.

Foreign Keys

Table Foreign Table Foreign Key Column
IBY_EXT_BANK_ACCT_CHANGE_HIST iby_ext_bank_acct_change_hist PREV_BANK_ACCT_CHANGE_HIST_ID
IBY_EXT_BANK_ACCT_CHANGE_HIST iby_ext_bank_accounts EXT_BANK_ACCOUNT_ID
IBY_EXT_BANK_ACCT_CHANGE_HIST iby_bepkeys PAYMENT_SYSTEM_ACCOUNT_ID
iby_bank_acct_owner_chng_hist iby_ext_bank_acct_change_hist EXT_BANK_ACCT_CHANGE_HIST_ID
iby_ext_bank_accounts iby_ext_bank_acct_change_hist LAST_CHANGE_HIST_ID
iby_ext_bank_acct_change_hist iby_ext_bank_acct_change_hist PREV_BANK_ACCT_CHANGE_HIST_ID

Indexes

Index Uniqueness Tablespace Columns
IBY_EXT_BANKACCT_CHNG_HIST_N1 Non Unique Default BANK_ACCOUNT_NUM_HASH1, BANK_ACCOUNT_NUM_HASH2
IBY_EXT_BANKACCT_CHNG_HIST_N2 Non Unique Default IBAN_HASH1, IBAN_HASH2
IBY_EXT_BANKACCT_CHNG_HIST_N3 Non Unique Default REQUEST_ID
IBY_EXT_BANKACCT_CHNG_HIST_U1 Unique Default EXT_BANK_ACCT_CHANGE_HIST_ID
IBY_EXT_BANKACCT_CHNG_HIST_U2 Unique Default EXT_BANK_ACCOUNT_ID, BANK_ACCOUNT_ENTITY_TYPE_CODE, PREV_BANK_ACCT_CHANGE_HIST_ID