IBY_TRXN_CORE
IBY_BEPKEYS stores information about the payment systems.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_TRXN_CORE_PK |
TRXNMID |
Columns
| Name | Datatype | Length | Precision | Not-null | 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 identifiers and there is a batch open for each terminal identifier. The merchant could perform operations on those batches independently. | ||
| TRACENUMBER | VARCHAR2 | 80 | Unique transaction identifier for 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 authorization, 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 payment system. | ||
| AUXMSG | VARCHAR2 | 255 | Auxilliary message that may be returned by the payment system or processing system. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | |||
| INSTR_SECURITY_VAL | VARCHAR2 | 10 | Security value | ||
| 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 information | ||
| INSTR_OWNER_ADDRESS_LINE2 | VARCHAR2 | 240 | Card holder billing address information | ||
| INSTR_OWNER_ADDRESS_LINE3 | VARCHAR2 | 240 | Card holder billing address information | ||
| INSTR_OWNER_CITY | VARCHAR2 | 80 | Card holder billing address information | ||
| INSTR_OWNER_STATE_PROVINCE | VARCHAR2 | 80 | Card holder billing address information | ||
| INSTR_OWNER_COUNTRY | VARCHAR2 | 80 | Card holder billing address information | ||
| INSTR_OWNER_POSTALCODE | VARCHAR2 | 80 | Card holder billing address information | ||
| INSTR_OWNER_PHONE | VARCHAR2 | 80 | Card holder billing address information | ||
| INSTR_OWNER_EMAIL | VARCHAR2 | 80 | Card holder billing address information | ||
| DEBIT_NETWORK_CODE | VARCHAR2 | 80 | Debit card network code | ||
| SURCHARGE_AMOUNT | NUMBER | Debit card surcharge amount | |||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise Id to support multi-tenancy |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_TRXN_CORE | iby_trxn_summaries_all | TRXNMID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_TRXN_CORE_N1 | Non Unique | Default | AUTHCODE |
| IBY_TRXN_CORE_N2 | Non Unique | Default | TRACENUMBER |
| IBY_TRXN_CORE_U1 | Unique | Default | TRXNMID |