1. Tables and Views for Sales and Fusion Service
  2. ZSF_FCST_METRICS_TEMP

ZSF_FCST_METRICS_TEMP

This table will have the same structure as the table ZSF_FCST_METRICS. The intermediate rows generated during the Metrics Generation Process will be parked in this table. A sum query will be run to sum all the rows in this table in order to consolidate the data created during Metrics Generation. Once the transaction is COMMITed, the data in this table is automatically truncated by the database. The reason this table is used is to avoid generation of redo logs. Each session has its own copy of a global temp table

Details

  • Schema: FUSION

  • Object owner: ZSF

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
BI_METRIC_TYPE VARCHAR2 30 Yes Type of metric. Can be BI_TERR_PROD, BI_TERR_PROD_ADJPER.
FCST_HEADER_ID NUMBER 18 Yes The forecast header for which the metric details are captured.
FCST_METRICS_PARTITION_KEY NUMBER 18 This is a new partition key. Its used as an alternate key for zsf_fcst_header
ADJUST_PERIOD_ID NUMBER 18 Yes Adjustment Period. For adjustments by Territory and Product, this will be the last adjust_period_id of the corresponding forecast header.
FCST_TERRITORY_ID NUMBER 18 Yes Territory Id of the fcst_participant_id for which the metrics details are captured
FCST_PARTICIPANT_ID NUMBER 18 Yes Participant Id from zsf_fcst_participant for which metrics are stored in this table.
FCST_PRODUCT_ID NUMBER 18 Yes Product id for which metrics is stored. If there are no products in the application, a dummy product will be created and that Id will be used in this column instead.
ROOT_PRODUCT_FLAG VARCHAR2 1 Used only in case the metrics should be computed for TERR, TERR_AP views. This will be either 'Y' indicating that fcst_product_id is the root product for that header or N if it is not the Root product
UNALLOCATED_ADJUSTMENT_FLAG VARCHAR2 1 This column will have the value 'N' if the adjustment of category BI_TERR_PROD_ADJPER is created from an actual VIEW2 adjustment. It will have a value 'Y' if the adjustment is a copy of the VIEW1 adjustment created for bi_metric_type BI_TERR_PROD_ADJPER.
CORP_REVN_AMT NUMBER unadjusted revenue amount for the non pseudo territory is stored here.
CORP_REVN_EXPECT_AMT NUMBER expected revenue amount for the non pseudo territory is stored here.
CORP_UPSIDE_AMT NUMBER Unadjusted Metrics for Non-Pseudo Territory, upside revenue amount is stored here
CORP_DOWNSIDE_AMT NUMBER Unadjusted Metrics for Non-Pseudo Territory, downside revenue amount is stored here.
CORP_PRED_REVN_AMT NUMBER Unadjusted Metrics for Non-Pseudo Territory, predicted revenue amount is stored here.
CORP_EXTN_UNADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom unadjusted metrics
CORP_EXTN_UNADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom unadjusted metrics
CORP_EXTN_UNADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom unadjusted metrics
CORP_EXTN_UNADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom unadjusted metrics
CORP_EXTN_UNADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom unadjusted metrics
CORP_REVN_UNAL_AMT NUMBER expected revenue amount (part of unadj metrics) for unallocated product. Will be NULL if product is a leaf product
CORP_REVN_EXPECT_UNAL_AMT NUMBER expected revenue amount (part of unadj metrics) for unallocated product. Will be NULL if product is a leaf product.
CORP_UPSIDE_UNAL_AMT NUMBER upside revenue amount (part of unadj metrics) for unallocated product. Will be NULL if product is a leaf product.
CORP_DOWNSIDE_UNAL_AMT NUMBER downside revenue amount (part of unadj metrics) for unallocated product. Will be NULL if product is a leaf product.
CORP_PRED_REVN_UNAL_AMT NUMBER predicted adjustment amount for Unadjusted Forecast for unallocated product. Will be NULL if product is a leaf product.
CORP_EXTN_UNADJ_MET_UNAL_1 NUMBER Runtime Extensibility: place holder column 1 for custom unadjusted metrics for unallocated product
CORP_EXTN_UNADJ_MET_UNAL_2 NUMBER Runtime Extensibility: place holder column 2 for custom unadjusted metrics for unallocated product
CORP_EXTN_UNADJ_MET_UNAL_3 NUMBER Runtime Extensibility: place holder column 3 for custom unadjusted metrics for unallocated product
CORP_EXTN_UNADJ_MET_UNAL_4 NUMBER Runtime Extensibility: place holder column 4 for custom unadjusted metrics for unallocated product
CORP_EXTN_UNADJ_MET_UNAL_5 NUMBER Runtime Extensibility: place holder column 5 for custom unadjusted metrics for unallocated product
CORP_ITEM_ADJ_AMT NUMBER item adjustment delta amount for non-pseudo terrtiory is stored here.
CORP_BEST_ITEM_ADJ_AMT NUMBER best case item adjustment (delta) amount for non-pseudo terrtiory is stored here.
CORP_WRST_ITEM_ADJ_AMT NUMBER worst case item adjustment (delta) amount for non-pseudo territory is stored here.
CORP_ITEM_SUBADJ_AMT NUMBER item adjustment delta amount made by all the subordinates is stored here.
CORP_BEST_ITEM_SUBADJ_AMT NUMBER best case item adjustment (delta) amount made by all the subordinates is stored here.
CORP_WRST_ITEM_SUBADJ_AMT NUMBER worst case item adjustment (delta) amount made by all the subordinates is stored here.
CORP_EXTN_ITADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom item adjustment metrics
CORP_EXTN_ITADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom item adjustment metrics
CORP_EXTN_ITADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom item adjustment metrics
CORP_EXTN_ITADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom item adjustment metrics
CORP_EXTN_ITADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom item adjustment metrics
CORP_EXTN_ITADJ_SUB_1 NUMBER Runtime Extensibility: place holder column 1 for custom item adjustment metrics for subordinate participant
CORP_EXTN_ITADJ_SUB_2 NUMBER Runtime Extensibility: place holder column 2 for custom item adjustment metrics for subordinate participant
CORP_EXTN_ITADJ_SUB_3 NUMBER Runtime Extensibility: place holder column 3 for custom item adjustment metrics for subordinate participant
CORP_EXTN_ITADJ_SUB_4 NUMBER Runtime Extensibility: place holder column 4 for custom item adjustment metrics for subordinate participant
CORP_EXTN_ITADJ_SUB_5 NUMBER Runtime Extensibility: place holder column 5 for custom item adjustment metrics for subordinate participant
CORP_ITEM_ADJ_UNAL_AMT NUMBER item adjustment delta amount for unallocated product. Will be NULL if product is a leaf product.
CORP_BEST_ITEM_ADJ_UNAL_AMT NUMBER best case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
CORP_WRST_ITEM_ADJ_UNAL_AMT NUMBER worst case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
CORP_ITEM_SUBADJ_UNAL_AMT NUMBER item adjustment delta amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
CORP_BEST_ITEM_SUBADJ_UNAL_AMT NUMBER best case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
CORP_WRST_ITEM_SUBADJ_UNAL_AMT NUMBER worst case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
CORP_EXTN_ITADJ_MET_UNAL_1 NUMBER place holder column 1 for custom item adjustment metrics for unallocated product
CORP_EXTN_ITADJ_MET_UNAL_2 NUMBER place holder column 2 for custom item adjustment metrics for unallocated product
CORP_EXTN_ITADJ_MET_UNAL_3 NUMBER place holder column 3 for custom item adjustment metrics for unallocated product
CORP_EXTN_ITADJ_MET_UNAL_4 NUMBER place holder column 4 for custom item adjustment metrics for unallocated product
CORP_EXTN_ITADJ_MET_UNAL_5 NUMBER place holder column 5 for custom item adjustment metrics for unallocated product
CORP_EXTN_ITADJ_SUB_UNAL_1 NUMBER place holder column 1 for custom item adjustment metrics for unallocated product for subordinate participant
CORP_EXTN_ITADJ_SUB_UNAL_2 NUMBER place holder column 2 for custom item adjustment metrics for unallocated product for subordinate participant
CORP_EXTN_ITADJ_SUB_UNAL_3 NUMBER place holder column 3 for custom item adjustment metrics for unallocated product for subordinate participant
CORP_EXTN_ITADJ_SUB_UNAL_4 NUMBER place holder column 4 for custom item adjustment metrics for unallocated product for subordinate participant
CORP_EXTN_ITADJ_SUB_UNAL_5 NUMBER place holder column 5 for custom item adjustment metrics for unallocated product for subordinate participant
CORP_SUM_ADJ_AMT NUMBER summary adjustment (delta) amount for non-pseudo territory is stored here.
CORP_BEST_SUM_ADJ_AMT NUMBER best case summary adjustment (delta) amount for non-pseudo territory is stored here.
CORP_WRST_SUM_ADJ_AMT NUMBER worst case summary adjustment (delta) amount for non-pseudo territory is stored here.
CORP_SUM_SUBADJ_AMT NUMBER summary adjustment (delta) amount made by all the subordinates is stored here.
CORP_BEST_SUM_SUBADJ_AMT NUMBER best case summary adjustment (delta) amount made by all the subordinates is stored here.
CORP_WRST_SUM_SUBADJ_AMT NUMBER worst case summary adjustment (delta) amount made by all the subordinates is stored here.
CORP_EXTN_SUMADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom summary adustment metrics
CORP_EXTN_SUMADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom summary adustment metrics
CORP_EXTN_SUMADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom summary adustment metrics
CORP_EXTN_SUMADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom summary adustment metrics
CORP_EXTN_SUMADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom summary adustment metrics
CORP_EXTN_SUMADJ_SUB_1 NUMBER Runtime Extensibility: place holder column 1 for custom summary adustment metrics for subordinate participant
CORP_EXTN_SUMADJ_SUB_2 NUMBER Runtime Extensibility: place holder column 2 for custom summary adustment metrics for subordinate participant
CORP_EXTN_SUMADJ_SUB_3 NUMBER Runtime Extensibility: place holder column 3 for custom summary adustment metrics for subordinate participant
CORP_EXTN_SUMADJ_SUB_4 NUMBER Runtime Extensibility: place holder column 4 for custom summary adustment metrics for subordinate participant
CORP_EXTN_SUMADJ_SUB_5 NUMBER Runtime Extensibility: place holder column 5 for custom summary adustment metrics for subordinate participant
CORP_SUM_ADJ_UNAL_AMT NUMBER unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
CORP_BEST_SUM_ADJ_UNAL_AMT NUMBER best case summary adjustment (delta) amount for the unallocated product is stored here.
CORP_WRST_SUM_ADJ_UNAL_AMT NUMBER worst case summary adjustment (delta) amount for the unallocated product is stored here.
CORP_SUM_SUBADJ_UNAL_AMT NUMBER unallocated summary adjustment made for fcst_product_id made by all the subordinates. Will be NULL if fcst_product_id is a leaf product.
CORP_BEST_SUM_SUBADJ_UNAL_AMT NUMBER best case summary adjustment (delta) amount for the unallocated product made by all the subordinates
CORP_WRST_SUM_SUBADJ_UNAL_AMT NUMBER worst case summary adjustment (delta) amount for the unallocated product made by all the subordinates
CORP_EXTN_SUMADJ_MET_UNAL_1 NUMBER place holder column 1 for custom summary adustment metrics for unallocated product
CORP_EXTN_SUMADJ_MET_UNAL_2 NUMBER place holder column 2 for custom summary adustment metrics for unallocated product
CORP_EXTN_SUMADJ_MET_UNAL_3 NUMBER place holder column 3 for custom summary adustment metrics for unallocated product
CORP_EXTN_SUMADJ_MET_UNAL_4 NUMBER place holder column 4 for custom summary adustment metrics for unallocated product
CORP_EXTN_SUMADJ_MET_UNAL_5 NUMBER place holder column 5 for custom summary adustment metrics for unallocated product
CORP_EXTN_SUMADJ_SUB_UNAL_1 NUMBER place holder column 1 for custom summary adustment metrics for unallocated product for subordinate participant
CORP_EXTN_SUMADJ_SUB_UNAL_2 NUMBER place holder column 2 for custom summary adustment metrics for unallocated product for subordinate participant
CORP_EXTN_SUMADJ_SUB_UNAL_3 NUMBER place holder column 3 for custom summary adustment metrics for unallocated product for subordinate participant
CORP_EXTN_SUMADJ_SUB_UNAL_4 NUMBER place holder column 4 for custom summary adustment metrics for unallocated product for subordinate participant
CORP_EXTN_SUMADJ_SUB_UNAL_5 NUMBER place holder column 5 for custom summary adustment metrics for unallocated product for subordinate participant
CORP_PS_REVN_AMT NUMBER unadjusted revenue amount for the pseudo territory is stored here.
CORP_PS_REVN_EXPECT_AMT NUMBER expected revenue amount (part of unadj metrics) for the pseudo territory is stored here.
CORP_PS_UPSIDE_AMT NUMBER upside revenue amount (part of unadj metrics) - for the pseudo territory is stored here.
CORP_PS_DOWNSIDE_AMT NUMBER downside revenue amount (part of unadj metrics) - for the pseudo territory is stored here.
CORP_PS_PRED_REVN_AMT NUMBER predicted adjustment amount for Unadjusted Forecast for the pseudo territory is stored here.
CORP_PS_EXTN_UNADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom unadjusted metrics for pseudo territory
CORP_PS_EXTN_UNADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom unadjusted metrics for pseudo territory
CORP_PS_EXTN_UNADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom unadjusted metrics for pseudo territory
CORP_PS_EXTN_UNADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom unadjusted metrics for pseudo territory
CORP_PS_EXTN_UNADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom unadjusted metrics for pseudo territory
CORP_PS_REVN_UNAL_AMT NUMBER unadjusted revenue amount for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_REVN_EXPECT_UNAL_AMT NUMBER expected revenue amount (part of unadj metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_UPSIDE_UNAL_AMT NUMBER upside revenue amount (part of unadj metrics) - for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_DOWNSIDE_UNAL_AMT NUMBER downside revenue amount (part of unadj metrics) - for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_PRED_REVN_UNAL_AMT NUMBER predicted adjustment amount for Unadjusted Forecast for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_EXTN_UNADJ_MET_UNAL_1 NUMBER place holder column 1 for custom unadjusted metrics for unallocated product for pseudo territory
CORP_PS_EXTN_UNADJ_MET_UNAL_2 NUMBER place holder column 2 for custom unadjusted metrics for unallocated product for pseudo territory
CORP_PS_EXTN_UNADJ_MET_UNAL_3 NUMBER place holder column 3 for custom unadjusted metrics for unallocated product for pseudo territory
CORP_PS_EXTN_UNADJ_MET_UNAL_4 NUMBER place holder column 4 for custom unadjusted metrics for unallocated product for pseudo territory
CORP_PS_EXTN_UNADJ_MET_UNAL_5 NUMBER place holder column 5 for custom unadjusted metrics for unallocated product for pseudo territory
CORP_PS_ITEM_ADJ_AMT NUMBER item adjustment delta amount for the pseudo territory is stored here.
CORP_PS_BEST_ITEM_ADJ_AMT NUMBER best case item adjustment (delta) amount for the pseudo territory is stored here.
CORP_PS_WRST_ITEM_ADJ_AMT NUMBER worst case item adjustment (delta) amount for the pseudo territory is stored here.
CORP_PS_EXTN_ITADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom item adjustment metrics for pseudo territory.
CORP_PS_EXTN_ITADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom item adjustment metrics for pseudo territory.
CORP_PS_EXTN_ITADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom item adjustment metrics for pseudo territory.
CORP_PS_EXTN_ITADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom item adjustment metrics for pseudo territory.
CORP_PS_EXTN_ITADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom item adjustment metrics for pseudo territory.
CORP_PS_ITEM_ADJ_UNAL_AMT NUMBER item adjustment delta amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_BEST_ITEM_ADJ_UNAL_AMT NUMBER best case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_WRST_ITEM_ADJ_UNAL_AMT NUMBER worst case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
CORP_PS_EXTN_ITADJ_MET_UNAL_1 NUMBER place holder column 1 for custom item adjustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_ITADJ_MET_UNAL_2 NUMBER place holder column 2 for custom item adjustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_ITADJ_MET_UNAL_3 NUMBER place holder column 3 for custom item adjustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_ITADJ_MET_UNAL_4 NUMBER place holder column 4 for custom item adjustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_ITADJ_MET_UNAL_5 NUMBER place holder column 5 for custom item adjustment metrics for unallocated product for pseudo territory
CORP_PS_SUM_ADJ_AMT NUMBER summary adjustment (delta) amount for the pseudo territory is stored here.
CORP_PS_BEST_SUM_ADJ_AMT NUMBER best case summary adjustment (delta) amount for the pseudo territory is stored here.
CORP_PS_WRST_SUM_ADJ_AMT NUMBER worst case summary adjustment (delta) amount for the pseudo territory is stored here.
CORP_PS_EXTN_SUMADJ_MET_1 NUMBER Runtime Extensibility: place holder column 1 for custom summary adustment metrics for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_2 NUMBER Runtime Extensibility: place holder column 2 for custom summary adustment metrics for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_3 NUMBER Runtime Extensibility: place holder column 3 for custom summary adustment metrics for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_4 NUMBER Runtime Extensibility: place holder column 4 for custom summary adustment metrics for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_5 NUMBER Runtime Extensibility: place holder column 5 for custom summary adustment metrics for pseudo territory
CORP_PS_SUM_ADJ_UNAL_AMT NUMBER unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product. for the pseudo territory
CORP_PS_BEST_SUM_ADJ_UNAL_AMT NUMBER best case summary adjustment (delta) amount for the unallocated product for the pseudo territory is stored here.
CORP_PS_WRST_SUM_ADJ_UNAL_AMT NUMBER worst case summary adjustment (delta) amount for the unallocated product for the pseudo territory
CORP_PS_EXTN_SUMADJ_MET_UNAL_1 NUMBER place holder column 1 for custom summary adustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_UNAL_2 NUMBER place holder column 2 for custom summary adustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_UNAL_3 NUMBER place holder column 3 for custom summary adustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_UNAL_4 NUMBER place holder column 4 for custom summary adustment metrics for unallocated product for pseudo territory
CORP_PS_EXTN_SUMADJ_MET_UNAL_5 NUMBER place holder column 5 for custom summary adustment metrics for unallocated product for pseudo territory
CORP_REVN_WON_AMT NUMBER This field has the Won amount stored in corporate currency.
CORP_REVN_WON_UNAL_AMT NUMBER This field has the revenue won amount in corporate currency that is unallocated.
CORP_PS_REVN_WON_AMT NUMBER This field has the revenue won amount for the pseudo territory in corporate currency.
CORP_PS_REVN_WON_UNAL_AMT NUMBER This field stores the won revenue unallocated amount for pseudo territory in corporate currency
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
UNADJ_QUANTITY NUMBER unadjusted Quantity for the non pseudo territory is stored here.
UNADJ_UNAL_QUANTITY NUMBER The Quantity associated to the unallocated product. Will be NULL if product is a leaf product
ITADJ_QUANTITY NUMBER item adjustment for Quantity for non-pseudo terrtiory is stored here.
ITADJ_UNAL_QUANTITY NUMBER item adjustment for Quantity for unallocated product. Will be NULL if product is a leaf product.
ITADJ_SUB_QUANTITY NUMBER item adjustment for Quantity made by all the subordinates is stored here.
ITADJ_SUB_UNAL_QUANTITY NUMBER Subordinate Item Adjustment for Unallocated product
SUMADJ_QUANTITY NUMBER summary adjustment (delta) for Quantity for non-pseudo territory is stored here.
SUMADJ_UNAL_QUANTITY NUMBER unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
SUMADJ_SUB_QUANTITY NUMBER summary adjustment (delta) on Quantity made by all the subordinates is stored here.
SUMADJ_SUB_UNAL_QUANTITY NUMBER Subordinate Adjustment for an unallocated product
PS_UNADJ_QUANTITY NUMBER unadjusted Quantity for the pseudo territory is stored here.
PS_UNADJ_UNAL_QUANTITY NUMBER unadjusted Quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
PS_ITADJ_QUANTITY NUMBER item adjustment delta for Quantity for the pseudo territory is stored here.
PS_ITADJ_UNAL_QUANTITY NUMBER item adjustment delta afor Quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
PS_SUMADJ_QUANTITY NUMBER summary adjustment delta for Quantity for the pseudo territory is stored here.
PS_SUMADJ_UNAL_QUANTITY NUMBER unallocated summary adjustment for Quantity made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product. for the pseudo territory
RNWL_PRED_REVN_AMT NUMBER Unadjusted metrics for non-pseudo territory, predicted renewal revenue amount is stored here.
RNWL_REVN_EXPECT_AMT NUMBER Expected renewal revenue amount for the non pseudo territory is stored here.
RNWL_REVN_AMT NUMBER Unadjusted renewal revenue amount for the non pseudo territory is stored here.
RNWL_DOWNSIDE_AMT NUMBER Unadjusted metrics for non-pseudo territory, downside renewal renewal revenue amount is stored here.
RNWL_REVN_WON_AMT NUMBER Renewal won amount in corporate currency.
RNWL_UPSIDE_AMT NUMBER Unadjusted metrics for non-pseudo territory, upside renewal revenue amount is stored here.
RNWL_REVN_UNAL_AMT NUMBER Renewal revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
RNWL_DOWNSIDE_UNAL_AMT NUMBER Downside renewal revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
RNWL_PRED_REVN_UNAL_AMT NUMBER Predicted renewal adjustment amount for unadjusted forecast for unallocated product. Will be NULL if product is a leaf product.
RNWL_REVN_EXPECT_UNAL_AMT NUMBER Expected renewal revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
RNWL_REVN_WON_UNAL_AMT NUMBER This field has the renewal revenue won amount in corporate currency that is unallocated.
RNWL_UPSIDE_UNAL_AMT NUMBER Upside renewal revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_REVN_EXPECT_AMT NUMBER Expected renewal revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
RNWL_PS_DOWNSIDE_AMT NUMBER Downside renewal revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
RNWL_PS_UPSIDE_AMT NUMBER Upside renewal revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
RNWL_PS_PRED_REVN_AMT NUMBER Predicted renewal adjustment amount for unadjusted Forecast for the pseudo territory is stored here.
RNWL_PS_REVN_WON_AMT NUMBER This field has the renewal revenue won amount for the pseudo territory in corporate currency.
RNWL_PS_REVN_AMT NUMBER Unadjusted renewal revenue amount for the pseudo territory is stored here.
RNWL_PS_DOWNSIDE_UNAL_AMT NUMBER Downside renewal revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_PRED_REVN_UNAL_AMT NUMBER Predicted renewal adjustment amount for unadjusted forecast for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_REVN_WON_UNAL_AMT NUMBER This field stores the renewal won revenue unallocated amount for pseudo territory in corporate currency.
RNWL_PS_UPSIDE_UNAL_AMT NUMBER Upside renewal revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_REVN_EXPECT_UNAL_AMT NUMBER Expected renewal revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_REVN_UNAL_AMT NUMBER Unadjusted renewal revenue amount for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_UNADJ_QUANTITY NUMBER Renewal unadjusted quantity for the non pseudo territory is stored here.
RNWL_UNADJ_UNAL_QUANTITY NUMBER Renewal quantity associated to the unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_UNADJ_QUANTITY NUMBER Renewal unadjusted quantity for the pseudo territory is stored here.
RNWL_PS_UNADJ_UNAL_QUANTITY NUMBER Renewal unadjusted quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_BEST_ITEM_ADJ_AMT NUMBER Renewal best case item adjustment (delta) amount for non-pseudo territory is stored here.
RNWL_ITEM_ADJ_AMT NUMBER Renewal item adjustment delta amount for non-pseudo territory is stored here.
RNWL_BEST_ITEM_SUBADJ_AMT NUMBER Renewal best case item adjustment (delta) amount made by all the subordinates is stored here.
RNWL_WRST_ITEM_ADJ_AMT NUMBER Renewal worst case item adjustment (delta) amount for non-pseudo territory is stored here.
RNWL_WRST_ITEM_SUBADJ_AMT NUMBER Renewal worst case item adjustment (delta) amount made by all the subordinates is stored here.
RNWL_ITEM_SUBADJ_AMT NUMBER Renewal item adjustment (delta) amount made by all the subordinates is stored here.
RNWL_WRST_ITEM_SUBADJ_UNAL_AMT NUMBER Renewal worst case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
RNWL_ITEM_ADJ_UNAL_AMT NUMBER Renewal item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
RNWL_WRST_ITEM_ADJ_UNAL_AMT NUMBER Renewal worst case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
RNWL_ITEM_SUBADJ_UNAL_AMT NUMBER Renewal item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
RNWL_BEST_ITEM_ADJ_UNAL_AMT NUMBER Renewal best case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
RNWL_BEST_ITEM_SUBADJ_UNAL_AMT NUMBER Renewal best case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
RNWL_PS_BEST_ITEM_ADJ_AMT NUMBER Renewal best case item adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_ITEM_ADJ_AMT NUMBER Renewal item adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_WRST_ITEM_ADJ_AMT NUMBER Renewal worst case item adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_ITEM_ADJ_UNAL_AMT NUMBER Renewal item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_WRST_ITEM_ADJ_UNAL_AMT NUMBER Renewal worst case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_PS_BEST_ITEM_ADJ_UNAL_AMT NUMBER Renewal best case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_ITADJ_SUB_QUANTITY NUMBER Renewal item adjustment for quantity made by all the subordinates is stored here.
RNWL_ITADJ_QUANTITY NUMBER Renewal item adjustment for quantity for non-pseudo territory is stored here.
RNWL_ITADJ_UNAL_QUANTITY NUMBER Renewal item adjustment for quantity for unallocated product. Will be NULL if product is a leaf product.
RNWL_ITADJ_SUB_UNAL_QUANTITY NUMBER Subordinate renewal item adjustment for unallocated product.
RNWL_PS_ITADJ_QUANTITY NUMBER Renewal item adjustment (delta) for quantity for the pseudo territory is stored here.
RNWL_PS_ITADJ_UNAL_QUANTITY NUMBER Renewal item adjustment (delta) for quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
RNWL_BEST_SUM_SUBADJ_AMT NUMBER Renewal best case summary adjustment (delta) amount made by all the subordinates is stored here.
RNWL_SUM_ADJ_AMT NUMBER Renewal summary adjustment (delta) amount for non-pseudo territory is stored here.
RNWL_WRST_SUM_ADJ_AMT NUMBER Renewal worst case summary adjustment (delta) amount for non-pseudo territory is stored here.
RNWL_SUM_SUBADJ_AMT NUMBER Renewal summary adjustment (delta) amount made by all the subordinates is stored here.
RNWL_BEST_SUM_ADJ_AMT NUMBER Renewal best case summary adjustment (delta) amount for non-pseudo territory is stored here.
RNWL_WRST_SUM_SUBADJ_AMT NUMBER Worst case renewal summary adjustment (delta) amount made by all the subordinates is stored here.
RNWL_BEST_SUM_SUBADJ_UNAL_AMT NUMBER Renewal best case summary adjustment (delta) amount for the unallocated product made by all the subordinates.
RNWL_WRST_SUM_ADJ_UNAL_AMT NUMBER Renewal worst case summary adjustment (delta) amount for the unallocated product is stored here.
RNWL_WRST_SUM_SUBADJ_UNAL_AMT NUMBER Renewal worst case summary adjustment (delta) amount for the unallocated product made by all the subordinates.
RNWL_SUM_SUBADJ_UNAL_AMT NUMBER Renewal unallocated summary adjustment made for fcst_product_id made by all the subordinates. Will be NULL if fcst_product_id is a leaf product.
RNWL_BEST_SUM_ADJ_UNAL_AMT NUMBER Renewal best case summary adjustment (delta) amount for the unallocated product is stored here.
RNWL_SUM_ADJ_UNAL_AMT NUMBER Renewal unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
RNWL_PS_WRST_SUM_ADJ_AMT NUMBER Renewal worst case summary adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_SUM_ADJ_AMT NUMBER Renewal summary adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_BEST_SUM_ADJ_AMT NUMBER Renewal best case summary adjustment (delta) amount for the pseudo territory is stored here.
RNWL_PS_SUM_ADJ_UNAL_AMT NUMBER Renewal unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product for the pseudo territory.
RNWL_PS_WRST_SUM_ADJ_UNAL_AMT NUMBER Renewal worst case summary adjustment (delta) amount for the unallocated product for the pseudo territory.
RNWL_PS_BEST_SUM_ADJ_UNAL_AMT NUMBER Renewal best case summary adjustment (delta) amount for the unallocated product for the pseudo territory is stored here.
RNWL_SUMADJ_SUB_QUANTITY NUMBER Renewal summary adjustment (delta) on quantity made by all the subordinates is stored here.
RNWL_SUMADJ_QUANTITY NUMBER Renewal summary adjustment (delta) for quantity for non-pseudo territory is stored here.
RNWL_SUMADJ_SUB_UNAL_QUANTITY NUMBER Subordinate renewal adjustment for an unallocated product.
RNWL_SUMADJ_UNAL_QUANTITY NUMBER Renewal unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
RNWL_PS_SUMADJ_QUANTITY NUMBER Renewal summary adjustment delta for quantity for the pseudo territory is stored here.
RNWL_PS_SUMADJ_UNAL_QUANTITY NUMBER Renewal unallocated summary adjustment for quantity made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product for the pseudo territory.
NEW_REVN_EXPECT_AMT NUMBER Expected new revenue amount for the non pseudo territory is stored here.
NEW_DOWNSIDE_AMT NUMBER Unadjusted metrics for non-pseudo territory, downside new revenue amount is stored here.
NEW_REVN_WON_AMT NUMBER New won amount in corporate currency.
NEW_PRED_REVN_AMT NUMBER Unadjusted metrics for non-pseudo territory, predicted new revenue amount is stored here.
NEW_UPSIDE_AMT NUMBER Unadjusted metrics for non-pseudo territory, upside new revenue amount is stored here.
NEW_REVN_AMT NUMBER Unadjusted new revenue amount for the non pseudo territory is stored here.
NEW_REVN_EXPECT_UNAL_AMT NUMBER Expected new revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
NEW_UPSIDE_UNAL_AMT NUMBER Upside new revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
NEW_PRED_REVN_UNAL_AMT NUMBER Predicted new adjustment amount for unadjusted forecast for unallocated product. Will be NULL if product is a leaf product.
NEW_DOWNSIDE_UNAL_AMT NUMBER Downside new revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product.
NEW_REVN_UNAL_AMT NUMBER New revenue amount (part of unadjusted metrics) for unallocated product. Will be NULL if product is a leaf product
NEW_REVN_WON_UNAL_AMT NUMBER This field has the new revenue won amount in corporate currency that is unallocated.
NEW_PS_PRED_REVN_AMT NUMBER Predicted new adjustment amount for unadjusted Forecast for the pseudo territory is stored here.
NEW_PS_DOWNSIDE_AMT NUMBER Downside new revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
NEW_PS_REVN_WON_AMT NUMBER This field has the new revenue won amount for the pseudo territory in corporate currency.
NEW_PS_REVN_EXPECT_AMT NUMBER Expected new revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
NEW_PS_REVN_AMT NUMBER Unadjusted new revenue amount for the pseudo territory is stored here.
NEW_PS_UPSIDE_AMT NUMBER Upside new revenue amount (part of unadjusted metrics) for the pseudo territory is stored here.
NEW_PS_REVN_EXPECT_UNAL_AMT NUMBER Expected new revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_PRED_REVN_UNAL_AMT NUMBER Predicted new adjustment amount for unadjusted forecast for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_REVN_WON_UNAL_AMT NUMBER This field stores the new won revenue unallocated amount for pseudo territory in corporate currency.
NEW_PS_REVN_UNAL_AMT NUMBER Unadjusted new revenue amount for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_UPSIDE_UNAL_AMT NUMBER Upside new revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_DOWNSIDE_UNAL_AMT NUMBER Downside new revenue amount (part of unadjusted metrics) for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_UNADJ_QUANTITY NUMBER New unadjusted quantity for the non pseudo territory is stored here.
NEW_UNADJ_UNAL_QUANTITY NUMBER New quantity associated to the unallocated product. Will be NULL if product is a leaf product.
NEW_PS_UNADJ_QUANTITY NUMBER New unadjusted quantity for the pseudo territory is stored here.
NEW_PS_UNADJ_UNAL_QUANTITY NUMBER New unadjusted quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_WRST_ITEM_SUBADJ_AMT NUMBER New worst case item adjustment (delta) amount made by all the subordinates is stored here.
NEW_BEST_ITEM_SUBADJ_AMT NUMBER New best case item adjustment (delta) amount made by all the subordinates is stored here.
NEW_ITEM_ADJ_AMT NUMBER New item adjustment delta amount for non-pseudo territory is stored here.
NEW_ITEM_SUBADJ_AMT NUMBER New item adjustment (delta) amount made by all the subordinates is stored here.
NEW_WRST_ITEM_ADJ_AMT NUMBER New worst case item adjustment (delta) amount for non-pseudo territory is stored here.
NEW_BEST_ITEM_ADJ_AMT NUMBER New best case item adjustment (delta) amount for non-pseudo territory is stored here.
NEW_ITEM_SUBADJ_UNAL_AMT NUMBER New item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
NEW_WRST_ITEM_SUBADJ_UNAL_AMT NUMBER New worst case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
NEW_WRST_ITEM_ADJ_UNAL_AMT NUMBER New worst case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
NEW_BEST_ITEM_SUBADJ_UNAL_AMT NUMBER New best case item adjustment (delta) amount for unallocated product made by all the subordinates. Will be NULL if product is a leaf product.
NEW_BEST_ITEM_ADJ_UNAL_AMT NUMBER New best case item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
NEW_ITEM_ADJ_UNAL_AMT NUMBER New item adjustment (delta) amount for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_BEST_ITEM_ADJ_AMT NUMBER New best case item adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_WRST_ITEM_ADJ_AMT NUMBER New worst case item adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_ITEM_ADJ_AMT NUMBER New item adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_WRST_ITEM_ADJ_UNAL_AMT NUMBER New worst case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_ITEM_ADJ_UNAL_AMT NUMBER New item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_BEST_ITEM_ADJ_UNAL_AMT NUMBER New best case item adjustment (delta) amount for the pseudo territory for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_ITADJ_SUB_QUANTITY NUMBER New item adjustment for quantity made by all the subordinates is stored here.
NEW_ITADJ_QUANTITY NUMBER New item adjustment for quantity for non-pseudo territory is stored here.
NEW_ITADJ_SUB_UNAL_QUANTITY NUMBER Subordinate new item adjustment for unallocated product.
NEW_ITADJ_UNAL_QUANTITY NUMBER New item adjustment for quantity for unallocated product. Will be NULL if product is a leaf product.
NEW_PS_ITADJ_QUANTITY NUMBER New item adjustment (delta) for quantity for the pseudo territory is stored here.
NEW_PS_ITADJ_UNAL_QUANTITY NUMBER New item adjustment (delta) for quantity for the pseudo territory for unallocated product. Will be NULL if product is a leaf product.
NEW_SUM_ADJ_AMT NUMBER New summary adjustment (delta) amount for non-pseudo territory is stored here.
NEW_BEST_SUM_ADJ_AMT NUMBER New best case summary adjustment (delta) amount for non-pseudo territory is stored here.
NEW_SUM_SUBADJ_AMT NUMBER New summary adjustment (delta) amount made by all the subordinates is stored here.
NEW_WRST_SUM_SUBADJ_AMT NUMBER Worst case new summary adjustment (delta) amount made by all the subordinates is stored here.
NEW_WRST_SUM_ADJ_AMT NUMBER New worst case summary adjustment (delta) amount for non-pseudo territory is stored here.
NEW_BEST_SUM_SUBADJ_AMT NUMBER New best case summary adjustment (delta) amount made by all the subordinates is stored here.
NEW_WRST_SUM_SUBADJ_UNAL_AMT NUMBER New worst case summary adjustment (delta) amount for the unallocated product made by all the subordinates.
NEW_WRST_SUM_ADJ_UNAL_AMT NUMBER New worst case summary adjustment (delta) amount for the unallocated product is stored here.
NEW_BEST_SUM_ADJ_UNAL_AMT NUMBER New best case summary adjustment (delta) amount for the unallocated product is stored here.
NEW_BEST_SUM_SUBADJ_UNAL_AMT NUMBER New best case summary adjustment (delta) amount for the unallocated product made by all the subordinates.
NEW_SUM_SUBADJ_UNAL_AMT NUMBER New unallocated summary adjustment made for fcst_product_id made by all the subordinates. Will be NULL if fcst_product_id is a leaf product.
NEW_SUM_ADJ_UNAL_AMT NUMBER New unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
NEW_PS_BEST_SUM_ADJ_AMT NUMBER New best case summary adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_SUM_ADJ_AMT NUMBER New summary adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_WRST_SUM_ADJ_AMT NUMBER New worst case summary adjustment (delta) amount for the pseudo territory is stored here.
NEW_PS_WRST_SUM_ADJ_UNAL_AMT NUMBER New worst case summary adjustment (delta) amount for the unallocated product for the pseudo territory.
NEW_PS_SUM_ADJ_UNAL_AMT NUMBER New unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product for the pseudo territory.
NEW_PS_BEST_SUM_ADJ_UNAL_AMT NUMBER New best case summary adjustment (delta) amount for the unallocated product for the pseudo territory is stored here.
NEW_SUMADJ_QUANTITY NUMBER New summary adjustment (delta) for quantity for non-pseudo territory is stored here.
NEW_SUMADJ_SUB_QUANTITY NUMBER New summary adjustment (delta) on quantity made by all the subordinates is stored here.
NEW_SUMADJ_SUB_UNAL_QUANTITY NUMBER Subordinate new adjustment for an unallocated product.
NEW_SUMADJ_UNAL_QUANTITY NUMBER New unallocated summary adjustment made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product.
NEW_PS_SUMADJ_QUANTITY NUMBER New summary adjustment delta for quantity for the pseudo territory is stored here.
NEW_PS_SUMADJ_UNAL_QUANTITY NUMBER New unallocated summary adjustment for quantity made for fcst_product_id. Will be NULL if fcst_product_id is a leaf product for the pseudo territory.