# 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, 2025, Oracle and/or its affiliates.