CHARGEABLE_ITEM

Chargeable Item

Definition


The CHARGEABLE_ITEM table contains the chargeable items used when manually processing a chargeable item with the app Process a Chargeable Item in the Cockpit user interface.

Description


The CHARGEABLE_ITEM table contains the chargeable items used when manually processing a chargeable item with the app Process a Chargeable Item.

The chargeable item contains a list of charging properties.

Technical Data


Schema Version 2023.0.2
Tablespace COCKPIT_DATA
Partitioned No

Summary


The CHARGEABLE_ITEM table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
OID PK_CHARGEABLE_ITEM       

The unique identifier of the chargeable item. It is generated by the SAP CC Cockpit application.
CATALOG       CATALOG (NAME)
 

    The name of the pricing catalog that owns the chargeable item
    CHARGEABLE_ITEM_CLASS       CHARGEABLE_ITEM_CLASS (NAME)
     

      The name of the chargeable item class that defines the structure of the chargeable item
      CONSUMPTION_DATE        

        The date and time when the chargeable service is consumed by then end customer
        SERVICE_IDENTIFIER        

          The identifier of the chargeable service (or product) that is consumed by then end customer
          USER_IDENTIFIER        

            The technical identifier of the end customer consuming the chargeable service
            SESSION_ID        

              The identifier of the spring session that owns the chargeable item

              Column Details

              The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

              OID

              Definition The unique identifier of the chargeable item. It is generated by the SAP CC Cockpit application.
              Type DECIMAL(28), NOT NULL
              Primary Key PK_CHARGEABLE_ITEM

              CATALOG

              Definition The name of the pricing catalog that owns the chargeable item
              Type VARCHAR2(256 CHAR), NULL

              CHARGEABLE_ITEM_CLASS

              Definition The name of the chargeable item class that defines the structure of the chargeable item
              Type VARCHAR2(256 CHAR), NULL

              CONSUMPTION_DATE

              Definition The date and time when the chargeable service is consumed by then end customer
              Type DATE, NULL

              SERVICE_IDENTIFIER

              Definition The identifier of the chargeable service (or product) that is consumed by then end customer
              Type VARCHAR2(256 CHAR), NULL

              USER_IDENTIFIER

              Definition The technical identifier of the end customer consuming the chargeable service
              Type VARCHAR2(256 CHAR), NULL

              SESSION_ID

              Definition The identifier of the spring session that owns the chargeable item
              Type VARCHAR2(256 CHAR), NULL

              Primary Key Details

              See the primary key information:

              PK_CHARGEABLE_ITEM

              Column(s) OID
              Tablespace COCKPIT_INDX