Formatted search that does not change if the row is based on another document:
SELECT ( case
when $[$38.45.Number] > 0
then $[$38.U_PLS_AddnlDesc.0]
Else
(select
T0.[FrgnName] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0])
end)
as AddlDesc
Comments
0 comments
Please sign in to leave a comment.