DW_BANK_ACCOUNT_D

This table contains details about bank accounts.

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   Source record identifier.    
BANK_ACCOUNT_HOLDER_NAME VARCHAR2 256     Bank account holder's name.    
BANK_ACCOUNT_TYPE VARCHAR2 32     Bank account type. Possible values are Customer, Supplier, or Company.    
BANK_ACCOUNT_NUM VARCHAR2 32     Bank account number.    
MASKED_BANK_ACCOUNT_NUM VARCHAR2 4000     Masked bank account number.    
BANK_ACCOUNT_NAME VARCHAR2 512     Bank account name.    
BANK_NAME VARCHAR2 512     Bank name.    
BANK_BRANCH_NAME VARCHAR2 512     Bank branch name.    
ACTIVE_FLAG VARCHAR2 16     Indicates an active bank account.