Fair_value_prices

Important: This table’s data is available only to the accounts that have Advanced Revenue Management enabled.

Columns

Name Type Length Precision Scale References In Description
currency_id NUMBER 39 0 Currency ID
date_created TIMESTAMP Date created
date_last_modified TIMESTAMP Date last modified
end_date TIMESTAMP End date
fair_value_formula VARCHAR2 200 Fair value formula
fair_value_price_extid VARCHAR2 255 Fair value price external ID
fair_value_price_id NUMBER 39 0 Fair value price ID
fair_value_range_policy VARCHAR2 128 Fair value range policy
high_value VARCHAR2 42 High value
is_vsoe VARCHAR2 3 Whether is VSOE
item_id NUMBER 39 0 Item ID
item_revenue_category VARCHAR2 250 Item revenue category
low_value VARCHAR2 42 Low value
start_date TIMESTAMP Start date
unit_id NUMBER 39 0 Unit ID
unit_price NUMBER 30 15 Unit price
units_type_id NUMBER 39 0 Units type ID