Skip to Content

Query For Document Row level FMS

Hi,

I have created one UDF field in the name of Department in Cost center. This field value has to display in one of the RDR1 table, When PrcCode from OPRC & OcrCode from RDR1 is Same. My below query is not displaying the value...

SELECT T0.U_Department FROM OPRC T0 WHERE T0.PrcCode = $[$38.1.0]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 04 at 01:07 PM

    Hi,

    Try this query,

    SELECT T0.U_Department FROM OPRC T0 WHERE T0.PrcCode = $[$38.2004.0]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded