| Schema Version | 2025.0.0 | |
| Partitioned | Yes, when you use the partitioning scheme and corresponding SQL scripts | |
The SPENDING_STATUS_REPORT 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_SPENDSTATRPT |
|
The internal unique identifier of the spending status report. It is generated by the SAP CC system. | |||
| CLIENT_NUMBER |
|
The client number associated to the spending status report | ||||
| MONITORING_ID |
|
The external identifier specified by the client application or system | ||||
| REPORT_TIMESTAMP |
|
The date and time of the creation of the report | ||||
| REPORT_EXPIRATION |
|
The date and time after which the spending status report is not relevant anymore | ||||
| RESEND_ATTEMPT |
|
The number of attempts to resend the report already done | ||||
| NEXT_RESEND |
|
The date and time of the next attempt to resend the report | ||||
| REPORT_SNAPSHOT |
|
The snapshot of all the monitored spending statuses and the reported label values as defined in the SPENDING_STATUS_DESC database table | ||||
| PARTITION_ID | PK_SPENDSTATRPT |
|
The partition of the subscriber account owning the spending status report |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The internal unique identifier of the spending status report. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_SPENDSTATRPT |
| Definition | The client number associated to the spending status report |
| Type | DECIMAL(3), NOT NULL |
| Definition | The external identifier specified by the client application or system |
| Type | NVARCHAR(256), NOT NULL |
| Definition | The date and time of the creation of the report |
| Type | DATETIME, NOT NULL |
| Definition | The date and time after which the spending status report is not relevant anymore |
| Type | DATETIME, NOT NULL |
| Definition | The number of attempts to resend the report already done |
| Type | DECIMAL(4), NOT NULL |
| Definition | The date and time of the next attempt to resend the report |
| Type | DATETIME, NOT NULL |
| Definition | The snapshot of all the monitored spending statuses and the reported label values as defined in the SPENDING_STATUS_DESC database table |
| Type | IMAGE, NOT NULL |
| Definition | The partition of the subscriber account owning the spending status report |
| Type | DECIMAL(4), NOT NULL |
| Primary Key | PK_SPENDSTATRPT |
See the primary key information:
| Column(s) | PARTITION_ID,OID |
| Segment | SESSION_RATING_INDX |
