Michael,

Thanks for your input. I have actually seen this and it is great for it maps out the table relations. Unfortunately it only lists key fields.

What I was looking for was a printed list of all the fields in each table, their data types and their lengths. I can get this information with the references everyone has provided but it will be tedius to build the lists. I'm surprised that Salesforce does not have a doc on this as it seem to me to be a pretty basic piece of reference material.

I need the list because I am modeling the entire schema in a datamart to be used to mix SFDC data with data from other  DBMS's  for local reporting. The whole thin will sit under a report writer, much like Crystal but much easier to use for folks new to report writing. The system will have all the standard relations mapped so that all a user has to do is pull out the fields they want and plop them on the screen. The datamart data pull runs on a schedule so the datamart gets auto-magically populated overnight and it will do a transform on the fly if required.

I noticed there were products that charge a yearly fee (in the 8k a year range) for similar services, i.e. pulling SFDC data down locally and thought it was a bit much so we are developing this report write for folks so they can pay for it once and not have to deal with the subscription fees associated with the other products.

The report writer is done, All I need to do is model the SFDC tables in the datamart and build the autolink table. Hence, I was looking for an easy to read list of data fields with their associated lengths and data types.

What I have will have to suffice though. I suppose I should post the list on one of our websites one it is done so others will have a place to go for the reference.

Thanks for your input.

Daniel