One moment please...
 
 
Exact Financials   
 

Data dictionary exactcs - 7.32

#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
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
142jrnlexcaCategory (Mandatory)
143langy_langLanguages
144laydeby_laydebReminder profile: Language (Line)
145layfdcLayout flag descriptions
146layfgrLayout fields per group
147layfldFields per layout
148layflgFlags per layout
149laygdcLayout group descriptions
150laygflFlags per layout per group
151laygrfLayout group flags
152laygrpLayout groups
153laytflLayout type flags
154ledbalG/L account balances
155ledgery_ledgerG/L accounts
156ledmchMatching transactions
157ledrevG/L revaluations
158ledtrsGeneral ledger transaction
159licdaty_licdatLicenses
160llcocy_llcocCost codes
161llcocdy_llcocdCost code details
162llcocty_llcoctCost code details
163lldescy_lldescExtra description codes
164lldomey_lldomeDelivery/Order methods
165llicntTake on inventory
166llidesy_llidesExtra item descriptions
167lligrpy_lligrpItem groups
168llinvcy_llinvcInvoice codes
169llitcry_llitcrCreditor/item data
170llitemy_llitemItems
171llitxty_llitxtText items
172lllgrrLink recurring to generated
173lllrrLink recurring to relations
174llpdigy_llpdigPrice lists (Per item group detail)
175llpdity_llpditPrice lists (Per item detail)
176llpligy_llpligPrice lists (Per item group)
177llplity_llplitPrice lists (Per item)
178llplsty_llplstPrice lists
179llrechRecurring (Invoices)
180llrechtRecurring notes
181llreclRecurring lines
182llrectRecurring text lines
183lltexty_lltextGeneral text codes
184logfieldLogging (Fields)
185loghistDeleted (Logging)
186logrecLogging (Records)
187logsetty_logsettLogging settings
188logtableLogging (Tables)
189lpechPurchase order counters
190lpecihPurchase invoice counters
191lpecilPurchase invoice counter lines
192lpeclManual matching: Purchase order (Purchase invoice)
193lpecrhReceipt counters
194lpecrlManual matching: Receipt lines
195lpeihPurchase invoices
196lpeihtPurchase invoice notes
197lpeilPurchase invoice lines
198lpeitPurchase invoice text lines
199lpelicLink invoices to commitments
200lpelifLink purchase invoices to fina
201lpelioPurchase order - Purchase invoice history
202lpelirReceipt - Purchase invoice
203lpelmfLink matching to finance
204lpelocLink orders to commitments
205lpelofLink purchase orders to financ
206lpelrfLink receipts to finance
207lpelroPurchase order - Receipt history
208lpelspLink sales to purchase
209lpemioMatching purchase invoices/ord
210lpemroMatching receipts/purchase ord
211lpeohPurchase orders
212lpeohtPurchase order notes
213lpeolPurchase order lines
214lpeotPurchase order text lines
215lperhReceipts
216lperhtReceipt notes
217lperlReceipt lines
218lpertReceipt text lines
219lphchPurchase order counters (Historical)
220lphcihPurchase invoice counters (Historical)
221lphcilPurchase invoice counter lines (Historical)
222lphclPurchase order counter lines (Historical)
223lphcrhReceipt counters (Historical)
224lphcrlReceipt counter lines (Historical)
225lphihPurchase invoices (Historical)
226lphihtPurchase invoice notes
227lphilPurchase invoice lines (Historical)
228lphitPurchase invoice text line his
229lphlicLink lphil to comsl
230lphlifLink purchase invoices to fina
231lphlioLink purchase invoices to purc
232lphlirLink purchase invoices to rece
233lphlmfLink matching to finance
234lphlocLink lphol to comsl
235lphlofLink purchase orders to financ
236lphlrfLink receipts to finance
237lphlroLink receipt history to purcha
238lphlspLink sales to purchase
239lphmilPurchase invoice matching line
240lphmioMatching purchase invoice/orde
241lphmohPurchase order matching
242lphmoiMatching purchase order/invoic
243lphmolPurchase order matching lines
244lphmorMatching purchase order/receip
245lphmrlReceipt matching lines
246lphmroMatching receipt/purchase orde
247lphohPurchase orders (Historical)
248lphohtPurchase order history notes
249lpholPurchase order lines (Historical)
250lphotPurchase order history text li
251lphrhReceipts (Historical)
252lphrhtReceipt history notes
253lphrlReceipt lines (Historical)
254lphrtReceipt history text lines
255lseihSales invoices
256lseilSales invoice lines
257lseitSales invoice text lines
258lselifLink sales to finance
259lselofLink sales orders to finance
260lseohSales orders
261lseolSales order lines
262lseotSales order text lines
263lshihSales invoices (Historical)
264lshilSales invoice lines (Historical)
265lshitInvoice history texts
266lshlifLink sales to finance
267lshlofLink sales orders to finance
268lshohSales orders (Historical)
269lsholSales order lines (Historical)
270lshotSales order history text lines
271lsitsty_lsitstStock changes
272lsrepy_lsrepRepresentatives
273lsrevsRevenue statistics
274mcompy_mcompMain classifications
275mdim1y_mdim1Dimension 1
276mdim2y_mdim2Dimension 2
277mdim3y_mdim3Dimension 3
278mdim4y_mdim4Dimension 4
279mdim5y_mdim5Dimension 5
280paycony_payconPayment conditions
281payextPayment extra data
282payfmtPayment formats
283paymenpayments
284payordPayment orders
285payoutPayment outstanding items
286payselPayment runs
287perclsy_perclsClosed periods
288perdaty_perdatPeriod date tables
289pochlPayment over companies: Headers
290pocslPayment over companies: Details
291practvActivities
292prbudgetProject budgets
293prcajty_prcajtCost allocations per journalizing type
294prcally_prcallCost allocations
295prccaty_prccatCost categories
296prccmay_prccmaCost center manager
297prdeby_prdebProject debtors
298prdehProject entries (Direct revenue)
299prdepy_prdepProject: Departments
300prdesProject entry lines (Direct revenue)
301prdhrty_prdhrtDebtor hour category rates
302prdprty_prdprtDebtor position rates
303prdtrsProject transactions (Direct)
304prelpfLink project to finance
305prempy_prempProject employees
306premrty_premrtEmployee rates per project
307prghrty_prghrtProject group hour category rates
308prgprty_prgprtProject group position rates
309prgrpy_prgrpProject groups
310prhcaty_prhcatHour categories
311prhcrty_prhcrtHour category rates per project
312prhehProject entries (Hour)
313prhesProject entry lines (Hour)
314prhraty_prhratEmployee-hour category rates
315prhrpry_prhrprEmployee-hour category rates per project
316prhtrsProject transactions (Hour)
317priehProject entries (Item)
318priesProject entry lines (Item)
319prinamTo be invoiced
320prinfiFinal invoices
321prinfi_tFinal invoice text
322pringcy_pringcInvoice groups: Cost category
323pringhy_pringhInvoice groups
324pringly_pringlInvoice group: Lines
325pringl_tInvoice group line text
326prinphInvoice proposals
327prinpsInvoice proposal lines
328prinshy_prinshProject installments
329prinssy_prinssProject installment lines
330prinss_tInstallment line text
331printrTo be invoiced transactions
332printr_tAmounts to be invoiced text
333pritrsProject transactions (Item)
334prjamtAmounts (Journalize/Release)
335prjtccy_prjtccJournalizing types per cost category
336prjtgry_prjtgrJournalizing types per project group
337prjtypy_prjtypJournalizing types
338prlocy_prlocProject: Locations
339prmachy_prmachMachinery
340prmehProject entries (Machinery)
341prmesProject entry lines (Machinery)
342prmraty_prmratMachinery-unit rates
343prmsty_prmstProject master cards
344prmstdeby_prmstdebDebtors per project
345prmtrsProject transactions (Machinery)
346prndefy_prndefPrinter definitions
347prnfrmy_prnfrmForm printers
348prnusry_prnusrUser printers
349propsy_propsProperties
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)
396prxlpLink purchase
397prxlsiLink sales invoice
398prxtrsProject transactions (External)
399scencodey_scencodeScenario entries
400scentryy_scentryScenario entry lines
401stalogNotes (Extended)
402stapplApplications (Menu)
403stapplogApplication log
404stbenty_stbentBase entities
405stbicy_stbicBIC codes
406stblevy_stblevBase levels
407stbrlayLayouts
408stbrlayfLayout fields
409stcumdatCumulative data
410stcumdefCumulative definitions
411stdefchgy_stdefchgDefaults and changeability
412stdeficoDefault icons
413stestrhStructure entry header
414stestrlStructure entry line
415stetaskTasks (current)
416stexcaExternal categories
417stexobDocuments
418stextendTable extensions
419stformulaFormulas
420stgatewayGateway
421stgdprdataGDPR: Data
422stgdprhGDPR: Settings
423stgdprlGDPR: Settings (Line)
424stgrpy_stgrpUser groups
425stgrpworkspUser groups per workspace
426sthtaskTasks (current)
427stidpIdentity provider
428stifexExternal calls
429stjobhy_stjobhScheduled jobs
430stjobly_stjoblScheduled job (Parameters)
431stlangLanguages (Application)
432stlnglayy_stlnglayLayouts per language
433stltrmLink terms to master data
434stmnumenu definition
435stmnutxtmenutext
436stnactypey_stnactypeAddress types
437stpostalPostal codes
438stprgy_stprggrpprograms
439stprggrpy_stprggrpMenu authorization
440stprocessProcess history
441strecentRecent
442struley_struleRules
443struleusry_struleusrRule users
444ststrdetStructure details
445ststrucy_ststrucStructures
446sttaskFavorites
447sttermTranslations (User)
448sttranTranslations (System)
449sttsklstTask lists
450sttstrStructure transaction
451sttstrtStructure transaction notes
452stuipropUser interface properties
453stusery_stuserUsers
454stuserworkspUsers per workspace
455stusgrpy_stusgrpUsers per group
456stusrolLicenses per user
457stusrpwdUser passwords
458stworkspmembWorkspace members
459stxlinkXML import definitions
460stxlnodeXML definition nodes
461stxsattpSchema attribute type
462stxsattrSchema attribute
463stxschemXML schemas
464stxselemSchema element
465stxseltpSchema element type
466t_tdefy_t_tdefTest type definitions
467t_tdfdy_t_tdfdTest type descriptions
468t_tdscy_t_tdscTest fields (Description)
469t_testy_t_testCompanies
470titlesy_titlesTitles
471unitsy_unitsUnits
472usrlayForm layouts
473vatboxy_vatboxVAT return boxes
474vatbox_amtVAT return box: Amounts
475vathisVAT history
476vatlnby_vatlnbVAT linked boxes
477vatlntVAT linked total boxes
478vatrepy_vatrepVAT fiscal representatives
479vattrsy_vattrsVAT codes
480xratesExchange rates
481z_findatFinancial years
482z_linkRestrictions
483z_setty_z_settSettings
484z_sevSeveral data
485z_usety_z_usetuser settings