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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.