[Home] [Help] [Dependency Information]
Object Name: | IBY_BANKACCT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBY.IBY_BANKACCT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View used to work with registered bank accounts.
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 |
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;
APPS.IBY_BANKACCT_V is not referenced by any database object
|
|
|