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: IBY.IBY_TRXN_CORE#

Object Details

Object Name:	IBY_TRXN_CORE#
Object Type:	VIEW
Owner:	IBY
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRXNMID	NUMBER		Yes
TERMINALID	VARCHAR2	(80)
TRACENUMBER	VARCHAR2	(80)
AUTHCODE	VARCHAR2	(80)
REFERENCECODE	VARCHAR2	(80)
OPERATIONCODE	VARCHAR2	(80)
INSTRNAME	VARCHAR2	(80)
AUTHTYPE	VARCHAR2	(20)
AVSCODE	VARCHAR2	(80)
ACQUIRER	VARCHAR2	(80)
AUXMSG	VARCHAR2	(255)
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
PONUMBER	VARCHAR2	(80)
TAXAMOUNT	NUMBER
SHIPFROMZIP	VARCHAR2	(80)
SHIPTOZIP	VARCHAR2	(80)
SECURITY_GROUP_ID	NUMBER
VOICEAUTHFLAG	VARCHAR2	(1)
CVV2RESULT	VARCHAR2	(5)
PROC_TRACENUMBER	VARCHAR2	(80)
DATE_OF_VOICE_AUTHORIZATION	DATE
POS_READER_CAPABILITY_CODE	VARCHAR2	(30)
POS_ENTRY_METHOD_CODE	VARCHAR2	(30)
POS_ID_METHOD_CODE	VARCHAR2	(30)
POS_AUTH_SOURCE_CODE	VARCHAR2	(30)
READER_DATA	VARCHAR2	(255)
POS_TRXN_FLAG	VARCHAR2	(1)
INSTR_EXPIRYDATE	DATE
CARD_SUBTYPE_CODE	VARCHAR2	(30)
CARD_DATA_LEVEL	VARCHAR2	(10)
INSTR_OWNER_NAME	VARCHAR2	(80)
INSTR_OWNER_ADDRESS_LINE1	VARCHAR2	(240)
INSTR_OWNER_ADDRESS_LINE2	VARCHAR2	(240)
INSTR_OWNER_ADDRESS_LINE3	VARCHAR2	(240)
INSTR_OWNER_CITY	VARCHAR2	(80)
INSTR_OWNER_STATE_PROVINCE	VARCHAR2	(80)
INSTR_OWNER_COUNTRY	VARCHAR2	(80)
INSTR_OWNER_POSTALCODE	VARCHAR2	(80)
INSTR_OWNER_PHONE	VARCHAR2	(80)
INSTR_OWNER_EMAIL	VARCHAR2	(80)
DEBIT_NETWORK_CODE	VARCHAR2	(80)
SURCHARGE_AMOUNT	NUMBER
ENCRYPTED	VARCHAR2	(240)	Yes
EXPIRY_SEC_SEGMENT_ID	NUMBER	(15)
CHNAME_SEC_SEGMENT_ID	NUMBER	(15)

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# references the following:

IBY: IBY_TRXN_CORE

IBY.IBY_TRXN_CORE# is referenced by following:

APPS: IBY_TRXN_CORE