Site Search:
Sign in | Join | Help

Dynamics GP

Notes, Tips and Tricks on Developing in Dynamics GP

Olympic Project Cost Tables

pcSystemMaster               pcSystemMaster               pc00100
pcPeriodMaster               pcPeriodMaster               pc00110
pcPeriodMasterTemp           pcPeriodMasterTemp           pc00119
pcPeriodYear                 pcPeriodYear                 pc00120
pcProjectTypeMaster          pcProjectTypeMaster          pc00130
pcProjectSubTypeMaster       pcProjectSubTypeMaster       pc00135
pcTaskTypeMaster             pcTaskTypeMaster             pc00140
pcTaskSubTypeMaster          pcTaskSubTypeMaster          pc00145
pcCostCategoryMaster         pcCostCategoryMaster         pc00150
pcCodeMaster                 pcCodeMaster                 pc00160
pcOverheadCategoryMaster     pcOverheadCategoryMaster     pc00170
pcOverheadDepartmentMaster   pcOverheadDepartmentMaster   pc00180
pcValuationClassMaster       pcValuationClassMaster       pc00190
pcProjectMaster              pcProjectMaster              pc00200
pcProjectRates               pcProjectRates               pc00210
pcBudgetMaster               pcBudgetMaster               pc00250
pcAssemblyMaster             pcAssemblyMaster             pc00260
pcAssemblyUofMMaster         pcAssemblyUofMMaster         pc00270
pcAssemblyClassMaster        pcAssemblyClassMaster        pc00280
pcTaskMaster                 pcTaskMaster                 pc00300
pcTaskMoveActivity           pcTaskMoveActivity           pc00380
pcTaskMoveTemp               pcTaskMoveTemp               pc00390
pcEmployeeMaster             pcEmployeeMaster             pc00400
pcEmployeeClassMaster        pcEmployeeClassMaster        pc00420
pcCrewMaster                 pcCrewMaster                 pc00430
pcMinimumWageGroupMaster     pcMinimumWageGroupMaster     pc00440
pcPayCodeDetail              pcPayCodeDetail              pc00450
pcMinimumWagePayCodeSetup    pcMinimumWagePayCodeSetup    pc00460
pcCrewMembers                pcCrewMembers                pc00470
pcExplorerNodes              pcExplorerNodes              pc00500
pcDepartmentMaster           pcDepartmentMaster           pc00600
pcPayGroupMaster             pcPayGroupMaster             pc00620
pcPayGroupPeriod             pcPayGroupPeriod             pc00625
pcImportMaster               pcImportMaster               pc00700
pcImportFieldMapping         pcImportFieldMapping         pc00710
pcImportFieldMappingTemp     pcImportFieldMappingTemp     pc00711
pcImportFieldTranslation     pcImportFieldTranslation     pc00720
pcImportFieldTranslationTemp pcImportFieldTranslationTemp pc00721
pcbProjectTemp               pcbProjectTemp               pc00751
pcbTaskTemp                  pcbTaskTemp                  pc00752
pcbCostCategoryTemp          pcbCostCategoryTemp          pc00753
pcbSubCostCategoryTemp       pcbSubCostCategoryTemp       pc00754
pcbTransactionTemp           pcbTransactionTemp           pc00755
pcProjectModel               pcProjectModel               pc00841
pcProjectModelDetail         pcProjectModelDetail         pc00851
pcPayCodeMaster              pcPayCodeMaster              pc00900
pcPayCodeUofMMaster          pcPayCodeUofMMaster          pc00910
pcTransaction                pcTransaction                pc10000
pcTransactionTemp            pcTransactionTemp            pc10001
pcTransactionImport          pcTransactionImport          pc10005
pcCrewTransactionTemp        pcCrewTransactionTemp        pc11000
pcCrewTransactionHist        pcCrewTransactionHist        pc12000
pcBurdenTransactionTemp      pcBurdenTransactionTemp      pc15000
pcBurdenPostingRatesTemp     pcBurdenPostingRatesTemp     pc15200
pcBurdenPostingAccountsTemp  pcBurdenPostingAccountsTemp  pc15400
pcBurdenGLTransactionTemp    pcBurdenGLTransactionTemp    pc15600
pcBurdenTransactionHist      pcBurdenTransactionHist      pc16000
pcValuationHist              pcValuationHist              pc20000
pcValuationTemp              pcValuationTemp              pc20001
pcValuationDetailHist        pcValuationDetailHist        pc20100
pcValuationDetailTemp        pcValuationDetailTemp        pc20101
pcValuationGLTemp            pcValuationGLTemp            pc20201
pcBudgetTransaction          pcBudgetTransaction          pc25000
pcBudgetTransactionTemp      pcBudgetTransactionTemp      pc25001
pcBudgetBillingDetails       pcBudgetBillingDetails       pc25100
pcAssemblyTransaction        pcAssemblyTransaction        pc26000
pcAssemblyTransactionTemp    pcAssemblyTransactionTemp    pc26001
pcPOTransaction              pcPOTransaction              pc30000
pcPOTransactionTemp          pcPOTransactionTemp          pc30001
pcPOReceiptTransaction       pcPOReceiptTransaction       pc30100
pcPOReceiptTransactionTemp   pcPOReceiptTransactionTemp   pc30101
pcSOPTransaction             pcSOPTransaction             pc35000
pcGLReconciliation           pcGLReconciliation           pc39000
pcGLReconciliationDetail     pcGLReconciliationDetail     pc39001
pcCreateSOP_Trx              pcCreateSOP_Trx              pc90100
pcCreatePM_Trx               pcCreatePM_Trx               pc90200
pcCreateUPR_Trx              pcCreateUPR_Trx              pc90300
pcPMTransactionWork          pcPMTransactionWork          pc90410

 


 

Published Mar 23 2009, 05:41 PM by Steve Gray

Comments

 

Raul said:

I am trying to reconcile the total revenue from PC Project Model window within GP Project Cost to underlying table(s) in SQL, mainly PC10000 but the numbers tie back to each other.  First can these two be reconciled against each other or are there additional tables to be considered; secondly where else can I submit my question if it can't be answered here?

May 18, 2009 2:24 PM
 

Steve Gray said:

You're right, this is really not the right place for Oly support. Have you tried calling them? They're really great people and have the best support going.

May 18, 2009 5:20 PM

Leave a Comment

(required)  
(optional)
(required)  
Add

About Steve Gray

Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.