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_EFT_PF_B

Object Details

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

IBY_FNDCPT_SYS_EFT_PF stores payment system-defined attributes of the bank account electronic funds transfer process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_FNDCPT_SYS_EFT_PF_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYS_EFT_PROFILE_CODE ZD_EDITION_NAME
IBY_FNDCPT_SYS_EFT_PF_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYER_NOTIFICATION_FORMAT
IBY_FNDCPT_SYS_EFT_PF_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOMPANY_LETTER_FORMAT

Columns

Name	Datatype	Length	Mandatory	Comments
SYS_EFT_PROFILE_CODE	VARCHAR2	(30)	Yes	System process profile identifier
PAYMENT_SYSTEM_ID	NUMBER	(15)	Yes	Payment system identifier
VERIFY_FORMAT_CODE	VARCHAR2	(30)		Payment format identifier for verification messages (if supported).
VERIFY_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for verification messages
VERIFY_ACK_RDR_CODE	VARCHAR2	(30)		Acknowledgment reader for verification responses
SETTLE_REQUIRE_VRFY_FLAG	VARCHAR2	(1)	Yes	Y or N flag indicating that the settlements require pre-existing verification operations
FUNDS_XFER_FORMAT_CODE	VARCHAR2	(30)	Yes	Format for funds transfer transactions.
FUNDS_XFER_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for funds transfer messages.
FUNDS_XFER_ACK_RDR_CODE	VARCHAR2	(30)		Acknowledgment reader for funds transfer responses
QUERY_FORMAT_CODE	VARCHAR2	(30)		Format for the query request
QUERY_TRANS_PRTCL_CODE	VARCHAR2	(30)		Transmission protocol for query requests
QUERY_ACK_RDR_CODE	VARCHAR2	(30)		Query acknowledgement/response reader
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
LIMIT_BY_SETTLEMENT_NUM	NUMBER			Maximum number of settlements that can be included in a settlement batch
INACTIVE_DATE	DATE			Inactivity date for the profile
CREATED_BY	NUMBER	(15)		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)		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.
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)		Payment format identifier for payer notification
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
ACCOMPANY_LETTER_FORMAT	VARCHAR2	(30)		Accompany Letter Format
AUTOMATIC_PN_SUBMIT_FLAG	VARCHAR2	(1)		Y or N flag indicating whether the payer notification is submitted automatically at settlement completion point
PAYER_NOTIFICATION_CONDITION	VARCHAR2	(30)		Condition for Payer notification to be sent is based on All the receipts or num of receipts
PN_COND_NUM_OF_RECEIPTS	NUMBER			Number of reciptis, Payer Notification will be sent only if Number of receipts in the batch > this number.
EXCLUDE_TRXN_DET_EXTRACTION	VARCHAR2	(1)		Indicates to Excude the extraction of Invoice details
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT SYS_EFT_PROFILE_CODE
,      PAYMENT_SYSTEM_ID
,      VERIFY_FORMAT_CODE
,      VERIFY_TRANS_PRTCL_CODE
,      VERIFY_ACK_RDR_CODE
,      SETTLE_REQUIRE_VRFY_FLAG
,      FUNDS_XFER_FORMAT_CODE
,      FUNDS_XFER_TRANS_PRTCL_CODE
,      FUNDS_XFER_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
,      LIMIT_BY_SETTLEMENT_NUM
,      INACTIVE_DATE
,      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
,      ACCOMPANY_LETTER_FORMAT
,      AUTOMATIC_PN_SUBMIT_FLAG
,      PAYER_NOTIFICATION_CONDITION
,      PN_COND_NUM_OF_RECEIPTS
,      EXCLUDE_TRXN_DET_EXTRACTION
,      ZD_EDITION_NAME
FROM IBY.IBY_FNDCPT_SYS_EFT_PF_B;

Dependencies

[top of page]

IBY.IBY_FNDCPT_SYS_EFT_PF_B does not reference any database object

IBY.IBY_FNDCPT_SYS_EFT_PF_B is referenced by following:

IBY: IBY_FNDCPT_SYS_EFT_PF_B#