DW_BANK_ACCOUNT_D
This table contains details about bank accounts.
Details
Module:
Key Columns
BANK_ACCOUNT_ID
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 |