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.

ECIF

Data source: ECIFAS

EVALUATE
SUMMARIZECOLUMNS
(
'ECIF Case'[Case Id],
'ECIF Case'[Case Name],
'ECIF Case'[Case Requester],
'Profit Center'[Funding Source],
'ECIF Case'[Sponsoring Area],
'ECIF Case'[Sponsoring SubRegion],
'ECIF Case'[Sponsoring Country],
'ECIF Case'[Case Approved Date],
'ECIF Case'[Case Start Date],
'ECIF Case'[Case End Date],
'ECIF Case'[Case Close Reason],
'ECIF Case'[Case Status],
'ECIF Case'[Case Competitor],
'ECIF Case'[Submitted Date],
'ECIF Program'[Program Name],
'ECIF Program'[Program Id],
'ECIF Program'[Program Owner],
'ECIF Program'[Program Status],
'Account Information'[TPID],

'ECIF Case'[Case Created Date],
'ECIF Case'[Case Request Created By],
'ECIF Program Request'[IO Create Date],
'ECIF Case'[Planned Vendor Name],
'ECIF Case'[Planned Vendor No.],
'ECIF Case'[Status Detail],
'Account Information'[TPID Area],
'Account Information'[Top Parent],
'ECIF Supplier'[Vendor Id],
'Purchase Order Details'[PO Submitted Date],
'Purchase Order Details'[PO Approved Date],

'ECIF Program'[Program Year],
'ECIF Program Request'[Program Request Approval Status],
'Primary Product'[Primary Product],
'ECIF Program'[Program Type],
"ECIF Case Count", [ECIF Case Count]
)