AUDIT_CYCLE
Definition
The AUDIT_CYCLE table contains settings for the audit cycle
Technical Data
| Schema Version |
4.5.13 |
| Tablespace |
CATALOG_DATA |
| Partitioned |
No |
Summary
The AUDIT_CYCLE table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| Definition |
The audit cycle unique Id |
| Type |
DECIMAL(28), NOT NULL |
| Primary Key |
PK_AUDIT_CYCLE |
CODE
| Definition |
The audit cycle code |
| Type |
VARCHAR(256), NULL |
| Available Index |
IX_AUDIT_CODE |
DESCRIPTION
| Definition |
The audit cycle description |
| Type |
VARCHAR(2000), NULL |
ORIGINAL_DATE
| Definition |
The date of the first audit cycle |
| Description |
The date of the first audit cycle. If null the first trigger date is set to current
date.
|
| Type |
TIMESTAMP, NOT NULL |
FREQUENCY_TYPE
| Definition |
The frequency of the audit cycle |
| Format |
The possible values are:
-1: Daily
0: weekly
1: bi-weekly
2: monthly
3: bi-monthly
4: tri-monthly
5: semi-annual
6: annual
|
| Type |
DECIMAL(1), NULL |
Primary Key Details
PK_AUDIT_CYCLE
Index Details
The following database indexes are available in the
AUDIT_CYCLE database table to improve the speed of data retrieval operations during
the business processes of SAP Convergent Charging:
IX_AUDIT_CODE
| Indexed Column(s) |
CODE |
| Unique |
Yes |
| Partitioned |
No |
| Tablespace |
CATALOG_INDX |
