[{"_id":ObjectId("5d654ed25616a9d461bc0a91"),"aC":"AN","aI":"ABCD","aN":"000000000001","aT":"AB","pD":"2022-11-07","transaction":{"seqNo":1,"tC":"S"}},{"_id":ObjectId("5d654ed25616a9d461bc0a93"),"aC":"AN","aI":"ABCD","aN":"000000000001","aT":"AB","pD":"2022-11-07","transaction":{"seqNo":1,"tC":"S"}},{"_id":ObjectId("5d654ed25616a9d461bc0a92"),"aC":"AN","aI":"ABCD","aN":"000000000002","aT":"AB","pD":"2022-11-08","transaction":{"seqNo":2,"tC":"S"}}]

db.collection.aggregate([{"$group":{"_id":{"aC":"$aC","aI":"$aI","aN":"$aN","aT":"$aT","seqNo":"$transaction.seqNo","tC":"$transaction.tC","pD":"$pD"},doc:{$first:"$$ROOT"}}},{"$replaceRoot":{"newRoot":"$doc"}},{"$merge":{"into":"B","on":"_id","whenMatched":"replace"}}])