IBY_EXT_BANK_ACCOUNTS
IBY_EXT_BANK_ACCOUNTS defines the external bank account entity. This table should not be translated for any columns.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_EXT_BANK_ACCOUNTS_PK |
EXT_BANK_ACCOUNT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| EXT_BANK_ACCOUNT_ID | NUMBER | 18 | Yes | Primary key of this table | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Yes | Country code of the bank account | ||
| BRANCH_ID | NUMBER | 18 | Identifier of the bank branch that this bank account belongs to | |||
| BANK_ID | NUMBER | 18 | Identifier of the bank that the bank branch belong to | |||
| BANK_ACCOUNT_NUM | VARCHAR2 | 100 | Account number | |||
| BANK_ACCOUNT_NUM_HASH1 | VARCHAR2 | 64 | Hash of the 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; to be used for display purposes | |||
| BA_MASK_SETTING | VARCHAR2 | 30 | Current bank account masking setting; values taken from lookup IBY_INSTRUMENT_MASK_SETTING | |||
| BA_UNMASK_LENGTH | NUMBER | 2 | Number of digits to expose in the external bank account mask | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | |||
| IBAN | VARCHAR2 | 50 | International Bank Account Number | |||
| IBAN_HASH1 | VARCHAR2 | 64 | IBAN hash value | |||
| IBAN_HASH2 | VARCHAR2 | 64 | IBAN salted hash value | |||
| MASKED_IBAN | VARCHAR2 | 50 | Masked IBAN value; to be used for display purposes | |||
| CHECK_DIGITS | VARCHAR2 | 30 | Check digits | |||
| BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Bank account type (e.g. SAVINGS, CHECKING) | |||
| ACCOUNT_CLASSIFICATION | VARCHAR2 | 30 | Account classification | |||
| ACCOUNT_SUFFIX | VARCHAR2 | 30 | Account suffix | |||
| AGENCY_LOCATION_CODE | VARCHAR2 | 30 | Agency location code | |||
| PAYMENT_FACTOR_FLAG | VARCHAR2 | 1 | Indicates whether this is a payment factor bank account | |||
| FOREIGN_PAYMENT_USE_FLAG | VARCHAR2 | 1 | Yes or No flag indicating whether this bank account can be used for foreign payments, or only domestic payments. | |||
| EXCHANGE_RATE_AGREEMENT_NUM | VARCHAR2 | 80 | Exchange rate agreement number | |||
| EXCHANGE_RATE_AGREEMENT_TYPE | VARCHAR2 | 80 | Exchange rate agreement type | |||
| EXCHANGE_RATE | NUMBER | Exchange rate | ||||
| HEDGING_CONTRACT_REFERENCE | VARCHAR2 | 20 | Hedging contract reference | |||
| SECONDARY_ACCOUNT_REFERENCE | VARCHAR2 | 30 | Account number reference such as Building Society Roll Number | |||
| BA_NUM_SEC_SEGMENT_ID | NUMBER | 18 | Bank account number security identifier | |||
| ENCRYPTED | VARCHAR2 | 1 | Yes | Whether the instrument is encrypted | ||
| IBAN_SEC_SEGMENT_ID | NUMBER | 18 | IBAN security identifier | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | External Bank Accounts (IBY_EXT_BANK_ACCOUNTS) | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Current who column | |||
| PROGRAM_ID | NUMBER | 18 | Current who column | |||
| PROGRAM_UPDATE_DATE | DATE | Current who column | ||||
| START_DATE | DATE | Date when the bank account becomes active. | ||||
| END_DATE | DATE | Date when the bank account becomes inactive. | ||||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| 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. | |||
| 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. | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Bank account name | |||
| BANK_ACCOUNT_NAME_ALT | VARCHAR2 | 320 | Alternate account name | |||
| SHORT_ACCT_NAME | VARCHAR2 | 30 | Short account name | |||
| DESCRIPTION | VARCHAR2 | 240 | Description | |||
| BANK_ACCOUNT_NUM_ELECTRONIC | VARCHAR2 | 100 | The 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 | Denotes the versions of the encryption algorithm used for the Bank account number encryption. | |||
| ORIG_SYSTEM | VARCHAR2 | 80 | Original system from which the bank account record was imported from | |||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Unique bank account identifier from foreign or legacy system | |||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise identifier to support multi-tenancy. | |||
| BANK_BRANCH_PARTY_FLAG | VARCHAR2 | 1 | Indicates whether or not this bank account is associated with any bank and branch created in Trading Community Architecture (TCA). If the value is Yes or Null, bank and branch information is stored in TCA and the bank and branch identifiers are stored on the bank account. If the value is No, bank and branch attributes are stored on the bank account. | |||
| 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 bank branch where payee has a bank account. | |||
| BRANCH_NUMBER | VARCHAR2 | 30 | Number of bank branch. This is known as routing transit number in US and Canada. | |||
| EFT_SWIFT_CODE | VARCHAR2 | 30 | Identifier code used by SWIFT to identify bank or bank branch. | |||
| VAT_BANK_ACCOUNT_ID | NUMBER | 18 | To identify the local currency VAT account to which the VAT amount is paid for a foreign currency invoice. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_EXT_BANK_ACCOUNTS | iby_security_segments | BA_NUM_SEC_SEGMENT_ID |
| IBY_EXT_BANK_ACCOUNTS | iby_security_segments | IBAN_SEC_SEGMENT_ID |
| IBY_EXT_BANK_ACCOUNTS | iby_security_segments | BA_NUM_ELEC_SEC_SEGMENT_ID |
| IBY_EXT_BANK_ACCOUNTS | hz_parties | BRANCH_ID |
| IBY_EXT_BANK_ACCOUNTS | hz_parties | BANK_ID |
| ap_checks_all | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| ra_customer_trx_all | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| ra_customer_trx_all | iby_ext_bank_accounts | DRAWEE_BANK_ACCOUNT_ID |
| poz_acnt_gen_reqs | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| iby_account_owners | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| poz_acnt_addr_summ_reqs | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| ar_payments_interface_all | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| iby_digital_payment_accounts | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| iby_intermediary_accts | iby_ext_bank_accounts | BANK_ACCT_ID |
| poz_supp_bank_acct_requests | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| iby_temp_ext_bank_accts | iby_ext_bank_accounts | EXT_BANK_ACCOUNT_ID |
| iby_docs_payable_all | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| ar_interim_cash_receipts_all | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| ar_cash_receipts_all | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| ra_interface_lines_all | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| ap_payment_schedules_all | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| iby_gen_docs_payable | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_EXT_BANK_ACCOUNTS_N1 | Non Unique | Default | BANK_ID |
| IBY_EXT_BANK_ACCOUNTS_N2 | Non Unique | Default | BRANCH_ID |
| IBY_EXT_BANK_ACCOUNTS_N3 | Non Unique | Default | BANK_ACCOUNT_NUM_HASH1, BANK_ACCOUNT_NUM_HASH2 |
| IBY_EXT_BANK_ACCOUNTS_N4 | Non Unique | Default | IBAN_HASH1, IBAN_HASH2 |
| IBY_EXT_BANK_ACCOUNTS_N5 | Non Unique | Default | BA_MASK_SETTING, BA_UNMASK_LENGTH |
| IBY_EXT_BANK_ACCOUNTS_N6 | Non Unique | Default | BANK_ACCOUNT_NUM, BRANCH_ID, BANK_ID |
| IBY_EXT_BANK_ACCOUNTS_N7 | Non Unique | Default | BANK_ACCOUNT_NAME |
| IBY_EXT_BANK_ACCOUNTS_N8 | Non Unique | Default | "PAYMENT_FACTOR_FLAG" |
| IBY_EXT_BANK_ACCOUNTS_U1 | Unique | Default | EXT_BANK_ACCOUNT_ID |