Community Facebook Twitter LinkedIn YouTube Overview Why Choose Products Add-on Services Support Partners Community Buy Now Swiftpage, SalesLogix and ACT! Are Now One
Community Home Blogs Share Ideas Search Request Access additional resources
Reply
New Member
raineycd
Posts: 2
Country: USA
Message 1 of 3 (311 Views)
Accepted Solution

TBL_CONTACT Schema

I can't seem to find a schema list for TBL_CONTACT.  I am looking for the real name of the "Craft" field but a full list of field names would be very helpful!

 

Thanks!

Chad

Please use plain text.
Moderator
mwood
Posts: 1,105
Country: USA
Message 2 of 3 (289 Views)

Re: TBL_CONTACT Schema

There are other ways, but you can get a complete list of all fields in the DB via ActDiag (start -> run : ActDiag). From there go to the database list, right click on your database and choose Database Reports -> Database Structure -> Field Detail Report.

Matthew Wood
Sage Act SDK Support
Community Moderator
Please use plain text.
New Member
raineycd
Posts: 2
Country: USA
Message 3 of 3 (286 Views)

Re: TBL_CONTACT Schema

Thank you, thank you, thank you!!!  That helps a TON!!!  And Craft = CATEGORY - never would have guessed that one!

Please use plain text.