Opportunity Revenue Fact
Module:
REVENUE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
REVENUE_ID | NUMBER | 38 | 0 | True | Primary key. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Unique Identifier | ||||
ACTUAL_CLOSE_DATE | DATE | the date when the revenue line was closed | |||||
BUSINESS_UNIT_ID | NUMBER | 38 | 0 | (Internal Organization) to which this Opportunity belongs. | DW_BUSINESS_UNIT_D_TL | BUSINESS_UNIT_ID | |
CLOSE_REASON_CODE | VARCHAR2 | 64 | Close reason | DW_CXS_REASON_WON_LOST_CODE_D_TL | CODE | ||
REVENUE_CURRENCY_CODE | VARCHAR2 | 32 | CRM common currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
OPPORTUNITY_CURRENCY_CONVERSION_RATE | NUMBER | This rate is used for the conversion of the revenue amount to the opportunity summary currency if the currency of the revenue line is different from that of the opportunity.This is the amount that one currency can be exchanged for at a specific point of time. | |||||
OPPORTUNITY_CURRENCY_CONVERSION_RATE_TYP | VARCHAR2 | 32 | Currency Conversion rate type | DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL | CODE | ||
CREATED_BY | VARCHAR2 | 64 | user who created the row | ||||
CREATION_TIMESTAMP | TIMESTAMP | Creation Timestamp - Audit column | |||||
CREATION_DATE | DATE | Creation Date - Audit column | |||||
REVENUE_CREATION_TIMESTAMP | TIMESTAMP | Revenue Creation Date | |||||
REVENUE_CREATION_DATE | DATE | Revenue Creation Date | |||||
CRM_CURRENCY_CODE | VARCHAR2 | 32 | CRM common currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CRM_CONVERSION_RATE | NUMBER | This rate is used for the conversion of the revenue amount to the crm common currency for the Revenue Forecast Metrics if the currency of the revenue line is different.This is the amount that one currency can be exchanged for at a specific point of time. | |||||
CRM_CONVERSION_RATE_TYPE | VARCHAR2 | 32 | Currency Conversion rate type | DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL | CODE | ||
CUSTOMER_PARTY_ID | NUMBER | 38 | 0 | Customer ID | DW_CXS_SALES_ACCOUNT_D | PARTY_ID | |
DISCOUNT_PERCENT | NUMBER | Discount percent | |||||
EXPECTED_CLOSE_DATE | DATE | Estimated close date for this revenue - defaulted from opportunity's close date | |||||
EXPECTED_AMOUNT | NUMBER | Expected revenue amount | |||||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Product inventory item ID | DW_CXS_PRODUCT_D | INVENTORY_ITEM_ID | |
INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 | Product inventory organization ID | |||
LAST_UPDATE_TIMESTAMP | TIMESTAMP | date and time of the last update | |||||
LAST_UPDATE_DATE | DATE | date and time of the last update | |||||
OPPORTUNITY_ID | NUMBER | 38 | 0 | Opportunity ID | |||
OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Salesrep or partner ID | DW_CXS_RESOURCE_D | RESOURCE_ID | |
PRIMARY_FLAG | VARCHAR2 | 32 | Primary flag - defines the primary revenue record | ||||
PRIMARY_TERRITORY_VERSION_ID | NUMBER | 38 | 0 | Primary territory version id | DW_CXS_SALES_TERRITORY_D | TERRITORY_VERSION_ID | |
PRODUCT_GROUP_ID | NUMBER | 38 | 0 | The product group id | DW_CXS_PRODUCT_GROUP_D | PRODUCT_GROUP_ID | |
QUANTITY | NUMBER | Quantity | |||||
RECOMMENDED_REVENUE_AMOUNT | NUMBER | Recomented Revenue Amount | |||||
RECOMMENDED_WIN_PROBABILITY | NUMBER | Recomented Win probability percent | |||||
RECURRING_END_DATE | DATE | The recurrence end date | |||||
RECURRING_FREQUENCY_CODE | VARCHAR2 | 32 | Frequency for the receurrence | DW_CXS_RECURRING_FREQUENCY_CODE_D_TL | CODE | ||
RECURRING_NUMBER_PERIODS | NUMBER | 38 | 0 | The number of periods for creating the recurrence | |||
RECURRING_PARENT_REVENUE_ID | NUMBER | 38 | 0 | Parent revenue id for the recurrence | |||
RECURRING_QUANTITY | NUMBER | The recurrence quantity | |||||
RECURRING_REVENUE_AMOUNT | NUMBER | The revenue amount for the recurrence | |||||
RECURRING_REVENUE_INDICATOR | VARCHAR2 | 16 | Derived from column RECURRING_TYPE_CODE, will store "P" for parent recurrence, "C" for child recurrence and "N" for all the non recurring records. | ||||
RECURRING_START_DATE | DATE | The recurrence start date | |||||
RECURRING_TYPE_CODE | VARCHAR2 | 32 | Recurring type code | DW_CXS_RECURRENCE_TYPE_CODE_D_TL | CODE | ||
RECURRING_UNIT_PRICE | NUMBER | Unit price for the recurrence | |||||
REVENUE_AMOUNT | NUMBER | Revenue amount | |||||
REVENUE_CATEGORY_CODE | VARCHAR2 | 32 | Revenue Category | DW_CXS_REVENUE_CATEGORY_D_TL | CODE | ||
REVENUE_LINE_TYPE_CODE | VARCHAR2 | 32 | Type such as Opportunity Summary Revenue Standard Revenue | DW_CXS_REVENUE_LINE_TYPE_CODE_D_TL | CODE | ||
REVENUE_NUMBER | VARCHAR2 | 32 | User editable revenue number. Defaulted from REVN_ID. Needs to be unique cannot be NULL | ||||
REVENUE_SEQUENCE_NUMBER | NUMBER | 38 | 0 | Revenue Sequence number | |||
REVENUE_TYPE_CODE | VARCHAR2 | 64 | Indicates revenue type | DW_CXS_TYPE_CODE_D_TL | CODE | ||
SALES_ACCOUNT_ID | NUMBER | 38 | 0 | Sales Account Id | DW_CXS_SALES_ACCOUNT_D | SALES_ACCOUNT_ID | |
SALES_CREDIT_TYPE_CODE | VARCHAR2 | 32 | Quota or Non-quota sales credit type | DW_CXS_SALES_CREDIT_TYPE_CODE_D_TL | CODE | ||
SPLIT_PARENT_REVENUE_ID | NUMBER | 38 | 0 | Split parent revenue id | |||
SPLIT_PERCENT | NUMBER | Split percent | |||||
SPLIT_REVENUE_INDICATOR | VARCHAR2 | 32 | Derived from column SPLIT_TYPE_CODE, will store P for parent split, C for child split and N for all the non split records. | ||||
SPLIT_TYPE_CODE | VARCHAR2 | 32 | Split type code | DW_CXS_SPLIT_TYPE_CODE_D_TL | CODE | ||
STATUS_CODE | VARCHAR2 | 64 | Revenue status code | DW_CXS_STATUS_CODE_D_TL | CODE | ||
TOP_PARENT_REVENUE_NUMBER | VARCHAR2 | 32 | Revenue number of the Revenue Line the split recurrence or the split of the recurrence rolls up to. It is non-unique and can be NULL | ||||
UNIT_PRICE | NUMBER | Unit Price | |||||
UOM_CODE | VARCHAR2 | 32 | Unit of measure code for product | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
WIN_PROBABILITY | NUMBER | Win probability percent | |||||
REVENUE_STATUS_CATEGORY | VARCHAR2 | 32 | Revenue Sales Status Category | DW_CXS_STATUS_CATEGORY_D_TL | CODE | ||
PRIMARY_COMPETITOR_PARTY_ID | NUMBER | Primary Competitor | DW_CXS_COMPETITOR_D | COMPETITOR_ID | |||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. | ||||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly | ||||
CRM_REVENUE_AMOUNT | NUMBER | CRM Revenue amount | |||||
OPPORTUNITY_CURRENCY_CODE | VARCHAR2 | 16 | currency code for the extensibility | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
OPPORTUNITY_CURRENCY_REVENUE_AMOUNT | NUMBER | Opportunity currency Revenue amount | |||||
OPPORTUNITY_NAME | VARCHAR2 | 512 | Opportunity Name | ||||
OPPORTUNITY_CREATION_DATE | DATE | Truncated Opportunity creation date for functional use.Can be used for DATE dimension join | |||||
OPPORTUNITY_CURRENT_SALES_STAGE_ID | NUMBER | 38 | 0 | Current Sales Stage | DW_CXS_SALES_STAGE_D_TL | SALES_STAGE_ID | |
OPPORTUNITY_CLOSE_DATE | DATE | Expected close date unless the opportunity is closed. When opportunity closed then actual close date. | |||||
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID | NUMBER | 38 | 0 | Primary Competitor | DW_CXS_COMPETITOR_D | COMPETITOR_ID | |
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID | NUMBER | 38 | 0 | Primary Partner asociated with the opportunity | DW_CXS_PARTNER_D | PARTNER_ID | |
GLOBAL_REVENUE_AMOUNT | NUMBER | Global Revenue amount | |||||
PRODUCT_ID | NUMBER | 38 | 0 | Stores Product group ID if Item ID is null, else it will store Item ID | |||
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Salesrep or partner ID | DW_CXS_RESOURCE_D | RESOURCE_ID | |
SALES_ACCOUNT_OWNER_PARTY_ID | NUMBER | 38 | 0 | Sales Account owner Id | DW_CXS_RESOURCE_D | RESOURCE_ID | |
PRIMARY_TERRITORY_OWNER_PARTY_ID | NUMBER | 38 | 0 | Primary territory owner id | DW_CXS_RESOURCE_D | RESOURCE_ID | |
ITEM_OR_PRODUCT_GROUP | VARCHAR2 | 32 | Indicates whether Revenue line is ProductGroup Or Item | ||||
GLOBAL_EXPECTED_AMOUNT | NUMBER | Global Expected revenue amount | |||||
CRM_CURRENCY_EXPECTED_AMOUNT | NUMBER | CRM currency Expected revenue amount | |||||
OPPORTUNITY_CURRENCY_EXPECTED_AMOUNT | NUMBER | Opportunity currency Expected revenue amount | |||||
GLOBAL_RECOMMENDED_REVENUE_AMOUNT | NUMBER | Global Recommended Revenue Amount | |||||
CRM_CURRENCY_RECOMMENDED_REVENUE_AMOUNT | NUMBER | CRM currency Recommended Revenue Amount | |||||
OPPORTUNITY_CURRENCY_RECOMND_REVENUE_AMT | NUMBER | Opportunity currency Recommended Revenue Amount | |||||
GLOBAL_RECURRING_REVENUE_AMOUNT | NUMBER | Global revenue amount for the recurrence | |||||
CRM_CURRENCY_RECURRING_REVENUE_AMOUNT | NUMBER | CRM currency revenue amount for the recurrence | |||||
OPPORTUNITY_CURRENCY_RECURNG_REVENUE_AMT | NUMBER | Opportunity currency revenue amount for the recurrence | |||||
GLOBAL_RECURRING_UNIT_PRICE | NUMBER | Global Unit price for the recurrence | |||||
CRM_CURRENCY_RECURRING_UNIT_PRICE | NUMBER | CRM currency Unit price for the recurrence | |||||
OPPORTUNITY_CURRENCY_RECURRING_UNITPRICE | NUMBER | Opportunity currency Unit price for the recurrence | |||||
GLOBAL_UNIT_PRICE | NUMBER | Global Unit Price | |||||
CRM_CURRENCY_UNIT_PRICE | NUMBER | CRM currency Unit Price | |||||
OPPORTUNITY_CURRENCY_UNIT_PRICE | NUMBER | Opportunity currency Unit Price | |||||
CAMPAIGN_ID | NUMBER | 38 | 0 | Campaign Identifier | |||
CAMPAIGN_ACTUAL_COST | NUMBER | Amount of money spent to run the campaign. | |||||
CAMPAIGN_BUDGETED_COST | NUMBER | Amount of money budgeted for the campaign. | |||||
CAMPAIGN_CURRENCY_CODE | VARCHAR2 | 16 | Currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CAMPAIGN_OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Owner of the campaign row. | DW_CXS_RESOURCE_D | RESOURCE_ID | |
CAMPAIGN_CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
CAMPAIGN_REGION_CODE | VARCHAR2 | 128 | Region code of the Campaign. | ||||
CAMPAIGN_NAME | VARCHAR2 | 128 | Name of the campaign | ||||
CAMPAIGN_START_DATE | DATE | Starting Date for the campaign | |||||
CAMPAIGN_END_DATE | DATE | Ending date for the campaign. Responses received after this date are still counted | |||||
CAMPAIGN_PRODUCT_DESCRIPTION | VARCHAR2 | 128 | Product Name on the Campaign. | ||||
CAMPAIGN_STATUS_CODE | VARCHAR2 | 32 | Status code of the Campaign created. ('ORA_DRAFT', 'ORA_COMPLETED, ORA_ACTIVE') | DW_CXM_CAMPAIGN_STATUS_D_TL | CODE | ||
CAMPAIGN_TYPE_CODE | VARCHAR2 | 32 | Type of campaign. ( 'ORA_EVENT','ORA_BLOG_POST') | DW_CXM_CAMPAIGN_TYPE_D_TL | CODE | ||
CAMPAIGN_DESCRIPTION | VARCHAR2 | 999 | Description of the campaign | ||||
CAMPAIGN_ACTIVE_FLAG | VARCHAR2 | 16 | Indicates whether the campaign is active('Y') or not ('N') | ||||
GLOBAL_CURRENCY_CAMPAIGN_ACTUAL_COST | NUMBER | Campaign actual cost in global currency | |||||
GLOBAL_CURRENCY_CAMPAIGN_BUDGETED_COST | NUMBER | Campaign budgeted cost in global currency | |||||
CAMPAIGN_CREATION_DATE | DATE | Who column: indicates the date of the creation of the row. | |||||
SOURCED_FROM_CAMPAIGN_FLAG | VARCHAR2 | 16 | Flag to identifiy if an opportunity is linked to any marketing campaign | ||||
CREATED_BY_MODULE | VARCHAR2 | 32 | Created By Module, it will be used to identify the opportunities converted from leads | ||||
CONTRACT_START_DATE | DATE | The start date of the contract for the quote | |||||
CONTRACT_START_TIMESTAMP | TIMESTAMP | The start date and time of the contract for the quote | |||||
CONTRACT_END_DATE | DATE | The end date of the contract for the quote | |||||
CONTRACT_END_TIMESTAMP | TIMESTAMP | The end date and time of the contract for the quote | |||||
REVENUE_TYPE_CATEGORY | VARCHAR2 | 32 | The Revenue category type on the opportunity revenue line. | DW_CXS_REVENUE_CATEGORY_TYPE_D_TL | CODE | ||
NON_RECURRING_REVENUE | NUMBER | Non-Recurring Revenue Amount | |||||
RECURRING_REVENUE | NUMBER | The recurring revenue amount on the revenue line | |||||
USAGE_REVENUE | NUMBER | The usage revenue amount on the revenue line | |||||
MONTHLY_RECURRING_REVENUE | NUMBER | The monthly recurring revenue on the revenue line | |||||
MONTHLY_USAGE_REVENUE | NUMBER | The monthly usage revenue on the revenue line | |||||
CRM_CURRENCY_NON_RECURRING_REVENUE | NUMBER | Non-Recurring Revenue Amount in CRM currency | |||||
CRM_CURRENCY_RECURRING_REVENUE | NUMBER | The recurring revenue amount on the revenue line in CRM currency | |||||
CRM_CURRENCY_USAGE_REVENUE | NUMBER | The usage revenue amount on the revenue line in CRM currency | |||||
CRM_CURRENCY_MONTHLY_RECURRING_REVENUE | NUMBER | The monthly recurring revenue on the revenue line in CRM currency | |||||
CRM_CURRENCY_MONTHLY_USAGE_REVENUE | NUMBER | The monthly usage revenue on the revenue line in CRM currency | |||||
GLOBAL_CURRENCY_NON_RECURRING_REVENUE | NUMBER | Non-Recurring Revenue Amount in Global currency | |||||
GLOBAL_CURRENCY_RECURRING_REVENUE | NUMBER | The recurring revenue amount on the revenue line in Global currency | |||||
GLOBAL_CURRENCY_USAGE_REVENUE | NUMBER | The usage revenue amount on the revenue line in Global currency | |||||
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE | NUMBER | The monthly recurring revenue on the revenue line in Global currency | |||||
GLOBAL_CURRENCY_MONTHLY_USAGE_REVENUE | NUMBER | The monthly usage revenue on the revenue line in Global currency | |||||
PRICE_TYPE_CODE | VARCHAR2 | 32 | The type of pricing associated with the revenue line | DW_CXS_PRICE_TYPE_D_TL | CODE | ||
OPPORTUNITY_QUOTES_ASSOCIATION_FLAG | VARCHAR2 | 16 | Opporunity quote assoisction flag | ||||
OPPORTUNITY_EXPECTED_CLOSE_DATE | DATE | Expected close date unless the opportunity is closed. When opportunity closed then actual close date. | |||||
PRIMARY_CAMPAIGN_ID | NUMBER | 38 | 0 | Primary Campaign Id of the Opportunity. Reference Key to Campaign object. | |||
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID | NUMBER | 38 | 0 | Primary Contact | DW_CXS_COMPETITOR_D | COMPETITOR_ID |
Copyright © 2019, 2024, Oracle and/or its affiliates.