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_TRXN_SUMMARIES_ALL

Object Details

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

IBY_TRXN_SUMMARIES_ALL stores information about each payment request. This table is used for both online and offline payment transactions. The information contained in this table is generic in nature to cover the various payment instruments and the operations on them. The specific details are stored in other detail tables such as IBY_TRXN_CORE, IBY_TRXN_EXTENDED, and IBY_TRXN_FI, based on the type of operation and the payment instrument used for payment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_TRXN_SUMM_TRXNMID_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRXNMID
IBY_TRXN_SUMMARIES_ALL_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
IBY_TRXN_SUMMARIES_ALL_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQDATE
IBY_TRXN_SUMMARIES_ALL_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRXNREF
IBY_TRXN_SUMMARIES_ALL_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTRNUM_HASH
IBY_TRXN_SUMMARIES_ALL_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MBATCHID
IBY_TRXN_SUMMARIES_ALL_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRXNTYPEID
IBY_TRXN_SUMMARIES_ALL_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYERID MPAYEEID
IBY_TRXN_SUMMARIES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTRNUMBER
IBY_TRXN_SUMMARIES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYERINSTRID
IBY_TRXN_SUMMARIES_ALL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCHID
IBY_TRXN_SUMM_MTANGIBLEID_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MTANGIBLEID
IBY_TRXN_SUMM_NEEDSUPD_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEEDSUPDT
IBY_TRXN_SUMM_PAYEEID_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYEEID
IBY_TRXN_SUMM_STATUS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
IBY_TRXN_SUMM_TANGIBLEID_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TANGIBLEID
IBY_TRXN_SUMM_TRANS_ID_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTIONID

Columns

Name	Datatype	Length	Mandatory	Comments
TRXNMID	NUMBER		Yes	System-generated Identifier
TRANSACTIONID	NUMBER		Yes	Identifier generated for each payment request, or orapmtreq, and passed back to electronic commerce application
TANGIBLEID	VARCHAR2	(80)	Yes	Bill or order Identifier
PAYEEID	VARCHAR2	(80)	Yes	Identifier of the payee passed by electronic commerce application
BEPID	NUMBER	(15)		Payment system Identifier
MPAYEEID	NUMBER		Yes	Payee Identifier
ECAPPID	NUMBER	(15)	Yes	Electronic commerce application Identifier
ORG_ID	NUMBER	(15)		Organization Identifier
PAYMENTMETHODNAME	VARCHAR2	(80)		Payment method name
MTANGIBLEID	NUMBER		Yes	Master identifier that points to iby_tangible table for additional information about orders
PAYEEINSTRID	NUMBER			Instrument Identifier for the payee
PAYERID	VARCHAR2	(80)		Payer Identifier
PAYERINSTRID	NUMBER			Instrument Identifier for the payer
DETAILLOOKUP	VARCHAR2	(30)		Lookup column for CORE, EXTENDED, or FI transactions
AMOUNT	NUMBER			Transaction amount
INSTRNUMBER	VARCHAR2	(60)		Instrument number can be credit card number for 11i in case of unregistered instruments.
CURRENCYNAMECODE	VARCHAR2	(15)		Currency code
STATUS	NUMBER	(15)	Yes	Status of the transaction from lookup type IBY_TRANSACTION_STATUS
UPDATEDATE	DATE			Date that scheduled payment is updated
TRXNTYPEID	NUMBER	(15)		From lookup type IBY_TRXNTYPES
ERRORLOCATION	NUMBER			Identifies the location of error
BEPCODE	VARCHAR2	(40)		Error code from payment system
BEPMESSAGE	VARCHAR2	(255)		Error message from payment system
BATCHID	VARCHAR2	(80)		Batch Identifier provided by electronic commerce application
SETTLEDATE	DATE			Scheduled date for the bill or order used for offline payments only
MBATCHID	NUMBER			Batch Identifier
REQDATE	DATE			Date when the batch operation request is received
REQTYPE	VARCHAR2	(20)		Type of request such as closebatch, purgebatch, or openbatch
REQSEQ	NUMBER	(4)		Request sequence
DESTURL	VARCHAR2	(1024)		Payment system URL constructed during schedule of payments
NLSLANG	VARCHAR2	(80)		NLS language
NEEDSUPDT	VARCHAR2	(3)		Y or N flag indicating that the row has changed status
OVERALL_SCORE	NUMBER			Overall risk score
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
INSTRTYPE	VARCHAR2	(30)		Instrument type
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
SALES_REP_PARTY_ID	NUMBER	(15)		Party Identifier for the sales representative who initiated the transaction. Foreign key to HZ_PARTIES
BEPKEY	VARCHAR2	(80)		Merchant account Identifier used with this transaction
CUST_ACCOUNT_ID	NUMBER	(15)		Customer account for which the payment transaction is being processed. Foreign key to HZ_CUST_ACCOUNTS
INSTRSUBTYPE	VARCHAR2	(40)		Holds the instrument subtype for the payment transaction
SUB_KEY_ID	NUMBER			Oracle internal use only, reserved for future use
ECBATCHID	VARCHAR2	(80)		Used for AR bills receivable integration. RA_BATCHES_ALL.BATCH_ID
TRXNREF	VARCHAR2	(240)		Optional, secondary transaction Identifier to be passed by source application. Useful in distinguishing transactions when the tangible or order ID must be shared
PROCESS_PROFILE_CODE	VARCHAR2	(30)		Funds capture process profile
ACCT_SITE_USE_ID	NUMBER	(15)		Account site use identifier
ORG_TYPE	VARCHAR2	(30)		Organization type from lookup type IBY_ORGANIZATION_TYPES
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
BILL_TO_ADDRESS_ID	NUMBER	(15)		Identifier of the bill-to address
FACTORED_FLAG	VARCHAR2	(1)		Y or N flag that indicates if this payment comes from a third party on behalf of the ultimate payer
INSTRNUM_HASH	VARCHAR2	(60)		Hash value of the transaction payment instrument number
INSTRNUM_LENGTH	NUMBER	(3)		Length of the transaction payment instrument
PAYMENT_CHANNEL_CODE	VARCHAR2	(30)		Payment method
CC_ISSUER_RANGE_ID	NUMBER	(15)		Identifier of the credit card number range the payment instrument number belongs to
INSTRNUM_SEC_SEGMENT_ID	NUMBER	(15)		Identifier of the security segment holding the encrypted payment instrument number
PROC_REFERENCE_CODE	VARCHAR2	(240)		Payment processor reference code
PROC_REFERENCE_AMOUNT	NUMBER			Payment processor reference amount
SETTLEMENT_CUSTOMER_REFERENCE	VARCHAR2	(255)		Settlement customer reference
BR_MATURITY_DATE	DATE			Bills receivable maturity date
SETTLEMENT_DUE_DATE	DATE			Settlement due date
CALL_APP_SERVICE_REQ_CODE	VARCHAR2	(255)		External application request set identifier
BANK_CHARGE_BEARER_CODE	VARCHAR2	(30)		Bank charge bearer
DIRDEB_INSTRUCTION_CODE	VARCHAR2	(30)		Direct debit instruction code
DEBIT_ADVICE_DELIVERY_METHOD	VARCHAR2	(30)		Default delivery method set on the payer level for debit notification
DEBIT_ADVICE_EMAIL	VARCHAR2	(255)		Debit notification email address
DEBIT_ADVICE_FAX	VARCHAR2	(100)		Debit notification fax number
PAYER_PARTY_ID	NUMBER			Payer TCA party identifier
FIRST_TRXN_FLAG	VARCHAR2	(1)		Y or N flag
ACCT_SITE_ID	NUMBER	(15)		Identifier of the account site for a funds capture transaction
DEBIT_AUTH_FLAG	VARCHAR2	(1)		Debit authorization flag
DEBIT_AUTH_METHOD	VARCHAR2	(30)		Debit authorization method
DEBIT_AUTH_REFERENCE	VARCHAR2	(100)		Debit authorization reference
PAYER_INSTR_ASSIGNMENT_ID	NUMBER	(15)		Instrument assignment identifier for the payer instrument
PAYER_NOTIFICATION_REQUIRED	VARCHAR2	(1)		Y or N flag indicating whether payer notification is created for this transaction if it is a settlement
PAYER_NOTIFICATION_CREATED	VARCHAR2	(1)		Y or N flag indicating whether payer notification is created for this transaction if it is a settlement
AR_RECEIPT_METHOD_ID	NUMBER	(15)		Oracle Receivables receipt method
BR_DRAWEE_ISSUED_FLAG	VARCHAR2	(1)		Y or N flag that indicates if the the drawee issues the bill recievable
BR_SIGNED_FLAG	VARCHAR2	(1)		Y or N flag that indicates if the drawee needs to accept the bill receivable
SALT_VERSION	NUMBER	(2)		Salt Version used for Encryption
INITIATOR_EXTENSION_ID	NUMBER	(15)	Yes	This is a foreign key to IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID. This denotes the extension that initiated the transaction.
LOGICAL_GROUP_REFERENCE	VARCHAR2	(80)		Stroes the logical group reference of a transaction.
SEQ_TYPE	VARCHAR2	(30)		payment type code
SERVICE_LEVEL	VARCHAR2	(30)		service level for a transaction
LOCALINSTR	VARCHAR2	(30)		local instrument of a transction
CATEGORY_PURPOSE	VARCHAR2	(30)		category purpose of a trxn.
DEBIT_AUTHORIZATION_ID	NUMBER	(15)		Mandate ID
CREDITOR_REFERENCE	VARCHAR2	(35)		Creditor reference for a transaction.

Query Text

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


SELECT TRXNMID
,      TRANSACTIONID
,      TANGIBLEID
,      PAYEEID
,      BEPID
,      MPAYEEID
,      ECAPPID
,      ORG_ID
,      PAYMENTMETHODNAME
,      MTANGIBLEID
,      PAYEEINSTRID
,      PAYERID
,      PAYERINSTRID
,      DETAILLOOKUP
,      AMOUNT
,      INSTRNUMBER
,      CURRENCYNAMECODE
,      STATUS
,      UPDATEDATE
,      TRXNTYPEID
,      ERRORLOCATION
,      BEPCODE
,      BEPMESSAGE
,      BATCHID
,      SETTLEDATE
,      MBATCHID
,      REQDATE
,      REQTYPE
,      REQSEQ
,      DESTURL
,      NLSLANG
,      NEEDSUPDT
,      OVERALL_SCORE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INSTRTYPE
,      SECURITY_GROUP_ID
,      SALES_REP_PARTY_ID
,      BEPKEY
,      CUST_ACCOUNT_ID
,      INSTRSUBTYPE
,      SUB_KEY_ID
,      ECBATCHID
,      TRXNREF
,      PROCESS_PROFILE_CODE
,      ACCT_SITE_USE_ID
,      ORG_TYPE
,      LEGAL_ENTITY_ID
,      BILL_TO_ADDRESS_ID
,      FACTORED_FLAG
,      INSTRNUM_HASH
,      INSTRNUM_LENGTH
,      PAYMENT_CHANNEL_CODE
,      CC_ISSUER_RANGE_ID
,      INSTRNUM_SEC_SEGMENT_ID
,      PROC_REFERENCE_CODE
,      PROC_REFERENCE_AMOUNT
,      SETTLEMENT_CUSTOMER_REFERENCE
,      BR_MATURITY_DATE
,      SETTLEMENT_DUE_DATE
,      CALL_APP_SERVICE_REQ_CODE
,      BANK_CHARGE_BEARER_CODE
,      DIRDEB_INSTRUCTION_CODE
,      DEBIT_ADVICE_DELIVERY_METHOD
,      DEBIT_ADVICE_EMAIL
,      DEBIT_ADVICE_FAX
,      PAYER_PARTY_ID
,      FIRST_TRXN_FLAG
,      ACCT_SITE_ID
,      DEBIT_AUTH_FLAG
,      DEBIT_AUTH_METHOD
,      DEBIT_AUTH_REFERENCE
,      PAYER_INSTR_ASSIGNMENT_ID
,      PAYER_NOTIFICATION_REQUIRED
,      PAYER_NOTIFICATION_CREATED
,      AR_RECEIPT_METHOD_ID
,      BR_DRAWEE_ISSUED_FLAG
,      BR_SIGNED_FLAG
,      SALT_VERSION
,      INITIATOR_EXTENSION_ID
,      LOGICAL_GROUP_REFERENCE
,      SEQ_TYPE
,      SERVICE_LEVEL
,      LOCALINSTR
,      CATEGORY_PURPOSE
,      DEBIT_AUTHORIZATION_ID
,      CREDITOR_REFERENCE
FROM IBY.IBY_TRXN_SUMMARIES_ALL;

Dependencies

[top of page]

IBY.IBY_TRXN_SUMMARIES_ALL does not reference any database object

IBY.IBY_TRXN_SUMMARIES_ALL is referenced by following:

IBY: IBY_TRXN_SUMMARIES_ALL#