Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

AccountSellerAssignment

Data source: asazure://centralus.asazure.windows.net/accountscyprod

EVALUATE(
CALCULATETABLE(
SUMMARIZECOLUMNS(
vw_CY_ASTAssignments_Full[MSSalesTPID]
,vw_CY_ASTAssignments_Full[AccountName]
,vw_CY_ASTAssignments_Full[EmailAlias]
,vw_CY_ASTAssignments_Full[AssignmentStartDate]
,vw_CY_ASTAssignments_Full[AssignmentEndDate]
,vw_CY_ASTAssignments_Full[ReportingManagerAlias]
,vw_CY_ASTAssignments_Full[AssignmentStatus]
,vw_CY_ASTAssignments_Full[StandardTitle]
,vw_CY_ASTAssignments_Full[Qualifier1]
,vw_CY_ASTAssignments_Full[Qualifier2]
,vw_CY_ASTAssignments_Full[ROLE]
,vw_CY_ASTAssignments_Full[MCSCoverageModel]
,vw_CY_ASTAssignments_Full[OrgDesc],
vw_CY_ASTAssignments_Full[CreatedDate],
vw_CY_ASTAssignments_Full[CreatedByAlias],
vw_CY_ASTAssignments_Full[LastModifiedDate],
vw_CY_ASTAssignments_Full[LastModifiedByAlias],
"VNP","",
"VNPName",""
)
,KEEPFILTERS(vw_CY_ASTAssignments_Full[AssignmentStatus]="ACTIVE")
)
)