IDCUST field in Accpac Tables... Relationships

[Stamina007]

Hi
Hi

Does anyone have table 'relationships' of Accpac. I have the ACCPAC Advantage Series Application Object Models that shows you all the tables and views but no relationships..

I need to know for instance what tables have the customer code (IDCUST) in. We using Accpac 5.0 Advantage and I need to write a simple VB Program to change an old customer code to a new customer code. Same customer only the customer code changes.

We talk directly via ODBC to the Accpac Tables in MS SQL. Its easy to look for IDCUST field in all the tables but sometimes its called things like CUSTOMER in the OEINVH and OEINVD tables. I Need to change it in all the tables that has it in.

My next project is to do the same type of thing for the Item Code in ICITEM. So I need to know what tables contains the ICITEM field.

Any help would be much appreciated.

JayCee

 

[jayconverse]

Forget it, you'll corrupt your database. Get the Customer Number Change and Item Number change options products from Accpac.

Jay Converse
IT Director
Systemlink, Inc.

 

[Stamina007]

Thanks for the advice, but we are talking Microsoft SQL here not Pervasive. So we change the field value directly when nobody works on the database.

Why would it corrupt if we change all the relevant customer codes ?

 

[jayconverse]

The database doesn't matter, I work with all of them. Go ahead and do what you want, it's your data.

Jay Converse
IT Director
Systemlink, Inc.

 

[Stamina007]

We've used the Customer Change product before and find that it takes too long. I think Accpac's solution is using views and not calling a stored procedure or sql update statement. We are only interrested in changing the value in a field and not the attributes of the field or relationships to Customer Groups.

 

[jayconverse]

It doesn't use views, it uses simple transactions so it can be database independent. If you want to do it yourself, you just find all occurrences of IDCUST and CUSTOMER, and change them. This assumes you aren't combining 2 into 1, where you would definitely need Customer Change.

Jay Converse
IT Director
Systemlink, Inc.

 

[Stamina007]

Thank you