SQL to Aurelius

In this case create a bidirectional association, adding the other side of the association in TPerPay object:




  [ManyValuedAssociation([], CascadeTypeAllRemoveOrphan, 'FPerPayId')]
  property DebItmDList: TList<TDebItmD > read FDebItmDList write FDebItmDList;


as described here: http://www.tmssoftware.biz/business/aurelius/doc/web/lazy-loading_associations.html

If your relation is 1-1 (which it seems from your SQL) you are all good, if not you can remove duplicates: http://www.tmssoftware.biz/business/aurelius/doc/web/removing_duplicated_objects.html