1. Tables and Views for Financials
  2. VRM_PRICING_LINES

VRM_PRICING_LINES

This is an extension object to document lines that store the processing results of Dimension Value Assignment Process i.e. Pricing_Combination_Id and Line Grouping i.e. Line_Group_Number.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_PRICING_LINES_PK

DOCUMENT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOCUMENT_LINE_ID NUMBER 18 Yes Internal unique identifier of a source document line. Active
DOCUMENT_ID NUMBER 18 Yes Unique identifier of a source document. Active
STATUS VARCHAR2 30 Yes Price basis line status. Values derived from the lookup type VSOE_PBL_STATUS. Active
GROUP_NUMBER NUMBER 18 Internal unique identifier of a line group. Active
GROUPING_REASON_CODE VARCHAR2 30 Reason code for a line grouping. Active
PRICING_COMBINATION_ID NUMBER 18 Identifier of the pricing dimension combination. Active
ITEM_GROUP_ID NUMBER 18 Unique identifier of an item group. Active
TEMPLATE_ID NUMBER 18 Internal Identifier of the FMV template. Active
DOCUMENT_DATE DATE Yes Date of source document. Active
DIMENSION_FLAG VARCHAR2 1 Flag that indicates whether pricing combination is successfully derived for the given document line. Active
MEA_FLAG VARCHAR2 1 A flag to indicates whether the source document line belong to a MEA or not.
EXCLUDED_FLAG VARCHAR2 1 Flag that indicates if standalone sales has been excluded from VSOE price calculation. Active
EXCLUSION_REASON_CODE VARCHAR2 60 Exclusion reason to exclude a line from VSOE price calculation. Values are from the lookup VSOE_PBL_EXCLUDING_REASON. Active
EXCLUSION_REVIEW_FLAG VARCHAR2 10 Flag that indicates if a revenue analyst or manager has reviewed the line marked as excluded by the system. Active
EXCEPTION_FLAG VARCHAR2 1 Flag that indicates if VSOE price has an exception. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
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. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REVENUE_DOCUMENT_ID NUMBER 18 Unique identifier of a revenue document.
REV_PROGRAM_CONTROL_ID NUMBER 18 Internal Identifier of the revenue program run.
WORKER_NUMBER NUMBER 18 Number of parallel processes for a concurrent process.
PREV_DOCUMENT_LINE_ID NUMBER 18 Reference document line internal identifier.
NET_LINE_AMOUNT NUMBER Line amount after adjusting return amount.
NET_UNIT_SALES_PRICE NUMBER Unit selling price after adjusting return amount.
NET_UNIT_SALES_PCT_BASE_PRICE NUMBER Unit sales percent base price after adjusting return amount.
NET_DISCOUNT_PERCENT NUMBER Discount percentage after adjusting return amount.
REVISED_COST NUMBER Adjusted cost of sale after the document is revised.
REVISED_GROSS_MARGIN_PERCENT NUMBER Adjusted gross margin of sales after the document is revised.
CONCATENATED_SEGMENTS CLOB The concatenated pricing dimension flexfield.
DISPLAY_FLAG VARCHAR2 1 Indicates whether to display the FMV for the line. Possible values are Yes or No.
ITEM_TYPE VARCHAR2 10 Indicates the type of a source document items. Possible values are ITEM, MEMO_LINE and ITEM_GROUP.
ITEM_TYPE_ID NUMBER 18 Item type unique identifier.
NET_QUANTITY NUMBER Net quantity of a transaction line.
UPDATE_FMV_REP_VALUE VARCHAR2 1 Indicates whether to allow updates on Base Price Percentage or Cost or not. Possible values are Yes or No.
COMMENTS VARCHAR2 1000 Comments entered for MEA or standalone sales.
REVISED_UOM_CODE VARCHAR2 200 Revised unit of measure code.
NET_DISCOUNT_AMOUNT NUMBER Net discount amount of the original line.
REV_REC_STATUS VARCHAR2 60 Status of a document line to indicate whether line is processed by revenue.
ELEMENT_TYPE VARCHAR2 30 Element is a deliverable or separate unit of accounting. Used to group element types for FMV sets. Values are from the lookup VRM_ELEMENT_TYPE.
NET_UNIT_LIST_PRICE NUMBER Net unit list price discount used to validate VSOE value of a MEA line.
NET_BASE_PRICE NUMBER Net base price used to validate VSOE value of a MEA line.
DELIVERED_DATE DATE Fulfillment date of a source document line.
RECONCILIATION_STATUS VARCHAR2 60 The billing and revenue reconciliation status for a revenue line.
RECONCILIATION_DATE DATE Date the revenue line is reconciled.
BILLED_AMOUNT NUMBER Line amount of the transaction line. Tax amount is excluded.
DELIVERY_DATE DATE Fulfillment date of a source document line.
DELIVERY_STATUS VARCHAR2 30 Delivery status of a source document. Values are from the lookup VRM_MEA_LINE_DELIVERY_STATUS.
RECONCILIATION_REQUEST_ID NUMBER 18 Request with the updated reconciliation information on the pricing line.
RECONCILIATION_BATCH_NUMBER NUMBER 18 Identifies the batch to be processed for a reconciliation request.
LEDGER_ID NUMBER 18 Ledger unique identifier.
CUST_CONTRACT_CREATION_STATUS VARCHAR2 30 Status used to track whether this line is included in a performance obligation line of a contract.
CUST_CONTRACT_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created a customer contract using this row.
SATISFACTION_MEASUREMENT_MODEL VARCHAR2 30 Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from the lookup type ORA_VRM_SATIS_MEAS_MODEL.
REVENUE_RULE_ID NUMBER 18 Revenue scheduling rule unique identifier.
REVENUE_RULE_DURATION NUMBER Number of periods in which revenue of this performance obligation line is to be recognized.
CONTRACT_UPDATE_TEMPLATE_ID NUMBER 18 Revenue contract update template identifier.
INITIAL_DOCUMENT_LINE_ID NUMBER 18 Reference key that identifies the parent source document line for the current line.
ADD_TO_CONTRACT_ACTION_CODE VARCHAR2 30 Specifies how a new line from the source system should be processed. Values are derived from the lookup type ORA_ADD_TO_CONTRACT_ACTION. Blank is equivalent to ORA_ADD_TO_EXISTING_PO.
DOCUMENT_LINE_TYPE_CODE VARCHAR2 30 Specifies the type of line sent from the source system. Values are derived from the lookup type ORA_VRM_DOCUMENT_LINE_TYPE. Blank is equivalent to ORA_NEW_LINE.
TOP_PARENT_DOCUMENT_LINE_ID NUMBER 18 Reference key that identifies the top most parent document line for the current line.
REVISION_INTENT_TYPE_CODE VARCHAR2 30 Revision intent for the source document revision line. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE.
WARNING_MESSAGE_NAME VARCHAR2 30 Specifies message name for warning line.
CONTRACT_RULE_ID NUMBER 18 Internal identifier of the customer contract identification rule.
CONTRACT_HASH_CODE VARCHAR2 550 Contract processing unique identifier.
CONTRACT_REFERENCE VARCHAR2 1000 User entered contract reference or grouping attribute values used to identify the contract as derived by enabling the Copy to Reference option in the Contract Identification rule.
CONTRACT_TYPE VARCHAR2 30 Oracle internal use only.
CONTRACT_CLASSIFICATION_CODE VARCHAR2 30 Classification code of a contract. Values are derived from lookup type ORA_VRM_CONTRACT_CLASSIF_CODE.
IMMATERIAL_CHANGE_CODE VARCHAR2 30 Immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE.
CONTRACT_MODIFICATION_DATE DATE The date on which the revenue contract was modified.
LATEST_IMMATERIAL_CHANGE_CODE VARCHAR2 30 Latest immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE.
LATEST_CONTRACT_MOD_DATE DATE Latest date on which the revenue contract was modified.
REVISED_RECURRING_FLAG VARCHAR2 1 Revised indicator specifying that the line will recur on the line's satisfaction plan end date. Valid values are from the lookup type VRM_YES/NO.
REVISED_RECURRING_FREQUENCY NUMBER Revised frequency number of the recurring pattern.
REVISED_RECUR_PATTERN_CODE VARCHAR2 30 Revised recurring frequency of the line. Valid values are from the lookup type VRM_RECUR_PATTERN_CODE.
REVISED_TERMINATION_DATE DATE Revised termination date, which is the date the line was terminated and will no longer recur automatically.
REVISED_RECURRING_AMOUNT NUMBER Revised selling amount per frequency for the recurring line.
REVISED_RULE_END_DATE DATE Revised revenue recoginition end date for the revenue scheduling rule.
REVISED_RULE_START_DATE DATE Revised revenue recoginition start date for the revenue scheduling rule.
REVISED_ACCOUNTING_RULE_ID NUMBER 18 Revised revenue scheduling rule identifier.
DOCUMENT_GROUP_ID NUMBER 18 Source document group identifier used to group the initial recurring source document header and system-generated recurring source document headers. Value is the source document identifier for the original source document.
ORIGINAL_DOCUMENT_LINE_ID NUMBER 18 Original source document line identifier used to create the recurring source document line.
RECUR_LINE_PROCESSED_FLAG VARCHAR2 1 Indicates the line was processed for the period. Valid values are from the lookup type VRM_YES/NO.
TERMINATION_DATE DATE The date on which the revenue line was terminated.
NET_UNIT_SSP NUMBER Net unit standalone selling price of the item or memo line.
LATEST_PERIOD_ACTION_CODE VARCHAR2 30 Latest satisfaction period action that was processed on this document line. Valid values are from the lookup type ORA_VRM_PERIOD_SUBLINE_ACTION.
TOTAL_REVERSAL_DAYS NUMBER 8 Total number of days the service was suspended. This value is calculated based on the number of days between the effective dates of all reversals and their corresponding reinstatements.
LATEST_REVERSAL_DAYS NUMBER 8 Number of days since the latest suspension of service. This value is calculated based on the the number of days between the effective plan end date of the promised detail and the recently processed reversal subline.
REVISED_SERVICE_UOM VARCHAR2 200 Revised unit of measure of the service item on the source document line. Valid values are from the Price Periodicity UOM Class defined in Oracle Fusion Pricing.
REVISED_SERVICE_DURATION NUMBER Revised duration of the service item in terms of the service unit of measure.

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_PRICING_LINES vrm_source_documents DOCUMENT_ID
VRM_PRICING_LINES vrm_line_groups GROUP_NUMBER
VRM_PRICING_LINES vrm_pricing_combinations PRICING_COMBINATION_ID
VRM_PRICING_LINES vrm_item_groups_b ITEM_GROUP_ID
VRM_PRICING_LINES vrm_fmv_templates_b TEMPLATE_ID
VRM_PRICING_LINES vrm_pricing_lines PREV_DOCUMENT_LINE_ID
VRM_PRICING_LINES vrm_source_doc_lines TOP_PARENT_DOCUMENT_LINE_ID
vrm_billing_line_details vrm_pricing_lines DOCUMENT_LINE_ID
vrm_fmv_set_usage_ref_lines vrm_pricing_lines DOCUMENT_LINE_ID
vrm_pricing_lines vrm_pricing_lines PREV_DOCUMENT_LINE_ID
vrm_fmv_data_set_usages vrm_pricing_lines DOCUMENT_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_PRICING_LINES_N1 Non Unique FUSION_TS_TX_IDX DISPLAY_FLAG, LEDGER_ID, CONTRACT_HASH_CODE Active
VRM_PRICING_LINES_N10 Non Unique Default REV_PROGRAM_CONTROL_ID, REV_REC_STATUS
VRM_PRICING_LINES_N11 Non Unique Default REV_REC_STATUS
VRM_PRICING_LINES_N12 Non Unique Default RECUR_LINE_PROCESSED_FLAG, REVISED_RULE_END_DATE
VRM_PRICING_LINES_N13 Non Unique Default RECONCILIATION_STATUS, LEDGER_ID
VRM_PRICING_LINES_N14 Non Unique Default RECONCILIATION_DATE, LEDGER_ID, RECONCILIATION_STATUS
VRM_PRICING_LINES_N2 Non Unique Default CONTRACT_HASH_CODE, DISPLAY_FLAG
VRM_PRICING_LINES_N3 Non Unique FUSION_TS_TX_IDX DOCUMENT_DATE Active
VRM_PRICING_LINES_N4 Non Unique FUSION_TS_TX_IDX DOCUMENT_GROUP_ID Active
VRM_PRICING_LINES_N5 Non Unique Default STATUS
VRM_PRICING_LINES_N6 Non Unique Default REQUEST_ID, WARNING_MESSAGE_NAME
VRM_PRICING_LINES_N7 Non Unique Default PREV_DOCUMENT_LINE_ID
VRM_PRICING_LINES_N8 Non Unique Default DOCUMENT_ID
VRM_PRICING_LINES_N9 Non Unique Default DIMENSION_FLAG, LEDGER_ID, DISPLAY_FLAG
VRM_PRICING_LINES_U1 Unique FUSION_TS_TX_IDX DOCUMENT_LINE_ID Active