Код:
//ЗАПРОС ПО ТАБЛИЦЕ МОДЕЛЕЙ УЧЕТА
qbds = this.query().dataSourceTable(tablenum(RAssetStandards));
qry = new Query();
qbds=qry.addDataSource(tablenum(RAssetStandards),'lbdt2');
//инв номер ОС
qbr=qbds.addRange(fieldnum(RAssetStandards,AssetId));
strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,AssetId)).value();
qbr.value(strRangeValue);
//срок жизни
qbrLife=qbds.addRange(fieldnum(RAssetStandards,Lifetime));
strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,Lifetime)).value();
qbrLife.value(strRangeValue);
//профиль разноски
qbrProfile=qbds.addRange(fieldnum(RAssetStandards,PostingProfile));
strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,PostingProfile)).value();
qbrProfile.value(strRangeValue);
//группа амортизации
qbrGroup=qbds.addRange(fieldnum(RAssetStandards,AssetGroup));
strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,AssetGroup)).value();
qbrGroup.value(strRangeValue);
//модель учета
qbrStandard=qbds.addRange(fieldnum(RAssetStandards,assetStandardId));
strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,assetStandardId)).value();
qbrStandard.value(strRangeValue);
excelDocument.InsertValue(ComExcelDocument_RU::numToNameCell(3,4),
strRangeValue);
//ЗАПРОС ПО ТАБЛИЦЕ ПРОВОДОК ОС
qbdsAT = qbds.addDataSource(tablenum(RAssetTrans));
qbdsAT.fetchMode(JoinMode::INNERJOIN);
qbdsAT.relations(true);
qbdsAT.addLink(fieldnum(RAssetTrans, accountNum), fieldnum(RAssetStandards, assetId));
qbdsAT.addSortField(fieldnum(RAssetTrans, Voucher));