Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our Olympic PC scripts. All of our scripts for Dynamics GP can be found here
Module List > Module COMPANY..Olympic PC tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 pc00100pcSystemMaster
The pc00100 is the Project System Master table.
 pc00105pcSystemMasterUDLabels
The pc00105 is the Project System User Defined Lable table.
 pc00110pcPeriodMaster
The pc00110 is the PC Period Master table. This table stores PC Reporting Period Data
 pc00119pcPeriodMasterTemp
 pc00120pcPeriodYear
The pc00120 is the PC Reporting Year Master table. This table stores PC Reporting Period Data
 pc00130pcProjectTypeMaster
The pc00130 is the PC Project Type Master table.
 pc00135pcProjectSubTypeMaster
The pc00135 is the PC Project Sub-Type Master table.
 pc00140pcTaskTypeMaster
The pc00140 is the PC Task Type Master table.
 pc00145pcTaskSubTypeMaster
The pc00145 is the PC Task Sub-Type Master table.
 pc00150pcCostCategoryMaster
The pc00150 is the PC Cost Category table. This table stores Sub-Cost Categories assigned to a Cost Category
 pc00160pcCodeMaster
The pc00160 is the PC Code Master table. This table stores Project/Task level User Sort Field Data
 pc00170pcOverheadCategoryMaster
The pc00170 is the PC Security Role Master table.
 pc00180pcOverheadDepartmentMaster
 pc00190pcValuationClassMaster
The pc00190 is the PC Valuation Class Master table.
pc00200pcProjectMaster
The pc00200 is the Project master record table.
 pc00201pcProjectLookup
 pc00205pcProjectUserDefined
The pc00205 is the Project User Defined Field data table. This holds values entered at the Project level as User Defined values.
 pc00210pcProjectRates
The pc00210 is the PC Project Rates table.
 pc00235pcProjectIDSetup
The pc00235 is the PC Project ID Setup table. This is used to create Auto Numbering Templates for new projects.
 pc00250pcBudgetMaster
The pc00250 is the PC Budget Master table. This table only stores the BudgetID's - budget details are stored in the pc25000
 pc00260pcAssemblyMaster
 pc00270pcAssemblyUofMMaster
 pc00280pcAssemblyClassMaster
 pc00290pcDistributionMaster
The pc00290 is the PC Distribution Master table. This creates Auto Distribution Groups
 pc00295pcDistributionSetup
The pc00295 is the PC Distribution Setup table. This file stores the distribution % for Auto Distribution Groups
pc00300pcTaskMaster
The pc00300 is the Task master record table.
 pc00301 
 pc00305pcTaskUserDefined
The pc00305 is the Task User Defined Field data table. This holds values entered at the Task level as User Defined values.
 pc00330pcGroupMaster
The pc00330 is the PC Group Master table. This table stores the Organization Group Setup for PC Project Security
 pc00340pcGroupUserMaster
The pc00340 is the PC Group User Master table. This table stores the Organization Group User Assigments PC Project Security
 pc00380pcTaskMoveActivity
 pc00390pcTaskMoveTemp
 pc00400pcEmployeeMaster
The pc00400 is the Employee master record table.
 pc00405pcEmployeeUserDefined
The pc00405 is the Employee User Defined Field data table. This holds values entered and associated with the Employee record User Defined values.
 pc00410pcEmployeeCreditCards
The pc00410 is the Employee Credit Card Master table.
 pc00420pcEmployeeClassMaster
The pc00420 is the Employee Class Master table.
 pc00430pcCrewMaster
The pc00430 is the PC Employee Roles Master table. This table stores role assignments for PC Users
 pc00440pcMinimumWageGroupMaster
 pc00450pcPayCodeDetail
The pc00450 is the PC Pay Code Detail table. Table stores details of paycodes assigned to employees or employee class
 pc00460pcMinimumWagePayCodeSetup
 pc00470pcCrewMembers
 pc00500pcExplorerNodes
 pc00510pcPurchaseTaxClassMaster
The pc00510 is the PC Purchase Tax Class Master table.
 pc00520pcPurchaseTaxMaster
The pc00520 is the PC Purchase Tax Master table.
 pc00525pcPurchaseTaxDetail
The pc00525 is the PC Purchase Tax Detail table.
 pc00600 
 pc00620pcPayGroupMaster
The pc00620 is the PC Pay Group Master table.
 pc00625pcPayGroupPeriod
The pc00625 is the PC Pay Group Period table.
 pc00650pcPoolMaster
 pc00652pcPoolAccountMaster
 pc00660pcBaseMaster
 pc00662pcBasePoolMaster
 pc00670pcRateIDMaster
The pc00670 is the PC Rate ID Master table. (Overhead Rate ID)
 pc00672pcPoolRateMaster
 pc00700pcImportMaster
The pc00700 is the PC Import Master table.
 pc00710pcImportFieldMapping
The pc00710 is the PC Import ID Column Mapping table.
 pc00711pcImportFieldMappingTemp
 pc00720pcImportFieldTranslation
The pc00720 is the PC Import Field Translation Mapping table.
 pc00721pcImportFieldTranslationTemp
 pc00751pcbProjectTemp
 pc00752pcbTaskTemp
 pc00753pcbCostCategoryTemp
 pc00754pcbSubCostCategoryTemp
 pc00755pcbTransactionTemp
 pc00758pcbPOTransactionTemp
 pc00841pcProjectModel
 pc00851pcProjectModelDetail
 pc00910pcPayCodeUofMMaster
The pc00910 is the PC Pay Code Unit of Measure table.
 pc00920pcPayCodeMaster
The pc00920 is the PC Pay Code Master table.
 pc00930pcReasonCodeMaster
The pc00930 is the PC Reason Code Master table.
 WSBehavior 
 WSBehaviorOption 
Freq
Used
 Display Name
pc10000pcTransaction
The pc10000 is the Project Cost Transactions Table. These record contain Actual Cost and Revenue details.
 pc10001pcTransactionTemp
 pc10005pcTransactionImport
The pc10005 is the PC Imports Staging table.
 pc10100pcTransactionExt
The pc10100 is the pc Transaction Extended table. Table stores Exchange Rate info, Credit Card info, & Tax Info
 pc10200pcTransactionException
The pc10200 is the pc Transaction Exception table.
 pc10300pcTransactionAttachments
The pc10300 is the pc Transaction Attachments table.
 pc10301pcTransactionAttachmentsTemp
 pc11000pcCrewTransactionTemp
 pc12000pcCrewTransactionHist
 pc15000pcBurdenTransactionTemp
 pc15100pcBurdenDetailTemp
 pc15200pcBurdenPostingRatesTemp
 pc15400pcBurdenPostingAccountsTemp
 pc15600pcBurdenGLTransactionTemp
 pc15800pcBurdenApplyTemp
 pc15900pcBurdenBaseTemp
 pc16000pcBurdenTransactionHist
The pc16000 is the pc Burden Transaction Hist table.
 pc16001pcBurdenTransactionArchive
 pc16100pcBurdenDetailHist
 pc16200pcBurdenPoolHist
 pc16600pcBurdenGLHist
 pc16800pcBurdenApplyHist
 pc16900pcBurdenBaseHist
 pc17000pcLaborCheckHist
 pc17001pcLaborCheckTemp
 pc17002pcLaborCheckDetailTemp
 pc17005pcLaborCheckImport
 pc17009pcLaborCheckImportTemp
 pc17011pcLaborTransactionTemp
 pc17013pcLaborPayCodesToExclude
Freq
Used
 Display Name
 pc20000pcValuationHist
 pc20001pcValuationTemp
 pc20100pcValuationDetailHist
The pc20100 is the pc Valuation Detail Hist table.
 pc20101pcValuationDetailTemp
 pc20201pcValuationDetailTemp
pc25000pcBudgetTransaction
The pc25000 is the Project Budget transaction table.
 pc25001pcBudgetTransactionTemp
 pc25100pcBudgetBillingDetails
The pc25100 is the Project Scheduled Billing Table.
 pc26000pcAssemblyTransaction
 pc26001pcAssemblyTransactionTemp
Work Tables
Freq
Used
 Display Name
 pc30000pcPOTransaction
The pc30000 is the Project Purchase Order transaction table.
 pc30001pcPOTransactionTemp
 pc30100pcPOReceiptTransaction
The pc30100 is the Project Purchase Order Receipts transaction table.
 pc30101pcPOReceiptTransactionTemp
pc35000pcSOPTransaction
 pc39000pcGLReconciliation
 pc39001pcGLReconciliationDetail
Freq
Used
 Display Name
 OLYTime 
 pc90000pcTransactionAudit
The pc90000 is the PC Transaction Audit Table.
 pc90100pcCreateSOP_Trx
 pc90101pcCreateSOP_TrxAvailable
 pc90200pcCreatePM_Trx
 pc90201pcCreatePM_TrxAvailable
 pc90300pcCreateUPR_Trx
 pc90301pcCreateUPR_TrxAvailable
 pc90410pcPMTransactionWork
 pc90510pcApproval_Transactions
 pc90520pcApproval_ProjectTask
 pc90530pcApproval_GroupUser
 pc90610pcInvApproval_Transactions
 pc90620pcInvApproval_ProjectTask
 pc90630pcInvApproval_GroupUser
 pc90640pcInvApproval_CustProjTask
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3