This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | Interface table to store the currency rates obtained from GL |
---|
Interface table to store the currency conversion rate from transaction currency to BIS Primary Global Currency. Currency rates are obtained from FII and GL APIs. The interface table is used in base summary concurrent program for better performance.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_CURRENCY_RATE_U1 | UNIQUE | APPS_TS_INTERFACE |
CURRENCY_CODE
EXCHANGE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (15) | Y | Transaction Currency code |
EXCHANGE_DATE | DATE | Y | Date of the currency conversion | |
EXCHANGE_RATE | NUMBER | Currency conversion rate from transaction currency to BIS Primary Global Currency | ||
EXCHANGE_RATE_S | NUMBER | Currency conversion rate from transaction currency to BIS Secondary Global Currency |
BIL.BIL_BI_CURRENCY_RATE does not reference any database object
BIL.BIL_BI_CURRENCY_RATE is referenced by following:
Description: | Temporary staging table to be used by the pipeline base summary |
---|
Temporary staging table to be used by the pipeline base summary collection program
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_DENLOG_STG_N1 | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_LINE_ID | NUMBER | Lead line identifier | ||
SALES_CREDIT_ID | NUMBER | sales credit identifier | ||
SALESGROUP_ID | NUMBER | Sales group identifier | ||
SALESFORCE_ID | NUMBER | Salesrep identifier | ||
LEAD_ID | NUMBER | Lead identifier | ||
WIN_PROBABILITY | NUMBER | win probability | ||
CURRENCY_CODE | VARCHAR2 | (240) | Currency code | |
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | win loss indicator | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Indicates whether opportunity is included in forecast | |
ITEM_ID | NUMBER | Item identifier | ||
ITEM_ORGANIZATION_ID | NUMBER | Organization identifier | ||
LEAD_NUMBER | VARCHAR2 | (30) | Lead Number | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier | ||
OPEN_STATUS_FLAG | VARCHAR2 | (1) | Indicates whether opportunity is in open status | |
CREDIT_AMOUNT | NUMBER | credit amount | ||
LAST_UPDATE_DATE | DATE | Last update date | ||
DECISION_DATE | DATE | Decision date | ||
PRIM_CONVERSION_RATE | NUMBER | Conversion rate for primary currency | ||
CONVERSION_RATE_S | NUMBER | Conversion rate for secondary currency |
BIL.BIL_BI_DENLOG_STG does not reference any database object
BIL.BIL_BI_DENLOG_STG is referenced by following:
Description: | Sales Forecast Base Summary table contains the summarized data for forecast by period for each sales group and salesperson. |
---|
Sales Forecast Base Summary table contains the summarized data for forecast by period for each sales group and salesperson.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_FST_DTL_F_U1 | UNIQUE | APPS_TS_SUMMARY |
TXN_TIME_ID
TXN_PERIOD_TYPE_ID FORECAST_TIME_ID FORECAST_PERIOD_TYPE_ID SALES_GROUP_ID SALESREP_ID PRODUCT_CATEGORY_ID CREDIT_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TXN_TIME_ID | NUMBER | Y | Time Id based on forecast submission date | |
TXN_PERIOD_TYPE_ID | NUMBER | Y | Period type id based on submission date | |
FORECAST_TIME_ID | NUMBER | Y | Time id based on forecast period | |
FORECAST_PERIOD_TYPE_ID | NUMBER | Y | Period type id based on forecast period | |
SALES_GROUP_ID | NUMBER | Y | Sales group identifier | |
FORECAST_CATEGORY_ID | NUMBER | Obsolete. Forecast Category Identifier | ||
PRODUCT_CATEGORY_ID | NUMBER | Y | Product Category Identifier | |
CREDIT_TYPE_ID | NUMBER | Y | Credit type identifier | |
SALESREP_ID | NUMBER | Salesrep identifier | ||
FORECAST_AMT | NUMBER | Forecast Amount In Primary Global Currency | ||
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard who column | |
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
FORECAST_AMT_S | NUMBER | Forecast Amount In Secondary Global Currency | ||
OPP_FORECAST_AMT | NUMBER | Opportunity forecast amount in primary currency | ||
OPP_FORECAST_AMT_S | NUMBER | Opportunity forecast amount in secondary currency |
BIL.BIL_BI_FST_DTL_F does not reference any database object
BIL.BIL_BI_FST_DTL_F is referenced by following:
Description: | Staging table used to populate the fact table BIL_BI_FST_DTL_F |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_FST_DTL_STG_N1 | NONUNIQUE | APPS_TS_INTERFACE |
SALES_GROUP_ID
PRODUCT_CATEGORY_ID PERIOD_NAME SUBMISSION_DATE CREDIT_TYPE_ID SALESREP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ID | NUMBER | Forecast Identifier | ||
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Forecast Period Name | |
FORECAST_CATEGORY_ID | NUMBER | Obsolete. Forecast category Identifier. Replaced with product_category_id. | ||
PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
CREDIT_TYPE_ID | NUMBER | Y | Credit Type Identifier | |
SALES_GROUP_ID | NUMBER | Y | Sales Group Identifier | |
SALESREP_ID | NUMBER | Salesrep Identifier | ||
TXN_DAY | NUMBER | Time id of the day corresponding to the forecast submission date | ||
TXN_WEEK | NUMBER | Time id of the week corresponding to the forecast submission date | ||
TXN_PERIOD | NUMBER | Time id of the period (month, etc.) corresponding to the forecast submission date | ||
TXN_QUARTER | NUMBER | Time id of the quarter corresponding to the forecast submission date | ||
TXN_YEAR | NUMBER | Time id of the year corresponding to the forecast submission date | ||
FORECAST_PERIOD_DAY | NUMBER | Time id of the day corresponding to the forecast period | ||
FORECAST_PERIOD_WEEK | NUMBER | Time id of the week corresponding to the forecast period | ||
FORECAST_PERIOD_PERIOD | NUMBER | Time id of the period (month, etc.) corresponding to the forecast period | ||
FORECAST_PERIOD_QUARTER | NUMBER | Time id of the quarter corresponding to the forecast period | ||
FORECAST_PERIOD_YEAR | NUMBER | Time id of the year corresponding to the forecast period | ||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Functional currency code | |
PRIMARY_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
FORECAST_AMT | NUMBER | Forecast Amount In Primary Global Currency | ||
VALID_FLAG | VARCHAR2 | (1) | Flag to indicate whether the row is valid - the time id is in the time dimension | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency | ||
FORECAST_AMT_S | NUMBER | Forecast Amount In Secondary Global Currency | ||
FORECAST_AMT_1 | NUMBER | Dummy Column For Summary Adjustment In Primary Global Currency | ||
FORECAST_AMT_S_1 | NUMBER | Dummy Column For Summary Adjustment In Secondary Global Currency | ||
OPP_FORECAST_AMT | NUMBER | Opportunity forecast amount in primary currency | ||
OPP_FORECAST_AMT_S | NUMBER | Opportunity forecast amount in secondary currency | ||
OPP_FORECAST_AMT_1 | NUMBER | Column used for performing summary adjustments | ||
OPP_FORECAST_AMT_S_1 | NUMBER | Column used for performing summary adjustments in secondary currency |
BIL.BIL_BI_FST_DTL_STG does not reference any database object
BIL.BIL_BI_FST_DTL_STG is referenced by following:
Description: | Used for Index Management of Materialized Views |
---|
Used for Index Management of Materialized Views
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (240) | Table(Materialized View ) Name for which the Index Management is done | |
INDEX_NAME | VARCHAR2 | (240) | Name of Index being dropped and created | |
DDL_STMNT | VARCHAR2 | (4000) | To store the DDL statement of the Index |
BIL.BIL_BI_INDEX_MGMT does not reference any database object
BIL.BIL_BI_INDEX_MGMT is referenced by following:
Description: | Table that holds the forecast id's of the new forecasts processed in one run of the concurrent program that populates the fact table. It is truncated before each run. |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_NEW_FST_ID_U1 | UNIQUE | APPS_TS_INTERFACE | FORECAST_ID |
BIL_BI_NEW_FST_ID_U2 | UNIQUE | APPS_TS_INTERFACE | RECORD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_ID | NUMBER | Obsolete column, do not use.Record identifier | ||
FORECAST_ID | NUMBER | Y | Forecast identifier | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
CURRENCY_CODE | VARCHAR2 | (15) | Transactional Currency Code | |
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Forecasted Period Name | |
COLLECT_MODE | VARCHAR2 | (15) | Collectection Mode - INITIAL or INCREMENTAL |
BIL.BIL_BI_NEW_FST_ID does not reference any database object
BIL.BIL_BI_NEW_FST_ID is referenced by following:
Description: | Denormalized table containing the opportunity log id's used for populating opportunity detail summary table. |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_OPDTL_DENLOG_TMP_N1 | NONUNIQUE | APPS_TS_INTERFACE |
LEAD_ID
LEAD_LINE_ID SALES_CREDIT_ID |
BIL_BI_OPDTL_DENLOG_TMP_N2 | NONUNIQUE | APPS_TS_INTERFACE | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Lead identifier | ||
LEAD_LOG_ID | NUMBER | Lead log id - from AS_LEADS_LOG table | ||
LEAD_LINE_ID | NUMBER | Lead line identifier | ||
LEAD_LINE_LOG_ID | NUMBER | Lead line log id - from AS_LEAD_LINES_LOG table | ||
SALES_CREDIT_ID | NUMBER | Sales credit identifier | ||
SALES_CREDIT_LOG_ID | NUMBER | Sales credit log id - from AS_SALES_CREDITS_LOG table | ||
REV_FLAG | VARCHAR2 | (240) | Indicates whether this is a reversal row | |
CREATION_DATE | DATE | Obsolete | ||
LAST_UPDATE_DATE | DATE | Last update date | ||
CONVERSION_DATE | DATE | Obsolete | ||
SEQ_NO | NUMBER | Stores row number | ||
SECURITY_GROUP_ID | NUMBER | Standard who column |
BIL.BIL_BI_OPDTL_DENLOG_TMP does not reference any database object
BIL.BIL_BI_OPDTL_DENLOG_TMP is referenced by following:
Description: | Sales Opportunity Base Summary fact table contains daily snapshot of opportunity information by sales credits. |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_OPDTL_F_U1 | UNIQUE | APPS_TS_SUMMARY | SALES_CREDIT_ID |
BIL_BI_OPDTL_F_N1 | NONUNIQUE | APPS_TS_SUMMARY |
ITEM_ID
ITEM_ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPTY_ID | NUMBER | Y | Identifier for the opportunity | |
TXN_TIME_ID | NUMBER | Y | Last update date of the transaction expressed in Julian format | |
OPTY_CREATION_TIME_ID | NUMBER | Opportunity creation date expressed in Julian format | ||
OPTY_CLOSE_TIME_ID | NUMBER | Y | Opportunity line forecast date for open & won status, close date for other statuses | |
OPTY_LD_CONVERSION_TIME_ID | NUMBER | Date when opportunity is converted from a lead expressed in Julian format. | ||
SALES_GROUP_ID | NUMBER | Y | Sales group who gets the sales credit | |
SALESREP_ID | NUMBER | Y | Salesperson who gets sales credit | |
PRODUCT_CATEGORY_ID | NUMBER | Y | Product category identifier of opporunity purchase line | |
ITEM_ID | NUMBER | Item identifier associated with the opporunity purchase line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in. | ||
CUSTOMER_ID | NUMBER | Customer identifier of the opportunity. | ||
CAMPAIGN_OBJECT_ID | NUMBER | Obsolete | ||
CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Obsolete | |
CHILD_CAMPAIGN_OBJECT_ID | NUMBER | Obsolete | ||
CHILD_CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Obsolete | |
WIN_PROBABILITY | NUMBER | Win probability for the opportunity | ||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Flag that indicates whether the opportunity was won or lost or not an opportunity | |
OPEN_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates whether the opportunity is open or closed | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Flag that indicates whether the sales credit amount is added to the pipeline for forecasting | |
REV_FLAG | VARCHAR2 | (1) | Obsolete column. Do not use. | |
SALES_CREDIT_AMT | NUMBER | Sales credit amount in primary global currency | ||
CREATED_BY | NUMBER | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard who column | |
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update record | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
TXN_DATE | DATE | Obsolete column, do not use. Transaction date -last update date of the opportunity | ||
EFFECTIVE_DATE | DATE | Obsolete column. Do not use. Decision date for the opportunity | ||
WON_AMT | NUMBER | Obsolete column. Do not use. Won amount | ||
LOST_AMT | NUMBER | Obsolete column. Do not use. Lost amount | ||
NO_OPTY_AMT | NUMBER | Obsolete column. Do not use. No opportunity amount | ||
PIPELINE_AMT | NUMBER | Obsolete column. Do not use. Pipeline amount | ||
WTD_PIPELINE_PB1 | NUMBER | Obsolete column. Do not use. Pipeline with win probability between 0 and 25 percent | ||
WTD_PIPELINE_PB2 | NUMBER | Obsolete column. Do not use. Pipeline with win probability between 26 and 50 percent | ||
WTD_PIPELINE_PB3 | NUMBER | Obsolete column. Do not use. Pipeline with win probability between 51 and 75 percent | ||
WTD_PIPELINE_PB4 | NUMBER | Obsolete column. Do not use. Pipeline with win probability between 76 and 99 percent | ||
WTD_PIPELINE_PB5 | NUMBER | Obsolete column. Do not use. Pipeline with win probability 100 percent | ||
COMPETITOR_ID | NUMBER | Key competitor at the opportunity header level. | ||
HDR_SOURCE_PROMOTION_ID | NUMBER | Header marketing source promotion identifier | ||
OWNER_SALES_GROUP_ID | NUMBER | The owner sales group id of the opportunity header. | ||
OWNER_SALESREP_ID | NUMBER | Ownere sales rep id of the opportunity header. | ||
OPTY_AMT | NUMBER | Total opportunity amount in primary global currency (from the header). | ||
SALES_STAGE_ID | NUMBER | Identifier for the sales stage that the opportunity is in. | ||
LEAD_NUMBER | VARCHAR2 | (30) | Lead number is the user level identifier for an opportunity | |
STATUS | VARCHAR2 | (30) | Current status code of the opportunity. | |
LEAD_LINE_ID | NUMBER | Lead line identifier | ||
SALES_CREDIT_ID | NUMBER | Sales credit identifier | ||
OPTY_EFFECTIVE_TIME_ID | NUMBER | Close time is of an opportunity | ||
OPTY_RANK | NUMBER | Rank of opportunity line by forecast date, used in opportunity count columns. | ||
SALES_CREDIT_AMT_S | NUMBER | Sales Credit Amount In Secondary Global Currency | ||
OPTY_AMT_S | NUMBER | Total opportunity amount in secondary global currency (from the header). |
BIL.BIL_BI_OPDTL_F does not reference any database object
BIL.BIL_BI_OPDTL_F is referenced by following:
Description: | Staging table used to populate fact table bil_bi_opdtl_f |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_OPDTL_STG_U1 | UNIQUE | APPS_TS_INTERFACE |
LEAD_ID
LEAD_LINE_ID SALES_CREDIT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Y | Opportunity identifier | |
LEAD_LINE_ID | NUMBER | Opportunity purchase line identifier | ||
SALES_CREDIT_ID | NUMBER | Sales credit identifier | ||
TXN_DATE | DATE | Y | Opportunity last update date | |
EFFECTIVE_DATE | DATE | Y | Opportunity decision date | |
OPTY_CREATION_DATE | DATE | Opportunity creation date in julian format | ||
OPTY_LD_CONVERSION_DATE | DATE | Date an opporunity is converted from a lead expressed in Julian format | ||
VALID_FLAG | VARCHAR2 | (1) | Indicates whether the row is valid | |
REV_FLAG | VARCHAR2 | (1) | Reversal flag | |
TXN_CURRENCY | VARCHAR2 | (15) | Transaction currency | |
PRIM_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
SALES_GROUP_ID | NUMBER | Y | Sales group identifier | |
SALESREP_ID | NUMBER | Y | Salesrep identifier | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier of the opporunity line | ||
INTEREST_TYPE_ID | NUMBER | Interest type identifier of the opportunity line | ||
PRIMARY_INTEREST_CODE_ID | NUMBER | Primary interest code identifier for the opportunity line | ||
SECONDARY_INTEREST_CODE_ID | NUMBER | Secondary interest code identifier for the opportunity line | ||
ITEM_ID | NUMBER | Item id associated with the opporunity line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in | ||
CUSTOMER_ID | NUMBER | Customer identifier of the opportunity. | ||
HDR_SOURCE_PROMOTION_ID | NUMBER | Header makerting source promotion id | ||
CAMPAIGN_OBJECT_ID | NUMBER | Campaign or Parent Campaign Object Identifier corresponding to opportunity header source promotion. It represents parent for campaign / event schedules source promotion. | ||
CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Campaign or Parent Campaign Object Type corresponding to opportunity header source promotion. It represents parent for campaign / event schedules source promotion. | |
CHILD_CAMPAIGN_OBJECT_ID | NUMBER | Campaign Object Identifier corresponding to opportunity header source promotion for campaign / event schedules source promotion. | ||
CHILD_CAMPAIGN_OBJECT_TYPE | VARCHAR2 | (30) | Campaign Object Type corresponding to opportunity header source promotion for campaign / event schedules source promotion. | |
WIN_PROBABILITY | NUMBER | Win probability | ||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Flag that indicates whether the opportunity was won or lost or not an opportunity | |
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates whether the opportunity is open or closed | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Flag that indicates whether the sales credit amount is added to the pipeline for forecast | |
LEAD_NUMBER | VARCHAR2 | (30) | The opportunity number that user can use to search for an opportunity | |
OPTY_GLOBAL_AMT | NUMBER | Total opportunity amount. Same as opty_amt in bil_bi_opdtl_f | ||
SALES_CREDIT_AMOUNT | NUMBER | Sales credit amount | ||
DELETE_FLAG | VARCHAR2 | (1) | Obsolete. Flag that indicates whether the sales credit was deleted | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
COMPETITOR_ID | NUMBER | Key competitor at the opportunity header level. | ||
OWNER_SALES_GROUP_ID | NUMBER | The owner sales group id of the opportunity header. | ||
OWNER_SALESREP_ID | NUMBER | Owner salesrep id of the opportunity header. | ||
SALES_STAGE_ID | NUMBER | Identifier for the sales stage that the opportunity is in. | ||
STATUS | VARCHAR2 | (240) | Current status code of the opportunity. | |
CLOSE_DATE | DATE | Decision date or close date of an opportunity | ||
OPTY_RANK | NUMBER | Rank of opportunity line by forecast date, used in opportunity count columns. | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency |
BIL.BIL_BI_OPDTL_STG does not reference any database object
BIL.BIL_BI_OPDTL_STG is referenced by following:
Description: | Fact table for sales open and pipeline amounts for current dates - latest 3 weeks from sysdate |
---|
Fact table for sales open and pipeline amounts for current dates - latest 3 weeks from sysdate
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_PIPEC_F_U1 | UNIQUE | APPS_TS_TX_IDX |
SNAP_DATE
SALES_GROUP_ID SALESREP_ID ITEM_ID ITEM_ORGANIZATION_ID PRODUCT_CATEGORY_ID WIN_PROBABILITY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_GROUP_ID | NUMBER | Y | Sales group identifier | |
SALESREP_ID | NUMBER | Y | Salesrep identifier | |
SNAP_DATE | DATE | Y | The date on which the snapshot is taken. Snapshot before 6pm are considered taken for previous day. | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard who column | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier of opporunity purchase line | ||
ITEM_ID | NUMBER | Item identifier associated with the opporunity purchase line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in. | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
WIN_PROBABILITY | NUMBER | Win probability for the opportunity | ||
PIPELINE_AMT_DAY | NUMBER | Pipeline amount for the current day in primary global currency. | ||
PIPELINE_AMT_WEEK | NUMBER | Pipeline amount for the current week in primary global currency. | ||
PIPELINE_AMT_PERIOD | NUMBER | Pipeline amount for the current period in primary global currency. | ||
PIPELINE_AMT_QUARTER | NUMBER | Pipeline amount for the current quarter in primary global currency. | ||
PIPELINE_AMT_YEAR | NUMBER | Pipeline amount for the current year in primary global currency. | ||
OPEN_AMT_DAY | NUMBER | Open amount for the current day in primary global currency. | ||
OPEN_AMT_WEEK | NUMBER | Open amount for the current week in primary global currency. | ||
OPEN_AMT_PERIOD | NUMBER | Open amount for the current period in primary global currency. | ||
OPEN_AMT_QUARTER | NUMBER | Open amount for the current quarter in primary global currency. | ||
OPEN_AMT_YEAR | NUMBER | Open amount for the current year in primary global currency. | ||
PIPELINE_AMT_DAY_S | NUMBER | Pipeline amount for the current day in secondary global currency. | ||
PIPELINE_AMT_WEEK_S | NUMBER | Pipeline amount for the current week in secondary global currency. | ||
PIPELINE_AMT_PERIOD_S | NUMBER | Pipeline amount for the current period in secondary global currency. | ||
PIPELINE_AMT_QUARTER_S | NUMBER | Pipeline amount for the current quarter in secondary global currency. | ||
PIPELINE_AMT_YEAR_S | NUMBER | Pipeline amount for the current year in secondary global currency. | ||
OPEN_AMT_DAY_S | NUMBER | Open amount for the current day in secondary global currency. | ||
OPEN_AMT_WEEK_S | NUMBER | Open amount for the current week in secondary global currency. | ||
OPEN_AMT_PERIOD_S | NUMBER | Open amount for the current period in secondary global currency. | ||
OPEN_AMT_QUARTER_S | NUMBER | Open amount for the current quarter in secondary global currency. | ||
OPEN_AMT_YEAR_S | NUMBER | Open amount for the current year in secondary global currency. | ||
PRVWK_PIPE_AMT_DAY | NUMBER | Pipeline amount for the corresponding day in the prior week in primary global currency. | ||
PRVWK_PIPE_AMT_WK | NUMBER | Pipeline amount for the week as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_PIPE_AMT_PRD | NUMBER | Pipeline amount for the period as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_PIPE_AMT_QTR | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_PIPE_AMT_YR | NUMBER | Pipeline amount for the year as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_OPEN_AMT_DAY | NUMBER | Open amount for the corresponding day in the prior week in primary global currency. | ||
PRVWK_OPEN_AMT_WK | NUMBER | Open amount for the week as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_OPEN_AMT_PRD | NUMBER | Open amount for the period as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_OPEN_AMT_QTR | NUMBER | Open amount for the quarter as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_OPEN_AMT_YR | NUMBER | Open amount for the year as of the corresponding day in the prior week in primary global currency. | ||
PRVWK_PIPE_AMT_DAY_S | NUMBER | Pipeline amount for the corresponding day in the prior week in secondary global currency. | ||
PRVWK_PIPE_AMT_WK_S | NUMBER | Pipeline amount for the week as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_PIPE_AMT_PRD_S | NUMBER | Pipeline amount for the period as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_PIPE_AMT_QTR_S | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_PIPE_AMT_YR_S | NUMBER | Pipeline amount for the year as of the corresponding day in the prior week in secondary global currency | ||
PRVWK_OPEN_AMT_DAY_S | NUMBER | Pipeline amount for the corresponding day in the prior week in secondary global currency. | ||
PRVWK_OPEN_AMT_WK_S | NUMBER | Open amount for the week as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_OPEN_AMT_PRD_S | NUMBER | Open amount for the period as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_OPEN_AMT_QTR_S | NUMBER | Open amount for the quarter as of the corresponding day in the prior week in secondary global currency. | ||
PRVWK_OPEN_AMT_YR_S | NUMBER | Open amount for the year as of the corresponding day in the prior week in secondary global currency. | ||
PRVPRD_PIPE_AMT_DAY | NUMBER | Pipeline amount for the corresponding day in the prior period in primary global currency. | ||
PRVPRD_PIPE_AMT_WK | NUMBER | Pipeline amount for the week as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_PIPE_AMT_PRD | NUMBER | Pipeline amount for the period as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_PIPE_AMT_QTR | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_PIPE_AMT_YR | NUMBER | Pipeline amount for the year as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_OPEN_AMT_DAY | NUMBER | Open amount for the corresponding day in the prior period in primary global currency. | ||
PRVPRD_OPEN_AMT_WK | NUMBER | Open amount for the week as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_OPEN_AMT_PRD | NUMBER | Open amount for the period as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_OPEN_AMT_QTR | NUMBER | Open amount for the quarter as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_OPEN_AMT_YR | NUMBER | Pipeline amount for the year as of the corresponding day in the prior period in primary global currency. | ||
PRVPRD_PIPE_AMT_DAY_S | NUMBER | Pipeline amount for the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_PIPE_AMT_WK_S | NUMBER | Pipeline amount for the week as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_PIPE_AMT_PRD_S | NUMBER | Pipeline amount for the period as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_PIPE_AMT_QTR_S | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_PIPE_AMT_YR_S | NUMBER | Pipeline amount for the year as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_OPEN_AMT_DAY_S | NUMBER | Open amount for the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_OPEN_AMT_WK_S | NUMBER | Open amount for the week as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_OPEN_AMT_PRD_S | NUMBER | Open amount for the period as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_OPEN_AMT_QTR_S | NUMBER | Open amount for the quarter as of the corresponding day in the prior period in secondary global currency. | ||
PRVPRD_OPEN_AMT_YR_S | NUMBER | Open amount for the year as of the corresponding day in the prior period in secondary global currency. | ||
PRVQTR_PIPE_AMT_DAY | NUMBER | Pipeline amount for the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_PIPE_AMT_WK | NUMBER | Pipeline amount for the week as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_PIPE_AMT_PRD | NUMBER | Pipeline amount for the period as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_PIPE_AMT_QTR | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_PIPE_AMT_YR | NUMBER | Pipeline amount for the year as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_OPEN_AMT_DAY | NUMBER | Open amount for the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_OPEN_AMT_WK | NUMBER | Open amount for the week as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_OPEN_AMT_PRD | NUMBER | Open amount for the period as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_OPEN_AMT_QTR | NUMBER | Open amount for the quarter as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_OPEN_AMT_YR | NUMBER | Open amount for the year as of the corresponding day in the prior quarter in primary global currency. | ||
PRVQTR_PIPE_AMT_DAY_S | NUMBER | Pipeline amount for the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_PIPE_AMT_WK_S | NUMBER | Pipeline amount for the week as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_PIPE_AMT_PRD_S | NUMBER | Pipeline amount for the period as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_PIPE_AMT_QTR_S | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_PIPE_AMT_YR_S | NUMBER | Pipeline amount for the year as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_OPEN_AMT_DAY_S | NUMBER | Open amount for the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_OPEN_AMT_WK_S | NUMBER | Open amount for the week as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_OPEN_AMT_PRD_S | NUMBER | Open amount for the period as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_OPEN_AMT_QTR_S | NUMBER | Open amount for the quarter as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVQTR_OPEN_AMT_YR_S | NUMBER | Open amount for the year as of the corresponding day in the prior quarter in secondary global currency. | ||
PRVYR_PIPE_AMT_DAY | NUMBER | Pipeline amount for the corresponding day in the prior year in primary global currency. | ||
PRVYR_PIPE_AMT_WK | NUMBER | Pipeline amount for the week as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_PIPE_AMT_PRD | NUMBER | Pipeline amount for the period as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_PIPE_AMT_QTR | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_PIPE_AMT_YR | NUMBER | Pipeline amount for the year as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_OPEN_AMT_DAY | NUMBER | Open amount for the corresponding day in the prior year in primary global currency. | ||
PRVYR_OPEN_AMT_WK | NUMBER | Open amount for the week as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_OPEN_AMT_PRD | NUMBER | Open amount for the period as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_OPEN_AMT_QTR | NUMBER | Open amount for the quarter as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_OPEN_AMT_YR | NUMBER | Open amount for the year as of the corresponding day in the prior year in primary global currency. | ||
PRVYR_PIPE_AMT_DAY_S | NUMBER | Pipeline amount for the corresponding day in the prior year in secondary global currency. | ||
PRVYR_PIPE_AMT_WK_S | NUMBER | Pipeline amount for the week as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_PIPE_AMT_PRD_S | NUMBER | Pipeline amount for the period as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_PIPE_AMT_QTR_S | NUMBER | Pipeline amount for the quarter as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_PIPE_AMT_YR_S | NUMBER | Pipeline amount for the year as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_OPEN_AMT_DAY_S | NUMBER | Open amount for the corresponding day in the prior year in secondary global currency. | ||
PRVYR_OPEN_AMT_WK_S | NUMBER | Open amount for the week as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_OPEN_AMT_PRD_S | NUMBER | Open amount for the period as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_OPEN_AMT_QTR_S | NUMBER | Open amount for the quarter as of the corresponding day in the prior year in secondary global currency. | ||
PRVYR_OPEN_AMT_YR_S | NUMBER | Open amount for the year as of the corresponding day in the prior year in secondary global currency. |
BIL.BIL_BI_PIPEC_F does not reference any database object
BIL.BIL_BI_PIPEC_F is referenced by following:
Description: | Fact table for sales open and pipeline amounts for historical dates (older than 3 weeks from sysdate) |
---|
Fact table for sales open and pipeline amounts for historical dates (older than 3 weeks from sysdate)
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_PIPELINE_F_U1 | UNIQUE | APPS_TS_SUMMARY |
SNAP_DATE
SALES_GROUP_ID SALESREP_ID ITEM_ID ITEM_ORGANIZATION_ID PRODUCT_CATEGORY_ID WIN_PROBABILITY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_GROUP_ID | NUMBER | Y | Sales group identifier | |
SALESREP_ID | NUMBER | Y | Salesrep identifier | |
SNAP_DATE | DATE | Y | The date on which the snapshot is taken. Snapshot before 6pm are considered taken for previous day. | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard who column | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier of opporunity purchase line | ||
ITEM_ID | NUMBER | Item identifier associated with the opporunity purchase line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in. | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
REQUEST_ID | NUMBER | Request identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
WIN_PROBABILITY | NUMBER | Win probability for the opportunity | ||
PIPELINE_AMT_DAY | NUMBER | Pipeline amount for the current day in primary global currency. | ||
PIPELINE_AMT_WEEK | NUMBER | Pipeline amount for the current week in primary global currency. | ||
PIPELINE_AMT_PERIOD | NUMBER | Pipeline amount for the current period in primary global currency. | ||
PIPELINE_AMT_QUARTER | NUMBER | Pipeline amount for the current quarter in primary global currency. | ||
PIPELINE_AMT_YEAR | NUMBER | Pipeline amount for the current year in primary global currency. | ||
OPEN_AMT_DAY | NUMBER | Open amount for the current day in primary global currency. | ||
OPEN_AMT_WEEK | NUMBER | Open amount for the current week in primary global currency. | ||
OPEN_AMT_PERIOD | NUMBER | Open amount for the current period in primary global currency. | ||
OPEN_AMT_QUARTER | NUMBER | Open amount for the current quarter in primary global currency. | ||
OPEN_AMT_YEAR | NUMBER | Open amount for the current year in primary global currency. | ||
PIPELINE_AMT_DAY_S | NUMBER | Pipeline amount for the current day in secondary global currency. | ||
PIPELINE_AMT_WEEK_S | NUMBER | Pipeline amount for the current week in secondary global currency. | ||
PIPELINE_AMT_PERIOD_S | NUMBER | Pipeline amount for the current period in secondary global currency. | ||
PIPELINE_AMT_QUARTER_S | NUMBER | Pipeline amount for the current quarter in secondary global currency. | ||
PIPELINE_AMT_YEAR_S | NUMBER | Pipeline amount for the current year in secondary global currency. | ||
OPEN_AMT_DAY_S | NUMBER | Open amount for the current day in secondary global currency. | ||
OPEN_AMT_WEEK_S | NUMBER | Open amount for the current week in secondary global currency. | ||
OPEN_AMT_PERIOD_S | NUMBER | Open amount for the current period in secondary global currency. | ||
OPEN_AMT_QUARTER_S | NUMBER | Open amount for the current quarter in secondary global currency. | ||
OPEN_AMT_YEAR_S | NUMBER | Open amount for the current year in secondary global currency. |
BIL.BIL_BI_PIPELINE_F does not reference any database object
BIL.BIL_BI_PIPELINE_F is referenced by following:
Description: | Staging table for sales open and pipeline amounts |
---|
Staging table for sales open and pipeline amounts
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_PIPELINE_STG_N1 | NONUNIQUE | APPS_TS_INTERFACE |
SNAP_DATE
LEAD_ID LINE_ID CREDIT_ID |
BIL_BI_PIPELINE_STG_N2 | NONUNIQUE | APPS_TS_INTERFACE |
SNAP_DATE
SALES_GROUP_ID SALESREP_ID LEAD_ID ITEM_ID ITEM_ORGANIZATION_ID PRODUCT_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Y | Opportunity identifier | |
SALES_GROUP_ID | NUMBER | Y | Sales group identifier | |
SALESREP_ID | NUMBER | Y | Salesrep identifier | |
SNAP_DATE | DATE | Y | The date on which the snapshot is taken. Snapshot before 6pm are considered taken for previous day. | |
EFFECTIVE_DATE | DATE | Y | Opportunity decision date | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier of opporunity purchase line | ||
ITEM_ID | NUMBER | Item identifier associated with the opporunity purchase line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in. | ||
TXN_CURRENCY | VARCHAR2 | (15) | Transaction currency | |
PRIM_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Flag that indicates whether the opportunity was won or lost or not an opportunity | |
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates whether the opportunity is open or closed | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Flag that indicates whether the sales credit amount is added to the pipeline for forecasting | |
WIN_PROBABILITY | NUMBER | Win probability for the opportunity | ||
SALES_CREDIT_AMOUNT | NUMBER | Sales credit amount | ||
LEAD_NUMBER | VARCHAR2 | (30) | Lead number is the user level identifier for an opportunity | |
LINE_ID | NUMBER | Lead line identifier | ||
CREDIT_ID | NUMBER | sales credit identifier | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency |
BIL.BIL_BI_PIPELINE_STG does not reference any database object
BIL.BIL_BI_PIPELINE_STG is referenced by following:
Description: | Table that stores all processed forecasts. It is cummulative for all runs of the concurrent program tat populates the fact table. |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_PROCESSED_FST_ID_U1 | UNIQUE | APPS_TS_TX_IDX |
SALES_GROUP_ID
PRODUCT_CATEGORY_ID PERIOD_NAME CREDIT_TYPE_ID SUBMISSION_DATE SALESREP_ID |
BIL_BI_PROCESSED_FST_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ID | NUMBER | Y | Forecast Identifier | |
CREATED_BY | NUMBER | Y | Standard Who Column | |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Y | Standard Who Column | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard Who Column | ||
TXN_DAY | NUMBER | Transaction Day | ||
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Forecast Period Name | |
SALES_GROUP_ID | NUMBER | Sales Group Identifier | ||
SALESREP_ID | NUMBER | Sales Rep Identifier | ||
PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
CREDIT_TYPE_ID | NUMBER | Credit Type Identifier | ||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Functional Currency | |
PRIMARY_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency | ||
FORECAST_AMT | NUMBER | Forecast Amount In Primary Global Currency | ||
FORECAST_AMT_S | NUMBER | Forecast Amount In Secondary Global Currency | ||
OPP_FORECAST_AMT | NUMBER | Opportunity forecast amount in primary currency | ||
OPP_FORECAST_AMT_S | NUMBER | Opportunity forecast amount in secondary currency |
BIL.BIL_BI_PROCESSED_FST_ID does not reference any database object
BIL.BIL_BI_PROCESSED_FST_ID is referenced by following:
Description: | Interface table to be used by pipeline base summary collection program. |
---|
Interface table to be used by pipeline base summary collection program.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_DATE | DATE | Start date | ||
END_DATE | DATE | end date |
BIL.BIL_BI_TIME does not reference any database object
BIL.BIL_BI_TIME is referenced by following:
Description: | Table that stores info about the parallel workers spawned by the conc. program |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_BI_WORKER_JOBS_U1 | NONUNIQUE | APPS_TS_INTERFACE |
OBJECT_NAME
WORKER_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_NAME | VARCHAR2 | (240) | Y | Name of the table that the conc. program inserts data into |
START_RANGE | NUMBER | Y | Start of the range of id's processed by this worker | |
END_RANGE | NUMBER | Y | End of the range of id's processed by this worker | |
WORKER_NUMBER | NUMBER | Y | Identifier of the worker | |
STATUS | VARCHAR2 | (30) | Worker status | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column |
BIL.BIL_BI_WORKER_JOBS does not reference any database object
BIL.BIL_BI_WORKER_JOBS is referenced by following:
Description: | Data Out Level 1 table used for hierarchy of group levels for temporary use in collection programs. |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_DO_L1_BASE_GRP_TEMP_N1 | NONUNIQUE | APPS_TS_ARCHIVE | HIER_LEVEL |
BIL_DO_L1_BASE_GRP_TEMP_U1 | NONUNIQUE | APPS_TS_ARCHIVE | CHILD_SALES_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_GROUP_ID | NUMBER | Y | ||
CHILD_SALES_GROUP_ID | NUMBER | Y | ||
HIER_LEVEL | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | Y | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER |
BIL.BIL_DO_L1_BASE_GRP_TEMP does not reference any database object
BIL.BIL_DO_L1_BASE_GRP_TEMP is referenced by following:
Description: | Data Out Level 1 Lead to Opportunity Daily |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_DO_L1_LD_OPPTY_DLY_U1 | UNIQUE | APPS_TS_ARCHIVE |
SALES_GROUP_ID
COLLECTION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLLECTION_DATE | DATE | Y | ||
SALES_GROUP_ID | NUMBER | Y | ||
TOTAL_LEADS_ALL | NUMBER | |||
OPEN_LEADS_ALL | NUMBER | |||
OPEN_LEADS_DAY | NUMBER | |||
TOUCHED_LEADS_ALL | NUMBER | |||
TOUCHED_LEADS_DAY | NUMBER | |||
CONVERTED_LEADS_ALL | NUMBER | |||
CONVERTED_LEADS_DAY | NUMBER | |||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | Y | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER |
BIL.BIL_DO_L1_LD_OPPTY_DLY does not reference any database object
BIL.BIL_DO_L1_LD_OPPTY_DLY is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
BIL_DO_L1_OPPTY_SUMRY_U1 | UNIQUE | APPS_TS_ARCHIVE |
SALES_GROUP_ID
COLLECTION_DATE PERIOD_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLLECTION_DATE | DATE | Y | ||
SALES_GROUP_ID | NUMBER | Y | ||
PERIOD_NAME | VARCHAR2 | (15) | Y | |
PERIOD_TYPE | VARCHAR2 | (15) | Y | |
WON_AMOUNT | NUMBER | |||
OPEN_AMOUNT | NUMBER | |||
WEIGHTED_OPEN_AMOUNT | NUMBER | |||
FORECAST_AMOUNT | NUMBER | |||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | Y | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER |
BIL.BIL_DO_L1_OPPTY_SUMRY does not reference any database object
BIL.BIL_DO_L1_OPPTY_SUMRY is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTR1 | NUMBER | |||
ATTR2 | NUMBER | |||
ATTR3 | VARCHAR2 | (10) | ||
ATTR4 | VARCHAR2 | (80) | ||
ATTR5 | DATE |
BIL.BIL_TX_PROD_TMP does not reference any database object
BIL.BIL_TX_PROD_TMP is referenced by following:
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_COMP_PLANS - Dimension view used to provide descriptive information related to
sales compensation plans.
.
Source is Oracle CRM Sales Compensation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMP_PLAN_PK | NUMBER | Compensation Plan identifier | ||
COMP_PLAN_NAME | VARCHAR2 | (30) | Compensation Plan Name | |
COMP_PLAN_DESCRIPTION | VARCHAR2 | (1900) | Compensation Plan Description | |
COMP_PLAN_STATUS | VARCHAR2 | (30) | Compensation Plan Status | |
ALLOW_REV_CLASS_OVERLAP | VARCHAR2 | (1) | Compensation Plan Allow Rev Class Overlap | |
COMP_PLAN_START_DATE | DATE | Compensation Plan Start Date | ||
COMP_PLAN_END_DATE | DATE | Compensation Plan End Date | ||
ID | VARCHAR2 | (40) | Compensation Plan identifier | |
VALUE | VARCHAR2 | (80) | Compensation Plan Name |
APPS.BIL_DIMV_COMP_PLANS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_CREDIT_TYPES - view used to report on credit types by Sales Intelligence Pipeline
Analysis reports.
.
Source is Oracle CRM Sales Online schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Credit Type identifier | ||
VALUE | VARCHAR2 | (240) | Credit Type value |
APPS.BIL_DIMV_CREDIT_TYPE is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_CURRENCIES - Dimension view used to provide descriptive information related to
currency codes.
.
Source is Oracle Applications Foundation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (30) | Y | Currency Code identifier |
CURRENCY_NAME | VARCHAR2 | (80) | Y | Currency Code name |
CURRENCY_DESCRIPTION | VARCHAR2 | (240) | Currency Code description | |
COUNTRY_SHORT_NAME | VARCHAR2 | (2) | Territory short name | |
COUNTRY_FULL_NAME | VARCHAR2 | (0) | Territory description | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | Currency Code enabled flag |
START_DATE_ACTIVE | DATE | Currency Code start date active | ||
END_DATE_ACTIVE | DATE | Currency Code end date active | ||
ID | VARCHAR2 | (30) | Y | Currency Code identifier |
VALUE | VARCHAR2 | (80) | Y | Currency Code name |
APPS.BIL_DIMV_CURRENCIES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_CUSTOMERS - Dimension view used to provide access to customer names.
.
Source is Oracle Applications HR schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | Party identifier | ||
CUSTOMER_NAME | VARCHAR2 | (360) | Party name | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Unique identification number for this party. | |
PARTY_TYPE | VARCHAR2 | (80) | Type of the party; can be Person, Group, Organization or Relationship. | |
ADDRESS1 | VARCHAR2 | (240) | First line of the identifying address | |
ADDRESS2 | VARCHAR2 | (240) | Second line of the identifying address | |
ADDRESS3 | VARCHAR2 | (240) | Third line of the identifying address | |
ADDRESS4 | VARCHAR2 | (240) | Fourth line of the identifying address | |
CITY | VARCHAR2 | (80) | City of the identifying address | |
STATE | VARCHAR2 | (80) | State First line of the identifying address | |
COUNTRY | VARCHAR2 | (80) | Country of the identifying address | |
COUNTY | VARCHAR2 | (80) | County of the identifying address | |
PROVINCE | VARCHAR2 | (80) | Province of the identifying address | |
POSTAL_CODE | VARCHAR2 | (80) | Postal code of the identifying address | |
CREATION_DATE | DATE | Party identifier creation date | ||
ID | VARCHAR2 | (40) | Party identifier | |
VALUE | VARCHAR2 | (80) | Party name |
APPS.BIL_DIMV_CUSTOMERS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_EMP_STATUS - Dimension view used to provide access to descriptive information
related to employee status. Used for reporting on salesforce.
.
Source is Oracle Applications Human Resources schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMPLOYMENT_STATUS_PK | VARCHAR2 | (30) | Human Resource employee status lookup identifier | |
EMPLOYMENT_STATUS | VARCHAR2 | (80) | Human Resource employee lookup meaning | |
ENABLED_FLAG | VARCHAR2 | (1) | Human resource employee lookup enabled flag | |
START_DATE_ACTIVE | DATE | Human Resources employee status start date active | ||
END_DATE_ACTIVE | DATE | Human Resources employee status end date active | ||
DESCRIPTION | VARCHAR2 | (240) | Human Resources employee status description | |
ID | VARCHAR2 | (30) | Human Resource employee status lookup identifier | |
VALUE | VARCHAR2 | (80) | Human Resource employee lookup meaning |
APPS.BIL_DIMV_EMP_STATUS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_INTEREST_CODES - Dimension view used to provide descriptive information relating to
product interest codes.
.
Source is Oracle CRM Sales schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_CODE_PK | NUMBER | Interest code identifier | ||
INTEREST_TYPE_FK | NUMBER | Interest type identifier | ||
PARENT_INTEREST_CODE_FK | NUMBER | Parent interest code identifier | ||
INTEREST_CODE | VARCHAR2 | (100) | Interest code | |
DESCRIPTION | VARCHAR2 | (240) | Interest code description | |
ENABLED_FLAG | VARCHAR2 | (1) | Interest code enabled flag | |
ID | VARCHAR2 | (40) | Interest Code identifier | |
VALUE | VARCHAR2 | (80) | Interest Code description |
APPS.BIL_DIMV_INTEREST_CODES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_INTEREST_TYPES - Dimension view used to provide descriptive information relating to
product interest types.
.
Source is Oracle CRM Sales schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_TYPE_PK | NUMBER | Interest type identifier | ||
INTEREST_TYPE | VARCHAR2 | (80) | Interest type | |
DESCRIPTION | VARCHAR2 | (240) | Interest type description | |
ENABLED_FLAG | VARCHAR2 | (1) | Interest type enabled flag | |
ID | VARCHAR2 | (40) | Interest type identifier | |
VALUE | VARCHAR2 | (80) | Interest type description |
APPS.BIL_DIMV_INTEREST_TYPES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_JOB_TITLE - Dimension view used to provide descriptive information related to
employee job title. Used for reporting on salesforce.
.
Source is Oracle CRM Sales Schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_PK | NUMBER | Sales representative job identifier | ||
JOB_TITLE | VARCHAR2 | (700) | Sales representative job name | |
ID | VARCHAR2 | (40) | Sales representative job identifier | |
VALUE | VARCHAR2 | (700) | Sales representative job name |
APPS.BIL_DIMV_JOB_TITLE is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_OPTY - Dimension view used to provide access to opportunity names.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Lead Id | ||
LEAD_NUMBER | VARCHAR2 | (80) | Lead number | |
STATUS | VARCHAR2 | (30) | Lead status | |
DESCRIPTION | VARCHAR2 | (240) | Opportunity Description |
APPS.BIL_DIMV_OPTY is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_OPTY_STATUSES - view used to determine the status of a sales
opportunity.
.
Source is Oracle Sales Online schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS_CODE_PK | VARCHAR2 | (30) | status code for the opportunity status | |
MEANING | VARCHAR2 | (240) | Name of the opportunity status | |
DESCRIPTION | VARCHAR2 | (240) | Description of the opportunity status | |
ENABLED_FLAG | VARCHAR2 | (1) | indicates the status is enabled or not | |
LEAD_FLAG | VARCHAR2 | (1) | Flag to indicate that this status is for sales leads | |
OPP_FLAG | VARCHAR2 | (1) | Flag to indicate that this status is for sales opportunity | |
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | Flag to indicate that this status is for open opportunity | |
OPP_DECISION_DATE_FLAG | VARCHAR2 | (1) | Not used currently | |
STATUS_RANK | NUMBER | Not used currently | ||
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Flag to indicate opportunity with this status will appear in forecast. Valid values are 'Y' and 'N' | |
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Indicates whether the opportunity or lead is Won and Closed or Lost and Closed or just Closed because it is not an opportunity anymore. Validation will be made against Open Flag. Possible values are 'W', 'L', 'N' (neither equivalent to NULL) | |
USAGE_INDICATOR | VARCHAR2 | (30) | Indicates to whom the data will be exposed to. valid values are "OS" ,"PRM","ALL" | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column |
APPS.BIL_DIMV_OPTY_STATUSES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_PLAN_ELEMENTS - Dimension view used to provide descriptive information related to
compensation plan elements. Plan elements are defined as quota_id from cn_quotas_all.
.
Source is Oracle CRM Sales Compensation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUOTA_PK | NUMBER | Quoat plan element identifier | ||
ORG_FK | NUMBER | Organization identifier | ||
QUOTA_NAME | VARCHAR2 | (80) | Compensation plan element name | |
QUOTA_DESCRIPTION | VARCHAR2 | (1900) | Plan element description | |
QUOTA_TARGET | NUMBER | Target quota amount for quota based plan elements | ||
QUOTA_PAYMENT | NUMBER | Quota payment amount percentage | ||
QUOTA_PERIOD_TYPE | VARCHAR2 | (0) | Quota interval type | |
QUOTA_INCENTIVE_TYPE | VARCHAR2 | (80) | Quota incentive type code | |
QUOTA_PERFORMANCE_GOAL | NUMBER | Performance goal | ||
START_DATE | DATE | Start date for quota | ||
END_DATE | DATE | End date for quota | ||
ID | VARCHAR2 | (40) | Compensation plan element identifier | |
VALUE | VARCHAR2 | (80) | Compensation plan element name |
APPS.BIL_DIMV_PLAN_ELEMENTS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_PRIM_INT_CODES - Dimension view used to provide descriptive information related to
product primary interest codes. Used for Sales Intelligence performance measure reporting.
.
Source is Oracle CRM Sales Schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRIMARY_INTEREST_CODE_ID | NUMBER | Interest code identifier | ||
PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | Interest code | |
ID | VARCHAR2 | (40) | Interest code identifier | |
VALUE | VARCHAR2 | (80) | Interest code |
APPS.BIL_DIMV_PRIM_INT_CODES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BI._DIMV_PROD_LOV - Dimension view used to define the product hierarchy used for Sales
Intelligence reporting.
.
Source is Oracle CRM Sales and Sales Intelligence schemas.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_TYPE | VARCHAR2 | (80) | Interest type | |
PRIMARY_INTEREST_CODE_ID | NUMBER | Primary interest code identifier | ||
PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | Primary interest code | |
SECONDARY_INTEREST_CODE_ID | NUMBER | Secondary interest code identifier | ||
SECONDARY_INTEREST_CODE | VARCHAR2 | (100) | Secondary interest code | |
INTEREST_TYPE_ID | NUMBER | Interest type identifer |
APPS.BIL_DIMV_PROD_LOV is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | Person identifier | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Business group | |
PERSON_NAME | VARCHAR2 | (240) | Current person name | |
QUALIFICATION_TITLE | VARCHAR2 | (120) | Title of qualification | |
GRADE_ATTAINED | VARCHAR2 | (100) | Grade person holds qualification | |
QUALIFICATION_STATUS | VARCHAR2 | (4000) | Status of qualification, for example, whether training is ongoing or completed | |
AWARDED_DATE | DATE | Date qualification awarded | ||
FEE | NUMBER | Tuition fee amount that the person will be reimbursed | ||
FEE_CURRENCY | VARCHAR2 | (80) | Currency of the tuition fee | |
TRAINING_COMPLETED_AMOUNT | NUMBER | Amount of training completed, for example, 30 days completed of a training program that lasts 60 days, see also TRAINING_COMPLETED_UNITS and TOTAL_TRAINING_AMOUNT | ||
REIMBURSEMENT_ARRANGEMENTS | VARCHAR2 | (2000) | Arrangement by which tuition fees are reimbursed, for example, bank transfer to be paid when qualification is awarded | |
TOTAL_TRAINING_AMOUNT | NUMBER | Total amount of training to be completed, see also TRAINING_COMPLETED_UNITS and TRAINING_COMPLETED_AMOUNT | ||
TRAINING_COMPLETED_UNITS | VARCHAR2 | (100) | Units of TRAINING COMPLETED AMOUNT and TOTAL TRAINING AMOUNT | |
QUALIFICATION_START_DATE | DATE | Date training for qualification commenced | ||
QUALIFICATION_END_DATE | DATE | Date training for the qualification finished | ||
LICENSE_NUMBER | VARCHAR2 | (80) | License number associated with the qualification, for example, a driving licence number. | |
LICENSE_EXPIRY_DATE | DATE | Expiry date of the license associated with the qualification | ||
LICENSE_RESTRICTIONS | VARCHAR2 | (255) | Restrictions on license associated with the qualification, for example, a driving license might only be valid in certain states | |
PROJECTED_COMPLETION_DATE | DATE | Projected completion date of qualification training | ||
AWARDING_BODY | VARCHAR2 | (100) | Awarding body for qualification | |
METHOD_OF_REIMBURSEMENT | VARCHAR2 | (4000) | Method of reimbursement for training | |
GROUP_RANKING | VARCHAR2 | (100) | Group ranking for training | |
COMMENTS | VARCHAR2 | (2000) | Comments for qualification | |
SCHOOL_OR_COLLEGE_NAME | VARCHAR2 | (255) | School or college name | |
QUALIFICATION_CATEGORY | VARCHAR2 | (4000) | Qualification category | |
QUALIFICATION_TYPE_NAME | VARCHAR2 | (150) | Qualification type | |
BUSINESS_GROUP_ID | NUMBER | |||
SCHOOL_OR_COLLEGE_ID | NUMBER | |||
QUALIFICATION_ID | NUMBER |
APPS.BIL_DIMV_QUALIFICATIONS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_RATING_FACTORS - Dimension view used for providing rating factors list of values (LOV)
used during generation of Sales Intelligence reports.
.
Source is Oracle Applications Foundation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Identifier of rating factor | ||
VALUE | VARCHAR2 | (240) | Name of rating factor |
APPS.BIL_DIMV_RATING_FACTORS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SALESFORCE - Dimension view used to provide descriptive information for salesforce
members (salesreps), using resource_id in jtf_rs_resource_extns table.
.
Source is Oracle Applications Human Resource and CRM Foundation schemas.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALESFORCE_PK | NUMBER | Resource identifier for salesrep | ||
RESOURCE_NUMBER | VARCHAR2 | (30) | Resource Number for sales person. This is a Unique and shown to user on forms. | |
SALESFORCE_STATUS | NUMBER | Status of salesrep whether he or she is active in AR or not ( Used for OTHER type of Salesreps) | ||
SALESFORCE_TYPE | VARCHAR2 | (30) | Category of Resource. Validating from JTF_OBJECTS_VL. Allowed values: EMPLOYEE, PARTNER, PARTY, SUPPLIER_CONTACT, OTHER | |
EMPLOYEE_PERSON_FK | VARCHAR2 | (30) | Salesrep employee id | |
LAST_NAME | VARCHAR2 | (150) | Salesrep last name | |
FIRST_NAME | VARCHAR2 | (150) | Salesrep first name | |
FULL_NAME | VARCHAR2 | (301) | Salesrep full name | |
COMPENSATION_CURRENCY_CODE | VARCHAR2 | (15) | Currency in which salesrep is compensated | |
START_DATE_ACTIVE | DATE | Date this Resource becomes active, if limited | ||
END_DATE_ACTIVE | DATE | Date this Resource becomes inactive, if limited | ||
EMPLOYMENT_STATUS_FK | VARCHAR2 | (30) | User defined category. For example Full-Time Permanent or Part-Time Permanent. | |
JOB_FK | NUMBER | Salesrep job title | ||
MANAGING_EMPLOYEE_ID | NUMBER | Employee id of salesrep's manager | ||
ID | VARCHAR2 | (40) | Salesrep id | |
VALUE | VARCHAR2 | (80) | Salesrep name |
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SALES_GROUPS - Dimension view used to provide descriptive information for salesforce
sales groups.
.
Source is Oracle CRM Foundation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_GROUP_ID | NUMBER | Resource group unique identifier | ||
GROUP_NUMBER | VARCHAR2 | (30) | Resource group number | |
NAME | VARCHAR2 | (60) | Resource group name | |
DESCRIPTION | VARCHAR2 | (240) | Resource group description | |
ENABLED_FLAG | VARCHAR2 | (1) | Enabled flag, always 'Y' | |
START_DATE_ACTIVE | DATE | Date from which group becomes active | ||
END_DATE_ACTIVE | DATE | Date from which group becomes inactive | ||
EXCLUSIVE_FLAG | VARCHAR2 | (1) | Indicates whether group is exclusive | |
ID | VARCHAR2 | (40) | Resource group id | |
VALUE | VARCHAR2 | (80) | Resource group name |
APPS.BIL_DIMV_SALES_GROUPS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SALES_STAGES - View containing descriptors related to stages of the
sales cycle. Used for Pipeline Analysis reporting.
.
Source is Oracle CRM Sales Online Schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALES_STAGE_PK | NUMBER | Sales stage identifier | ||
NAME | VARCHAR2 | (60) | Sales stage name | |
DESCRIPTION | VARCHAR2 | (240) | Sales stage description | |
MIN_WIN_PROBABILITY | NUMBER | Sales stage minimum win probability | ||
MAX_WIN_PROBABILITY | NUMBER | Sales stage maximum win probability | ||
ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether sales stage is enabled or not | |
START_DATE_ACTIVE | DATE | Date from which sales stage becomes active | ||
END_DATE_ACTIVE | DATE | Date from which sales stage becomes inactive | ||
ORG_ID | NUMBER | Operating unit which performed this transaction | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column |
APPS.BIL_DIMV_SALES_STAGES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SEC_INT_CODES - Dimension view used to provide descriptive information related to
product secondary interest codes. Used for Sales Intelligence performance measure reporting.
.
Source is Oracle CRM Sales schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECONDARY_INTEREST_CODE_ID | NUMBER | Interest code identifier | ||
SECONDARY_INTEREST_CODE | VARCHAR2 | (100) | Interest code | |
ID | VARCHAR2 | (40) | Interest code identifier | |
VALUE | VARCHAR2 | (80) | Interest code |
APPS.BIL_DIMV_SEC_INT_CODES is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | Salesrep person id | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Business group to which salesrep belongs | |
PERSON_NAME | VARCHAR2 | (240) | Salesrep name | |
COMPETENCE_NAME | VARCHAR2 | (700) | Competence name | |
DATE_FROM | DATE | Start date for which training for this competence was attended | ||
DATE_TO | DATE | Start date for which training for this competence was attended | ||
PROFICIENCY_RATING_SOURCE | VARCHAR2 | (4000) | Proficiency rating source for this competence | |
CERTIFICATION_METHOD | VARCHAR2 | (4000) | certification method for this competence | |
CERTIFICATION_DATE | DATE | Certification date for this competence | ||
NEXT_REVIEW_DATE | DATE | Next review date | ||
PROFICIENCY_LEVEL | VARCHAR2 | (80) | Competence proficiency level | |
BUSINESS_GROUP_ID | NUMBER | Business group identifier | ||
COMPETENCE_ID | NUMBER | Competence identifier |
APPS.BIL_DIMV_SKILLS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SLSPROD_HIER - Dimension view used to define the relationships along the product
hierarchy.
.
Source is Oracle CRM Sales schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
INTEREST_TYPE_ID | NUMBER | Interest type identifier | ||
PRIMARY_INTEREST_CODE_ID | NUMBER | Primary interest code | ||
SECONDARY_INTEREST_CODE_ID | NUMBER | Secondary interest code | ||
INTEREST_TYPE | VARCHAR2 | (80) | Inteest type | |
PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | Primary Interest | |
SECONDARY_INTEREST_CODE | VARCHAR2 | (100) | secondary interest |
APPS.BIL_DIMV_SLSPROD_HIER is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SLS_CHANNELS - Dimension view use to provide descriptive information related to
sales channels.
.
Source is Oracle Applications Order Management schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANNEL_LOOKUP_CODE | VARCHAR2 | (30) | Sales channel identifier | |
CHANNEL_MEANING | VARCHAR2 | (80) | Sales channel name | |
CHANNEL_DESCRIPTION | VARCHAR2 | (240) | Sales channel desription | |
CHANNEL_ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether sales channel is nabled or not | |
CHANNEL_START_DATE_ACTIVE | DATE | Date from which sales channel becomes active | ||
CHANNEL_END_DATE_ACTIVE | DATE | Date from which sales channel becomes inactive | ||
ID | VARCHAR2 | (30) | Sales channel identifier | |
VALUE | VARCHAR2 | (80) | Sales channel name |
APPS.BIL_DIMV_SLS_CHANNELS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_SRV_SVTYS - Dimension view used to provide descriptive information related to
service request (incident) severity classifications.
.
Source is Oracle CRM Service schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INCIDENT_SEVERITY_ID | NUMBER | Severity Id | ||
NAME | VARCHAR2 | (90) | Severity Name | |
DESCRIPTION | VARCHAR2 | (720) | Severity Description | |
IMPORTANCE_LEVEL | NUMBER | Severity Importance Level | ||
INCIDENT_SUBTYPE | VARCHAR2 | (30) | Incident severity sub type | |
START_DATE_ACTIVE | DATE | Start date of the Incident | ||
END_DATE_ACTIVE | DATE | End date of the Incident | ||
ID | VARCHAR2 | (40) | Incident Severity Identifier | |
VALUE | VARCHAR2 | (90) | Incident Severity Name |
APPS.BIL_DIMV_SRV_SVTYS is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_TERRITORIES - Dimension view used to provide descriptive information related to
sales territories.
.
Source is Oracle CRM Foundation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERRITORY_PK | NUMBER | Territory unique identifier | ||
NAME | VARCHAR2 | (2000) | Territory name | |
TERRITORY_TYPE_ID | NUMBER | Territory type unique identifier | ||
START_DATE_ACTIVE | DATE | Date when this territory becomes active, if limited | ||
END_DATE_ACTIVE | DATE | Date when this territory becomes inactive, if limited | ||
ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether territory is enabled. | |
ORG_ID | NUMBER | Operating unit which performed this transaction. | ||
ID | VARCHAR2 | (40) | Territory identifier | |
VALUE | VARCHAR2 | (80) | Territory name |
APPS.BIL_DIMV_TERRITORIES is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_TERR_HIER - Dimension view used to relate the levels of the sales territory hierarchy.
.
Source is Oracle CRM Foundation schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERR_ID | NUMBER | Territory Unique Identifier | ||
PARENT_TERR_ID | NUMBER | Parent Territory Identifier | ||
IMMEDIATE_PARENT_FLAG | VARCHAR2 | (1) | Flag that indicates whether the parent territory identifier is for an immediate parent |
APPS.BIL_DIMV_TERR_HIER is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | |||
VALUE | VARCHAR2 | (240) |
APPS.BIL_DIMV_TOP_BOTTOM is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | CHAR | (2) | ||
VALUE | VARCHAR2 | (255) | Y |
APPS.BIL_DIMV_TOT_COMP_PLANS is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | CHAR | (2) | ||
VALUE | VARCHAR2 | (255) | Y |
APPS.BIL_DIMV_TOT_JOB_TITLES is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | CHAR | (2) | ||
VALUE | VARCHAR2 | (255) | Y |
APPS.BIL_DIMV_TOT_SLSFORCE is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | CHAR | (2) | ||
VALUE | VARCHAR2 | (255) | Y |
APPS.BIL_DIMV_TOT_SLSPRODS is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | CHAR | (2) | ||
VALUE | VARCHAR2 | (255) | Y |
APPS.BIL_DIMV_TOT_TERRITORY is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
BIL_DIMV_UOM - Dimension view used to provide descriptive in information for materials
management units of measure.
.
Source is Oracle Applications Materials Management schema.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure name | |
UOM_CODE | VARCHAR2 | (30) | Abbreviated unit of measure code | |
UOM_CLASS | VARCHAR2 | (10) | Unit of measure class | |
UOM_DISABLE_DATE | DATE | Date when the unit can no longer be used to define conversions | ||
UOM_DESCRIPTION | VARCHAR2 | (240) | Unit of measure description | |
BASE_UOM_FLAG | VARCHAR2 | (1) | Base unit of measure flag | |
ID | VARCHAR2 | (30) | Abbreviated unit of measure code | |
VALUE | VARCHAR2 | (25) | Unit of measure name |
APPS.BIL_DIMV_UOM is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |