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]

VIEW: APPS.IBY_EXTN_INSTR_DETAILS_V

Object Details

Object Name:	IBY_EXTN_INSTR_DETAILS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id
TRXN_EXTENSION_ID	NUMBER	(15)	Yes	Transaction Extension Identifier
PAYMENT_CHANNEL_CODE	VARCHAR2	(30)	Yes	Payment method identifier
PAYMENT_CHANNEL_NAME	VARCHAR2	(100)	Yes	Payment method name
INSTR_ASSIGNMENT_ID	NUMBER	(15)		Payment Instrument assignment identifier
INSTRUMENT_TYPE	VARCHAR2	(30)		CREDITCARD or BANKACCOUNT
INSTRUMENT_ID	NUMBER	(15)		Instrument ID
CURRENCY_CODE	VARCHAR2	(15)		null
CARD_NUMBER	VARCHAR2	(30)		Masked credit card number
CARD_NUMBER_HASH1	VARCHAR2	(64)		Hash value 1 of the credit card number
CARD_NUMBER_HASH2	VARCHAR2	(64)		Hash value 2 of the credit card number
CARD_EXPIRYDATE	VARCHAR2	(9)		Obsoleted as part of PA-DSS uptake
MASKED_CARD_EXPIRYDATE	VARCHAR2	(5)		Return 'XX/XX' when the record is encrypted, else return the expiry date in 'mm/yy' format
CARD_EXPIRED_FLAG	VARCHAR2	(1)		Marks if a card has already expired
CARD_ISSUER_CODE	VARCHAR2	(30)		The issuer of the card
CARD_ISSUER_NAME	VARCHAR2	(100)		Credit card brand name
PURCHASECARD_SUBTYPE	VARCHAR2	(30)		IBY_PURCHASECARD_SUBTYPE include B (Business Card), C (Corporate Card), P (Purchase Card) and U (Unknown)
CARD_HOLDER_NAME	VARCHAR2	(360)		Name of the card holder as mentioned on the card or party name
ENCRYPTED	VARCHAR2	(1)		Flag indicating whether the credit card number is encrypted
CARD_EXPIRATION_STATUS	VARCHAR2	(80)		Expired/Unexpired Status. Meant for display purpose
ACCOUNT_NUMBER	VARCHAR2	(100)		null
BANK_NUMBER	VARCHAR2	(30)		null
INSTRUMENT_SECURITY_CODE	VARCHAR2	(5)		Instrument security code
VOICE_AUTHORIZATION_FLAG	VARCHAR2	(1)		Y or N flag indicating this transaction has a voice authorization
VOICE_AUTHORIZATION_DATE	DATE			Voice authorization date
VOICE_AUTHORIZATION_CODE	VARCHAR2	(100)		Voice authorization code
ORIGIN_APPLICATION_ID	NUMBER		Yes	Originating application id
ORDER_ID	VARCHAR2	(75)		Transaction order identifier
PO_NUMBER	VARCHAR2	(100)		Purchase order number
PO_LINE_NUMBER	VARCHAR2	(100)		Purchase order line number
TRXN_REF_NUMBER1	VARCHAR2	(30)		Transaction reference number 1
TRXN_REF_NUMBER2	VARCHAR2	(30)		Transaction reference number 2
PAYMENT_SYSTEM_ORDER_NUMBER	VARCHAR2	(80)		Payment System Order Number for the transaction
ADDITIONAL_INFO	VARCHAR2	(255)		Free-text field for additional information
BANK_NAME	VARCHAR2	(360)		null
BANK_BRANCH_NAME	VARCHAR2	(360)		null

Query Text

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


SELECT ROW_ID
,      TRXN_EXTENSION_ID
,      PAYMENT_CHANNEL_CODE
,      PAYMENT_CHANNEL_NAME
,      INSTR_ASSIGNMENT_ID
,      INSTRUMENT_TYPE
,      INSTRUMENT_ID
,      CURRENCY_CODE
,      CARD_NUMBER
,      CARD_NUMBER_HASH1
,      CARD_NUMBER_HASH2
,      CARD_EXPIRYDATE
,      MASKED_CARD_EXPIRYDATE
,      CARD_EXPIRED_FLAG
,      CARD_ISSUER_CODE
,      CARD_ISSUER_NAME
,      PURCHASECARD_SUBTYPE
,      CARD_HOLDER_NAME
,      ENCRYPTED
,      CARD_EXPIRATION_STATUS
,      ACCOUNT_NUMBER
,      BANK_NUMBER
,      INSTRUMENT_SECURITY_CODE
,      VOICE_AUTHORIZATION_FLAG
,      VOICE_AUTHORIZATION_DATE
,      VOICE_AUTHORIZATION_CODE
,      ORIGIN_APPLICATION_ID
,      ORDER_ID
,      PO_NUMBER
,      PO_LINE_NUMBER
,      TRXN_REF_NUMBER1
,      TRXN_REF_NUMBER2
,      PAYMENT_SYSTEM_ORDER_NUMBER
,      ADDITIONAL_INFO
,      BANK_NAME
,      BANK_BRANCH_NAME
FROM APPS.IBY_EXTN_INSTR_DETAILS_V;