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. | |
| 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. | ||
| PAYMENT_SYSTEM_ACCOUNT_ID | NUMBER | 18 | Payment system account identifier for the validation service provider. | ||
| 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. | ||
| 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. |
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_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, PREV_BANK_ACCT_CHANGE_HIST_ID |