One moment please...
 
 
Exact Financials   
 

Data dictionary exactcs - 7.29

#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
350props_tProperties texts
351prphdfy_prphdfPhase list descriptions
352prphlpy_prphlpPhase list definitions
353prphsey_prphsePhases
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
363prrateProject rates
364prrccaCost category (Results)
365prrcypCost category budgets (By period)
366prreasonProject budget (Change codes)
367prrhcaEmployee forecast
368prrhypEmployee budgets (By period)
369prritmItem forecast
370prriypItem budgets (By period)
371prrmchMachinery forecast
372prrmypMachinery budgets (By period)
373prrprjResult project
374prrpypProject budgets (By period)
375prrtccaHistory: Cost category budgets
376prrtcypHistory: Cost category budgets per period
377prrthcaHistory: Employee budgets
378prrthypHistory: Employee budgets per period
379prrtitmHistory: Machinery budgets
380prrtiypHistory: Machinery budgets per period
381prrtmchHistory: Item budgets
382prrtmypHistory: Item budgets per period
383prrtprjResult project
384prrtpypResult project per period
385prrttyy_prrttyProject rate priority (Lines)
386prsccny_prsccnCost center structures
387prsdepy_prsdepDepartment structures
388prstaty_prstatStatuses (Project)
389prsurcy_prsurcSurcharge codes
390prtlpfProject - Financial (Link transaction)
391prtrsProject transactions
392prtypey_prtypeProject types
393prunity_prunitProject units
394prwiphWork in progress (Header)
395prwiplWork in progress (Lines)
396prxesProject entries (External)
397prxlfLink to finance
398prxlpLink purchase
399prxlsiLink sales invoice
400prxlsoLink sales order
401prxtrsProject transactions (External)
402scencodey_scencodeScenario entries
403scentryy_scentryScenario entry lines
404stalogNotes (Extended)
405stapplApplications (Menu)
406stapplogApplication log
407stbenty_stbentBase entities
408stbicy_stbicBIC codes
409stblevy_stblevBase levels
410stbrlayLayouts
411stbrlayfLayout fields
412stcumdatCumulative data
413stcumdefCumulative definitions
414stdefchgy_stdefchgDefaults and changeability
415stdeficoDefault icons
416stestrhStructure entry header
417stestrlStructure entry line
418stetaskTasks (current)
419stexcaExternal categories
420stexobDocuments
421stextendTable extensions
422stformulaFormulas
423stgatewayGateway
424stgdprdataGDPR: Data
425stgdprhGDPR: Settings
426stgdprlGDPR: Settings (Line)
427stgrpy_stgrpUser groups
428stgrpworkspUser groups per workspace
429sthtaskTasks (current)
430stidpIdentity provider
431stifexExternal calls
432stjobhy_stjobhScheduled jobs
433stjobly_stjoblScheduled job (Parameters)
434stlangLanguages (Application)
435stlnglayy_stlnglayLayouts per language
436stltrmLink terms to master data
437stmnumenu definition
438stmnutxtmenutext
439stnactypey_stnactypeAddress types
440stpostalPostal codes
441stprgy_stprggrpprograms
442stprggrpy_stprggrpMenu authorization
443stprocessProcess history
444strecentRecent
445struley_struleRules
446struleusry_struleusrRule users
447ststrdetStructure details
448ststrucy_ststrucStructures
449sttaskFavorites
450sttermTranslations (User)
451sttranTranslations (System)
452sttsklstTask lists
453sttstrStructure transaction
454sttstrtStructure transaction notes
455stuipropUser interface properties
456stusery_stuserUsers
457stuserworkspUsers per workspace
458stusgrpy_stusgrpUsers per group
459stusrolLicenses per user
460stusrpwdUser passwords
461stworkspmembWorkspace members
462stxlinkXML import definitions
463stxlnodeXML definition nodes
464stxsattpSchema attribute type
465stxsattrSchema attribute
466stxschemXML schemas
467stxselemSchema element
468stxseltpSchema element type
469t_tdefy_t_tdefTest type definitions
470t_tdfdy_t_tdfdTest type descriptions
471t_tdscy_t_tdscTest fields (Description)
472t_testy_t_testCompanies
473titlesy_titlesTitles
474unitsy_unitsUnits
475usrlayForm layouts
476vatboxy_vatboxVAT return boxes
477vatbox_amtVAT return box: Amounts
478vathisVAT history
479vatlnby_vatlnbVAT linked boxes
480vatlntVAT linked total boxes
481vatrepy_vatrepVAT fiscal representatives
482vattrsy_vattrsVAT codes
483xratesExchange rates
484z_findatFinancial years
485z_linkRestrictions
486z_setty_z_settSettings
487z_sevSeveral data
488z_usety_z_usetuser settings