1. Tables and Views
  2. PSC_BNP_CHECKOUT_LIN

PSC_BNP_CHECKOUT_LIN

This table contains staging line used to pass payload data between Pay Cart, Checkout and Payments

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_BNP_CHECKOUT_LIN_PK

CHECKOUT_ID, CHECKOUT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CHECKOUT_ID NUMBER 18 Yes Distinct value generated using the Fusion unique ID API Active
CHECKOUT_LINE_ID NUMBER 18 Yes Unique sequence number for the checkout row generated using FA Unique ID.
APPLICATION_REFERENCE_ID VARCHAR2 50 Yes Key identifier as the header passed by the consuming application. For example, CART_ID value from Pay Cart. Active
APPLICATION_REFERENCE_ID2 VARCHAR2 50 Additional key identifier passed by the consuming application
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row. Active
ADAPTER_ID VARCHAR2 100 The payment adapter in relation to the agency and payment method
ITEM_ID VARCHAR2 30 Yes Unique identifier of the item to be paid Active
ITEM_DESCRIPTION VARCHAR2 50 Relevant details in relation to the item ID Active
DEPARTMENT VARCHAR2 30 Yes A division within the agency devoted to a specific function Active
ITEM_QUANTITY NUMBER Yes Quantity of line items. This value cannot be negative. Active
ITEM_UNIT_PRICE NUMBER Yes Price per unit of the line item. This value multiplied by the item quantity value equates to the total line item amount. Active
CURRENCY_CODE VARCHAR2 3 Yes Currency code in relation to the item unit price and tax amount Active
ITEM_TAX_AMOUNT NUMBER Tax amount to apply to the line item Active
PAYMENT_METHOD_CODE VARCHAR2 30 Type of payment selected during checkout Active
PAYMENT_REFERENCE_ID VARCHAR2 50 Global unique ID comprised of a 4-character prefix and random digits Active
PAYMENT_HISTORY_KEY NUMBER 18 Distinct value generated using the Fusion unique ID API Active
PAYMENT_DATE DATE Date when checkout was initiated Active
PAYMENT_STATUS VARCHAR2 1 Status of the payment request. Valid values are paid, cancelled or error. Active
CLASSIFICATION VARCHAR2 3 Source application that generated the fee.
BILL_AGENCY_ID NUMBER 18 Column contains agency id of public sector Invoice.
INVOICE VARCHAR2 50 Column conatins invoice detail.
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 stores bill type for invoices
RECORD_TYPE_ID VARCHAR2 30 Indicates the issue subtype identifier/record type identifier.
FEE_ITEM_ID VARCHAR2 30 Indicates fee item identifier for a fee record.
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.
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 20 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
RECORD_ID VARCHAR2 50 Record id.
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.
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_CHECKOUT_LIN psc_bnp_checkout_hdr CHECKOUT_ID
PSC_BNP_CHECKOUT_LIN psc_bnp_bill_header BILL_AGENCY_ID, INVOICE, BILL_TYPE

Indexes

Index Uniqueness Tablespace Columns
PSC_BNP_CHECKOUT_LIN_PK Unique Default CHECKOUT_ID, CHECKOUT_LINE_ID