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.