![]() |
#20 |
Участник
|
Цитата:
какой план запроса на рабочем сервере?
A.SETTLEAMOUNTMST,A.CURRENCYCODE,A.DELPOSSIBLECASHDISC,A.DELUTILIZEDCASHDISC,A.DELCASHDISCDATE, A.DUEDATE,A.LASTSETTLEVOUCHER,A.LASTSETTLEDATE,A.CLOSED,A.TRANSTYPE,A.APPROVEDBY,A.APPROVED, A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.EXCHADJUSTMENT,A.DOCUMENTNUM,A.DOCUMENTDATE,A.LASTEXCHADJ, A.CORRECT,A.SETTLEMENT,A.DEL_OPENTRANS,A.INTEREST,A.COLLECTIONLETTER,A.POSTINGPROFILECLOSE,A.FROMACCOUNT,A.TOACCOUNT, A.DELOPEN,A.PAYMMODE,A.PAYMREFERENCE,A.PAYMMETHOD,A.CASHPAYMENT,A.CONTROLNUM,A.DELIVERYMODE,A.POSTINGPROFILE, A.OFFSETRECID,A.EUROTRIANGULATION,A.ORDERACCOUNT,A.CASHDISCCODE,A.PREPAYMENT,A.DEL_EXCHADJUSTMENTTOTAL,A.PAYMSPEC, A.CUSTEXCHADJUSTMENTREALIZED,A.CUSTEXCHADJUSTMENTUNREALIZED,A.OCRLINE,A.PAYMMANLACKDATE,A.PAYMMANBATCH,A.PAYMID, A.BILLOFEXCHANGEID,A.BILLOFEXCHANGESTATUS,A.BILLOFEXCHANGESEQNUM,A.BANKREMITTANCEFILEID,A.COLLECTIONLETTERCODE,A.PREPAYMENTINVOICE_RU, A.CASHPAYMENT_RU,A.SETTLESALESTAXONPAYMENT_RU,A.SALESTAXONPAYMENT_RU,A.RTAX25AMORTISATION,A.RCONTRACTCODE, A.RCONTRACTACCOUNT,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,A.CREATEDTIME, A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECVERSION,A.RECID,B.RCONTRACTPARTNERTYPE,B.RCONTRACTACCOUNT,B.RCONTRACTNUMBER, B.CONTRACTDATE,B.CONTRACTSTARTDATE,B.CONTRACTENDDATE,B.CONTRACTAMOUNT,B.CONTRACTVATAMOUNT,B.CURRENCYCODE, B.CONTRACTPAYMCODE,B.RCONTRACTPARTNERCODE,B.RCONTRACTSTATUS,B.CONTRACTPOSTINGPROGILE,B.CONTRACTPREPAYMENTPOSTING16014, B.CONTRACTRESPONSIBLEPERSON,B.CONTACTPERSONID,B.CONTRACTPAYMMODE,B.CONTRACTPAYMSPEC,B.CONTRACTPAYMENTSCHED, B.CONTRACTCASHDISC,B.CONTACTPHONE,B.LINEOFBUSSENESID,B.CONTACTTELEX,B.CONTACTURL,B.CONTACTEMAIL,B.CONTACTTELEFAX, B.CONTACTCELLULARPHONE,B.CONTACTPHONELOCAL,B.CONTRACRTHRMORGANISATIONID,B.RCONTRACTCODE,B.RCONTRACTPAYMDAYID, B.RCONTRACTACCOUNTBASIC,B.RCONTRACTCODEBASIC,B.RCONTRACTPARTNERCODEBASIC,B.PERIODEXPOSINVOICE4PAYM, B.PERIODGRANTEVIDENCE,B.DAYSHOOTEVIDENCE,B.PERIODADVANCEPAYMENT,B.FACTOREXCESS,B.BANKACCOUNTID, B.GROUPFINANCID,B.DECEMBER,B.NOVEMBER,B.OCTOBER,B.SEPTEMBER,B.AUGUST,B.JULY,B.JUNE,B.MAY,B.APRIL,B.MARCH, B.FEBRUARY,B.JANUARY,B.PERCENTADVANCE,B.SOURCE,B.PARAMETERWARNING,B.TYPECONTRACT,B.CONTRACTNUMBERDATE, B.EXPOSEPAYMENT,B.ACCEPTANCE,B.PERIODACCEPT,B.TERMPAYMENT,B.PERIODPAYMENT,B.DELIVERY,B.CONTRACTFORM,B.PROLONG, B.VIEWWARNING,B.ISWARN,B.PARMADVANCECALC,B.REGIONNETID,B.PRINTMARK,B.SPGESCONTRACTADD,B.SPGESGRUZOPOKUP,B.SPGESSITE, B.MODIFIEDDATE,B.MODIFIEDTIME,B.MODIFIEDBY,B.CREATEDDATE,B.CREATEDTIME,B.CREATEDBY,B.RECVERSION,B.RECID,B.RCONTRACTSUBJECT FROM CUSTTRANS A,RCONTRACTTABLE B WHERE ((A.DATAAREAID='Company') AND (A.TRANSDATE<={TS '2008-12-31 00:00:00.000'})) AND ((B.DATAAREAID='Company') AND (((((B.GROUPFINANCID='ТСЖ 1') AND (B.RCONTRACTPARTNERTYPE=0)) AND (A.ACCOUNTNUM=B.RCONTRACTPARTNERCODE)) AND (A.RCONTRACTACCOUNT=B.RCONTRACTACCOUNT)) AND (A.RCONTRACTCODE=B.RCONTRACTCODE))) ORDER BY A.DATAAREAID,A.TRANSDATE,A.ACCOUNTNUM,A.VOUCHER OPTION(FAST 7) Цитата:
И ещё увидел у вас в коде
X++: rangeDimension = queryRun.query().dataSourceTable(tableNum(CustTrans)).rangeField(fieldId2ext(fieldnum(CustTrans, Dimension),2)).value(); Вы этот фильтр не используете. он пустой во время тестирования?
__________________
..в каждой программе есть хотя бы одна ошибка.. |
|
|
|