ZPM_PARTNER_ROLLUPS

The zpm_partner_rollups table stores information Rollup Metrics data.

Details

  • Schema: FUSION

  • Object owner: ZPM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

ZPM_PARTNER_ROLLUPS_PK

PARTY_ID

Columns

Name Datatype Length Precision Not-null Comments
PARTY_ID NUMBER 18 Yes An identifier for the organization profiles used as a foreign key to the zpm_partner_profiles table.
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.
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_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CURRENCY_CODE VARCHAR2 15 The currency code. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
CORP_CURRENCY_CODE VARCHAR2 15 The corporate currency code associated with the partner. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
CURCY_CONV_RATE_TYPE VARCHAR2 30 The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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).
OPEN_OPTY_REVENUE_AMT NUMBER The cumulative total of open opportunity potential revenue amount for the partner.
HIER_OPEN_OPTY_REVENUE_AMT NUMBER The cumulative total of open opportunity potential revenue amount within the partner hierarchy.
WON_OPTY_REVENUE_AMT NUMBER The cumulative total of won opportunity potential revenue amount for the partner.
HIER_WON_OPTY_REVENUE_AMT NUMBER The cumulative total of potential revenue amount from won opportunities, within the partner hierarchy.
SUM_OPEN_OPTY_REVENUE_THIS_QTR NUMBER Total revenue from open opportunities with expected close date falling in the current quarter.
HIER_SUM_OPEN_OPTY_REV_QTR NUMBER The total revenue from open opportunities with expected close date falling in the current quarter and its hierarchy.
SUM_OPTY_REVENUE_WON_THIS_QTR NUMBER The total revenue of an partner from won opportunities with a close date falling in this quarter.
HIER_SUM_OPTY_REV_WON_QTR NUMBER The total revenue of an partner and its hieararchy from won opportunities with close date falling in this quarter.
SUM_OPEN_OPTY_REVENUE_NXT_QTR NUMBER Total revenue from open opportunities with expected close date falling in the next quarter.
HIER_SUM_OPEN_OPTY_REV_NXT_QTR NUMBER The total revenue from open opportunities with expected close date falling in the next quarter and its hierarchy.
PERC_DEAL_CONV_RATE NUMBER Percentage of deals registrations that gets converted to an opportunity
NUM_OF_OPEN_MDF_CLAIM NUMBER Count of the MDF Claims pending for approval of a Partner that are open
HIER_NUM_OF_OPEN_MDF_CLAIM NUMBER Count of the MDF Claims pending for approval of a Partner and it's hierarchies that are open
SUM_OPEN_MDF_CLAIM_AMT NUMBER Sum of the MDF Claims pending for approval amount of a Partner that are open
HIER_SUM_OPEN_MDF_CLAIM_AMT NUMBER Sum of the MDF Claims pending for approval amount of a Partner and it's hierarchies that are open
NUM_OF_APPRV_CLAIM NUMBER Count of the MDF Claims of a Partner that are approved
HIER_NUM_OF_APPRV_CLAIM NUMBER Count of the MDF Claims of a Partner and it's hierarchies that are approved
SUM_APPRV_CLAIM_AMT NUMBER Sum of the MDF Claims amount of a Partner that are approved
HIER_SUM_APPRV_CLAIM_AMT NUMBER Sum of the MDF Claims amount of a Partner and it's hierarchies that are approved
NUM_OF_OPEN_MDF_REQUEST NUMBER Count of the MDF Requests pending for approval of a Partner that are open
HIER_NUM_OF_OPEN_MDF_REQUEST NUMBER Count of the MDF Requests pending for approval of a Partner and it's hierarchies that are open
SUM_OPEN_MDF_REQUEST_AMT NUMBER Sum of the MDF Requests pending for approval amount of a Partner that are open
HIER_SUM_OPEN_MDF_REQUEST_AMT NUMBER Sum of the MDF Requests pending for approval amount of a Partner and it's hierarchies that are open
USED_APPROVED_BUDGET_AMT NUMBER Amount of MDF utilized from the approved MDF Budget
HIER_USED_APPROVED_BUDGET_AMT NUMBER Amount of MDF utilized from the approved MDF Budget and it's hierarchies
NUM_OF_PEND_APPR_ENROL NUMBER Count of Enrollments of a Partner that are pending for approval
HIER_NUM_OF_PEND_APPR_ENROL NUMBER Count of Enrollments of a Partner and it's hierarchies that are pending for approval
NUM_OF_OPEN_OPTY NUMBER The count of open opportunities within a partner.
HIER_NUM_OF_OPEN_OPTY NUMBER Count of opportunities that are open within a partner hierarchy.
EXTN_ATTRIBUTE_TIMESTAMP001 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP002 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP003 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER001 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER002 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER003 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER004 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER005 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER006 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER007 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER008 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP004 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP005 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP006 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER009 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER010 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER011 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER012 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER013 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER014 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER015 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER016 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP007 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP008 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP009 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER017 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER018 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER019 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER020 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER021 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER022 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER023 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER024 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP010 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP011 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP012 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER025 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER026 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER027 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER028 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER029 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER030 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER031 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER032 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP013 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP014 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP015 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER033 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER034 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER035 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER036 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER037 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER038 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER039 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER040 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP016 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP017 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP018 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER041 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER042 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER043 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER044 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER045 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER046 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER047 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER048 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP019 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP020 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP021 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER049 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER050 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER051 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER052 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER053 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER054 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER055 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER056 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP022 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP023 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP024 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER057 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER058 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER059 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER060 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER061 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER062 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER063 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER064 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP025 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP026 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP027 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER065 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER066 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER067 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER068 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER069 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER070 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER071 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER072 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP028 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP029 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP030 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER073 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER074 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER075 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER076 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER077 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER078 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER079 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER080 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP031 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP032 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP033 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER081 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER082 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER083 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER084 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER085 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER086 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER087 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER088 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP034 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP035 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP036 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER089 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER090 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER091 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER092 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER093 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER094 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER095 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER096 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP037 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP038 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP039 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER097 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER098 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER099 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER100 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP040 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.

Indexes

Index Uniqueness Tablespace Columns
ZPM_PARTNER_ROLLUPS_PK Unique FUSION_TS_TX_DATA PARTY_ID