# 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 |  | 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. Possible values are Customer, Supplier, or Company. |  |
BANK_ACCOUNT_NUM | VARCHAR2 | 32 |  |  | Bank account number. | DW_CE_BANK_ACCOUNT_TYPE_LKP_TL | BANK_ACCOUNT_TYPE_CODE
MASKED_BANK_ACCOUNT_NUM | VARCHAR2 | 999 |  |  | Masked bank account number. |  |
BANK_ACCOUNT_NAME | VARCHAR2 | 512 |  |  | Bank account name. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Account Owner Organization Id | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
BANK_NAME | VARCHAR2 | 512 |  |  | Bank name. |  |
BANK_BRANCH_NAME | VARCHAR2 | 512 |  |  | Bank branch name. |  |
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Indicates an active bank account. | DW_YN_LKP_TL | YN_LKP_CODE
ACCOUNT_CLASSIFICATION | VARCHAR2 | 32 |  |  | Account Classification | DW_CE_ACCOUNT_CLASSIFICATION_LKP_TL | ACCOUNT_CLASSIFICATION_CODE
DATA_SECURITY_FLAG | VARCHAR2 | 16 |  |  | Data Security Flag | DW_YN_LKP_TL | YN_LKP_CODE
NETTING_ACCT_FLAG | VARCHAR2 | 16 |  |  | Netting Account Flag | DW_YN_LKP_TL | YN_LKP_CODE
AP_USE_ALLOWED_FLAG | VARCHAR2 | 16 |  |  | AP Use Allowed Flag | DW_YN_LKP_TL | YN_LKP_CODE
AR_USE_ALLOWED_FLAG | VARCHAR2 | 16 |  |  | AR Use Allowed Flag | DW_YN_LKP_TL | YN_LKP_CODE
BANK_BRANCH_ID | NUMBER | 38 | 0 |  | Bank Branch Id |  |
BANK_ID | NUMBER | 38 | 0 |  | Bank Id |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Bank Account Created By User | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Bank Account Creation Date |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Bank Account Last Updated By User |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Bank Account Last Update Date |  |
MULTI_CURRENCY_ALLOWED_FLAG | VARCHAR2 | 16 |  |  | Multicurrency Allowed Flag | DW_YN_LKP_TL | YN_LKP_CODE
BANK_CODE | VARCHAR2 | 32 |  |  | Bank Number |  |
BANK_DESCRIPTION | VARCHAR2 | 999 |  |  | Bank Description |  |
BANK_COUNTRY_CODE | VARCHAR2 | 16 |  |  | Bank Country | DW_COUNTRY_D_TL | COUNTRY
BANK_BRANCH_NUMBER | VARCHAR2 | 32 |  |  | Bank Branch Number |  |
BANK_ACCOUNT_DESCRIPTION | VARCHAR2 | 512 |  |  | Bank Account Description |  |
PAY_USE_ALLOWED_FLAG | VARCHAR2 | 16 |  |  |  | DW_YN_LKP_TL | YN_LKP_CODE
BANK_ACCOUNT_NAME_ALT | VARCHAR2 | 512 |  |  | Alternative Bank Account Name |  |

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