The FILE_SEQUENCES table contains information about the sequences, which are used
for filenames generated
by the rater or bulkloader instances of the SAP CC system during acquisition, charging,
refilling, and bulk loading operations.
Notes
| Schema Version | 5.0.6 | |
| Tablespace | CATALOG_DATA | |
| Partitioned | No | |
The FILE_SEQUENCES 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 |
|---|---|---|---|---|---|---|
| INSTANCE_ID | IX_FILE_SEQUENCES |
|
The unique instance ID | |||
| SEQUENCE_ID | IX_FILE_SEQUENCES |
|
The sequence key identifier | |||
| VALUE |
|
The current value of the sequence |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique instance ID |
| Description |
The unique instance ID, made up with three elements:
|
| Type | VARCHAR(64), NOT NULL |
| Available Index | IX_FILE_SEQUENCES |
| Definition | The sequence key identifier |
| Description |
The identifier of the sequence, specified in the "bulkWriter" elements of the CIF
configuration.
|
| Type | VARCHAR(256), NULL |
| Available Index | IX_FILE_SEQUENCES |
| Definition | The current value of the sequence |
| Description |
The current value of the sequence, incremented by each bulkWriter at data file creation
time.
|
| Type | DECIMAL(6), NOT NULL |
The following database indexes are available in the FILE_SEQUENCES database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | INSTANCE_ID,SEQUENCE_ID |
| Unique | Yes |
| Partitioned | No |
| Tablespace | CATALOG_INDX |
