Bill Charge
Overview
The Bill Charge subject area represents an individual charge that is part of a Bill. Each Bill Charge is linked to a bill and reflects the rated amount for a specific service, usage, or fee within the billing cycle.
The Bill Charge subject area stores attributes such as charge amount, charge type, service identifier, effective date, and references to pricing or rate components used during rating. It provides the detailed breakdown of how the total on a bill is calculated, supporting both recurring and usage-based charges. Bill charges are generated during the rating and billing process of the parent bill.
Conforming Layers
The conforming layers of this subject area are the following:
BILL_CHG_OBJ
| Column | Source Column Description | Data Type | Data Length |
|---|---|---|---|
| BILLABLE_CHG_ID | Unique identifier for a billable charge record. | VARCHAR | 12 |
| SA_ID | Identifier for the service agreement associated with the billing charge. | VARCHAR | 10 |
| START_DT | Start date of the billable charge. | TIMESTAMP | |
| END_DT | End date of the billable charge. | TIMESTAMP | |
| DESCR_ON_BILL | Description that will appear on the customer's bill for the charge. | VARCHAR | 80 |
| BILLABLE_CHG_STAT | Current status of the billable charge. | VARCHAR | 2 |
| ILM_DT | Date when the billable charge is scheduled to be archived. | TIMESTAMP | |
| ILM_ARCH_SW | Indicator whether the billable charge is marked for archiving. | VARCHAR | 1 |
| BILL_CHG_TMPLT_CD | Code of the billing charge template defining the structure and calculation rules for the charge. | VARCHAR | |
| SQI_CD | Code of the Service Quantity Indicator used to define the type of service or the unit of measurement for a particular charge. | VARCHAR | 8 |
| SVC_QTY | Quantity of the service being billed to a customer. | DECIMAL | (18,6) |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| 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 | |
| COMPOSITE_KEY | Unique identifier in BILLABLE_CHG_ID format. This is the primary key. |
VARCHAR | 12 |
BILL_CHG_LINE_OBJ
| Column | Source Column Description | Data Type | Data Length |
|---|---|---|---|
| BILLABLE_CHG_ID | Unique identifier for a billable charge record. | VARCHAR | 12 |
| LINE_SEQ | Line sequence number associated with a specific charge line in a billable charge. | DECIMAL | (3,0) |
| DESCR_ON_BILL | Description that will appear on the customer's bill for the charge. | VARCHAR | 80 |
| CHARGE_AMT | Charge amount associated with the charge line. | DECIMAL | (15,2) |
| CURRENCY_CD | ISO code for the currency used in the account transactions. | VARCHAR | 3 |
| DST_ID | Identifier for the destination where the service or resource was consumed, or where the charge applies. | VARCHAR | 10 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| 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 | |
| COMPOSITE_KEY | Unique identifier in the BILLABLE_CHG_ID || LINE_SEQ format. This is the primary key. |
VARCHAR | 15 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 254 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 254 |
BCHG_READ_OBJ
| Column | Source Column Description | Data Type | Data Length |
|---|---|---|---|
| BILLABLE_CHG_ID | Unique identifier for a billable charge record. | VARCHAR | 12 |
| SP_ID | Identifier used to associate a billable charge record with a specific service provider in the system. | VARCHAR | 10 |
| SEQNO | Sequence number indicating the order of processing the billable charge. | DECIMAL | (5,0) |
| REG_CONST | Regulatory constant or regulatory identifier specifying regulatory requirements or constraints that may apply to the charge. | DECIMAL | (12,6) |
| USAGE_FLG | Indicator whether a specific billable charge is associated with usage-based billing. | VARCHAR | 2 |
| USE_PCT | Percentage of a billable charge that is used or allocated for a specific purpose, often related to discounts, tax calculations, or adjustments. | DECIMAL | (3,0) |
| HOW_TO_USE_FLG | Flag indicating how a billable charge should be applied, used, or processed. | VARCHAR | 2 |
| MSR_PEAK_QTY_SW | Switch indicating whether a particular billable charge is related to or affected by a peak quantity. | VARCHAR | 1 |
| UOM_CD | Code of the Unit of Measure (UOM) used in the billable charge. | VARCHAR | 4 |
| TOU_CD | Code of the Time of Use (TOU) used to identify the time-of-use pricing structure or rate associated with a billable charge. | VARCHAR | 8 |
| SQI_CD | Service Quality Indicator used to identify the quality level or status of the billable charge related to a service or product. | VARCHAR | 8 |
| START_REG_READ_ID | Start register read identifier associated with a particular billable charge. This identifier tracks consumption using meters or registers. | VARCHAR | 12 |
| START_READ_DTTM | Start date and time of the meter or register reading of the billable charge. | TIMESTAMP | |
| START_REG_READING | Initial register or meter reading of the billable charge. | DECIMAL | (15,6) |
| END_REG_READ_ID | Identifier for the End register or meter reading of the billable charge. | VARCHAR | 12 |
| END_READ_DTTM | End date and time of the meter or register reading of the billable charge. | TIMESTAMP | |
| END_REG_READING | Final register or meter reading of the billable charge. | DECIMAL | (15,6) |
| MSR_QTY | Quantity of a service or resource that is being tracked and billed. | DECIMAL | (18,6) |
| FINAL_UOM_CD | Final Unit of Measure (UOM) that the charge is billed in. | VARCHAR | 4 |
| FINAL_TOU_CD | Final Time-of-Use (TOU) of the billable charge. | VARCHAR | 8 |
| FINAL_REG_QTY | Final registered quantity of a billable charge. | DECIMAL | (18,6) |
| FINAL_SQI | Final Service Quantity Indicator (SQI) of a billable charge. | VARCHAR | 8 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| 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 | |
| COMPOSITE_KEY | Unique identifier in BILLABLE_CHG_ID format. This is the primary key. |
VARCHAR | 27 |