【059】应收单交易分录【主营业务收入】

获取应收单行的预设科目=主营业务收入的会计科目

查询SQL语句

select head.DocNo,arline.LineNum,Act.Segment1
from AR_ARBillLine as arline
inner join AR_ARBillHead as head on head.ID=arline.ARBillHead
inner join AR_ARBillRCLine as arrcline on arrcline.ARBillLine=arline.ID
inner join AAI_TransactionEntry as aai on aai.OriginalEntityType='UFIDA.U9.AR.ARBill.ARBillRCLine' and aai.OriginalEntity=arrcline.ID -- 交易分录
inner join AAI_TransEntryTemplet as aaitemp on aaitemp.ID=aai.EntryTemplet -- 交易分录模板
inner join AAI_PredeterminedAccount_Trl as aaipreaccl on aaipreaccl.ID=aaitemp.PredAcct and aaipreaccl.Name=N'主营业务收入' -- 预设科目
inner join CBO_Account AS Act ON aai.Account = Act.ID -- 会计科目
where head.DocNo='102TH2024110309'

结果