Project Invoice AutoAccounting rule

Hello

I want to create Accounting for Project Invoice  on the basis of Event types Or Expenditures. I.e. the (Receivables) Dr natural account segment in AA rules should populate value per Event Type or Expenditure Type. Is possible using source as SQL code (since Parameter as a lone source does not look a workable option). One Invoice can have multiple events & expenditures.

Event type A : Natural A/c code: 123456

Event type B : Natural A/c code: 234561

EXP type C : Natural A/c code: 123456

Thanks in advance

Nikhil