SPENDING_STATUS_REPORT
Definition
The SPENDING_STATUS_REPORT table contains all the spending status reports.
Technical Data
| Schema Version |
4.5.13 |
| Segment |
SESSION_RATING_DATA |
| Partitioned |
Yes, when you use the partitioning scheme and corresponding SQL scripts |
Summary
The SPENDING_STATUS_REPORT table is defined by the
following columns.
See the column details for more information.
Column Details
OID
| 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 |
MONITORING_ID
| Definition |
The external identifier specified by the client application or system |
| Type |
NVARCHAR(256), NOT NULL |
REPORT_TIMESTAMP
| Definition |
The date and time of the creation of the report |
| Type |
DATETIME, NOT NULL |
REPORT_EXPIRATION
| Definition |
The date and time after which the spending status report is not relevant anymore
|
| Type |
DATETIME, NOT NULL |
RESEND_ATTEMPT
| Definition |
The number of attempts to resend the report already done |
| Type |
DECIMAL(4), NOT NULL |
NEXT_RESEND
| Definition |
The date and time of the next attempt to resend the report |
| Type |
DATETIME, NOT NULL |
REPORT_SNAPSHOT
| 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 |
PARTITION_ID
| Definition |
The partition of the subscriber account owning the spending status report |
| Type |
DECIMAL(4), NOT NULL |
| Primary Key |
PK_SPENDSTATRPT |
Primary Key Details
PK_SPENDSTATRPT
