Clarity

  • Private Community

  • 1.  How are PLANNED and BUDGET costs fields being calculated?

    Posted Jun 17, 2016 02:17 PM

    These fields are stored as BLOBs in the Financials table and I'm having a hard time reproducing the front-end numbers in my query.

     

    PLANNED_COST_CAPITAL

    PLANNED_COST_OPERATING

    PLANNED_COST

    BUDGET_COST_CAPITAL

    BUDGET_COST_OPERATING

    BUDGET_COST

     

    Note: Just need the details for the non-Total fields.

     

    Thanks,



  • 2.  Re: How are PLANNED and BUDGET costs fields being calculated?
    Best Answer

    Broadcom Employee
    Posted Jun 17, 2016 05:43 PM

    Hello Marlon,

     

    Based on the column attributes mentioned, the table being referenced is FIN_FINANCIALS


    The following article helps gain information:
    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec440146.aspx

    Can you provide more details regarding the Financial Planning Slice Tables?

     

    Regards,

    Tuan



  • 3.  Re: How are PLANNED and BUDGET costs fields being calculated?

     
    Posted Jun 24, 2016 04:28 PM

    Hi marlon.mckenzie.1 - Did TuanTran's response help answer your question? If so please mark as Correct Answer. Thanks!