SET ROWCOUNT 0 SELECT 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_ FROM LG_003_03_EMFLINE GLTRN WITH(NOLOCK) LEFT OUTER JOIN LG_003_03_EMFICHE GLFIC WITH(NOLOCK) ON (GLTRN.ACCFICHEREF = GLFIC.LOGICALREF) LEFT OUTER JOIN LG_003_03_ACCDISTDETLN ACCDISTDET WITH(NOLOCK) ON (GLTRN.LOGICALREF = ACCDISTDET.PREVLINEREF) LEFT OUTER JOIN LG_003_PROJECT PROJECT WITH(NOLOCK) ON (ACCDISTDET.PROJECTREF = PROJECT.LOGICALREF) LEFT OUTER JOIN LG_003_EMCENTER COSTC WITH(NOLOCK) ON (ACCDISTDET.CENTERREF = COSTC.LOGICALREF) WHERE (GLTRN.ACCOUNTCODE LIKE '100.01.003.%' OR GLTRN.ACCOUNTCODE LIKE '100.01.003') AND (GLTRN.CANCELLED = 0) AND ((GLTRN.DATE_ >= CONVERT(dateTime, '1-1-2017', 101)) AND (GLTRN.DATE_ <= CONVERT(dateTime, '12-31-2017', 101))) AND (GLTRN.BRANCH IN (0,1,2)) AND (GLTRN.DEPARTMENT IN (0)) AND (GLTRN.STATUS IN (0)) ORDER BY GLTRN.DATE_, GLTRN.TRCODE, GLTRN.SIGN, GLFIC.FICHENO, GLTRN.LOGICALREF