Hello Leo,
Here is the SQL query.
SELECT A.ACCTGRPINDEX as GRPINDEX, A.ACCTGRPID as GRPID, A.ACCTGRPDESC as GRPDESC,
ISNULL(E.ACTNUMST,'') as ASSET_COST,
ISNULL(F.ACTNUMST,'') as PROCEEDS,
ISNULL(B.ACTNUMST,'') as DEPRCTN_EXP,
ISNULL(C.ACTNUMST,'') as DEPRCTN_RESERVE,
ISNULL(D.ACTNUMST,'') as DEPRCTN_PR_YR,
ISNULL(G.ACTNUMST, '') as GL_RECOGNIZED,
ISNULL(H.ACTNUMST, '') as GL_NON_RECOG,
ISNULL(I.ACTNUMST, '') as CLEARING
FROM FA41300 A
left join GL00105 B on B.ACTINDX = A.DEPREXPACCTINDX
left join GL00105 C on C.ACTINDX = A.DEPRRESVACCTINDX
left join GL00105 D on D.ACTINDX = A.PRIORYRDEPRACCTINDX
left join GL00105 E on E.ACTINDX = A.ASSETCOSTACCTINDX
left join GL00105 F on F.ACTINDX = A.PROCEEDSACCTINDX
left join GL00105 G on G.ACTINDX = A.RECGAINLOSSACCTINDX
left join GL00105 H on H.ACTINDX = A.NONRECGAINLOSSACCTINDX
left join GL00105 I on I.ACTINDX = A.CLEARINGACCTINDX
I hope this is what you are looking for.
--
@dyngp_warren
