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.
| Schema Version | 2025.0.0 | |
| Partitioned | No | |
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 |
|---|---|---|---|---|---|---|
| CLIENT_NUMBER |
|
The client number associated to the file | ||||
| 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 | ||||
| IN_ERROR |
|
Specifies if the file is in error | ||||
| ADD_INFO |
|
Additional Information |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The client number associated to the file |
| Type | DECIMAL(3), NOT NULL |
| Definition | The name of the file without extension |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The date when the file was created |
| Type | SECONDDATE, NOT NULL |
| Definition | The type of the system instance, which created the file |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | Specifies if the file is in error |
| Type | DECIMAL(1), NOT NULL |
| Default | 0 |
| Definition | Additional Information |
| Type | NVARCHAR(256), NULL |
