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