[Home] [Help] [Dependency Information]
Object Name: | IBY_BANKACCT |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_BANKACCT |
Subobject Name: | |
Status: | VALID |
IBY_BANKACCOUNT keeps bank account related information of the customer(payer) or payee.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_BANKACCT_INSTRID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INSTRID |
IBY_BANKACCT_BANKACCOUNTID_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BANKACCOUNTID |
IBY_BANKACCT_ENCRYPTED_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENCRYPTED |
IBY_BANKACCT_ROUTINGNO_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ROUTINGNO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTRID | NUMBER | (15) | Yes | System generated id. Primary key |
BANKACCOUNTID | VARCHAR2 | (80) | Yes | Bank Account number |
ADDRESSID | NUMBER | Address identifier, FK to HZ_LOCATIONS table. Address for the bank branch. | ||
FINAME | VARCHAR2 | (80) | Financial Institution Name - bank name | |
ACCTTYPEID | NUMBER | Yes | Accttype identifier, FK to iby_accttype. CHECKING, SAVING, etc. | |
BRANCHNAME | VARCHAR2 | (60) | Bank Branch Name. Used to store bank branch number | |
ROUTINGNO | VARCHAR2 | (25) | ABA Routing Number for US bank accounts; bank number for non-US banks issued by some Code Agency | |
DESCRIPTION | VARCHAR2 | (240) | Description of the instruments | |
INSTRNAME | VARCHAR2 | (80) | Name of the instrument | |
ACCOUNT_HOLDER_NAME | VARCHAR2 | (240) | Account Holder Name | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
BRANCHID | VARCHAR2 | (30) | Bank branch number. Added for AR-BR integration | |
BANKSWIFTCODE | VARCHAR2 | (30) | Bank SWIFT code. Added for AR-BR integration | |
CHECK_DIGITS | VARCHAR2 | (30) | Check digits for bank accounts that identify them separately from the bank account numbers | |
ENCRYPTED | VARCHAR2 | (1) | Indicates whether strong encryption was used on sensitive data | |
CURRENCY_CODE | VARCHAR2 | (15) | ISO three digits currency code |
Cut, paste (and edit) the following text to query this object:
SELECT INSTRID
, BANKACCOUNTID
, ADDRESSID
, FINAME
, ACCTTYPEID
, BRANCHNAME
, ROUTINGNO
, DESCRIPTION
, INSTRNAME
, ACCOUNT_HOLDER_NAME
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, BRANCHID
, BANKSWIFTCODE
, CHECK_DIGITS
, ENCRYPTED
, CURRENCY_CODE
FROM IBY.IBY_BANKACCT;
IBY.IBY_BANKACCT does not reference any database object
IBY.IBY_BANKACCT is referenced by following:
|
|
|