3.2 Billing Period
The Billing Period dataset is a supporting dataset that defines the time intervals and statuses associated with an invoice issuer's billing cycles for grouping and presenting charges on invoices. This dataset helps FinOps practitioners better understand how and when they can leverage Cost and Usage and Invoice Detail data for formal financial reporting and showback/chargeback processes.
Columns in this Dataset
| Column | Type | Level | Data Type |
|---|---|---|---|
| Billing Period Created | Dimension | Mandatory | Date/Time |
| Billing Period End | Dimension | Mandatory | Date/Time |
| Billing Period Last Updated | Dimension | Mandatory | Date/Time |
| Billing Period Start | Dimension | Mandatory | Date/Time |
| Billing Period Status | Dimension | Mandatory | String |
| Invoice Issuer Name | Dimension | Mandatory | String |
Relationships
The Billing Period dataset is primarily used to provide context for the Cost and Usage and Invoice Detail datasets. It is joined using the Billing Period Start and Invoice Issuer Name columns available in those datasets.
| Dataset A | Dataset A Column | Dataset B | Dataset B Column |
|---|---|---|---|
| Billing Period | Billing Period Start and Invoice Issuer Name | Cost and Usage | Billing Period Start and Invoice Issuer Name |
| Billing Period | Billing Period Start and Invoice Issuer Name | Invoice Detail | Billing Period Start and Invoice Issuer Name |
Requirements
BillingPeriod MUST adhere to the following requirements:
- BillingPeriod MUST be present when the invoice issuer supports payable invoices.
- The presence of columns in BillingPeriod MUST adhere to the following requirements:
- BillingPeriod MUST include BillingPeriodCreated.
- BillingPeriod MUST include BillingPeriodEnd.
- BillingPeriod MUST include BillingPeriodLastUpdated.
- BillingPeriod MUST include BillingPeriodStart.
- BillingPeriod MUST include BillingPeriodStatus.
- BillingPeriod MUST include InvoiceIssuerName.
- BillingPeriod MUST conform to CorrectionHandling requirements.
- BillingPeriod MUST conform to DatasetCompleteness requirements.
- BillingPeriod MUST conform to DatasetConfiguration requirements.
- BillingPeriod MUST conform to DeliveryHandling requirements.
- BillingPeriod FOCUS columns MUST conform to FocusColumnHandling requirements.
- BillingPeriod FOCUS columns MUST conform to NullHandling requirements.
- BillingPeriod custom columns MUST conform to CustomColumnHandling requirements.
Description
Describes the time intervals and statuses associated with an invoice issuer's billing cycles.