Skip to Content
0

Query For Document Row level FMS

Jan 04 at 12:09 PM

85

avatar image

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]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagarajan K Jan 04 at 01:07 PM
0

Hi,

Try this query,

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

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded