One moment please...
Exact Financials   

Data dictionary exactcs - 7.31

#TableLogging tableDescription
1admdaty_admdatCompany data
2admnac Company: Delivery addresses
3atrsh Financial entries
4atrss Financial entry lines
5balcen Cost center balances
6balcun Consolidated balance sheet
7balsht Balance sheet
8bdalcchy_bdalcchBudget: Cost center allocations
9bdalccly_bdalcclBudget: Cost center allocation (Lines)
10bdalcuh Budget: Cost unit allocations
11bdalcul Budget: Cost unit allocation (Lines)
12bdalloch Budget ccent allocation header
13bdallocl Budget ccent allocation line
14bdalphy_bdalphBudget: Period allocations
15bdalply_bdalplBudget: Period allocation (Lines)
16bdcumdat Budget cumulative data
17bdeauth Budget authorization entries
18bdeautl Budget authorization entry (Lines)
19bdenth Budget entries
20bdentl Budget entry (Lines)
21bdmngy_bdmngBudget managers
22bdpath Budget entry paths
23bdtaut Budget authorization transactions
24bdtautt Budget authorization transaction notes
25bdtrs Budget transactions
26bdtrst Budget transaction notes
27bdversy_bdversBudget versions
28bnkaccy_bnkaccBank accounts
29bnklnky_bnklnkBank links
30bnktpey_bnktpeBank account types
31ccenty_ccentCost centers
32ccnlnky_ccnlnklinking cost centers
33ccntrs Cost center transactions
35combud Year budgets (Commitments)
38comctr_t Contract notes
39comel Commitment entries
40comhl Commitments
42comsl Commitment lines
43comsl_t Commitment notes
44comtrs Commitment transactions
45consccy_consccConsolidation cost centers
46conscoy_conscoConsolidation companies
47conscuy_conscuConsolidation cost unit
48consgg Consolidation data
49contaby_contabConsolidation G/L accounts
51crdbal Creditor balances
52crdcaty_crdcatCreditor categories
53crdnacy_crdnacOrder addresses
54crdout Accounts payable
55crdrev Creditor revaluations
56crdtrs Creditor: Transactions
58credit_t creditor notes
59cstccny_cstccnCost center allocations
60cstcun Standard distr. cost units
61cunity_cunitCost units
63dbvery_dbverDatabase versions
64debbal Debtor balances
65debcaty_debcatDebtor categories
66debout Accounts receivable
67debrev Debtor revaluations
69debtor_t debtor notes
70debtrs Debtor: 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_trns Depreciation transactions
79earolrecy_earolrecData authorization
80earolusry_earolusrRoles per user
82ebabnk_mt940 Bank statement: MT940 codes
83ebabnk_txcd Bank statement transaction codes
84ebalnky_ebalnkBank links
85ebasth Bank statements
86ebasts Bank statement (Lines)
87ebauit Matched bank statements
88faelaf Link assets fin. entries
89fas_asmby_fas_asmbAsset structures
90fas_asty_fas_astFixed assets
91fas_booky_fas_bookAsset books
92fas_depry_fas_deprAsset depreciations
94fas_grpy_fas_grpAsset groups
95fas_locy_fas_locAsset: Locations
96fas_masty_fas_mastAsset sets
97fas_mnt Asset maintenance data
98fas_mthly_fas_mthlAsset set in book (Change)
99fas_prlnk Link asset trans to project
100fas_prmst Projects per asset
101fatlaf Link assets fin. transactions
102fiecol Collection runs
103fielbsf Link: Bank statement (Historic) to journal entry
104fielcf Link collections fin. entries
105fielfc Link atrss to comsl
106fielif Link intercompany to finance
107fielpayf Link: Payment (Historic) to journal entry
108fielrf Link recurring entries to fina
109fihbsh History: Bank statements
110fihbsl History: Bank statement (lines)
111fihpayext Payment extra data (Historic)
112fihpayfmt History: Payment formats
113fihpayord History: Payment orders
114fihpayout History: Payment outstanding items
115fihpayrun History: Payment runs
116fiicomp Pre entry
117filda Link dimensions to G/L account
118fipcolhy_fipcolhCollection installments
119fipcolly_fipcollCollection installment details
120firehy_firehRecurring entries
121firely_firelRecurring entry lines
122fitcol Collections (Historical)
123fitlbsf Link: Bank statement (Historic) to g/l transaction
124fitlcf Link collections fin. entries
125fitlfc Link ledtrs to comtrs
126fitlif Link intercompany to finance
127fitlpayf Link: Payment (Historic) to g/l transaction
128fitlrf Link recurring entries to fina
129fivatcor VAT corrections
130fprep Posting reports
131grpfdc Layout group flag descriptions
132iiowny_iiownInvoice owners
133iireg Incoming invoices
134isocnty_isocntISO countries
135isocury_isocurISO currencies
136isolngy_isolngISO languages
138journl_rule Bank statement: Matching rules
139jrlpayy_jrlpayJournal links payments
140jrlpcry_jrlpcrJournal links payment currency
141jrnlbal journal-balance
142jrnlexca Category (Mandatory)
144laydeby_laydebReminder profile: Language (Line)
145layfdc Layout flag descriptions
146layfgr Layout fields per group
147layfld Fields per layout
148layflg Flags per layout
149laygdc Layout group descriptions
150laygfl Flags per layout per group
151laygrf Layout group flags
152laygrp Layout groups
153laytfl Layout type flags
154ledbal G/L account balances
155ledgery_ledgerG/L accounts
156ledmch Matching transactions
157ledrev G/L revaluations
158ledtrs General ledger transaction
160llcocy_llcocCost codes
161llcocdy_llcocdCost code details
162llcocty_llcoctCost code details
163lldescy_lldescExtra description codes
164lldomey_lldomeDelivery/Order methods
165llicnt Take on inventory
166llidesy_llidesExtra item descriptions
167lligrpy_lligrpItem groups
168llinvcy_llinvcInvoice codes
169llitcry_llitcrCreditor/item data
171llitxty_llitxtText items
172lllgrr Link recurring to generated
173lllrr Link 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
179llrech Recurring (Invoices)
180llrecht Recurring notes
181llrecl Recurring lines
182llrect Recurring text lines
183lltexty_lltextGeneral text codes
184logfield Logging (Fields)
185loghist Deleted (Logging)
186logrec Logging (Records)
187logsetty_logsettLogging settings
188logtable Logging (Tables)
189lpech Purchase order counters
190lpecih Purchase invoice counters
191lpecil Purchase invoice counter lines
192lpecl Manual matching: Purchase order (Purchase invoice)
193lpecrh Receipt counters
194lpecrl Manual matching: Receipt lines
195lpeih Purchase invoices
196lpeiht Purchase invoice notes
197lpeil Purchase invoice lines
198lpeit Purchase invoice text lines
199lpelic Link invoices to commitments
200lpelif Link purchase invoices to fina
201lpelio Purchase order - Purchase invoice history
202lpelir Receipt - Purchase invoice
203lpelmf Link matching to finance
204lpeloc Link orders to commitments
205lpelof Link purchase orders to financ
206lpelrf Link receipts to finance
207lpelro Purchase order - Receipt history
208lpelsp Link sales to purchase
209lpemio Matching purchase invoices/ord
210lpemro Matching receipts/purchase ord
211lpeoh Purchase orders
212lpeoht Purchase order notes
213lpeol Purchase order lines
214lpeot Purchase order text lines
215lperh Receipts
216lperht Receipt notes
217lperl Receipt lines
218lpert Receipt text lines
219lphch Purchase order counters (Historical)
220lphcih Purchase invoice counters (Historical)
221lphcil Purchase invoice counter lines (Historical)
222lphcl Purchase order counter lines (Historical)
223lphcrh Receipt counters (Historical)
224lphcrl Receipt counter lines (Historical)
225lphih Purchase invoices (Historical)
226lphiht Purchase invoice notes
227lphil Purchase invoice lines (Historical)
228lphit Purchase invoice text line his
229lphlic Link lphil to comsl
230lphlif Link purchase invoices to fina
231lphlio Link purchase invoices to purc
232lphlir Link purchase invoices to rece
233lphlmf Link matching to finance
234lphloc Link lphol to comsl
235lphlof Link purchase orders to financ
236lphlrf Link receipts to finance
237lphlro Link receipt history to purcha
238lphlsp Link sales to purchase
239lphmil Purchase invoice matching line
240lphmio Matching purchase invoice/orde
241lphmoh Purchase order matching
242lphmoi Matching purchase order/invoic
243lphmol Purchase order matching lines
244lphmor Matching purchase order/receip
245lphmrl Receipt matching lines
246lphmro Matching receipt/purchase orde
247lphoh Purchase orders (Historical)
248lphoht Purchase order history notes
249lphol Purchase order lines (Historical)
250lphot Purchase order history text li
251lphrh Receipts (Historical)
252lphrht Receipt history notes
253lphrl Receipt lines (Historical)
254lphrt Receipt history text lines
255lseih Sales invoices
256lseil Sales invoice lines
257lseit Sales invoice text lines
258lselif Link sales to finance
259lselof Link sales orders to finance
260lseoh Sales orders
261lseol Sales order lines
262lseot Sales order text lines
263lshih Sales invoices (Historical)
264lshil Sales invoice lines (Historical)
265lshit Invoice history texts
266lshlif Link sales to finance
267lshlof Link sales orders to finance
268lshoh Sales orders (Historical)
269lshol Sales order lines (Historical)
270lshot Sales order history text lines
271lsitsty_lsitstStock changes
273lsrevs Revenue statistics
274mcompy_mcompMain classifications
275mdim1y_mdim1Dimension 1
276mdim2y_mdim2Dimension 2
277mdim3y_mdim3Dimension 3
278mdim4y_mdim4Dimension 4
279mdim5y_mdim5Dimension 5
280paycony_payconPayment conditions
281payext Payment extra data
282payfmt Payment formats
283paymen payments
284payord Payment orders
285payout Payment outstanding items
286paysel Payment runs
287perclsy_perclsClosed periods
288perdaty_perdatPeriod date tables
289pochl Payment over companies: Headers
290pocsl Payment over companies: Details
291practv Activities
292prbudget Project budgets
293prcajty_prcajtCost allocations per journalizing type
294prcally_prcallCost allocations
295prccaty_prccatCost categories
296prccmay_prccmaCost center manager
297prdeby_prdebProject debtors
298prdeh Project entries (Direct revenue)
299prdepy_prdepProject: Departments
300prdes Project entry lines (Direct revenue)
301prdhrty_prdhrtDebtor hour category rates
302prdprty_prdprtDebtor position rates
303prdtrs Project transactions (Direct)
304prelpf Link 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
312prheh Project entries (Hour)
313prhes Project entry lines (Hour)
314prhraty_prhratEmployee-hour category rates
315prhrpry_prhrprEmployee-hour category rates per project
316prhtrs Project transactions (Hour)
317prieh Project entries (Item)
318pries Project entry lines (Item)
319prinam To be invoiced
320prinfi Final invoices
321prinfi_t Final invoice text
322pringcy_pringcInvoice groups: Cost category
323pringhy_pringhInvoice groups
324pringly_pringlInvoice group: Lines
325pringl_t Invoice group line text
326prinph Invoice proposals
327prinps Invoice proposal lines
328prinshy_prinshProject installments
329prinssy_prinssProject installment lines
330prinss_t Installment line text
331printr To be invoiced transactions
332printr_t Amounts to be invoiced text
333pritrs Project transactions (Item)
334prjamt Amounts (Journalize/Release)
335prjtccy_prjtccJournalizing types per cost category
336prjtgry_prjtgrJournalizing types per project group
337prjtypy_prjtypJournalizing types
338prlocy_prlocProject: Locations
340prmeh Project entries (Machinery)
341prmes Project entry lines (Machinery)
342prmraty_prmratMachinery-unit rates
343prmsty_prmstProject master cards
344prmstdeby_prmstdebDebtors per project
345prmtrs Project transactions (Machinery)
346prndefy_prndefPrinter definitions
347prnfrmy_prnfrmForm printers
348prnusry_prnusrUser printers
350props_t Properties texts
351prphdfy_prphdfPhase list descriptions
352prphlpy_prphlpPhase list definitions
354prphsny_prphsnPhase lists
355prpmcy_prpmcProperty choices
356prpmrty_prpmrtMachinery rates per project
357prpmsty_prpmstProject structures
358prpmury_prpmurMachinery-unit rates per project
359prposy_prposProject positions
360prpsrty_prpsrtPosition rates per project
361prpurty_prpurtUnit rates per project
362prpvaly_prpvalProperty values
363prrate Project rates
364prrcca Cost category (Results)
365prrcyp Cost category budgets (By period)
366prreason Project budget (Change codes)
367prrhca Employee forecast
368prrhyp Employee budgets (By period)
369prritm Item forecast
370prriyp Item budgets (By period)
371prrmch Machinery forecast
372prrmyp Machinery budgets (By period)
373prrprj Result project
374prrpyp Project budgets (By period)
375prrtcca History: Cost category budgets
376prrtcyp History: Cost category budgets per period
377prrthca History: Employee budgets
378prrthyp History: Employee budgets per period
379prrtitm History: Machinery budgets
380prrtiyp History: Machinery budgets per period
381prrtmch History: Item budgets
382prrtmyp History: Item budgets per period
383prrtprj Result project
384prrtpyp Result project per period
385prrttyy_prrttyProject rate priority (Lines)
386prsccny_prsccnCost center structures
387prsdepy_prsdepDepartment structures
388prstaty_prstatStatuses (Project)
389prsurcy_prsurcSurcharge codes
390prtlpf Project - Financial (Link transaction)
391prtrs Project transactions
392prtypey_prtypeProject types
393prunity_prunitProject units
394prwiph Work in progress (Header)
395prwipl Work in progress (Lines)
396prxes Project entries (External)
397prxlf Link to finance
398prxlp Link purchase
399prxlsi Link sales invoice
400prxlso Link sales order
401prxtrs Project transactions (External)
402scencodey_scencodeScenario entries
403scentryy_scentryScenario entry lines
404stalog Notes (Extended)
405stappl Applications (Menu)
406stapplog Application log
407stbenty_stbentBase entities
408stbicy_stbicBIC codes
409stblevy_stblevBase levels
410stbrlay Layouts
411stbrlayf Layout fields
412stcumdat Cumulative data
413stcumdef Cumulative definitions
414stdefchgy_stdefchgDefaults and changeability
415stdefico Default icons
416stestrh Structure entry header
417stestrl Structure entry line
418stetask Tasks (current)
419stexca External categories
420stexob Documents
421stextend Table extensions
422stformula Formulas
423stgateway Gateway
424stgdprdata GDPR: Data
425stgdprh GDPR: Settings
426stgdprl GDPR: Settings (Line)
427stgrpy_stgrpUser groups
428stgrpworksp User groups per workspace
429sthtask Tasks (current)
430stidp Identity provider
431stifex External calls
432stjobhy_stjobhScheduled jobs
433stjobly_stjoblScheduled job (Parameters)
434stlang Languages (Application)
435stlnglayy_stlnglayLayouts per language
436stltrm Link terms to master data
437stmnu menu definition
438stmnutxt menutext
439stnactypey_stnactypeAddress types
440stpostal Postal codes
442stprggrpy_stprggrpMenu authorization
443stprocess Process history
444strecent Recent
446struleusry_struleusrRule users
447ststrdet Structure details
449sttask Favorites
450stterm Translations (User)
451sttran Translations (System)
452sttsklst Task lists
453sttstr Structure transaction
454sttstrt Structure transaction notes
455stuiprop User interface properties
457stuserworksp Users per workspace
458stusgrpy_stusgrpUsers per group
459stusrol Licenses per user
460stusrpwd User passwords
461stworkspmemb Workspace members
462stxlink XML import definitions
463stxlnode XML definition nodes
464stxsattp Schema attribute type
465stxsattr Schema attribute
466stxschem XML schemas
467stxselem Schema element
468stxseltp Schema element type
469t_tdefy_t_tdefTest type definitions
470t_tdfdy_t_tdfdTest type descriptions
471t_tdscy_t_tdscTest fields (Description)
475usrlay Form layouts
476vatboxy_vatboxVAT return boxes
477vatbox_amt VAT return box: Amounts
478vathis VAT history
479vatlnby_vatlnbVAT linked boxes
480vatlnt VAT linked total boxes
481vatrepy_vatrepVAT fiscal representatives
482vattrsy_vattrsVAT codes
483xrates Exchange rates
484z_findat Financial years
485z_link Restrictions
487z_sev Several data
488z_usety_z_usetuser settings