IBY_PAYMENT_TRXN_RESPONSES
This table stores information about bank or payment integrator transaction details, such as payment acknowledgments, responses, authorizations, and settlement details.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAYMENT_TRXN_RESPONSES_PK |
PAYMENT_TRXN_RESPONSE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_TRXN_RESPONSE_ID | NUMBER | 18 | Yes | Identifier for the payment transaction response. | |
| SOURCE_TRXN_ID | NUMBER | 18 | Yes | Reference to the payment transaction ID. | |
| SOURCE_TABLE_NAME | VARCHAR2 | 30 | Yes | Identifier of the source entity. Examples include IBY_PAYMENTS_ALL, IBY_PAY_INSTRUCTIONS_ALL, IBY_BATCHES_ALL and IBY_TRXN_SUMMARIES_ALL. | |
| PAYMENT_FLOW | VARCHAR2 | 30 | Yes | Specifies funds capture or disbursement flow. Values taken from lookup: IBY_PAYMENT_FLOW | |
| TRXN_SOURCE_CODE | VARCHAR2 | 30 | Yes | Feeder from which a record is created. Ex., Acknowledgement, Response, Reconciliation, Authorization. | |
| INBOUND_FILE_ID | NUMBER | 18 | Identifier of the inbound payment file. | ||
| FORMAT_CODE | VARCHAR2 | 30 | Code identifying the inbound file format. | ||
| PAYMENT_SYSTEM_ID | NUMBER | 18 | Payment system that the inbound file is pulled from. | ||
| PAYMENT_SYSTEM_ACCOUNT_ID | NUMBER | 18 | Payment system account identifier. | ||
| PROVIDER_RESPONSE_STATUS_CODE | VARCHAR2 | 30 | Status returned by the bank or payment service provider. | ||
| PROVIDER_RESPONSE_CODE | VARCHAR2 | 30 | Response code from bank or payment service provider. | ||
| PROVIDER_RESPONSE_MSG | VARCHAR2 | 4000 | Error message from bank or payment service provider. | ||
| PROVIDER_TRXN_RESPONSE_ID | VARCHAR2 | 60 | Response identifier generated by bank or payment service provider.Response identifier generated by bank or payment service provider. | ||
| ACKNOWLEDGEMENT_DATE | DATE | Date when acknowledgment was processed. | |||
| ISSUER_AUTHORIZATION_REFERENCE | VARCHAR2 | 80 | Alphanumeric reference assigned by the issuing bank for an authorized card transaction. | ||
| ACQUIRER_TRANSACTION_REFERENCE | VARCHAR2 | 80 | Payment reference number assigned to a transaction by the acquiring bank. It helps in tracking the payment status through its life cycle. | ||
| ISSUER_PROCESSING_TIMESTAMP | TIMESTAMP | Timestamp when a payment was authorized, declined, or cleared by the processor. | |||
| SETTLEMENT_CURRENCY | VARCHAR2 | 15 | Currency in which payment is settled at bank or payment system. | ||
| SETTLEMENT_AMOUNT | NUMBER | Payment amount settled against payment at bank or payment system. | |||
| SETTLEMENT_DATE | DATE | Date when the payment is settled at bank or payment system. | |||
| SETTLEMENT_EXCHANGE_RATE | NUMBER | 18 | Factor used to convert an amount from payment to settled currency. | ||
| SETTLEMENT_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type for the payment settlement at bank or payment system. | ||
| SETTLEMENT_EXCHANGE_RATE_DATE | DATE | Date when the settlement rate is quoted. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| PROVIDER_ADDL_ATTRIBUTE1 | VARCHAR2 | 2000 | Additional alphanumeric field reserved for future internal use. | ||
| PROVIDER_ADDL_ATTRIBUTE2 | VARCHAR2 | 360 | Additional alphanumeric field reserved for future internal use. | ||
| PROVIDER_ADDL_ATTRIBUTE3 | VARCHAR2 | 360 | Additional alphanumeric field reserved for future internal use. | ||
| PROVIDER_ADDL_ATTRIBUTE4 | VARCHAR2 | 360 | Additional alphanumeric field reserved for future internal use. | ||
| PROVIDER_ADDL_ATTRIBUTE5 | VARCHAR2 | 360 | Additional alphanumeric field reserved for future internal use. | ||
| PROVIDER_ADDL_ATTRIBUTE6 | NUMBER | Additional number field reserved for future internal use. | |||
| PROVIDER_ADDL_ATTRIBUTE7 | NUMBER | Additional number field reserved for future internal use. | |||
| PROVIDER_ADDL_ATTRIBUTE8 | NUMBER | Additional number field reserved for future internal use. | |||
| PROVIDER_ADDL_ATTRIBUTE9 | DATE | Additional date field reserved for future internal use. | |||
| PROVIDER_ADDL_ATTRIBUTE10 | DATE | Additional date field reserved for future internal use. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_PAYMENT_TRXN_RESPONSES | IBY_BEPINFO | PAYMENT_SYSTEM_ID |
| IBY_PAYMENT_TRXN_RESPONSES | IBY_BEPKEYS | PAYMENT_SYSTEM_ACCOUNT_ID |
| IBY_PAYMENT_TRXN_RESPONSES | IBY_FORMATS_B | FORMAT_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAYMENT_TRXN_RESPONSES_N1 | Non Unique | IBY_PAYMENT_TRXN_RESPONSES_N1 | SOURCE_TRXN_ID |
| IBY_PAYMENT_TRXN_RESPONSES_U1 | Unique | IBY_PAYMENT_TRXN_RESPONSES_U1 | PAYMENT_TRXN_RESPONSE_ID |