Post Code Hierarchy???

Dear Colleagues,

I have a bit complex situation and not sure how to build that in BW. Client is having 6 Divisions and in total there are 400 Area Post Code (Area Pin Code) in UK. Now the client is maintaining that in flat file as... all 400 post codes --> their corresponding Divisions --> and then respective Sales Rep.

Post code is a key driver here because 1 post code can be served by one or many sales rep and vice-varsa. Now if want to replicate that in BW, what is best feasible way to do the same?

Even you small inputs always been helpful, please respond.

Regards

Milind