1. Tables and Views
  2. PSC_BNP_PAYMENT_HIST_LIN

PSC_BNP_PAYMENT_HIST_LIN

This table contains line historical item data for all payments.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_BNP_PAYMENT_HIST_LIN_PK

PAYMENT_HISTORY_KEY, ITEM_REC_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
PAYMENT_HISTORY_KEY NUMBER 18 Yes A Unique identifier for the transaction. It uses auto-sequencing. 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.
ITEM_REC_KEY NUMBER 8 Yes Key for the Item. It uses auto-sequencing for unique identification. Active
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row.
ITEM_NAME VARCHAR2 30 Item name provided by the requesting application. Active
ITEM_DESCRIPTION VARCHAR2 100 Item description provided by the requesting application.
ITEM_LINE NUMBER 8 Yes Item line provided by the requesting application. When none is provided, it is set to zero. Active
ITEM_UNIT_PRICE NUMBER Yes Base price of the item being paid by the payment transaction. Active
ITEM_CURRENCY VARCHAR2 3 Yes Currency code for both the unit price and tax amount. Active
ITEM_REFERENCE VARCHAR2 50 Custom reference value provided by the requesting application. Active
APPLICATION_REFERENCE_ID1 VARCHAR2 50 Attribute identifying the first reference information/key from the source application.
APPLICATION_REFERENCE_ID2 VARCHAR2 50 Attribute identifying the second reference information/key from the source application.
CLASSIFICATION VARCHAR2 3 Source application that generated the fee.
ITEM_TAX_AMOUNT NUMBER Tax amount involve in the transaction. Active
RECORD_ID VARCHAR2 50 Source application's record id identifier.
RECORD_TYPE_ID VARCHAR2 30 Source application's record type identifier.
MIGRATED_DATA_FLAG VARCHAR2 3 Yes Attribute identifying data migrated from legacy system
BILL_AGENCY_ID NUMBER 18 Column contains Agency id for pscr invoice.
INVOICE VARCHAR2 50 Column contains public sector invoice identifier.
INVOICE_DATE DATE Column contains invoice date.
INVOICE_ID NUMBER 18 Invoice identifier.
INVOICE_LINE NUMBER 18 Column contains invoice line number.
INVOICE_SYSTEM_CD VARCHAR2 30 Invoice system code.
BILL_TYPE VARCHAR2 15 Column contains bill type for invoice.
FAR_CASH_RECEIPT_ID NUMBER 18 Column contains cash receipt id from oracle receivables system.
FAR_RECEIPT_STATUS VARCHAR2 30 Column contains status that drives the creation of receipts in oracle receivables.
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
DEPARTMENT_ID VARCHAR2 30 Indicates department associated to the fee item.
FEE_ITEM_ID VARCHAR2 30 Indicates fee item identifier for the fee item.
CASE_ID VARCHAR2 50 Indicates case identifier for a code enforcement fee.
FEE_REFERENCE_ID VARCHAR2 50 Indicates the reference identifier for the fee item.
FEE_REFERENCE_PUID VARCHAR2 480 Yes Indicates the PUID reference identifier for the fee item.
PAYMENT_LINE_PUID VARCHAR2 480 Yes Indicates the PUID reference identifier for data migration.
ADDRESS1 VARCHAR2 240 Attribute used for applicant or customer address line 1 Active
ADDRESS2 VARCHAR2 240 Attribute used for applicant or customer address line 2 Active
ADDRESS3 VARCHAR2 240 Attribute used for applicant or customer address line 3 Active
ADDRESS4 VARCHAR2 240 Attribute used for applicant or customer address line 4 Active
CITY VARCHAR2 60 Attribute used for applicant or customer city Active
COUNTRY VARCHAR2 60 Attribute used for applicant or customer country Active
COUNTY VARCHAR2 60 Attribute used for applicant or customer county Active
POSTAL_CODE VARCHAR2 60 Attribute used for applicant or customer postal code Active
POSTAL_PLUS4_CODE VARCHAR2 10 Attribute used for applicant or customer postal plus4 code Active
PROVINCE VARCHAR2 60 Attribute used for applicant or customer province Active
STATE VARCHAR2 60 Attribute used for applicant or customer state Active
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
REVERSAL_FLAG VARCHAR2 1 Yes Reversal flag to indicate payment reversal.
REVERSAL_TRAN_TYPE VARCHAR2 30 Yes Indicates type of reversal transaction
UNAPPLIED_FLAG VARCHAR2 1 Yes Identifies unapplied payment record
BUSINESS_ENTITY_ID VARCHAR2 50 Business entity identifier for business license payment.
BUS_PARTY_ID NUMBER 18 Business party identifier for business license payment.
BUS_BUSINESS_NAME VARCHAR2 100 Business name for business license payment.
BUS_BUSINESS_LEGAL_NAME VARCHAR2 240 Business legal name for business license payment.
BUS_DBA_BUSINESS_NAME VARCHAR2 100 Dba business name for business license payment.
ORGANIZATION_NAME VARCHAR2 360 Organization name for business license payment.
BUSINESS_LOCATION_ID VARCHAR2 50 Business location identifier for business license payment.
BUSINESS_LOCATION_PARTY_ID NUMBER 18 Business location party identifier for business license payment.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_BNP_PAYMENT_HIST_LIN psc_bnp_payment_hist_hdr PAYMENT_HISTORY_KEY
PSC_BNP_PAYMENT_HIST_LIN psc_bnp_bill_header BILL_AGENCY_ID, INVOICE, BILL_TYPE

Indexes

Index Uniqueness Tablespace Columns Status
PSC_BNP_PAYMENT_HIST_LIN_N1 Non Unique Default PAYMENT_REFERENCE_ID
PSC_BNP_PAYMENT_HIST_LIN_PK Unique Default PAYMENT_HISTORY_KEY, ITEM_REC_KEY Active
PSC_BNP_PAYMENT_HIST_LIN_U1 Unique Default PAYMENT_LINE_PUID