[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_USER_EFT_PF_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_USER_EFT_PF_B |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_USER_EFT_PF stores a complete credit card process profile defined for a single payment system account.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_USER_EFT_PF_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USER_EFT_PROFILE_CODE |
IBY_FNDCPT_USER_EFT_PF_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BEP_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_EFT_PROFILE_CODE | VARCHAR2 | (30) | Yes | Funds capture process profile identifier |
SYS_EFT_PROFILE_CODE | VARCHAR2 | (30) | Yes | System profile |
BEP_ACCOUNT_ID | NUMBER | (15) | Yes | Associated payment system account |
VERIFY_TRANS_CONFIG_ID | NUMBER | (15) | Identifier of the transmission configuration used for online verifications | |
FUNDS_XFER_TRANS_CONFIG_ID | NUMBER | (15) | Identifier of the transmission configuration used for funds transfers | |
QUERY_TRANS_CONFIG_ID | NUMBER | (15) | Transmission configuration for acknowledgement processing | |
INACTIVE_DATE | DATE | Inactivity date for the profile | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT USER_EFT_PROFILE_CODE
, SYS_EFT_PROFILE_CODE
, BEP_ACCOUNT_ID
, VERIFY_TRANS_CONFIG_ID
, FUNDS_XFER_TRANS_CONFIG_ID
, QUERY_TRANS_CONFIG_ID
, INACTIVE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_FNDCPT_USER_EFT_PF_B;
IBY.IBY_FNDCPT_USER_EFT_PF_B does not reference any database object
IBY.IBY_FNDCPT_USER_EFT_PF_B is referenced by following:
|
|
|