What do you want to know about Exact Tables: GBKMUT AMUTAK BACOAPPLOG ?

I use Google Analytics on my blog to get information of the visitors who are visiting my web blog. Sometimes I got hits on searches for Exact tables like: GBKMUT, AMUTAK, BACOAPPLOG etc.... I have no idea what the reason is for these searches. Maybe I can help you.

Image credits to doraeimages


On the web site of Exact Software, database documentation is available for:

Exact Globe click here to open.
Exact Synergy Enterprise click here to open.

If you need help, please leave a comment with an explanation what you are looking for or to tell if the database documentation was usefull.




Here is a list of all Exact tables:
aaccod, aacmut,aactbl,AbsenceEntitlements,AbsenceMainTypes,Absences,AbsenceTypes,accncd
AccountAdministrations,AccountCategories,AccountCategoryNames,
AccountClassesAccountClassNames,AccountConversionTypes,AccountMandatory,
AccountReportCategories,AccountStatus,AccountTypeProperties,AccountTypes,Addresses,
AddressPostCodes,AddressStates,AddressTypes,afgper,amutak,amutas,artext,artlnk,
artoms,artver,artleve,BacoAccessServers,BacoAppLog,BacoAppLogApps,BacoAppLogDays,
BacoAppLogHours,BacoDelegations,BacoDiscussionCategories,BacoDiscussionCounts,
BacoDiscussionFixedGroups,BacoDiscussionFixedTypes,BacoDiscussionGRoles,
BacoDiscussionGroups,BacoDiscussionLayoutLanguage,BacoDiscussionNewsLayouts,
BacoDiscussionPictures,BacoDiscussions,BacoDiscussionStates,BacoDiscussionStdPictures,
BacoDiscussionSubCategories,BacoDiscussionVersions,BacoErrorLog,BacoFreeNumbers,
BacoFunctionRoles,BacoFunctions,BacoLicenceOptions,BacoProcessLog,BacoProducts,
BacoReplicationArticles,BacoReplicationArticleSubtopics,BacoReplicationConflicts
BacoReplicationPushedSubtopics,BacoReplicationPushedTopics,BacoReplicationReplicatedArticles
BacoReplicationReplicatedSubtopics,BacoReplicationReplicatedTopics,BacoReplicationSubtopics
BacoReplicationTopics,BacoSearchTemplateFields,BacoSearchTemplates,BacoSettings
BacoUserGroups,Balance,BankAccounts,BankAuthorizations,BankFormats,BankNames,
BankTransactions,Barcodes,bdgmth,bdgtbl,bdgvrs,BDPictureRefs,BDViewColumns,bedryf,
betcd,bnkacc,bnkkop,btwavk,btwkpl,btwkpp,btwtrs,btwvrt,Budgets,CardSettings,
cicmpy,cicntp,ciFreeFields,Cisect,Cisize,Classifications,CompanyClasses,CompanyClassNames,
CompanyCostcenters,CompanyEmployees,CompanyLogs,CompanyParticipations,
CompetenceMatchProfiles,ConsolidationBalances,ConsolidationStructures,
ContractParameters,CostcenterClasses,CostcenterClassNames,CRMPageContent,CRMPages
CurrencyPeriodExchangeRates,dagbk,DataSource_Type,DaylightSavingDates,DDBrowseInfo,
DDColumns,DDIndexColumns,DDIndexes,DDReferenceColumns,DDReferences,DDTables,
DDTests,DivisionCreditors,DivisionDebtors,DocumentReferences,DocumentStatistics,
dtproperties,EbcBasicTypes,EbcBrowsers,EbcColumnGroups,EbcComponentRelations,
EbcComponentRelationTypes,EbcComponents,EbcComponentTypes
EbcDataComponentTypes,EbcDataLog,EbcDefaultStates,EbcDefaultTypes,EbcEnabledStates,
EbcEntities,EbcEntityRelations,EbcGroups,EbcLogCustom,EbcPropRelations,EbcPropRelationStates
EbcPropRelationTypes,EbcProps,EbcPropTypes,epavlk,epavlr,evbswz,evloc,ExactLicense,
ExactOptions,ExactTrialModules,fadpre,fadprm,fadprt,fagrp,fakcod,fakvcd,fatran,
FavoriteCategories,Favorites,frhkrg,frhsrg,frhstx,frkrg,frsrg,frstx,frvkrg,frvsrg,frvstx,
FunctionGroupDetails,FunctionGroups
gbkmut,grtbk,hrcomp_resource,hrcomp_trans,HRCompanyPeriods,HRCompetencies,
HRCompetencyRatings,hrcomponentitemlinks,hrcomponents,HREffectivedateDataLog,
HREmployeePeriods,HRErrorLog,hrfin,hrfint,hrfree,hrFreeFields,HRHumresLinks,hrjbtl,hrloc,
HRMainFint,HRMCompetenceGroups,HRMCompetenceLinks,HRMCompetenceProfiles,
HRMCompetenceRelations,HRMCompetences,
HRMFieldTypes,HRMFormElements,HRMFormLayouts,,HRMSelectionValues,HrPasswds
hrpayroll,hrpayrolldeclarations,,HRProcessLogs,HRProcessRequests,HRProcessTypes,
HRRoleDefs,HRRoleLevels,HRRoleLog,HRRoles,hrsk,hrwdoc,humres,intfac,inthav,inthis,
intlev,intmtf,intnr,intreg,intshp,intstl,intta,inttb,inttra,INWHSM,ItemAccounts,
ItemAssortment,ItemAttachmentArchive,ItemAttachments,ItemBaskets,ItemCatalogs,
ItemClasses,ItemClassLinks,ItemClassNames
ItemCountries,ItemCountryTranslations,ItemDivisions,ItemNumbers,ItemPrices,ItemProcess,
ItemProcessTypes,ItemRelations,ItemRelationTypes,ItemRelationTypeState,,ItemReleases
ItemReleaseStatus,Items,ItemTranslationLog,ItemTranslations,ItemUnits,kplkop,kplvrd,ksdrek
ksprek,kstdr,kstpl,land,landClasses,landClassNames,LastAction,laycrd,laydeb,layouts,laytype
License_Management,magaz,MailMergePending,mapfil,mapfld,mapfor,mapmsc,NLSal,
NLSalHrFint,NLSalSettings,NoiseWords,NoteLinkTableFields,notes,Numbers,
Numeric_field,Operations,Opportunities,OpportunityAccounts,OpportunityContacts,
OpportunityHistories,OpportunityItems,OpportunityProjects
OpportunityReasons,OpportunityRoles,OpportunitySources,ordlev,ordlog,ordsel,orhkrg,orhsrg
orhstx,orkrg,orsrg,orstx,orvkrg,orvsrg,orvstx,perdat,PeriodMaps,PortalFrames,Portals,pospreset
prafd,pred,prFreeFields,PRMember,ProductivityReports,ProjectAccounts,PRProject,PublicHolidays
pwfunc,pwmagaz,pwrole,pwrprm,pwruc,rates,RatingAmounts,RatioDefinitions,RatioFilterAccounts
recipe,RequestActions,RequestFieldOptions,RequestFields,RequestItems,RequestPaymentTypes,
RequestPriorities,RequestStatHistory,RequestStatus,RequestTasks,RequestViewColumns,
ResellerNews,ResourceStatus,ResourceTypes,RoleFunctionGroups,Routings,SearchTemplateFields,
SearchTemplates,Settings,ShippingDays,staffl,stfoms,SubSectors,syscrc,sysmnu,sysmnuusr,
taal,taxcod,taxdef,TaxSchedule,Templates,Terms,TimeZones,TransactionsPending,
TransactionTypes,Transfer,usrbar,usrmnu,valuta,VendorDetails,VendorTaxReturns,
Version_Detail_log,Version_Log,verslg,voorrd,WebContent,WebStyle,WordReferences,
Words,WordSynonyms,Workcenters,WorkflowOwnershipOptions,WorkScheduleGroups
WorkScheduleLinks,WorkSchedules,XMLEvents,XMLFiles,XMLGLTransactionsLog,
XMLReplications
XMLReplicationSources,XMLTopicDefinitions,XMLTopicHistory,XMLTopics,XMLTopicsDefinition
ZipCodeRanges

How to execute a script on multiple databases?

This blog post will describe how you can execute a script on multiple databases. For instances to retrieve the number of records in a table or to retrieve a specific value. The concept of the script is to generate the script which you want to execute on all database. In the example I will use, the script will retrieve the release of the software on the databases of Exact. If it is not an Exact database the script will not be executed.

-- Begin script: How to execute a script in multiple databases?

SET NOCOUNT ON

IF EXISTS (SELECT TOP 1 * FROM tempdb.dbo.sysobjects
WHERE Xtype ='U' AND ID = object_id(N'tempdb..#TableExport'))
BEGIN
DROP TABLE #TableExport
END
-- Create table to store retrieved data.
CREATE TABLE #TableExport (DBNAME NVARCHAR(256),Value nvarchar(3))

DECLARE DB CURSOR FOR SELECT DBID,NAME FROM MASTER..SYSDATABASES WHERE DBID > 4 -- Select Database ID and Name of all User databases
OPEN DB
DECLARE @DBNAME varchar(256); -- Database name
DECLARE @DBID nvarchar(3); -- Database ID
DECLARE @SQL nvarchar(4000); -- Generated SQL Script which will be executed against all databases

FETCH NEXT FROM DB INTO @DBID,@DBNAME
WHILE @@FETCH_STATUS = 0
BEGIN
-- Generate SQL script for the first database in paramater @SQL
SET @SQL = N'USE [' + @DBNAME + ']IF OBJECT_ID(''ExactLicense'') IS NOT NULL'
+ ' INSERT INTO #TableExport (DBNAME,Value)'
+ ' SELECT '''+@DBNAME + ''' as dbname,B.longvalue
FROM ['+@DBNAME+']..BacoSettings B
WHERE SettingType = 0 AND SettingGroup = ''General'' AND Settingname = ''Batch''
'
EXEC SP_EXECUTESQL @SQL -- Execute the generated script.

FETCH NEXT FROM DB INTO @DBID,@DBNAME -- Generate and execute script for the second database
END
CLOSE DB
DEALLOCATE DB
SELECT * FROM #TableExport ORDER BY DBNAME --Retrieve all data.
DROP TABLE #TableExport

-- END script: How to execute a script in multiple databases?