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