Hi everyone. I am new here and, as well, I am new to SalesForce DC I am building a user friendly reporting tool for Salesforce with a datamart so you can pull down your SFDC data locally and report off of it alone or in conjunction with data from one or more other in house database systems. I have searched high and low on the SFDC site and for the life of me I can not find a simple list of the tables with their fields, lengths, and datatypes. Figuring them out one at a time will get old fast. I don't suppose anyone here could point me in the correct direction? Thanks in advance! Daniel

Daniel that was my hardest thing to learn too when I started working with Salesforce and the API.

What type of database are you using? If it is Oracle or MySQL, I have a tool that will create a complete schema of our salesforce instance right here on this site that you can download and run, in php, on your localhost or web server.

Hope that helps

~Mike

Hi Daniel,

The Standard Objects page is a good starting point: Standard Objects

You may also find the Entity Relationship Diagrams useful:
Data Model

Regards,
toivo