[Home] [Help] [Dependency Information]
Object Name: | IBY_DEFAULT_BEP |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_DEFAULT_BEP |
Subobject Name: | |
Status: | VALID |
IBY_DEFAULT_BEP stores information that will allow a payment system account and funds capture process profile to be derived for a transaction should the routing rules fail to yield them.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_DEFAULT_BEP_BAM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BEPID
BEP_ACCOUNT_ID MPAYEEID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTRTYPE | VARCHAR2 | (30) | Yes | Type of Instrument supported by Back End Payment System |
BEPID | NUMBER | (15) | Yes | Back End Payment System identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
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. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
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). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
MPAYEEID | NUMBER | (15) | Payee identifier | |
PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) | Payment method of the transaction | |
FNDCPT_USER_PROFILE_CODE | VARCHAR2 | (30) | Default funds capture process profile to be used for the payment method if routing rules fail to yield one | |
BEP_ACCOUNT_ID | NUMBER | (15) | Default payment system account that |
Cut, paste (and edit) the following text to query this object:
SELECT INSTRTYPE
, BEPID
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, MPAYEEID
, PAYMENT_CHANNEL_CODE
, FNDCPT_USER_PROFILE_CODE
, BEP_ACCOUNT_ID
FROM IBY.IBY_DEFAULT_BEP;
IBY.IBY_DEFAULT_BEP does not reference any database object
IBY.IBY_DEFAULT_BEP is referenced by following:
|
|
|