One moment please...
 
 
Exact Financials   
 

Data dictionary exactcs - 7.22

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