OSS_BALANCE_BILL_LINES
Following table is used to capture balance billing information
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_BALANCE_BILL_LINES_PK |
BALANCE_BILL_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BALANCE_BILL_LINE_ID | NUMBER | 18 | Yes | Unique identifier for balance bill lines. | |
| BALANCE_BILL_LINE_PUID | VARCHAR2 | 120 | Yes | Alternate identifier for balance bill lines. | |
| ROOT_BILL_LINE_ID | NUMBER | 18 | This field stores the unique identifier of the root bill line linked to the balance bill line. | ||
| PARENT_BILL_LINE_ID | NUMBER | 18 | This field records the unique identifier of the parent bill line that is linked to the balance bill line. | ||
| BILL_LINE_ID | NUMBER | 18 | This field records the unique identifier of the bill line that is linked to the balance bill line. | ||
| BILL_SEQUENCE_NUMBER | NUMBER | This field stores the bill sequence number that uniquely identifies the billing instance linked to the specific balance bill line. | |||
| USAGE_QUANTITY | NUMBER | This field stores the usage quantity linked to the specific balance bill line. | |||
| PRICED_QUANTITY | NUMBER | This field stores the usage quantity linked to the specific balance bill line. | |||
| LIST_PRICE | NUMBER | This field stores the ulist price linked to the specific balance bill line. | |||
| AMOUNT | NUMBER | This field stores the bill amount linked to the specific balance bill line. | |||
| COPIED_FROM_SOURCE_ADJ_AMOUNT | NUMBER | Adjustment amount copied from souce bill line. | |||
| SYSTEM_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount from system price adjustment category. | |||
| VOLUME_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount due to volume price adjustment category. | |||
| SYSTEM_VOLUME_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount due to system volume price adjustment | |||
| ADJUSTED_LIST_PRICE | NUMBER | Total adjusted list price | |||
| MANUAL_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount due to manual price adjustment category. | |||
| PRICING_TERM_ADJ_AMOUNT | NUMBER | Adjustment amount due to pricing term adjustment category. | |||
| CPI_ADJ_AMOUNT | NUMBER | Adjustment amount due to CPI adjustment category. | |||
| SYSTEM_ADHOC_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount due to system adhoc adjustment category. | |||
| ADHOC_PRICE_ADJ_AMOUNT | NUMBER | Adjustment amount due to ad-hoc price adjustment category. | |||
| MANUAL_ADJ_LIST_PRICE | NUMBER | Total manual adjustments list price | |||
| ADJUSTED_PRICE | NUMBER | Total adjusted price | |||
| ALLOWANCE_ADJ_AMOUNT | NUMBER | Adjustment amount due to allowance. | |||
| ADJUSTMENTS_NET_PRICE | NUMBER | Total adjustments net price | |||
| PREV_BILLED_AMOUNT | NUMBER | Total previous billed amount | |||
| VOL_REBATE_SURCHARGE_AMOUNT | NUMBER | Adjustment amount due to volume rebates and surcharges | |||
| BILL_AMOUNT_1 | NUMBER | First placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_2 | NUMBER | Second placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_3 | NUMBER | Third placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_4 | NUMBER | Fourth placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_5 | NUMBER | Fifth placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_6 | NUMBER | Sixth placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_7 | NUMBER | Seventh placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_8 | NUMBER | Eighth placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_9 | NUMBER | Ninth placeholder for additional categories total adjustments amounts. | |||
| BILL_AMOUNT_10 | NUMBER | Tenth placeholder for additional categories total adjustments amounts. | |||
| BILL_SUBTOTAL_1 | NUMBER | First placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_2 | NUMBER | Second placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_3 | NUMBER | Third placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_4 | NUMBER | Fourth placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_5 | NUMBER | Fifth placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_6 | NUMBER | Sixth placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_7 | NUMBER | Seventh placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_8 | NUMBER | Eighth placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_9 | NUMBER | Ninth placeholder for additional categories sub total amounts. | |||
| BILL_SUBTOTAL_10 | NUMBER | Tenth placeholder for additional categories sub total amounts. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_BALANCE_BILL_LINES_PK | Unique | Default | BALANCE_BILL_LINE_ID |
| OSS_BALANCE_BILL_LINES_U1 | Unique | Default | BALANCE_BILL_LINE_PUID |