DW_BANK_ACCOUNT_ALL_D

This table contains details about all the bank accounts, secured and unsecured.

Details

Module:

Key Columns

BANK_ACCOUNT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BANK_ACCOUNT_ID NUMBER 38 0 True Bank account identifier.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier.
BANK_ACCOUNT_HOLDER_NAME VARCHAR2 256 Bank account holder's name.
BANK_ACCOUNT_TYPE VARCHAR2 32 Bank account type.
BANK_ACCOUNT_NUM VARCHAR2 32 Bank account number.
MASKED_BANK_ACCOUNT_NUM VARCHAR2 128 Masked bank account number.
BANK_ACCOUNT_NAME VARCHAR2 512 Bank account name.
ACCOUNT_CLASSIFICATION VARCHAR2 32 Account Classification
DATA_SECURITY_FLAG VARCHAR2 16 Data Security Flag
NETTING_ACCT_FLAG VARCHAR2 16 Netting Account Flag
ACTIVE_FLAG VARCHAR2 16 Indicates an active bank account.