1. Tables and Views for Sales and Fusion Service
  2. OSS_CREDIT_CARDS

OSS_CREDIT_CARDS

Credit Cards table stores the credit card information for the subscription.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

OSS_CREDIT_CARDS_PK

CREDIT_CARD_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CREDIT_CARD_ID NUMBER 18 Yes Primary Key. Active
CREDIT_CARD_PUID VARCHAR2 120 Yes PUID of the Credit Card.
SUBSCRIPTION_ID NUMBER 18 Subscription header identifier. Active
SUBSCRIPTION_PRODUCT_ID NUMBER 18 Subscription product line identifier. Active
INSTR_ASSIGNMENT_ID NUMBER 18 Instrument assignment identifier for subscription product payments through credit card. Active
TRXN_EXTENSION_ID NUMBER 18 Transaction extension identifier for subscription product payments through credit card. Active
PERCENTAGE NUMBER Percentage of the bill to be charged on credit card. Active
NOTES VARCHAR2 300 Credit card usage notes. Active
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
RENEWAL_CREDIT_CARD_FLAG VARCHAR2 1 Flag to identify renewal credit card record

Indexes

Index Uniqueness Tablespace Columns
OSS_CREDIT_CARDS_N1 Non Unique Default SUBSCRIPTION_ID
OSS_CREDIT_CARDS_N2 Non Unique Default SUBSCRIPTION_PRODUCT_ID
OSS_CREDIT_CARDS_U1 Unique FUSION_TS_TX_IDX CREDIT_CARD_ID
OSS_CREDIT_CARDS_U2 Unique FUSION_TS_TX_IDX CREDIT_CARD_PUID