Extract data from Microsoft Dynamics AX 2012 r2 and Insert Sales Orders using MD Web Services

My project requires to create SQL Data Views to extract records from Microsoft Dynamics 2012 r2. Each data view must return certain fields based on our data dictionary. For example, my Customer table has the following structure: Field Name Data Type CustomerCode Character (20), PK CustomerName Character (60) CustomerInternalCode Character (20) CustomerCommercialName Character (60) CustomerTaxpayerId Character (20) CustomerTaxpayerIdType Character (20) CustomerStatus Character (1) CustomerOpenOn DateTime CustomerCreditStatus Character (1) CustomerCreditLimit Decimal (17,4) CustomerCreditUsed Decima (17,4) CustomerSalesPersonCode Character (20) TerritoryCode Character (20) CustomerCategoryCode Character (20) So I need an equivalent SQL Data View from Microsoft Dynamics Customer table. The data views to be created are: • CustomerCategory • Manufacturer • PaymentTerm • PaymentType • PresentationType • ProductBrand • ProductGroup • ProductSubgroup • Store • Territory • Customer • CustomerAddress • CustomerPhone • CustomerContact • CustomerBalance • CustomerTransaction • CustomerPaymentType • CustomerPaymentTerm • CustomerInvoice • CustomerInvoiceDetail • PriceList • PriceListItem • CustomerPriceList • PriceListItemRange • Product • ProductInventory • ProductPaymentType • ProductPaymentTerm • ProductPresentation • SalesPersonStatistic • SalesPersonTerritory I will provide field descriptions for each table I need. I also need to insert Sales Orders on Microsoft Dynamics using their web service. Please do not place your bid if you have not worked at least one year with Microsoft Dynamics AX.