One moment please...
 
 
Exact Financials   
 

Data dictionary exactcs - 7.27

#TableLogging tableDescription
1admdaty_admdatCompany data
2admnacCompany: Delivery addresses
3atrshFinancial entries
4atrssFinancial entry lines
5balcenCost center balances
6balcunConsolidated balance sheet
7balshtBalance sheet
8bdalcchy_bdalcchBudget: Cost center allocations
9bdalccly_bdalcclBudget: Cost center allocation (Lines)
10bdalcuhBudget: Cost unit allocations
11bdalculBudget: Cost unit allocation (Lines)
12bdallochBudget ccent allocation header
13bdalloclBudget ccent allocation line
14bdalphy_bdalphBudget: Period allocations
15bdalply_bdalplBudget: Period allocation (Lines)
16bdcumdatBudget cumulative data
17bdeauthBudget authorization entries
18bdeautlBudget authorization entry (Lines)
19bdenthBudget entries
20bdentlBudget entry (Lines)
21bdmngy_bdmngBudget managers
22bdpathBudget entry paths
23bdtautBudget authorization transactions
24bdtauttBudget authorization transaction notes
25bdtrsBudget transactions
26bdtrstBudget transaction notes
27bdversy_bdversBudget versions
28bnkaccy_bnkaccBank accounts
29bnklnky_bnklnkBank links
30bnktpey_bnktpeBank account types
31ccenty_ccentCost centers
32ccnlnky_ccnlnklinking cost centers
33ccntrsCost center transactions
34colarry_colarrMandates
35combudYear budgets (Commitments)
36comclsy_comclsClassifications
37comctry_comctrContracts
38comctr_tContract notes
39comelCommitment entries
40comhlCommitments
41compy_compSub-classifications
42comslCommitment lines
43comsl_tCommitment notes
44comtrsCommitment transactions
45consccy_consccConsolidation cost centers
46conscoy_conscoConsolidation companies
47conscuy_conscuConsolidation cost unit
48consggConsolidation data
49contaby_contabConsolidation G/L accounts
50country_countrCountries
51crdbalCreditor balances
52crdcaty_crdcatCreditor categories
53crdnacy_crdnacOrder addresses
54crdoutAccounts payable
55crdrevCreditor revaluations
56crdtrsCreditor: Transactions
57credity_creditCreditors
58credit_tcreditor notes
59cstccny_cstccnCost center allocations
60cstcunStandard distr. cost units
61cunity_cunitCost units
62curreny_currenCurrencies
63dbvery_dbverDatabase versions
64debbalDebtor balances
65debcaty_debcatDebtor categories
66deboutAccounts receivable
67debrevDebtor revaluations
68debtory_debtorDebtors (Sales)
69debtor_tdebtor notes
70debtrsDebtor: Transactions
71delnacy_delnacDelivery addresses
72dpr_caldy_dpr_caldCalendar periods
73dpr_calmy_dpr_calmDepreciation calendars
74dpr_idxdy_dpr_idxdDepreciation index details
75dpr_idxmy_dpr_idxmDepreciation index tables
76dpr_mtaby_dpr_mtabDepreciation tables
77dpr_trnsDepreciation transactions
78earoley_earoleRoles
79earolrecy_earolrecData authorization
80earolusry_earolusrRoles per user
81ebabnky_ebabnkBanks
82ebabnk_mt940Bank statement: MT940 codes
83ebabnk_txcdBank statement transaction codes
84ebalnky_ebalnkBank links
85ebasthBank statements
86ebastsBank statement (Lines)
87ebauitMatched bank statements
88faelafLink assets fin. entries
89fas_asmby_fas_asmbAsset structures
90fas_asty_fas_astFixed assets
91fas_booky_fas_bookAsset books
92fas_depry_fas_deprAsset depreciations
93fas_depty_fas_deptDepartments
94fas_grpy_fas_grpAsset groups
95fas_locy_fas_locAsset: Locations
96fas_masty_fas_mastAsset sets
97fas_mntAsset maintenance data
98fas_mthly_fas_mthlAsset set in book (Change)
99fas_prlnkLink asset trans to project
100fas_prmstProjects per asset
101fatlafLink assets fin. transactions
102fiecolCollection runs
103fielbsfLink: Bank statement (Historic) to journal entry
104fielcfLink collections fin. entries
105fielfcLink atrss to comsl
106fielifLink intercompany to finance
107fielpayfLink: Payment (Historic) to journal entry
108fielrfLink recurring entries to fina
109fihbshHistory: Bank statements
110fihbslHistory: Bank statement (lines)
111fihpayextPayment extra data (Historic)
112fihpayfmtHistory: Payment formats
113fihpayordHistory: Payment orders
114fihpayoutHistory: Payment outstanding items
115fihpayrunHistory: Payment runs
116fiicompPre entry
117fildaLink dimensions to G/L account
118fipcolhy_fipcolhCollection installments
119fipcolly_fipcollCollection installment details
120firehy_firehRecurring entries
121firely_firelRecurring entry lines
122fitcolCollections (Historical)
123fitlbsfLink: Bank statement (Historic) to g/l transaction
124fitlcfLink collections fin. entries
125fitlfcLink ledtrs to comtrs
126fitlifLink intercompany to finance
127fitlpayfLink: Payment (Historic) to g/l transaction
128fitlrfLink recurring entries to fina
129fivatcorVAT corrections
130fprepPosting reports
131grpfdcLayout group flag descriptions
132iiowny_iiownInvoice owners
133iiregIncoming invoices
134isocnty_isocntISO countries
135isocury_isocurISO currencies
136isolngy_isolngISO languages
137journly_journlJournals
138journl_ruleBank statement: Matching rules
139jrlpayy_jrlpayJournal links payments
140jrlpcry_jrlpcrJournal links payment currency
141jrnlbaljournal-balance
142langy_langLanguages
143laydeby_laydebReminder profile: Language (Line)
144layfdcLayout flag descriptions
145layfgrLayout fields per group
146layfldFields per layout
147layflgFlags per layout
148laygdcLayout group descriptions
149laygflFlags per layout per group
150laygrfLayout group flags
151laygrpLayout groups
152laytflLayout type flags
153ledbalG/L account balances
154ledgery_ledgerG/L accounts
155ledmchMatching transactions
156ledrevG/L revaluations
157ledtrsGeneral ledger transaction
158licdaty_licdatLicenses
159llcocy_llcocCost codes
160llcocdy_llcocdCost code details
161llcocty_llcoctCost code details
162lldescy_lldescExtra description codes
163lldomey_lldomeDelivery/Order methods
164llicntTake on inventory
165llidesy_llidesExtra item descriptions
166lligrpy_lligrpItem groups
167llinvcy_llinvcInvoice codes
168llitcry_llitcrCreditor/item data
169llitemy_llitemItems
170llitxty_llitxtText items
171lllgrrLink recurring to generated
172lllrrLink recurring to relations
173llpdigy_llpdigPrice lists (Per item group detail)
174llpdity_llpditPrice lists (Per item detail)
175llpligy_llpligPrice lists (Per item group)
176llplity_llplitPrice lists (Per item)
177llplsty_llplstPrice lists
178llrechRecurring (Invoices)
179llrechtRecurring notes
180llreclRecurring lines
181llrectRecurring text lines
182lltexty_lltextGeneral text codes
183logfieldLogging (Fields)
184loghistDeleted (Logging)
185logrecLogging (Records)
186logsetty_logsettLogging settings
187logtableLogging (Tables)
188lpechPurchase order counters
189lpecihPurchase invoice counters
190lpecilPurchase invoice counter lines
191lpeclManual matching: Purchase order (Purchase invoice)
192lpecrhReceipt counters
193lpecrlManual matching: Receipt lines
194lpeihPurchase invoices
195lpeihtPurchase invoice notes
196lpeilPurchase invoice lines
197lpeitPurchase invoice text lines
198lpelicLink invoices to commitments
199lpelifLink purchase invoices to fina
200lpelioPurchase order - Purchase invoice history
201lpelirReceipt - Purchase invoice
202lpelmfLink matching to finance
203lpelocLink orders to commitments
204lpelofLink purchase orders to financ
205lpelrfLink receipts to finance
206lpelroPurchase order - Receipt history
207lpelspLink sales to purchase
208lpemioMatching purchase invoices/ord
209lpemroMatching receipts/purchase ord
210lpeohPurchase orders
211lpeohtPurchase order notes
212lpeolPurchase order lines
213lpeotPurchase order text lines
214lperhReceipts
215lperhtReceipt notes
216lperlReceipt lines
217lpertReceipt text lines
218lphchPurchase order counters (Historical)
219lphcihPurchase invoice counters (Historical)
220lphcilPurchase invoice counter lines (Historical)
221lphclPurchase order counter lines (Historical)
222lphcrhReceipt counters (Historical)
223lphcrlReceipt counter lines (Historical)
224lphihPurchase invoices (Historical)
225lphihtPurchase invoice notes
226lphilPurchase invoice lines (Historical)
227lphitPurchase invoice text line his
228lphlicLink lphil to comsl
229lphlifLink purchase invoices to fina
230lphlioLink purchase invoices to purc
231lphlirLink purchase invoices to rece
232lphlmfLink matching to finance
233lphlocLink lphol to comsl
234lphlofLink purchase orders to financ
235lphlrfLink receipts to finance
236lphlroLink receipt history to purcha
237lphlspLink sales to purchase
238lphmilPurchase invoice matching line
239lphmioMatching purchase invoice/orde
240lphmohPurchase order matching
241lphmoiMatching purchase order/invoic
242lphmolPurchase order matching lines
243lphmorMatching purchase order/receip
244lphmrlReceipt matching lines
245lphmroMatching receipt/purchase orde
246lphohPurchase orders (Historical)
247lphohtPurchase order history notes
248lpholPurchase order lines (Historical)
249lphotPurchase order history text li
250lphrhReceipts (Historical)
251lphrhtReceipt history notes
252lphrlReceipt lines (Historical)
253lphrtReceipt history text lines
254lseihSales invoices
255lseilSales invoice lines
256lseitSales invoice text lines
257lselifLink sales to finance
258lselofLink sales orders to finance
259lseohSales orders
260lseolSales order lines
261lseotSales order text lines
262lshihSales invoices (Historical)
263lshilSales invoice lines (Historical)
264lshitInvoice history texts
265lshlifLink sales to finance
266lshlofLink sales orders to finance
267lshohSales orders (Historical)
268lsholSales order lines (Historical)
269lshotSales order history text lines
270lsitsty_lsitstStock changes
271lsrepy_lsrepRepresentatives
272lsrevsRevenue statistics
273mcompy_mcompMain classifications
274mdim1y_mdim1Dimension 1
275mdim2y_mdim2Dimension 2
276mdim3y_mdim3Dimension 3
277mdim4y_mdim4Dimension 4
278mdim5y_mdim5Dimension 5
279paycony_payconPayment conditions
280payextPayment extra data
281payfmtPayment formats
282paymenpayments
283payordPayment orders
284payoutPayment outstanding items
285payselPayment runs
286perclsy_perclsClosed periods
287perdaty_perdatPeriod date tables
288pochlPayment over companies: Headers
289pocslPayment over companies: Details
290practvActivities
291prbudgetProject budgets
292prcajty_prcajtCost allocations per journalizing type
293prcally_prcallCost allocations
294prccaty_prccatCost categories
295prccmay_prccmaCost center manager
296prdeby_prdebProject debtors
297prdehProject entries (Direct revenue)
298prdepy_prdepProject: Departments
299prdesProject entry lines (Direct revenue)
300prdhrty_prdhrtDebtor hour category rates
301prdprty_prdprtDebtor position rates
302prdtrsProject transactions (Direct)
303prelpfLink project to finance
304prempy_prempProject employees
305premrty_premrtEmployee rates per project
306prghrty_prghrtProject group hour category rates
307prgprty_prgprtProject group position rates
308prgrpy_prgrpProject groups
309prhcaty_prhcatHour categories
310prhcrty_prhcrtHour category rates per project
311prhehProject entries (Hour)
312prhesProject entry lines (Hour)
313prhraty_prhratEmployee-hour category rates
314prhrpry_prhrprEmployee-hour category rates per project
315prhtrsProject transactions (Hour)
316priehProject entries (Item)
317priesProject entry lines (Item)
318prinamTo be invoiced
319prinfiFinal invoices
320prinfi_tFinal invoice text
321pringcy_pringcInvoice groups: Cost category
322pringhy_pringhInvoice groups
323pringly_pringlInvoice group: Lines
324pringl_tInvoice group line text
325prinphInvoice proposals
326prinpsInvoice proposal lines
327prinshy_prinshProject installments
328prinssy_prinssProject installment lines
329prinss_tInstallment line text
330printrTo be invoiced transactions
331printr_tAmounts to be invoiced text
332pritrsProject transactions (Item)
333prjamtAmounts (Journalize/Release)
334prjtccy_prjtccJournalizing types per cost category
335prjtgry_prjtgrJournalizing types per project group
336prjtypy_prjtypJournalizing types
337prlocy_prlocProject: Locations
338prmachy_prmachMachinery
339prmehProject entries (Machinery)
340prmesProject entry lines (Machinery)
341prmraty_prmratMachinery-unit rates
342prmsty_prmstProject master cards
343prmstdeby_prmstdebDebtors per project
344prmtrsProject transactions (Machinery)
345prndefy_prndefPrinter definitions
346prnfrmy_prnfrmForm printers
347prnusry_prnusrUser printers
348propsy_propsProperties
349props_tProperties texts
350prphdfy_prphdfPhase list descriptions
351prphlpy_prphlpPhase list definitions
352prphsey_prphsePhases
353prphsny_prphsnPhase lists
354prpmcy_prpmcProperty choices
355prpmrty_prpmrtMachinery rates per project
356prpmsty_prpmstProject structures
357prpmury_prpmurMachinery-unit rates per project
358prposy_prposProject positions
359prpsrty_prpsrtPosition rates per project
360prpurty_prpurtUnit rates per project
361prpvaly_prpvalProperty values
362prrateProject rates
363prrccaCost category (Results)
364prrcypCost category budgets (By period)
365prreasonProject budget (Change codes)
366prrhcaEmployee forecast
367prrhypEmployee budgets (By period)
368prritmItem forecast
369prriypItem budgets (By period)
370prrmchMachinery forecast
371prrmypMachinery budgets (By period)
372prrprjResult project
373prrpypProject budgets (By period)
374prrtccaHistory: Cost category budgets
375prrtcypHistory: Cost category budgets per period
376prrthcaHistory: Employee budgets
377prrthypHistory: Employee budgets per period
378prrtitmHistory: Machinery budgets
379prrtiypHistory: Machinery budgets per period
380prrtmchHistory: Item budgets
381prrtmypHistory: Item budgets per period
382prrtprjResult project
383prrtpypResult project per period
384prrttyy_prrttyProject rate priority (Lines)
385prsccny_prsccnCost center structures
386prsdepy_prsdepDepartment structures
387prstaty_prstatStatuses (Project)
388prsurcy_prsurcSurcharge codes
389prtlpfProject - Financial (Link transaction)
390prtrsProject transactions
391prtypey_prtypeProject types
392prunity_prunitProject units
393prwiphWork in progress (Header)
394prwiplWork in progress (Lines)
395prxesProject entries (External)
396prxlfLink to finance
397prxlpLink purchase
398prxlsiLink sales invoice
399prxlsoLink sales order
400prxtrsProject transactions (External)
401scencodey_scencodeScenario entries
402scentryy_scentryScenario entry lines
403stalogNotes (Extended)
404stapplApplications (Menu)
405stapplogApplication log
406stbenty_stbentBase entities
407stbicy_stbicBIC codes
408stblevy_stblevBase levels
409stbrlayLayouts
410stbrlayfLayout fields
411stcumdatCumulative data
412stcumdefCumulative definitions
413stdefchgy_stdefchgDefaults and changeability
414stdeficoDefault icons
415stestrhStructure entry header
416stestrlStructure entry line
417stetaskTasks (current)
418stexcaExternal categories
419stexobDocuments
420stextendTable extensions
421stformulaFormulas
422stgatewayGateway
423stgdprdataGDPR: Data
424stgdprhGDPR: Settings
425stgdprlGDPR: Settings (Line)
426stgrpy_stgrpUser groups
427stgrpworkspUser groups per workspace
428sthtaskTasks (current)
429stidpIdentity provider
430stifexExternal calls
431stjobhy_stjobhScheduled jobs
432stjobly_stjoblScheduled job (Parameters)
433stlangLanguages (Application)
434stlnglayy_stlnglayLayouts per language
435stltrmLink terms to master data
436stmnumenu definition
437stmnutxtmenutext
438stnactypey_stnactypeAddress types
439stpostalPostal codes
440stprgy_stprggrpprograms
441stprggrpy_stprggrpMenu authorization
442stprocessProcess history
443strecentRecent
444struley_struleRules
445struleusry_struleusrRule users
446ststrdetStructure details
447ststrucy_ststrucStructures
448sttaskFavorites
449sttermTranslations (User)
450sttranTranslations (System)
451sttsklstTask lists
452sttstrStructure transaction
453sttstrtStructure transaction notes
454stuipropUser interface properties
455stusery_stuserUsers
456stuserworkspUsers per workspace
457stusgrpy_stusgrpUsers per group
458stusrolLicenses per user
459stusrpwdUser passwords
460stworkspmembWorkspace members
461stxlinkXML import definitions
462stxlnodeXML definition nodes
463stxsattpSchema attribute type
464stxsattrSchema attribute
465stxschemXML schemas
466stxselemSchema element
467stxseltpSchema element type
468t_tdefy_t_tdefTest type definitions
469t_tdfdy_t_tdfdTest type descriptions
470t_tdscy_t_tdscTest fields (Description)
471t_testy_t_testCompanies
472titlesy_titlesTitles
473unitsy_unitsUnits
474usrlayForm layouts
475vatboxy_vatboxVAT return boxes
476vatbox_amtVAT return box: Amounts
477vathisVAT history
478vatlnby_vatlnbVAT linked boxes
479vatlntVAT linked total boxes
480vatrepy_vatrepVAT fiscal representatives
481vattrsy_vattrsVAT codes
482xratesExchange rates
483z_findatFinancial years
484z_linkRestrictions
485z_setty_z_settSettings
486z_sevSeveral data
487z_usety_z_usetuser settings