Linking GLTrans table with APDISTRIB

Sort:
You are not authorized to post a reply.
Author
Messages
JL Cabrera
New Member
Posts: 1
New Member

    Can anyone help me with the relationship between the gltrans table and the apdistrib?  I need to join both tables for reporting purposes.  Thanks in advance for the help.

     

    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      https://www.lawsonguru.co.../topic/Default.aspx=
      Thanks for using the LawsonGuru.com forums!
      John
      John Costa
      Veteran Member
      Posts: 154
      Veteran Member
        SELECT GLT.COMPANY, GLT.FISCAL_YEAR, GLT.ACCT_PERIOD, GLT.CONTROL_GROUP, GLT.SYSTEM, GLT.ACCT_UNIT, GLT.ACCOUNT, GLT.SOURCE_CODE,
        LTRIM(RTRIM(GLT.DESCRIPTION)) AS DESCRIPTION, GLT.ACTIVITY, GLT.ACCT_CATEGORY, GLT.STATUS, GLT.TRAN_AMOUNT, APD.INVOICE,
        GLT.OBJ_ID
        FROM dbo.GLTRANS AS GLT WITH (NOLOCK) LEFT OUTER JOIN
        dbo.APDISTRIB AS APD WITH (NOLOCK) ON GLT.OBJ_ID = APD.GLT_OBJ_ID
        _________________ John - Wichita, KS
        You are not authorized to post a reply.