1. Tables and Views
  2. PSC_BNP_CHECKOUT_HDR

PSC_BNP_CHECKOUT_HDR

This table contains staging header 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_HDR_PK

CHECKOUT_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
APPLICATION_REFERENCE_ID VARCHAR2 50 Yes Key information for the header. Defaults to CART_ID value from LNP Active
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row Active
CHECKOUT_STATUS VARCHAR2 1 Current state of the checkout transaction. Valid values are paid, cancelled or error. Active
CHECKOUT_MESSAGE VARCHAR2 255 Additional information regarding the state of the checkout transaction Active
RETURN_URL1 VARCHAR2 255 URL provided by the consuming application. User redirected to this URL after payment is complete. Active
CANCEL_URL1 VARCHAR2 255 URL provided by the consuming application. User redirected to this URL when payment is cancelled. Active
CALLBACK_URL VARCHAR2 255 Callback URL to post payload response data to consuming application
RETURN_URL2 VARCHAR2 255 Oracle internal use only Active
CANCEL_URL2 VARCHAR2 255 Oracle internal use only Active
PARTY_ID NUMBER 18 Attribute identifying the party id associated with this transaction.
PROFILE_ID NUMBER 18 Attribute identifying the profile id of the user associated with this transaction.
PAYER_FIRST_NAME VARCHAR2 150 First name of the person making the payment Active
PAYER_MIDDLE_NAME VARCHAR2 60 Middle name of the person making the payment Active
PAYER_LAST_NAME VARCHAR2 150 Last name of the person making the payment Active
PAYER_NAME_SUFFIX VARCHAR2 30 Additional information that indicates the payer's place in the family structure Active
PAYER_COUNTRY_CODE2 VARCHAR2 2 International two digit country code call prefix in relation to the payer phone number Active
PAYER_COUNTRY_CODE3 VARCHAR2 3 International three digit country code call prefix in relation to the payer phone number Active
PAYER_ADDRESS1 VARCHAR2 240 First line of the payer billing address and requires a valid street number and name Active
PAYER_ADDRESS2 VARCHAR2 240 Second line of the payer billing address such as apartment, suite, unit, building, floor or village information Active
PAYER_ADDRESS3 VARCHAR2 240 Third line of the payer billing address Active
PAYER_ADDRESS4 VARCHAR2 240 Fourth line of the payer billing address Active
PAYER_CITY VARCHAR2 60 City information in relation to the payer billing address Active
PAYER_POSTAL_CODE VARCHAR2 60 Postal code of the payer billing address. This could be a series of digits or letters or both. Active
PAYER_POSTAL_PLUS4 VARCHAR2 10 Additional digits used to identify a specific mail delivery route Active
PAYER_STATE VARCHAR2 60 State code of the payer billing address. In the U.S, this is the two character USPS state abbreviation for example, NY for New York. Active
PAYER_PROVINCE VARCHAR2 60 Region code for the payer billing address in non-US countries. In Canada, this is the two character province abbreviation by the Canada Post. Active
PAYER_COUNTY VARCHAR2 60 Couny of the payer billing address. This is a geographical subdivision within a state or region and encompasses multiple cities. Active
PAYER_EMAIL VARCHAR2 320 Email address of the person making the payment Active
PAYER_PHONE VARCHAR2 60 Phone number of the person making the payment Active
DESCRIPTION VARCHAR2 100 Additional information about the checkout transaction Active
AMOUNT NUMBER Yes Sum of all money required for payment Active
CURRENCY_CODE VARCHAR2 3 Yes Currency code in relation to the amount field Active
PAYMENT_TRACKING_DATA1 VARCHAR2 50 First checkout reference or tracking number passed by consuming application Active
PAYMENT_TRACKING_DATA2 VARCHAR2 50 Second checkout reference or tracking number passed by consuming application Active
BUSINESS_ENTITY_ID VARCHAR2 50 Business entity identifier for business license payment requests.
BUSINESS_ENTITY_PARTY_ID NUMBER 18 Party id of the business entity associated with this transaction.
BUSINESS_ENTITY_NAME VARCHAR2 100 Name of the business entity associated with this transaction.
BUSINESS_ENTITY_DBA_NAME VARCHAR2 100 Doing business as name of the business entity associated with this transaction.
BUSINESS_PROFILE_ID NUMBER 18 Profile id of the business entity associated with this transcation.
BUSINESS_LOCATION_ID VARCHAR2 50 Business location id of the business entity associated with this transaction.
BUSINESS_LOCATION_PARTY_ID NUMBER 18 Location party id of the business entity associated with this transaction.
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
RECONCILE_TYPE VARCHAR2 30 RECONCILE PAYMENT TYPE.
RECONCILE_STATUS VARCHAR2 30 RECONCILE PAYMENT STATUS.
RECONCILE_DATETIME TIMESTAMP RECONCILE PAYMENT DATE TIME.
AUTOPAY_METHOD VARCHAR2 30 Payment method associated with the autopayment request
ACTIVITY_TYPE VARCHAR2 30 Identifies the type of activity for which payment is recorded.
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.
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

Indexes

Index Uniqueness Tablespace Columns
PSC_BNP_CHECKOUT_HDR_PK Unique Default CHECKOUT_ID