eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBY.IBY_FNDCPT_SYS_CC_PF_B

Object Details

Object Name:	IBY_FNDCPT_SYS_CC_PF_B
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_FNDCPT_SYS_CC_PF_B
Subobject Name:
Status:	VALID

"IBY_FNDCPT_SYS_CC_PF stores Funds Capture processing rules for a Payment system for the credit card funds capture process.
This table corresponds to the Funds capture process profile UI. "

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_FNDCPT_SYS_CC_PF_SPC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYS_CC_PROFILE_CODE
IBY_FNDCPT_SYS_CC_PF_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYER_NOTIFICATION_FORMAT

Columns

Name	Datatype	Length	Mandatory	Comments
SYS_CC_PROFILE_CODE	VARCHAR2	(30)	Yes	Funds Capture Process Profile code.
PAYMENT_SYSTEM_ID	NUMBER	(15)	Yes	Payment system identifier
ONLINE_AUTH_FORMAT_CODE	VARCHAR2	(30)	Yes	Format code of online authorization message.
ONLINE_AUTH_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for online authorization messages
ONLINE_AUTH_ACK_RDR_CODE	VARCHAR2	(30)	Yes	Format code of acknowledgement message for online authorization transaction.
SETTLEMENT_FORMAT_CODE	VARCHAR2	(30)	Yes	Format code of settlement message.
SETTLEMENT_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for settlement messages
SETTLEMENT_ACK_RDR_CODE	VARCHAR2	(30)		Format code of acknowledgement message for settlement transaction.
QUERY_FORMAT_CODE	VARCHAR2	(30)		Format code for query request message.
QUERY_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for query requests
QUERY_ACK_RDR_CODE	VARCHAR2	(30)		Format code of acknowledgement message for query request transaction.
GROUP_BY_ORG	VARCHAR2	(1)		Y or N flag specifying whether settlements should be grouped into settlement batches by first party organization
GROUP_BY_LEGAL_ENTITY	VARCHAR2	(1)		Y or N flag specifying whether settlements should be grouped into settlement batches by first party legal entity
GROUP_BY_INT_BANK_ACCOUNT	VARCHAR2	(1)		Y or N flag specifying whether settlements should be grouped into settlement batches by internal bank account
GROUP_BY_SETTLEMENT_CURR	VARCHAR2	(1)		Y or N flag specifying whether settlements should be grouped into settlement batches by settlement currency
GROUP_BY_SETTLEMENT_DATE	VARCHAR2	(1)		Y or N flag specifying whether settlements should be grouped into settlement batches by settlement date
LIMIT_BY_AMT_CURR	VARCHAR2	(10)		Currency in which the maximum total amount per settlement batch is calculated.
LIMIT_BY_EXCH_RATE_TYPE	VARCHAR2	(255)		Exchange rate type used to compare the settlement batch total amount to the maximum total amount allowed. Types are defined in the General Ledger currency exchange rate type lookups table. These include CORPORATE, SPOT, and DAILY.
LIMIT_BY_TOTAL_AMT	NUMBER			Maximum total amount for which a settlement batch can be created
INACTIVE_DATE	DATE			Inactivity date for the profile
LIMIT_BY_SETTLEMENT_NUM	NUMBER			Maximum number of settlements that can be included in a settlement batch
CREATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
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. This number is incremented for every update to the row through the application.
SETTLEMENT_COMPLETE_POINT	VARCHAR2	(50)		A point when the settlement is considered complete.
OVERRIDE_PAYER_DELIVERY_FLAG	VARCHAR2	(1)		Y or N Flag indicating whether the payer notification delivery method should be overridden by the payer delivery method preference.
PAYER_NOTIFICATION_FORMAT	VARCHAR2	(30)		Format code of payer notification message
PAYER_NOTIFICATION_DEL_METHOD	VARCHAR2	(100)		Remittance advice delivery method. Values, from the lookup IBY_DELIVERY_METHODS, include EMAIL, FAX, and PRINTED
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
AUTOMATIC_PN_SUBMIT_FLAG	VARCHAR2	(1)		Y or No Flag indicating whether the payer notification is submitted automatically at settlement completion point

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYS_CC_PROFILE_CODE
,      PAYMENT_SYSTEM_ID
,      ONLINE_AUTH_FORMAT_CODE
,      ONLINE_AUTH_TRANS_PRTCL_CODE
,      ONLINE_AUTH_ACK_RDR_CODE
,      SETTLEMENT_FORMAT_CODE
,      SETTLEMENT_TRANS_PRTCL_CODE
,      SETTLEMENT_ACK_RDR_CODE
,      QUERY_FORMAT_CODE
,      QUERY_TRANS_PRTCL_CODE
,      QUERY_ACK_RDR_CODE
,      GROUP_BY_ORG
,      GROUP_BY_LEGAL_ENTITY
,      GROUP_BY_INT_BANK_ACCOUNT
,      GROUP_BY_SETTLEMENT_CURR
,      GROUP_BY_SETTLEMENT_DATE
,      LIMIT_BY_AMT_CURR
,      LIMIT_BY_EXCH_RATE_TYPE
,      LIMIT_BY_TOTAL_AMT
,      INACTIVE_DATE
,      LIMIT_BY_SETTLEMENT_NUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SETTLEMENT_COMPLETE_POINT
,      OVERRIDE_PAYER_DELIVERY_FLAG
,      PAYER_NOTIFICATION_FORMAT
,      PAYER_NOTIFICATION_DEL_METHOD
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTOMATIC_PN_SUBMIT_FLAG
FROM IBY.IBY_FNDCPT_SYS_CC_PF_B;

Dependencies

[top of page]

IBY.IBY_FNDCPT_SYS_CC_PF_B does not reference any database object

IBY.IBY_FNDCPT_SYS_CC_PF_B is referenced by following:

APPS: IBY_FNDCPT_SYS_CC_PF_B