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
  • T_Kress's avatar
    T_Kress
    Valued Contributor
    2 months ago

    If you load the Solution Exchange tool called Table Data Manager into your app, it will allow you to look at the scheme for all application tables and views.

    That should help you:

     

  • cap08's avatar
    cap08
    New Contributor III
    2 months ago

    I will definitely use that tool, thanks!

  • 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|'

       

    • MarcusH's avatar
      MarcusH
      Valued Contributor
      2 months ago

      Do you mean Fs and not Fx? If so then that is FlipSign.

      • cap08's avatar
        cap08
        New Contributor III
        2 months ago

        oh you're right - Fs - thanks

  • Henning's avatar
    Henning
    Valued Contributor II
    2 months ago

    Hi, with regards to the other part of your question, how do you mean that exactly, "Has anyone created an intercompany report by entity?"?

    Assuming your legal entities are in the entity dimension, the system default intercompany report is showing the matching by legal entity.

    Or do you mean on a IC transaction basis, which is why you want to look at the stage table? In that case, take a look at the transaction matching solution from OneStream, if that is what you are looking for.