Bill Cycle
Overview
The Bill Cycle subject area defines the schedule and frequency for generating customer invoices. It sets billing rules and timelines, manages billing windows, and records the status of billing runs such as completed or frozen. The MO supports recurring billing for customer groups and aligns billing dates with accounting periods. It is used to organize invoice generation and ensure integration with financial processes.
Conforming Layers
The only conforming layer of this subject area is BILL_CYC_OBJ.
BILL_CYC_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| BILL_CYC_CD | Unique code of the billing cycle. It is the primary identifier for each schedule entry. | VARCHAR | 4 |
| DESCR | Descriptive name of the billing cycle. | VARCHAR | 60 |
| WIN_START_DT | Start date of the billing window. | TIMESTAMP | |
| WIN_END_DT | End date of the billing window. | TIMESTAMP | |
| ACCOUNTING_DT | Accounting date for the billing cycle that is aligned with the correct financial period. | TIMESTAMP | |
| EST_DT | Estimated billing date for planning purposes. | TIMESTAMP | |
| CIS_DIVISION | Division within the Customer Information System (CIS) that is accountable for this transaction. | VARCHAR | 5 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | CDC_FLAG | Flag specifying the type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| COMPOSITE_KEY | Unique identifier in the BILL_CYC_CD || WIN_START_DT format. |
VARCHAR | 20 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP |