![]() |
#9 |
Программер
|
Аксапта 3.0 сп3
СУБД SQL Server 2005 SP2 (9.0.3042) План запроса: Код: SELECT A.ACCOUNTNUM,A.TRANSDATE,A.VOUCHER,A.TXT,A.AMOUNTMST,A.AMOUNTCUR,A.CURRENCYCODE,A.TRANSTYPE,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.DIMENSION5_,A.DIMENSION6_,A.DIMENSION7_,A.DIMENSION8_,A.QTY,A.PURCHLEDGERID,A.DOCUMENTDATE,A.JOURNALNUM,A.JOURNALIZESEQNUM,A.ALLOCATELEVEL,A.POSTING,A.CORRECT,A.DEL_CLOSEDID,A.CREDITING,A.DOCUMENTNUM,A.PAYMREFERENCE,A.PERIODCODE,A.OPERATIONSTAX,A.TOACCOUNT,A.FROMACCOUNT,A.PAYMMODE,A.JOURNALIZENUM,A.AMOUNTMSTSECOND,A.EUROTRIANGULATION,A.FURTHERPOSTINGTYPE,A.LEDGERPOSTINGJOURNALID,A.TAXREFID,A.DEL_OFFSETACCOUNTNUM_RU,A.BONDBATCHTRANS_RU,A.BONDBATCH_RU,A.RTSLFROMCOMPANYID,A.RTSLSESSIONTRANSID,A.JOURNALLINENUM,A.INSIDEDOCUMENTNUM,A.AVISODIMENSION,A.AVISODIMENSION2_,A.AVISODIMENSION3_,A.AVISODIMENSION4_,A.AVISODIMENSION5_,A.AVISODIMENSION6_,A.AVISODIMENSION7_,A.AVISODIMENSION8_,A.DOCUMENTLINENUM,A.MODULETRANS_RU,A.MODULETRANSID_RU,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECID FROM LEDGERTRANS A WHERE ((DATAAREAID=?) AND (CREDITING=?)) ORDER BY A.DATAAREAID DESC,A.BONDBATCH_RU DESC,A.BONDBATCHTRANS_RU DESC,A.CREDITING DESC OPTION(FAST 1) |
|