Skip to Content
0
Dec 19, 2018 at 09:09 AM

Getting error in calculation view using Sql Script View

75 Views

Dear Team,

Schema name is A_GM

SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."BPLName", T0."CashAcct", T0."Canceled", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."OVPM" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode" UNION ALL SELECT 'IC Pymt' "DocType", T0."CardCode", T0."DocDate", T0."DocTotalSy",T0."CheckAcct", T0."CashAcct", T0."Canceled", T0."BPLName", T1."CardName", T1."City", T1."CardType", T1."State1",T2."GroupName", T3."AcctName" FROM "A_GM"."ORCT" T0 LEFT OUTER JOIN "A_GM"."OCRD" T1 ON T0."CardCode" = T1."CardCode" LEFT OUTER JOIN "A_GM"."OCRG" T2 ON T1."GroupCode" = T2."GroupCode" LEFT OUTER JOIN "A_GM"."OACT" T3 ON T0."CardCode" = T3."AcctCode"

Please find the screenshot for the error.

Attachments

cal.png (252.7 kB)