[Home] [Help] [Dependency Information]
Object Name: | IBY_TRXN_CORE# |
---|---|
Object Type: | VIEW |
Owner: | IBY |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|