Microsoft AX 2012 Components

We want some component built using Microsoft Dynamics AX 2012 data structures that will take data and push/extract data into AX 2012 to

a - create new records (inform of data errors)
b - update existing records (inform of data errors)
c - output records to a csv file.

We would like this built in the AX development environment or direct SQL stored procedures. If we have direct SQL stored procedures, it would be perfect as we can then use the code to integrate and pull data from other sources also.

Customer Data -> In/Out
Product Data -> In/Out
Stock Data -> In/Out
Order Data -> In/Out
Invoice Data -> Out

For example, Customer Fields in AX2012 we would like are below

1. Customer Account
2. Record Type
3. Customer Name
4. Customer Group (underlined are the ones presented in a form)
- B2B (Business to Business)
- B2B_EU
- B2B_Non_EU
- B2B_UK
- B2B1 (Business to Business <10000)
- Bunzl (Bunzl Customer Group)
- EU (Europe)
- GP (GP Surgeries)
- INT (International – Rest of the world)
- MISC (Miscellaneous)
- NHS (NHS Hospitals)
- PH (Private Hospitals)
- PH_N (Private Hospitals Nuffield)
- RDC (Regional Distribution Centres)
- UN (Un-Allocated)
5. Language (default en-gb)
6. Currency (GBP default)
7. Vat Group (underlined are the ones presented in a form)
- DOM_CUS (Domestic Sales)
- DOM_SUP (Domestic Purchases)
- EU_CUS (EU Sales)
- EU_SUP (EU Purchases)
- EXPORT (Export Vat Outside of EU)
- IMPORT (Import Vat Outside of EU)
- ZERO (Zero Vat)
- ZERO_SUP (Zero Rated Suppliers)
8. Vat Number
9. Item Vat Group (generated combination of VAT Group & VAT Number)
10. Terms of Payment
11. Country (Primary Address)
12. Postcode (Primary Address)
13. Street (Primary Address)
14. Street Number (Primary Address)
15. City (Primary Address)
16. Phone (Primary Address)
17. E-Mail Address
Additional Customer Information

Credit and Collections Section
• Invoicing and delivery on hold (default value No)
• Mandatory credit limit (0 or 1)
• Credit Limit (default 0.00)

Sales order defaults Section
• Site (Rocialle)
• Warehouse: (400)

Invoice and Delivery Section
• Invoice Account
• Invoice Address
• Invoice Template (PSAProjInvoice.Report)