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.

SupportDeliveryContractAgreement

Data source: ESA_CES_Prod

evaluate
summarizecolumns
(
Agreement[Agreement ID],
Agreement[Agreement Name],
'Top Parent Account'[Primary TPID],
'Top Parent Account'[Primary TPID Name],
'Top Parent Account'[MS Sales Top Parent ID],
'Top Parent Account'[MS Sales Top Parent Name],
'Top Parent Account'[TP Segment Name],
'Top Parent Account'[TP Sub Segment Name],
Agreement[Work Performed For TPID],
Agreement[Work Performed For TPID Name],
Agreement[Agreement Status],
Agreement[Agreement Type],
Agreement[Agreement Start Date],
Agreement[Agreement Renewal Date],
Agreement[Agreement End Date],
Agreement[Actual Renewed Date],
Agreement[Is Unified Broker Agreement],
Agreement[Is Multi-Year Agreement],
Agreement[Is Extension Active],
Agreement[Is Agreement Active],
Agreement[Is Invalid Agreement],
Agreement[Is Early Renewal],
Agreement[Is Upcoming Expiration],
Agreement[Renewed From],
Agreement[Renewed From Category],
Agreement[Renewed To],
Agreement[Renewed To Category],
Agreement[Renewed To Agreement Type],
"Agreement Net Amount USD",[Agreement Net Amount USD]
)