<!-- wp:paragraph --> <p>SET ROWCOUNT 0</p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>SELECT <br> GLTRN.DEBIT, GLTRN.CREDIT, GLTRN.LINEEXP, GLTRN.TRCURR, GLTRN.TRRATE, GLTRN.DATE_, GLTRN.REPORTRATE, GLTRN.STATUS, GLTRN.BRANCH, GLTRN.DEPARTMENT, GLTRN.SPECODE, GLTRN.LOGICALREF, GLTRN.SIGN, GLTRN.TRCODE, GLTRN.CROSSCODE, GLTRN.REPORTNET, GLTRN.TRNET, GLTRN.AMNT, GLTRN.ACCOUNTREF, GLFIC.FICHENO, GLFIC.LOGICALREF, GLFIC.CYPHCODE, ACCDISTDET.LOGICALREF, ACCDISTDET.TRNET, ACCDISTDET.TRCURR, ACCDISTDET.TRRATE, ACCDISTDET.REPORTNET, ACCDISTDET.REPORTRATE, ACCDISTDET.CREDEBNET, ACCDISTDET.TSIGN, ACCDISTDET.CENTERREF, PROJECT.CODE, PROJECT.NAME, PROJECT.LOGICALREF, PROJECT.ACTIVE, COSTC.CODE, COSTC.ACTIVE, COSTC.DEFINITION_<br> FROM <br> LG_017_02_EMFLINE GLTRN WITH(NOLOCK) LEFT OUTER JOIN LG_017_02_EMFICHE GLFIC WITH(NOLOCK) ON (GLTRN.ACCFICHEREF = GLFIC.LOGICALREF) LEFT OUTER JOIN LG_017_02_ACCDISTDETLN ACCDISTDET WITH(NOLOCK) ON (GLTRN.LOGICALREF = ACCDISTDET.PREVLINEREF) LEFT OUTER JOIN LG_017_PROJECT PROJECT WITH(NOLOCK) ON (ACCDISTDET.PROJECTREF = PROJECT.LOGICALREF) LEFT OUTER JOIN LG_017_EMCENTER COSTC WITH(NOLOCK) ON (ACCDISTDET.CENTERREF = COSTC.LOGICALREF)<br> WHERE <br> (GLTRN.ACCOUNTCODE LIKE '120.00.000020.%' OR GLTRN.ACCOUNTCODE LIKE '120.00.000020') AND (GLTRN.CANCELLED = 0) AND ((GLTRN.DATE_ &gt;= CONVERT(dateTime, '1-1-2018', 101)) AND (GLTRN.DATE_ &lt;= CONVERT(dateTime, '12-31-2018', 101))) AND (GLTRN.BRANCH IN (0)) AND (GLTRN.DEPARTMENT IN (0)) AND (GLTRN.STATUS IN (0))</p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>ORDER BY <br> GLTRN.DATE_, GLTRN.TRCODE, GLTRN.SIGN, GLFIC.FICHENO, GLTRN.LOGICALREF</p> <!-- /wp:paragraph -->