SPENDING_STATUS_REPORT

Definition

The SPENDING_STATUS_REPORT table contains all the spending status reports.

Technical Data

Schema Version	5.0.6
Tablespace	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 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.
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

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

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	VARCHAR(256), NOT NULL

REPORT_TIMESTAMP

Definition	The date and time of the creation of the report
Type	TIMESTAMP, NOT NULL

REPORT_EXPIRATION

Definition	The date and time after which the spending status report is not relevant anymore
Type	TIMESTAMP, 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	TIMESTAMP, 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	BLOB, 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

See the primary key information:

PK_SPENDSTATRPT

Column(s)	PARTITION_ID,OID
Tablespace	SESSION_RATING_INDX