DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V

Object Details
Object Name: AR_DRAWEE_BANK_ACCOUNTS_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_DRAWEE_BANK_ACCOUNTS_H_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
DRAW_BANK_ACCOUNT_USE VARCHAR2 (25) Yes Bank account type code. Possible values are: INTERNAL or SUPPLIER for banks defined for Oracle Payables, INTERNAL or EXTERNAL for banks defined for Oracle Receivables and PAYROLL for banks defined for Payroll
DRAW_BA_ASSET_CCID NUMBER (15)
Accounting Flexfield identifier for cash account associated with bank account
DRAW_BANK_ACCOUNT_ID NUMBER (15) Yes Bank account identifier
DRAW_BANK_ACCOUNT_NAME VARCHAR2 (80) Yes Bank account name
DRAW_BANK_ACCOUNT_NAME_ALT VARCHAR2 (320)
Alternate bank account name
DRAW_BANK_ACCOUNT_NUM VARCHAR2 (30) Yes Bank account number
DRAW_BANK_ACCOUNT_TYPE VARCHAR2 (25)
Bank account type code
DRAW_BA_BANK_CHARGES_CCID NUMBER (15)
Accounting Flexfield identifier for the Bank Charges Account
DRAW_BA_BANK_ERRORS_CCID NUMBER (15)
Accounting Flexfield identifier for the Bank Errors Account
DRAW_BA_BR_FACTOR_CCID NUMBER (15)
Accounting Flexfield identifier for the Bills Receivable Factoring account
DRAW_BA_BR_REMITTANCE_CCID NUMBER (15)
Accounting Flexfield identifier for the Bills Receivable Remittance account
DRAW_BA_CASH_CLEARING_CCID NUMBER (15)
Accounting Flexfield identifier for the Cash Clearing Account
DRAW_BA_CURRENCY_CODE VARCHAR2 (15)
Currency code
DRAW_BA_DESCRIPTION VARCHAR2 (240)
Description
DRAW_BA_EARNED_CCID NUMBER (15)
Accounting Flexfield identifier for the Earned Account
DRAW_BA_FACTOR_CCID NUMBER (15)
Accounting Flexfield identifier for the Factor Account
DRAW_BA_FUTURE_PAYMENT_CCID NUMBER (15)
Accounting Flexfield identifier for the future dated payment account
DRAW_BA_GAIN_CCID NUMBER (15)
Accounting Flexfield identifier for account to which you post realized exchange rate gains
DRAW_BA_GLOBAL_ATTR1 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR10 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR18 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR19 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR2 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR20 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR3 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR4 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR5 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR6 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR7 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR8 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR9 VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_GLOBAL_ATTR_CAT VARCHAR2 (150)
Reserved for country-specific functionality
DRAW_BA_LOSS_CCID NUMBER (15)
Accounting Flexfield identifier for account to which you post realized exchange rate losses
DRAW_BA_ON_ACCOUNT_CCID NUMBER (15)
Accounting Flexfield identifier for the On Account Account
DRAW_BA_RECEIPT_CLEARING_CCID NUMBER (15)
Accounting Flexfield identifier for the Receipt Confirmation Account
DRAW_BA_REMITTANCE_CCID NUMBER (15)
Accounting Flexfield identifier for the Remittance Account
DRAW_BA_SHORT_TERM_DEP_CCID NUMBER (15)
Accounting Flexfield identifier for the Short Term Deposit Account
DRAW_BA_UNAPPLIED_CCID NUMBER (15)
Accounting Flexfield identifier for the Unapplied Account
DRAW_BA_UNEARNED_CCID NUMBER (15)
Accounting Flexfield identifier for the Unearned Account
DRAW_BA_UNIDENTIFIED_CCID NUMBER (15)
Accounting Flexfield identifier for the Unidentified Account
DRAW_BA_AGENCY_LOCATION_CODE VARCHAR2 (30)
Agency Location code assigned by US Treasury
DRAW_BA_IBAN_NUMBER VARCHAR2 (40)
International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
EVENT_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DRAW_BANK_ACCOUNT_USE
,      DRAW_BA_ASSET_CCID
,      DRAW_BANK_ACCOUNT_ID
,      DRAW_BANK_ACCOUNT_NAME
,      DRAW_BANK_ACCOUNT_NAME_ALT
,      DRAW_BANK_ACCOUNT_NUM
,      DRAW_BANK_ACCOUNT_TYPE
,      DRAW_BA_BANK_CHARGES_CCID
,      DRAW_BA_BANK_ERRORS_CCID
,      DRAW_BA_BR_FACTOR_CCID
,      DRAW_BA_BR_REMITTANCE_CCID
,      DRAW_BA_CASH_CLEARING_CCID
,      DRAW_BA_CURRENCY_CODE
,      DRAW_BA_DESCRIPTION
,      DRAW_BA_EARNED_CCID
,      DRAW_BA_FACTOR_CCID
,      DRAW_BA_FUTURE_PAYMENT_CCID
,      DRAW_BA_GAIN_CCID
,      DRAW_BA_GLOBAL_ATTR1
,      DRAW_BA_GLOBAL_ATTR10
,      DRAW_BA_GLOBAL_ATTR18
,      DRAW_BA_GLOBAL_ATTR19
,      DRAW_BA_GLOBAL_ATTR2
,      DRAW_BA_GLOBAL_ATTR20
,      DRAW_BA_GLOBAL_ATTR3
,      DRAW_BA_GLOBAL_ATTR4
,      DRAW_BA_GLOBAL_ATTR5
,      DRAW_BA_GLOBAL_ATTR6
,      DRAW_BA_GLOBAL_ATTR7
,      DRAW_BA_GLOBAL_ATTR8
,      DRAW_BA_GLOBAL_ATTR9
,      DRAW_BA_GLOBAL_ATTR_CAT
,      DRAW_BA_LOSS_CCID
,      DRAW_BA_ON_ACCOUNT_CCID
,      DRAW_BA_RECEIPT_CLEARING_CCID
,      DRAW_BA_REMITTANCE_CCID
,      DRAW_BA_SHORT_TERM_DEP_CCID
,      DRAW_BA_UNAPPLIED_CCID
,      DRAW_BA_UNEARNED_CCID
,      DRAW_BA_UNIDENTIFIED_CCID
,      DRAW_BA_AGENCY_LOCATION_CODE
,      DRAW_BA_IBAN_NUMBER
,      EVENT_ID
FROM APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V;

Dependencies

[top of page]

APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V references the following:

SchemaAPPS
SynonymAP_BANK_ACCOUNTS_ALL
SynonymAR_XLA_LINES_EXTRACT

APPS.AR_DRAWEE_BANK_ACCOUNTS_H_V is not referenced by any database object