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

OSS_REVENUE_LINES

This table contains revenue data

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

OSS_REVENUE_LINES_PK

REVENUE_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
REVENUE_LINE_ID NUMBER 18 Yes Unique Identifier of the revenue line,primary key.
REVENUE_LINE_PUID VARCHAR2 120 Yes Public Unique Identifier of the revenue line
CHARGE_ID NUMBER 18 Charge Identifier,parent key to oss_charges
CHARGE_DEFINITION VARCHAR2 30 Charge definition code for the charge
CHARGE_NAME VARCHAR2 120 Charge name of the referenced charge
FULFILL_LINE_ID NUMBER 18 Order fulfillment line identifier
SATISFACTION_MEASUREMENT_MODEL VARCHAR2 30 Revenue satisfaction measurement model used-Period,Quantity or percentage
RULE_START_DATE DATE Revenue recognition start date
RULE_END_DATE DATE Revenue recognition end date for periodic revenue line
SERVICE_DURATION NUMBER Service duration for revenue recognition
SERVICE_PERIOD VARCHAR2 30 Service Period for revenue recognition
UNIT_SSP NUMBER Unit price if the item is sold as a stand alone item
UNIT_LIST_PRICE NUMBER Unit list price of the item
UNIT_SELLING_PRICE NUMBER Unit Selling price of the item
LINE_AMOUNT NUMBER Total revenue line amount to be recognized
EXTENDED_SSP NUMBER Total selling price if the item is sold as standalone item
VERSION_NUMBER NUMBER 9 Revenue revision number
VERSION_FLAG VARCHAR2 1 Flag indicating if the record is creating a revenue revision
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.
DOCUMENT_TYPE_ID NUMBER 18 Identifies the origin of subscription.
SUBSCRIPTION_ID NUMBER 18 Subscription identifier,foreign key to oss_subscriptions.
SUBSCRIPTION_PRODUCT_ID NUMBER 18 Subscription product Identifier,foreign key to oss_products.
PRODUCT_ASSOCIATION_ID NUMBER 18 Product association identifier,product key to oss_product_associations.
INITIAL_DOCUMENT_TYPE_ID NUMBER 18 Identifier of subscription origin for reference revenue line.
INITIAL_REVENUE_LINE_ID NUMBER 18 Identifier of reference revenue line.
INITIAL_FULFILL_LINE_ID NUMBER 18 Fulfill line id of reference revenue line.
INITIAL_CHARGE_DEFINITION VARCHAR2 30 Charge definition of reference revenue line.
REF_DOCUMENT_TYPE_ID NUMBER 18 Document Type identifier of parent source document line.
REF_REVENUE_LINE_ID NUMBER 18 Identifier of reference revenue line.
REF_FULFILL_LINE_ID NUMBER 18 Represents order management fulfillment line id for subscriptions created from order management.
REF_CHARGE_DEFINITION VARCHAR2 30 Represents the referenced charge definition.

Indexes

Index Uniqueness Tablespace Columns
OSS_REVENUE_LINES_U1 Unique Default REVENUE_LINE_ID
OSS_REVENUE_LINES_U2 Unique Default REVENUE_LINE_PUID
OSS_REVENUE_LINES_N1 Non Unique Default REF_REVENUE_LINE_ID
OSS_REVENUE_LINES_N2 Non Unique Default CHARGE_ID
OSS_REVENUE_LINES_N3 Non Unique Default SUBSCRIPTION_ID
OSS_REVENUE_LINES_N4 Non Unique Default SUBSCRIPTION_PRODUCT_ID, CHARGE_NAME