CHARGED_ITEM_FILES

Definition


The CHARGED_ITEM_FILES table contains information about the files of charged items, chargeable items, and refill items generated by the rater and bulkloader instances of the SAP CC system during the charging and refilling operations

Description


The CHARGED_ITEM_FILES table contains information about the files of charged items, chargeable items, and refill items generated by the rater and bulkloader instances of the SAP CC system during the charging and refilling operations. The back-end database does not include these resulting items because they are stored in data files.

Note

For compatibility reasons, the name of this table remains unchanged even if the files contain other items than charged items.

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The CHARGED_ITEM_FILES 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
FILE_NAME        

    The name of the file without extension
    CREATION_DATE        

      The date when the file was created
      INSTANCE_TYPE        

        The type of the system instance, which created the file

        More...

        IN_ERROR        

          Specifies if the file is in error
          ADD_INFO        

            Additional Information

            Column Details

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

            FILE_NAME

            Definition The name of the file without extension
            Type NVARCHAR(256), NOT NULL

            CREATION_DATE

            Definition The date when the file was created
            Type DATETIME, NOT NULL

            INSTANCE_TYPE

            Definition The type of the system instance, which created the file
            Format

            The possible values are:

            • 0: Rater
            • 1: Bulkloader

            Type DECIMAL(1), NOT NULL

            IN_ERROR

            Definition Specifies if the file is in error
            Type DECIMAL(1), NOT NULL
            Default 0

            ADD_INFO

            Definition Additional Information
            Type NVARCHAR(256), NULL