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

VIEW: APPS.IBY_BANKACCT_V

Object Details
Object Name: IBY_BANKACCT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_BANKACCT_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View used to work with registered bank accounts.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTRID NUMBER (15) Yes ID that iPayment uses to identify a registered
BANKACCOUNTID VARCHAR2 (80) Yes The bank account number of a registered bank account.
FINAME VARCHAR2 (80)
The name of the financial institution (bank) to which a bank account belongs.
BRANCHID VARCHAR2 (60)
The ID or name of the bank branch at which the account holder does business.
ACCTTYPE VARCHAR2 (30)
The type of bank account (e.g. savings, checking).
INSTRBUF VARCHAR2 (240)
Description of registered bank account.
INSTRNAME VARCHAR2 (80)
Mnemonic for a registered bank account.
ACCOUNT_HOLDER_NAME VARCHAR2 (240)
Name of the bank account holder.
BANKID VARCHAR2 (25)
Routing number of financial institution (bank).
OWNERID VARCHAR2 (80) Yes ID that iPayment uses to identify bank account holder.
OWNERTYPE VARCHAR2 (20) Yes The type of the account holder (e.g. user).
CHECK_DIGITS VARCHAR2 (30)
Check digits for bank accounts that identify them separately from the bank account numbers
Query Text

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


SELECT INSTRID
,      BANKACCOUNTID
,      FINAME
,      BRANCHID
,      ACCTTYPE
,      INSTRBUF
,      INSTRNAME
,      ACCOUNT_HOLDER_NAME
,      BANKID
,      OWNERID
,      OWNERTYPE
,      CHECK_DIGITS
FROM APPS.IBY_BANKACCT_V;

Dependencies

[top of page]

APPS.IBY_BANKACCT_V references the following:

SchemaAPPS
SynonymIBY_ACCTTYPE
SynonymIBY_BANKACCT
SynonymIBY_INSTRHOLDER

APPS.IBY_BANKACCT_V is not referenced by any database object