Community
Showing results for 
Search instead for 
Do you mean 
Reply

how do know product table name?

Avid Listener
Posts: 83
Country: Malaysia

how do know product table name?

hi all,

 

how do i know product table name ?  As for contact is tbl_contact.

 

Thanks.

Bronze Super Contributor
Posts: 1,231
Country: USA

Re: how do know product table name?

You can run the Database Structure report using the ACTDiag.exe tool at the root of ACTsage.exe

 

This will be a very long report detailing all tables and fields in ACT!.  Here is a short example of the Products section:

  

-------------------------------------------------
    ACT! Table: Opportunity Product
Physical Table: TBL_OPPORTUNITY_PRODUCT
  Record Count: 397
 Created On/By: May 24 2006  6:39AM / ACT! System
   Field Count: 18 (17 Physical, 0 Virtual, 1 Calculated)
(in approx. bytes) Supported Pagesize: 8096, Current Pagesize: 1063, Available Pagesize: 7033

 

 

Hope this helps

-- Jim Durkin

Avid Listener
Posts: 83
Country: Malaysia

Re: how do know product table name?

Hi Jimdurkin,

 

Thanks and its solved.