[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 independently. | |
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) | Ppayment 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 - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. |
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 the LOGIN_ID column of the FND_LOGINS table. | |
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) | Indicate whether voice authorization obtained. | |
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 3 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 | (1) | 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 |
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;
IBY.IBY_TRXN_CORE does not reference any database object
IBY.IBY_TRXN_CORE is referenced by following:
|
|
|