1. Tables and Views
  2. PSC_BNP_CSH_DRW_PAY_HIST

PSC_BNP_CSH_DRW_PAY_HIST

This table contains cash drawer payment history information. It is used to capture the history for a cash drawer transaction.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_BNP_CSH_DRW_PAY_HIST_PK

AGENCY_ID, RECEIPT_NUMBER, RECEIPT_LINE_NUMBER

Columns

Name Datatype Length Precision Not-null Comments Status
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row.
RECEIPT_NUMBER VARCHAR2 50 Yes Receipt Number associated to the Payment. Active
RECEIPT_LINE_NUMBER NUMBER 3 Yes Receipt Line Number associated to the Payment. Active
RECEIPT_STATUS VARCHAR2 3 Yes Status of the Receipt associated to the Payment. Active
RECEIPT_DATE DATE Yes Creation Date of the Receipt associated to the Payment. Active
DESCRIPTION VARCHAR2 100 Yes Description of the Receipt Line Number associated to the Payment.
DRAWER_ID VARCHAR2 30 Yes A unique identifier for the cash drawer used by the Payment. Active
PARTY_ID NUMBER 18 Yes A unique identifier for the Customer associated to this payment. Active
PROFILE_ID NUMBER 18 A unique identifier for the Profile.
CURRENCY_CODE VARCHAR2 3 Yes Currency Code used for Payment. Active
PAYMENT_AMOUNT NUMBER Yes Payment amount owned by the customer. Active
LINE_AMOUNT NUMBER Yes Payment line amount owned by the customer. Active
TOTAL_TEND_AMOUNT NUMBER Yes Total paid amount expressed in CURRENCY_CODE. Active
CHANGE_AMOUNT NUMBER Yes Change amount given expressed in CURRENCY_CODE. Active
PAYMENT_METHOD_CODE VARCHAR2 30 Yes Method of Payment used in this payment transaction. The Payment methods Cash, Personal Check, Cashier???s Check, Email Order are collectively referred to as Cash Drawer. The Cash Drawer Payment Methods List is stored in the Cash Drawer History table. Active
PAYMENT_REFERENCE_ID VARCHAR2 50 Yes Reference value created by the Payment Engine and sent as a pass thru data to the Payment Processor, Trust Account and Cash Drawer. Active
CHECK_NUMBER VARCHAR2 10 Check Number used by this transaction. Active
PRIMARY_ID VARCHAR2 3 Attribute identifying the Primary Verification ID for check payment. Active
SECONDARY_ID VARCHAR2 3 Attribute identifying the Secondary Verification ID for check payment. Active
COMMENTS VARCHAR2 240 Comment area to store more information about the transaction.
RECONCILE_ID NUMBER 18 Reconcile Id used for Payment Reconciliation. Active
CHECK_DATE DATE Date of the Check used by this transaction. Active
PAYER_NAME VARCHAR2 100 Name of the Payer of this transaction. Active
PAYER_ADDRESS VARCHAR2 240 Address of the Payer of this transaction. Active
CHECKOUT_ID VARCHAR2 50 Check out ID used during checking out. Active
SESSION_ID VARCHAR2 50 Yes Attribute identifying the session associated with the row. Active
CASHIER_ID VARCHAR2 50 Yes Attribute identifying the Cashier ID associated with the row.
DEPOSIT_SLIP_NUMBER VARCHAR2 50 Deposit Slip number where this transaction was deposited.
ACTUAL_AMOUNT NUMBER Actual amount for check when the payment is reconciled.
AMOUNT_SHORTAGE NUMBER Personal check or Cashier check shortage amount.
AMOUNT_OVERAGE NUMBER Personal check or Cashier check overage amount.
BUSINESS_ENTITY_PARTY_ID NUMBER 18 Party id of the business entity associated with this transaction
BUSINESS_ENTITY_PROFILE_ID NUMBER 18 Profile id of the business entity associated with this transaction.
MIGRATED_DATA_FLAG VARCHAR2 1 Yes Attribute identifying data migrated from legacy system
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 Account event status for the payment
REVERSAL_FLAG VARCHAR2 1 Yes Reversal flag to indicate payment reversal.
PAYMENT_STATUS VARCHAR2 30 Yes Indicates payment reversal status.
REVERSAL_REASON_CD VARCHAR2 30 Indicates reversal reason code.
OA_APPLIED_FLAG VARCHAR2 1 Yes Payment on account credit is applied
OA_AVAILABLE_AMOUNT NUMBER Amount available to apply payment on account credit
OA_APPLIED_AMOUNT NUMBER Amount of credit applied to the payment
REVERSAL_TRAN_TYPE VARCHAR2 30 Yes Indicates type of reversal transaction
UNAPPLIED_FLAG VARCHAR2 1 Yes Identifies unapplied payment record
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_CSH_DRW_PAY_HIST psc_bnp_cash_drawer_b AGENCY_ID, DRAWER_ID
PSC_BNP_CSH_DRW_PAY_HIST psc_bnp_csh_drw_sess SESSION_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_BNP_CSH_DRW_PAY_HIST_N1 Non Unique Default AGENCY_ID, DRAWER_ID
PSC_BNP_CSH_DRW_PAY_HIST_N2 Non Unique Default SESSION_ID Active
PSC_BNP_CSH_DRW_PAY_HIST_PK Unique Default AGENCY_ID, RECEIPT_NUMBER, RECEIPT_LINE_NUMBER Active