[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_USER_CC_PF_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_USER_CC_PF_B |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_USER_CC_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_CC_PF_B_UPC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USER_CC_PROFILE_CODE |
IBY_FNDCPT_USER_CC_PF_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BEP_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_CC_PROFILE_CODE | VARCHAR2 | (30) | Yes | Funds capture process profile identifier |
SYS_CC_PROFILE_CODE | VARCHAR2 | (30) | Yes | System profile |
BEP_ACCOUNT_ID | NUMBER | (15) | Yes | Associated payment system account |
ONLINE_AUTH_TRANS_CONFIG_ID | NUMBER | (15) | Identifier of the transmission configuration used for online authorizations | |
SETTLEMENT_TRANS_CONFIG_ID | NUMBER | (15) | Identifier of the transmission configuration used for settlements | |
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_CC_PROFILE_CODE
, SYS_CC_PROFILE_CODE
, BEP_ACCOUNT_ID
, ONLINE_AUTH_TRANS_CONFIG_ID
, SETTLEMENT_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_CC_PF_B;
IBY.IBY_FNDCPT_USER_CC_PF_B does not reference any database object
IBY.IBY_FNDCPT_USER_CC_PF_B is referenced by following:
|
|
|