DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Name Search

The grid below contains all the tables in Dynamics GP. Filter the grid by entering text in the 'filter' boxes at the top of the grid.
For example, put 'RM' in the 'Table Name' filter box and put 'dist' in the 'Display Name' box, you'll see the RM tables that have DIST in their description. Useful, right?

Database NameTable NameDisplay NameTechnical Name
Data pager
Data pager
12345678910...
Page size:
PageSizeComboBox
select
 4701 items in 48 pages
DYNAMICSAAG00100Analytical Acctg. System SetupaaSyProductSetp
DYNAMICSAAG00101SQL CommandsaaSySQLCmd
DYNAMICSAAG00102aaSyTableRowaaSyTableRow
DYNAMICSAAG00103aaSyColumnMstraaSyColumnMstr
DYNAMICSAAG00104Analytical Acctg. Company SetupaaSyCompanyMstr
DYNAMICSAAG00105SQL CommandsaaSyTPSQLCmd
CompanyAAG00200aaAccountMstraaAccountMstr
CompanyAAG00201aaAccountClassMstraaAccountClassMstr
CompanyAAG00202aaAccountClassDimaaAccountClassDim
CompanyAAG00300aaDistrQueryMstraaDistrQueryMstr
CompanyAAG00301aaDistrQueryColaaDistrQueryCol
CompanyAAG00302aaDistrQueryFltraaDistrQueryFltr
CompanyAAG00303aaDistrQueryOrderaaDistrQueryOrder
CompanyAAG00304aaDistrQueryUsrWrkaaDistrQueryUsrWrk
CompanyAAG00310aaMLQueryMstraaMLQueryMstr
CompanyAAG00311aaMLQueryLvlaaMLQueryLvl
CompanyAAG00312aaMLQuerySysColaaMLQuerySysCol
CompanyAAG00313aaMLQueryFltraaMLQueryFltr
CompanyAAG00314aaMLQueryDetaaMLQueryDet
CompanyAAG00315aaMLQueryUsrWrkaaMLQueryUsrWrk
CompanyAAG00316AA ML UDF SelectionaaMLUDFSelect
CompanyAAG00317AA ML UDF Code StringaaMLUDFCodeString
CompanyAAG00400aaTrxDimMstraaTrxDimMstr
CompanyAAG00401aaTrxDimCodeSetpaaTrxDimCodeSetp
CompanyAAG00402aaTrxDimCodeNumSetpaaTrxDimCodeNumSetp
CompanyAAG00403aaTrxDimCodeBoolSetpaaTrxDimCodeBoolSetp
CompanyAAG00404aaTrxDimCodeDateSetpaaTrxDimCodeDateSetp
CompanyAAG00405aaTrxDimRelationaaTrxDimRelation
CompanyAAG00406aaTrxDimCodeRelationaaTrxDimCodeRelation
CompanyAAG00407AA Trx Dim Adjustment OptionaaTrxDimAdjOption
CompanyAAG00500aaDateSetupaaDateSetp
CompanyAAG00600aaTreeMstraaTreeMstr
CompanyAAG00601aaTreeNodeMstraaTreeNodeMstr
CompanyAAG00602aaTreeNodeLinkaaTreeNodeLink
CompanyAAG00603aaTreeNodeUserWorkaaTreeNodeUserWork
CompanyAAG00605aaTreeMstrDupeaaTreeMstrDupe
CompanyAAG00700aaOptionSetpaaOptionSetp
CompanyAAG00800aa Alias MasteraaAliasMstr
CompanyAAG00801aa Alias Transaction Dimension CodeaaAliasTrxDimCode
CompanyAAG00900AA Budget Tree MasteraaBudgetTreeMstr
CompanyAAG00901AA Budget Tree Trx Dim MasteraaBudgetTreeTrxDimMstr
CompanyAAG00902AA Budget Tree Trx Dim Code MasteraaBudgetTreeTrxDimCodeMstr
CompanyAAG00903AA Budget MasteraaBudgetMstr
CompanyAAG00904AA Budget Tree BalanceaaBudgetTreeBalance
CompanyAAG00905AA Budget Tree Account BalanceaaBudgetTreeAccountBalance
CompanyAAG00906AA Budget Tree View WorkaaBudgetTreeViewWork
CompanyAAG01000AA UDF Setup optionaaUDFSetup
CompanyAAG01001AA UDF Trx Dim SetupaaUDFTrxDimSetup
CompanyAAG01002AA Trx Dim CodeUDF MaintenanceaaUDFTrxDimCodeMnt
CompanyAAG02000AA User Access to Codes SetupaaUserAccessToCodesSetup
CompanyAAG02001AA Access Codes to Accounts SetupaaCodesAccessToAccountsSetup
CompanyAAG02002AA User Access To Employee SetupaaUserAccessToEmployeeSetup
CompanyAAG03000AA Payroll Default DimensionaaUPRDefaultDim
CompanyAAG04000  
CompanyAAG04001  
CompanyAAG05000  
CompanyAAG05001  
CompanyAAG10000aaGLWorkHdraaGLWorkHdr
CompanyAAG10001aaGLWorkDistaaGLWorkDist
CompanyAAG10002aaGLWorkAssignaaGLWorkAssign
CompanyAAG10003aaGLWorkCodeaaGLWorkCode
CompanyAAG10407aa Print options WorkaaDistrRepOptionWork
CompanyAAG20000aaSubLedgerHdraaSubLedgerHdr
CompanyAAG20001aaSubLedgerDistaaSubLedgerDist
CompanyAAG20002aaSubLedgerAssignaaSubLedgerAssign
CompanyAAG20003aaSubLedgerCodeaaSubLedgerCode
CompanyAAG2000EaaSubLedgerErroraaSubLedgerError
CompanyAAG2000TaaCM Distribution TEMPaaCMDistributionTemp
CompanyAAG20011aaSubLedgerDistDUPaaSubLedgerDistDUP
CompanyAAG2001Taa CM Deposit Diff TEMPaaCMDepositDiffTemp
CompanyAAG30000aaGLHdraaGLHdr
CompanyAAG30001aaGLDistaaGLDist
CompanyAAG30002aaGLAssignaaGLAssign
CompanyAAG30003aaGLCodeaaGLCode
CompanyAAG3000EaaGLWorkErroraaGLWorkError
CompanyAAG40000aaGLHistHdraaGLHistHdr
CompanyAAG40001aaGLHistDistaaGLHistDist
CompanyAAG40002aaGLHistAssignaaGLHistAssign
CompanyAAG40003aaGLHistCodeaaGLHistCode
CompanyAAG50000aaSubLedgerHdrReportaaSubLedgerHdrReport
CompanyAAG50001aaSubLedgerDistReportaaSubLedgerDistReport
CompanyAAG50002aaSubLedgerAssignReportaaSubLedgerAssignReport
CompanyAAG60000aaGLWorkHdrReportaaGLWorkHdrReport
CompanyAAG60001aaGLWorkDistReportaaGLWorkDistReport
CompanyAAG60002aaGLWorkAssignReportaaGLWorkAssignReport
CompanyAAG70000aaGLHdrReportaaGLHdrReport
CompanyAAG70001aaGLDistReportaaGLDistReport
CompanyAAG70002aaGLAssignReportaaGLAssignReport
DYNAMICSAAU10130Archive_HR_Applicant_User_DefinedArchive_HR_Applicant_User_Defined
DYNAMICSAAX10130Archive_HR_Applicant_ExtraArchive_HR_Applicant_Extra
CompanyABCLog  
CompanyACColumnAcct_Combiner_ColumnsAcct_Combiner_Columns
DYNAMICSACRSTBLACRS Tables SetupFA_ACRS_SETP
CompanyActive  
DYNAMICSACTIVITYUser ActivitySY_Current_Activity
DYNAMICSADH00100  
DYNAMICSADH00101  
DYNAMICSADH00102  
DYNAMICSADH00103  
DYNAMICSADH00104  
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3