Adding Columns to tables

C

Charlie Zarzour

I am new to project server. I am in the process of integrating Project
Server to Microsoft Great Plains Project Accounting 9.0 for the purpose
of feeding Timesheets into Project Accounting. I am very familiar with
Project Accounting and the integration connector eConnect. I have read
up on Timephased data and how it works in PS with
sp_psactualsbyday.sql.

I need to add a Column to the following Tables in PS in order to store
the link between MS PA and PS. How do I add an extra Column to the
following tables. Do I use Enterprise Manager or go through Project Server.


MSP_WEB_ASSIGNMENTS (store PA Cost Category)
MSP_WEB_PROJECTS (store PA Project Alias)
MSP_WEB_RESOURCES (store PA Employee ID)
MSP_WEB_WORK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top