The aim of this project was to develop Data mapping within an asset allocation analysis Portal, the system receive accounts payable raw data (text files) from the client from different systems (ORACLE, ,SQL SERVER) which will be converted into SQL Data. Firstly, we needed to understand how the data look like as per the accounts payable . we needed to check , if we got correct tables and all the necessary tables which are used for accounts payable. Also, we needed to check for the credits, debits, payment and journals. Here joins were created between the client tables and after running certain scripts finally transaction table will be created