1. Tables and Views
  2. PSC_BNP_REFUND_HIST_HDR

PSC_BNP_REFUND_HIST_HDR

This table contains historical payment header data for all payment methods

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_BNP_REFUND_HIST_HDR_PK

REFUND_HISTORY_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
REFUND_HISTORY_KEY NUMBER 18 Yes A unique identifier for the transaction. It uses auto-sequencing. Active
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row.
REFUND_DATE DATE Yes Date in which the refund was requested. Active
REFUND_REFERENCE_ID VARCHAR2 50 Yes Combination value consisting of ‘RE-‘prefix + value using PSC GUID function. This value is passed to calling app and displayed to user. Active
REFUND_TYPE VARCHAR2 10 Yes Either Chargeback (referenced transaction to same payment method) or Refund (referenced transaction but using different payment method).
REFUND_METHOD_CODE VARCHAR2 30 Yes Refund method code. Defaults to payment method code used in original payment transaction. Active
REFUND_CURRENCY VARCHAR2 3 Yes Typically same currency used for the payment. Active
REFUND_AMOUNT NUMBER Yes Total refund amount processed by the payment gateway or trust account system. Active
REFUND_REASON_CODE VARCHAR2 20 Reason code for refund passed by the fee source application.
PAYMENT_REFERENCE_ID VARCHAR2 50 Yes Payment reference of the original payment for which the refund is requested from.
PAYMENT_AMOUNT NUMBER Total payment amount of the original payment.
PAYMENT_CURRENCY VARCHAR2 3 Currency Code used for the original payment transaction.
PAYMENT_METHOD_CODE VARCHAR2 30 Payment method code used for the original payment transaction.
PAYMENT_DATE DATE Payment date in which the original payment transaction occurred.
PARTY_ID NUMBER 18 Yes Party id from the original payment transaction or a new party if allowed by the agency.
PROFILE_ID NUMBER 18 Yes Profile id from the original payment transaction or a new profile id if allowed by the agency.
EMAIL_ID VARCHAR2 100 Email id used in the original payment transaction or new email id if allowed by the agency. Active
REFUND_TRANSACTION_ID VARCHAR2 50 Transaction ID received from the payment gateway, trust account system or accounts payable system. Active
REFUND_STATUS VARCHAR2 10 Yes Refund request status set by PSC Payment Engine. Active
REFUND_REQUEST_CODE VARCHAR2 50 Refund code or reference value returned by the payment gateway. Active
REFUND_FAILURE_CODE VARCHAR2 100 Failure code returned by the payment gateway. E.g. EXPIRED_CREDIT_CARD
REFUND_DTTM TIMESTAMP Date and time when the refund was processed Active
REFUND_REFERENCE1 VARCHAR2 50 Pass thru reference data from calling app. Should not contain PII information. Active
REFUND_REFERENCE2 VARCHAR2 50 Additional pass thru reference data from calling app. Should not contain PII information. Active
RESPONSE_MESSAGE1 VARCHAR2 100 Response message returned by the payment gateway.
RESPONSE_MESSAGE2 VARCHAR2 100 Response message returned by the payment gateway.
RESPONSE_MESSAGE3 VARCHAR2 100 Response message returned by the payment gateway.
BUSINESS_ENTITY_ID VARCHAR2 50 Business entity identifier associated with this transaction.
BUSINESS_ENTITY_PARTY_ID NUMBER 18 Party id of the business entity associated with this transaction.
BUSINESS_PROFILE_ID NUMBER 18 Profile id of the business entity associated with this transaction.
FAR_RECEIPT_STATUS VARCHAR2 30 Column contains status that drives the creation of receipts in oracle receivables.
ACCOUNTING_DATE DATE Accounting date for the payment transaction
EVENT_ID NUMBER 18 Event id for the payment transaction
ACCTG_EVENT_STATUS VARCHAR2 30 Yes Accounting event status for the payment
TRUST_ACCOUNT_NUMBER VARCHAR2 30 Trust Account Number associated with the payment
ACCOUNT_TYPE VARCHAR2 30 Account Type associated with the payment
ACCOUNT_PURPOSE VARCHAR2 30 Account Purpose associated with the payment
REFUND_TRANSACTION_TYPE VARCHAR2 30 Yes Indicates type of refund transaction
PUBLISHED_STATUS VARCHAR2 30 Yes Indicates the publish status of the transaction.
RECON_HISTORY_KEY NUMBER 18 Unique identifier for each bank reconciliation transaction record.
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. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Foreign Keys

Table Foreign Table Foreign Key Column
psc_bnp_refund_hist_lin psc_bnp_refund_hist_hdr REFUND_HISTORY_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_BNP_REFUND_HIST_HDR_N1 Non Unique Default PAYMENT_REFERENCE_ID
PSC_BNP_REFUND_HIST_HDR_PK Unique Default REFUND_HISTORY_KEY