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_CORE

Object Details

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

IBY_BEPKEYS stores information about the payment systems.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_TRXN_CORE_TRXNMID_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRXNMID
IBY_TRXN_CORE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUTHCODE
IBY_TRXN_CORE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRACENUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TRXNMID	NUMBER		Yes	Primary key as well as foreign key associating the POS data with a single credit card transaction
TERMINALID	VARCHAR2	(80)		used for credit card processing. A merchant can get multiple terminal Ids and there is a batch open for each Terminal Id. The merchant could perform operations on those batches independantly.
TRACENUMBER	VARCHAR2	(80)		Unique Transaction id for payworks Back End Payment System follow-on transactions
AUTHCODE	VARCHAR2	(80)		authorization code received from Credit Card Processing System for authorization.
REFERENCECODE	VARCHAR2	(80)		reference code received from Back End Payment Systems or processing system which can be used for reference.
OPERATIONCODE	VARCHAR2	(80)		generic code for any operation such as auth, capture etc
INSTRNAME	VARCHAR2	(80)		payment instrument name such as Visa, MasterCard etc.
AUTHTYPE	VARCHAR2	(20)		denotes whether authorization is authonly or authcapture.
AVSCODE	VARCHAR2	(80)		Address Verification Code from back end payment systems.
ACQUIRER	VARCHAR2	(80)		merchant bank which may be optionally returned by back end payment system.
AUXMSG	VARCHAR2	(255)		auxillary message that may be returned by the payment system or processing system.
OBJECT_VERSION_NUMBER	NUMBER	(5)	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.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
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).
PONUMBER	VARCHAR2	(80)		Buyer's Purchase Order Number
TAXAMOUNT	NUMBER			The amount, out of the total price, that consists of tax.
SHIPFROMZIP	VARCHAR2	(80)		The ZIP code from which merchandise is to be sent.
SHIPTOZIP	VARCHAR2	(80)		The ZIP code to which merchandise is to be sent.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
VOICEAUTHFLAG	VARCHAR2	(1)		Indicates whether Authorization was done manually
CVV2RESULT	VARCHAR2	(5)		CVV2 validation result returned by the payment system/credit card network.
PROC_TRACENUMBER	VARCHAR2	(80)		Processor trace/reference number column. Required by certain processors.
DATE_OF_VOICE_AUTHORIZATION	DATE			Date Of Voice Authorization
POS_READER_CAPABILITY_CODE	VARCHAR2	(30)		Card reader capability at the point-of-sale from lookup type IBY_POS_CAPABILITY_TYPE
POS_ENTRY_METHOD_CODE	VARCHAR2	(30)		Card entry method from lookup type IBY_POS_ENTRY_TYPE
POS_ID_METHOD_CODE	VARCHAR2	(30)		Card holder identification method from lookup type IBY_POS_CARD_ID_TYPE
POS_AUTH_SOURCE_CODE	VARCHAR2	(30)		Card authorization source from lookup type IBY_POS_AUTH_SRC_TYPE
READER_DATA	VARCHAR2	(255)		Card reader data, encoded in a text format
POS_TRXN_FLAG	VARCHAR2	(1)		Indicates whether the transaction occurred at a point-of-sale
INSTR_EXPIRYDATE	DATE			Expiration date for the card
CARD_SUBTYPE_CODE	VARCHAR2	(30)		Subtype, used for purchase cards from lookup type IBY_PURCHASECARD_SUBTYPE
CARD_DATA_LEVEL	VARCHAR2	(10)		Purchase card data level from lookup type IBY_PCARD_DATA_LEVEL
INSTR_OWNER_NAME	VARCHAR2	(80)		Card holder name, as a single string
INSTR_OWNER_ADDRESS_LINE1	VARCHAR2	(240)		Card holder billing address line 1 information.
INSTR_OWNER_ADDRESS_LINE2	VARCHAR2	(240)		Card holder billing address line 2 information.
INSTR_OWNER_ADDRESS_LINE3	VARCHAR2	(240)		Card holder billing address line 2 information.
INSTR_OWNER_CITY	VARCHAR2	(80)		Card holder billing address city information
INSTR_OWNER_STATE_PROVINCE	VARCHAR2	(80)		Card holder billing address state or province information
INSTR_OWNER_COUNTRY	VARCHAR2	(80)		Card holder billing address country information
INSTR_OWNER_POSTALCODE	VARCHAR2	(80)		Card holder billing address information
INSTR_OWNER_PHONE	VARCHAR2	(80)		Card holder billing address phone information
INSTR_OWNER_EMAIL	VARCHAR2	(80)		Card holder email information
DEBIT_NETWORK_CODE	VARCHAR2	(80)		Debit card network code
SURCHARGE_AMOUNT	NUMBER			Debit card surcharge amount
ENCRYPTED	VARCHAR2	(240)	Yes	Indicates whether the card holder name and the expiry date details are encrypted or not.
EXPIRY_SEC_SEGMENT_ID	NUMBER	(15)		Expiry date segment identifier - for security purposes
CHNAME_SEC_SEGMENT_ID	NUMBER	(15)		Card holder name segment identifier - for security purposes

Query Text

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


SELECT TRXNMID
,      TERMINALID
,      TRACENUMBER
,      AUTHCODE
,      REFERENCECODE
,      OPERATIONCODE
,      INSTRNAME
,      AUTHTYPE
,      AVSCODE
,      ACQUIRER
,      AUXMSG
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PONUMBER
,      TAXAMOUNT
,      SHIPFROMZIP
,      SHIPTOZIP
,      SECURITY_GROUP_ID
,      VOICEAUTHFLAG
,      CVV2RESULT
,      PROC_TRACENUMBER
,      DATE_OF_VOICE_AUTHORIZATION
,      POS_READER_CAPABILITY_CODE
,      POS_ENTRY_METHOD_CODE
,      POS_ID_METHOD_CODE
,      POS_AUTH_SOURCE_CODE
,      READER_DATA
,      POS_TRXN_FLAG
,      INSTR_EXPIRYDATE
,      CARD_SUBTYPE_CODE
,      CARD_DATA_LEVEL
,      INSTR_OWNER_NAME
,      INSTR_OWNER_ADDRESS_LINE1
,      INSTR_OWNER_ADDRESS_LINE2
,      INSTR_OWNER_ADDRESS_LINE3
,      INSTR_OWNER_CITY
,      INSTR_OWNER_STATE_PROVINCE
,      INSTR_OWNER_COUNTRY
,      INSTR_OWNER_POSTALCODE
,      INSTR_OWNER_PHONE
,      INSTR_OWNER_EMAIL
,      DEBIT_NETWORK_CODE
,      SURCHARGE_AMOUNT
,      ENCRYPTED
,      EXPIRY_SEC_SEGMENT_ID
,      CHNAME_SEC_SEGMENT_ID
FROM IBY.IBY_TRXN_CORE;

Dependencies

[top of page]

IBY.IBY_TRXN_CORE does not reference any database object

IBY.IBY_TRXN_CORE is referenced by following:

IBY: IBY_TRXN_CORE#