Organization Usage: Updated billing views¶

The following views have been updated to help reconcile monthly usage statements:

As part of these changes, a small, one-time adjustment might be made for customers who have an active contract. Contracts begin by completing an order form.

Billing views of the Organization Usage schema and monthly usage statements behave as follows:

Before the change:

The following makes billing reconciliation difficult:

Billing views include usage that is not included on the monthly usage statement. For example, usage with a value of less than $0.01 is not billed on a statement.
Billing views do not use rounded values, while official values on the usage statements do.
Data types in the billing views are inconsistent.
The SERVICE_TYPE column of the RATE_SHEET_DAILY view does not include all types.

In addition, usage statements contain total usage for the contract by appending the current month to the end of the list.

After the change:

Monthly usage statements now contain usage for the current month only.

The billing views contain the following new columns and updated columns:

View	New columns	Updated columns
CONTRACT_ITEMS		Data type of AMOUNT changes from NUMBER(38,10) to NUMBER(38,2). Data type of CONTRACT_MODIFIED changes from TIMESTAMP_LTZ to DATE.
RATE_SHEET_DAILY	BILLING_TYPE RATING_TYPE IS_ADJUSTMENT	SERVICE_TYPE can be any of the possible service types, similar to other views. `compute` is no longer a possible value.
REMAINING_BALANCE_DAILY	MARKETPLACE_CAPACITY_ DRAWDOWN_BALANCE	Data type of ROLLOVER_BALANCE changes from FLOAT to NUMBER(38,2).
USAGE_IN_CURRENCY_DAILY	BILLING_TYPE RATING_TYPE SERVICE_TYPE IS_ADJUSTMENT	Data type of USAGE changes from NUMBER(38,6) to NUMBER(38,3). Data type of USAGE_IN_CURRENCY changes from NUMBER(38,6) to NUMBER(38,2).

Ref: 1584