1. Tables and Views for Financials
  2. IBY_EXT_BANK_ACCOUNTS_

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_

LAST_UPDATE_DATE, LAST_UPDATED_BY, EXT_BANK_ACCOUNT_ID

Columns

Name Datatype Length Precision Not-null Comments
EXT_BANK_ACCOUNT_ID NUMBER 18 Yes Primary key of this table
COUNTRY_CODE VARCHAR2 2 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 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.
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.
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 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.
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.
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_EXT_BANK_ACCOUNTSN1_ Non Unique Default EXT_BANK_ACCOUNT_ID, LAST_UPDATE_DATE
IBY_EXT_BANK_ACCOUNTS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, EXT_BANK_ACCOUNT_ID