1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OSS_CHARGE_LINES

OSS_CHARGE_LINES

Following table to capture subscription register charge line.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

OSS_CHARGE_LINES_PK

CHARGE_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
CHARGE_LINE_ID NUMBER 18 Yes Unique identifier for balance charge line.
CHARGE_LINE_NUMBER VARCHAR2 120 Field used to capture balance charge line number.
SUBSCRIPTION_ID NUMBER 18 Field used to capture subscription id.
SUBSCRIPTION_PRODUCT_ID NUMBER 18 Field used to capture subscription product id.
CHARGE_ID NUMBER 18 Field used to capture charge id.
CHARGE_DEFINITION_ID NUMBER 18 Field used to capture charge definition id.
CHARGE_DEFINITION VARCHAR2 30 Field used to capture charge definition.
BALANCE_REGISTER_ID NUMBER 18 Field used to capture balance register id.
BALANCE_REGISTER_PERIOD_ID NUMBER 18 Field used to capture balance register period id.
PERIOD_START_DATE DATE Field used to capture period start date.
PERIOD_END_DATE DATE Field used to capture period end date.
START_DATE DATE Field used to capture start date.
END_DATE DATE Field used to capture end date.
CHARGE_PERIOD_FACTOR NUMBER Field used to capture charge period factor.
CHARGE_LINE_SEQUENCE NUMBER Track the line sequence for given charge line.
PREVIOUS_END_DATE DATE Track the previous end date for given charge line.
PREVIOUS_CHARGE_PERIOD_FACTOR NUMBER Track the previous charge period factor for given charge line.
ORIG_SUBSCRIPTION_PRODUCT_PUID VARCHAR2 120 It tracks the original subscription product puid for given charge line.
RENEWAL_SEQUENCE_NUMBER NUMBER It tracks the renewal sequence number for given charge line.
REPORTED_QUANTITY NUMBER It tracks the reported quantity for given charge line.
ROUNDED_QUANTITY NUMBER It tracks the rounded quantity for given charge line.
USAGE_QUANTITY NUMBER It tracks the usage quantity for given charge line.
USAGE_UOM VARCHAR2 3 It tracks the usage unit of measure for given charge line.
ALLOWANCE_QUANTITY NUMBER It tracks the allowance quantity for given charge line.
UNIT_PRICE NUMBER It tracks the unit price for given charge line.
EXTENDED_AMOUNT NUMBER It tracks the extended amount for given charge line.
ALLOWANCE_AMOUNT NUMBER It tracks the allowance amount for given charge line.
UNBILLED_AMOUNT NUMBER It tracks the unbilled amount for given charge line.
BILLED_AMOUNT NUMBER It tracks the billed amount for given charge line.
CURRENCY_CODE VARCHAR2 15 It tracks the currency for given charge line.
NET_UNIT_PRICE NUMBER It tracks the net unit price for given charge line.
SUMMARIZED_RATING_FLAG VARCHAR2 1 It tracks the summarized rating flag for given charge line.
RATING_MODEL VARCHAR2 30 It tracks the rating model for given charge line.
BALANCE_PROFILE_CHARGE_ID NUMBER 18 It tracks the balance profile charge id for given charge line.
PRODUCT_CHANGE_SEQUENCE_NUMBER NUMBER It tracks the product change sequence number for given charge line.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
AMOUNT NUMBER It tracks the amount for given charge line.
TRUEUP_AMOUNT NUMBER It tracks the true up amount for given charge line.
UNBILLED_QUANTITY NUMBER It tracks the unbilled quantity for given charge line.
BILLED_QUANTITY NUMBER It tracks the billed quantity for given charge line.
TRUEUP_QUANTITY NUMBER It tracks the true up quantity for given charge 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
COPIED_FROM_SOURCE_ADJ_AMOUNT NUMBER Adjustment amount calculated based on the charge adjustments copied from the Source Product
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_CHARGE_LINES_N1 Non Unique Default SUBSCRIPTION_PRODUCT_ID, CHARGE_ID
OSS_CHARGE_LINES_N2 Non Unique Default BALANCE_REGISTER_ID, PERIOD_START_DATE, PERIOD_END_DATE
OSS_CHARGE_LINES_N3 Non Unique Default CHARGE_ID, PERIOD_START_DATE, PERIOD_END_DATE
OSS_CHARGE_LINES_PK Unique Default CHARGE_LINE_ID
OSS_CHARGE_LINES_U1 Unique Default CHARGE_LINE_NUMBER