Forum Discussion

cap08's avatar
cap08
New Contributor III
2 months ago

Intercompany Report and Stage Table Questions

Hi,  Has anyone created an intercompany report by entity? I'm trying to use the vstagesourceandtargetdata table - is there any documentation with descriptions of the table's columns? Thanks! ...
Reports
cap08's avatar
cap08
New Contributor III
2 months ago

This tool is great! Just wish it explained what the column names represented. I can figure out most of them except 'Fak', 'Lb', 'Tv' and 'Fx'. 

 

T_Kress's avatar
T_Kress
Valued Contributor
2 months ago

Lb = the label field at the data source level.  As far as the others I do not know.  Maybe set up an adaptor SQL to pull top 1,000 rows from the view and see if the data in the view helps you understand those columns.

Here is SQL for a data adaptor, just be sure to limit it to top 1,000 or a particular time or WF name.

SELECT TOP (1000) 
       [Wfk]
      ,[Wsk]
      ,[Wtk]
      ,[Fak]
      ,[Ri]
      ,[Rt]
      ,[Si]
      ,[Lb]
      ,[Tv]
      ,[Et]
      ,[EtT]
      ,[EtR]
      ,[Pr]
      ,[PrT]
      ,[PrR]
      ,[Cn]
      ,[CnT]
      ,[CnR]
      ,[Vw]
      ,[VwT]
      ,[VwR]
      ,[Sn]
      ,[SnT]
      ,[SnR]
      ,[Tm]
      ,[TmT]
      ,[TmR]
      ,[Ac]
      ,[AcT]
      ,[AcR]
      ,[Fw]
      ,[FwT]
      ,[FwR]
      ,[Og]
      ,[OgT]
      ,[OgR]
      ,[Ic]
      ,[IcT]
      ,[IcR]
      ,[U1]
      ,[U1T]
      ,[U1R]
      ,[U2]
      ,[U2T]
      ,[U2R]
      ,[U3]
      ,[U3T]
      ,[U3R]
      ,[U4]
      ,[U4T]
      ,[U4R]
      ,[U5]
      ,[U5T]
      ,[U5R]
      ,[U6]
      ,[U6T]
      ,[U6R]
      ,[U7]
      ,[U7T]
      ,[U7R]
      ,[U8]
      ,[U8T]
      ,[U8R]
      ,[Fs]
      ,[RawAmount]
      ,[ConvertedAmount]
FROM [dbo].[vStageSourceAndTargetDataWithAttributes] WHERE TmT ='|WFTime|'