Exact Financials

Data dictionary exactcs - 7.26

#	Table	Logging table	Description
1	admdat	y_admdat	Company data
2	admnac		Company: Delivery addresses
3	atrsh		Financial entries
4	atrss		Financial entry lines
5	balcen		Cost center balances
6	balcun		Consolidated balance sheet
7	balsht		Balance sheet
8	bdalcch	y_bdalcch	Budget: Cost center allocations
9	bdalccl	y_bdalccl	Budget: Cost center allocation (Lines)
10	bdalcuh		Budget: Cost unit allocations
11	bdalcul		Budget: Cost unit allocation (Lines)
12	bdalloch		Budget ccent allocation header
13	bdallocl		Budget ccent allocation line
14	bdalph	y_bdalph	Budget: Period allocations
15	bdalpl	y_bdalpl	Budget: Period allocation (Lines)
16	bdcumdat		Budget cumulative data
17	bdeauth		Budget authorization entries
18	bdeautl		Budget authorization entry (Lines)
19	bdenth		Budget entries
20	bdentl		Budget entry (Lines)
21	bdmng	y_bdmng	Budget managers
22	bdpath		Budget entry paths
23	bdtaut		Budget authorization transactions
24	bdtautt		Budget authorization transaction notes
25	bdtrs		Budget transactions
26	bdtrst		Budget transaction notes
27	bdvers	y_bdvers	Budget versions
28	bnkacc	y_bnkacc	Bank accounts
29	bnklnk	y_bnklnk	Bank links
30	bnktpe	y_bnktpe	Bank account types
31	ccent	y_ccent	Cost centers
32	ccnlnk	y_ccnlnk	linking cost centers
33	ccntrs		Cost center transactions
34	colarr	y_colarr	Mandates
35	combud		Year budgets (Commitments)
36	comcls	y_comcls	Classifications
37	comctr	y_comctr	Contracts
38	comctr_t		Contract notes
39	comel		Commitment entries
40	comhl		Commitments
41	comp	y_comp	Sub-classifications
42	comsl		Commitment lines
43	comsl_t		Commitment notes
44	comtrs		Commitment transactions
45	conscc	y_conscc	Consolidation cost centers
46	consco	y_consco	Consolidation companies
47	conscu	y_conscu	Consolidation cost unit
48	consgg		Consolidation data
49	contab	y_contab	Consolidation G/L accounts
50	countr	y_countr	Countries
51	crdbal		Creditor balances
52	crdcat	y_crdcat	Creditor categories
53	crdnac		Order addresses
54	crdout		Accounts payable
55	crdrev		Creditor revaluations
56	crdtrs		Creditor: Transactions
57	credit	y_credit	Creditors
58	credit_t		creditor notes
59	cstccn	y_cstccn	Cost center allocations
60	cstcun		Standard distr. cost units
61	cunit	y_cunit	Cost units
62	curren	y_curren	Currencies
63	dbver	y_dbver	Database versions
64	debbal		Debtor balances
65	debcat	y_debcat	Debtor categories
66	debout		Accounts receivable
67	debrev		Debtor revaluations
68	debtor	y_debtor	Debtors (Sales)
69	debtor_t		debtor notes
70	debtrs		Debtor: Transactions
71	delnac	y_delnac	Delivery addresses
72	dpr_cald	y_dpr_cald	Calendar periods
73	dpr_calm	y_dpr_calm	Depreciation calendars
74	dpr_idxd	y_dpr_idxd	Depreciation index details
75	dpr_idxm	y_dpr_idxm	Depreciation index tables
76	dpr_mtab	y_dpr_mtab	Depreciation tables
77	dpr_trns		Depreciation transactions
78	earole	y_earole	Roles
79	earolrec	y_earolrec	Data authorization
80	earolusr	y_earolusr	Roles per user
81	ebabnk	y_ebabnk	Banks
82	ebabnk_mt940		Bank statement: MT940 codes
83	ebabnk_txcd		Bank statement transaction codes
84	ebalnk	y_ebalnk	Bank links
85	ebasth		Bank statements
86	ebasts		Bank statement (Lines)
87	ebauit		Matched bank statements
88	faelaf		Link assets fin. entries
89	fas_asmb	y_fas_asmb	Asset structures
90	fas_ast	y_fas_ast	Fixed assets
91	fas_book	y_fas_book	Asset books
92	fas_depr	y_fas_depr	Asset depreciations
93	fas_dept	y_fas_dept	Departments
94	fas_grp	y_fas_grp	Asset groups
95	fas_loc	y_fas_loc	Asset: Locations
96	fas_mast	y_fas_mast	Asset sets
97	fas_mnt		Asset maintenance data
98	fas_mthl	y_fas_mthl	Asset set in book (Change)
99	fas_prlnk		Link asset trans to project
100	fas_prmst		Projects per asset
101	fatlaf		Link assets fin. transactions
102	fiecol		Collection runs
103	fielbsf		Link: Bank statement (Historic) to journal entry
104	fielcf		Link collections fin. entries
105	fielfc		Link atrss to comsl
106	fielif		Link intercompany to finance
107	fielpayf		Link: Payment (Historic) to journal entry
108	fielrf		Link recurring entries to fina
109	fihbsh		History: Bank statements
110	fihbsl		History: Bank statement (lines)
111	fihpayext		Payment extra data (Historic)
112	fihpayfmt		History: Payment formats
113	fihpayord		History: Payment orders
114	fihpayout		History: Payment outstanding items
115	fihpayrun		History: Payment runs
116	fiicomp		Pre entry
117	filda		Link dimensions to G/L account
118	fipcolh	y_fipcolh	Collection installments
119	fipcoll	y_fipcoll	Collection installment details
120	fireh	y_fireh	Recurring entries
121	firel	y_firel	Recurring entry lines
122	fitcol		Collections (Historical)
123	fitlbsf		Link: Bank statement (Historic) to g/l transaction
124	fitlcf		Link collections fin. entries
125	fitlfc		Link ledtrs to comtrs
126	fitlif		Link intercompany to finance
127	fitlpayf		Link: Payment (Historic) to g/l transaction
128	fitlrf		Link recurring entries to fina
129	fivatcor		VAT corrections
130	fprep		Posting reports
131	grpfdc		Layout group flag descriptions
132	iiown	y_iiown	Invoice owners
133	iireg		Incoming invoices
134	isocnt	y_isocnt	ISO countries
135	isocur	y_isocur	ISO currencies
136	isolng	y_isolng	ISO languages
137	journl	y_journl	Journals
138	journl_rule		Bank statement: Matching rules
139	jrlpay	y_jrlpay	Journal links payments
140	jrlpcr	y_jrlpcr	Journal links payment currency
141	jrnlbal		journal-balance
142	lang	y_lang	Languages
143	laydeb	y_laydeb	Reminder profile: Language (Line)
144	layfdc		Layout flag descriptions
145	layfgr		Layout fields per group
146	layfld		Fields per layout
147	layflg		Flags per layout
148	laygdc		Layout group descriptions
149	laygfl		Flags per layout per group
150	laygrf		Layout group flags
151	laygrp		Layout groups
152	laytfl		Layout type flags
153	ledbal		G/L account balances
154	ledger	y_ledger	G/L accounts
155	ledmch		Matching transactions
156	ledrev		G/L revaluations
157	ledtrs		General ledger transaction
158	licdat	y_licdat	Licenses
159	llcoc	y_llcoc	Cost codes
160	llcocd	y_llcocd	Cost code details
161	llcoct	y_llcoct	Cost code details
162	lldesc	y_lldesc	Extra description codes
163	lldome	y_lldome	Delivery/Order methods
164	llicnt		Take on inventory
165	llides	y_llides	Extra item descriptions
166	lligrp	y_lligrp	Item groups
167	llinvc	y_llinvc	Invoice codes
168	llitcr	y_llitcr	Creditor/item data
169	llitem	y_llitem	Items
170	llitxt	y_llitxt	Text items
171	lllgrr		Link recurring to generated
172	lllrr		Link recurring to relations
173	llpdig	y_llpdig	Price lists (Per item group detail)
174	llpdit	y_llpdit	Price lists (Per item detail)
175	llplig	y_llplig	Price lists (Per item group)
176	llplit	y_llplit	Price lists (Per item)
177	llplst	y_llplst	Price lists
178	llrech		Recurring (Invoices)
179	llrecht		Recurring notes
180	llrecl		Recurring lines
181	llrect		Recurring text lines
182	lltext	y_lltext	General text codes
183	logfield		Logging (Fields)
184	loghist		Deleted (Logging)
185	logrec		Logging (Records)
186	logsett	y_logsett	Logging settings
187	logtable		Logging (Tables)
188	lpech		Purchase order counters
189	lpecih		Purchase invoice counters
190	lpecil		Purchase invoice counter lines
191	lpecl		Manual matching: Purchase order (Purchase invoice)
192	lpecrh		Receipt counters
193	lpecrl		Manual matching: Receipt lines
194	lpeih		Purchase invoices
195	lpeiht		Purchase invoice notes
196	lpeil		Purchase invoice lines
197	lpeit		Purchase invoice text lines
198	lpelic		Link invoices to commitments
199	lpelif		Link purchase invoices to fina
200	lpelio		Purchase order - Purchase invoice history
201	lpelir		Receipt - Purchase invoice
202	lpelmf		Link matching to finance
203	lpeloc		Link orders to commitments
204	lpelof		Link purchase orders to financ
205	lpelrf		Link receipts to finance
206	lpelro		Purchase order - Receipt history
207	lpelsp		Link sales to purchase
208	lpemio		Matching purchase invoices/ord
209	lpemro		Matching receipts/purchase ord
210	lpeoh		Purchase orders
211	lpeoht		Purchase order notes
212	lpeol		Purchase order lines
213	lpeot		Purchase order text lines
214	lperh		Receipts
215	lperht		Receipt notes
216	lperl		Receipt lines
217	lpert		Receipt text lines
218	lphch		Purchase order counters (Historical)
219	lphcih		Purchase invoice counters (Historical)
220	lphcil		Purchase invoice counter lines (Historical)
221	lphcl		Purchase order counter lines (Historical)
222	lphcrh		Receipt counters (Historical)
223	lphcrl		Receipt counter lines (Historical)
224	lphih		Purchase invoices (Historical)
225	lphiht		Purchase invoice notes
226	lphil		Purchase invoice lines (Historical)
227	lphit		Purchase invoice text line his
228	lphlic		Link lphil to comsl
229	lphlif		Link purchase invoices to fina
230	lphlio		Link purchase invoices to purc
231	lphlir		Link purchase invoices to rece
232	lphlmf		Link matching to finance
233	lphloc		Link lphol to comsl
234	lphlof		Link purchase orders to financ
235	lphlrf		Link receipts to finance
236	lphlro		Link receipt history to purcha
237	lphlsp		Link sales to purchase
238	lphmil		Purchase invoice matching line
239	lphmio		Matching purchase invoice/orde
240	lphmoh		Purchase order matching
241	lphmoi		Matching purchase order/invoic
242	lphmol		Purchase order matching lines
243	lphmor		Matching purchase order/receip
244	lphmrl		Receipt matching lines
245	lphmro		Matching receipt/purchase orde
246	lphoh		Purchase orders (Historical)
247	lphoht		Purchase order history notes
248	lphol		Purchase order lines (Historical)
249	lphot		Purchase order history text li
250	lphrh		Receipts (Historical)
251	lphrht		Receipt history notes
252	lphrl		Receipt lines (Historical)
253	lphrt		Receipt history text lines
254	lseih		Sales invoices
255	lseil		Sales invoice lines
256	lseit		Sales invoice text lines
257	lselif		Link sales to finance
258	lselof		Link sales orders to finance
259	lseoh		Sales orders
260	lseol		Sales order lines
261	lseot		Sales order text lines
262	lshih		Sales invoices (Historical)
263	lshil		Sales invoice lines (Historical)
264	lshit		Invoice history texts
265	lshlif		Link sales to finance
266	lshlof		Link sales orders to finance
267	lshoh		Sales orders (Historical)
268	lshol		Sales order lines (Historical)
269	lshot		Sales order history text lines
270	lsitst	y_lsitst	Stock changes
271	lsrep	y_lsrep	Representatives
272	lsrevs		Revenue statistics
273	mcomp	y_mcomp	Main classifications
274	mdim1	y_mdim1	Dimension 1
275	mdim2	y_mdim2	Dimension 2
276	mdim3	y_mdim3	Dimension 3
277	mdim4	y_mdim4	Dimension 4
278	mdim5	y_mdim5	Dimension 5
279	paycon	y_paycon	Payment conditions
280	payext		Payment extra data
281	payfmt		Payment formats
282	paymen		payments
283	payord		Payment orders
284	payout		Payment outstanding items
285	paysel		Payment runs
286	percls	y_percls	Closed periods
287	perdat	y_perdat	Period date tables
288	pochl		Payment over companies: Headers
289	pocsl		Payment over companies: Details
290	practv		Activities
291	prbudget		Project budgets
292	prcajt	y_prcajt	Cost allocations per journalizing type
293	prcall	y_prcall	Cost allocations
294	prccat	y_prccat	Cost categories
295	prccma	y_prccma	Cost center manager
296	prdeb	y_prdeb	Project debtors
297	prdeh		Project entries (Direct revenue)
298	prdep	y_prdep	Project: Departments
299	prdes		Project entry lines (Direct revenue)
300	prdhrt	y_prdhrt	Debtor hour category rates
301	prdprt	y_prdprt	Debtor position rates
302	prdtrs		Project transactions (Direct)
303	prelpf		Link project to finance
304	premp	y_premp	Project employees
305	premrt	y_premrt	Employee rates per project
306	prghrt	y_prghrt	Project group hour category rates
307	prgprt	y_prgprt	Project group position rates
308	prgrp	y_prgrp	Project groups
309	prhcat	y_prhcat	Hour categories
310	prhcrt	y_prhcrt	Hour category rates per project
311	prheh		Project entries (Hour)
312	prhes		Project entry lines (Hour)
313	prhrat	y_prhrat	Employee-hour category rates
314	prhrpr	y_prhrpr	Employee-hour category rates per project
315	prhtrs		Project transactions (Hour)
316	prieh		Project entries (Item)
317	pries		Project entry lines (Item)
318	prinam		To be invoiced
319	prinfi		Final invoices
320	prinfi_t		Final invoice text
321	pringc	y_pringc	Invoice groups: Cost category
322	pringh	y_pringh	Invoice groups
323	pringl	y_pringl	Invoice group: Lines
324	pringl_t		Invoice group line text
325	prinph		Invoice proposals
326	prinps		Invoice proposal lines
327	prinsh	y_prinsh	Project installments
328	prinss	y_prinss	Project installment lines
329	prinss_t		Installment line text
330	printr		To be invoiced transactions
331	printr_t		Amounts to be invoiced text
332	pritrs		Project transactions (Item)
333	prjamt		Amounts (Journalize/Release)
334	prjtcc	y_prjtcc	Journalizing types per cost category
335	prjtgr	y_prjtgr	Journalizing types per project group
336	prjtyp	y_prjtyp	Journalizing types
337	prloc	y_prloc	Project: Locations
338	prmach	y_prmach	Machinery
339	prmeh		Project entries (Machinery)
340	prmes		Project entry lines (Machinery)
341	prmrat	y_prmrat	Machinery-unit rates
342	prmst	y_prmst	Project master cards
343	prmstdeb	y_prmstdeb	Debtors per project
344	prmtrs		Project transactions (Machinery)
345	prndef	y_prndef	Printer definitions
346	prnfrm	y_prnfrm	Form printers
347	prnusr	y_prnusr	User printers
348	props	y_props	Properties
349	props_t		Properties texts
350	prphdf	y_prphdf	Phase list descriptions
351	prphlp	y_prphlp	Phase list definitions
352	prphse	y_prphse	Phases
353	prphsn	y_prphsn	Phase lists
354	prpmc	y_prpmc	Property choices
355	prpmrt	y_prpmrt	Machinery rates per project
356	prpmst	y_prpmst	Project structures
357	prpmur	y_prpmur	Machinery-unit rates per project
358	prpos	y_prpos	Project positions
359	prpsrt	y_prpsrt	Position rates per project
360	prpurt	y_prpurt	Unit rates per project
361	prpval	y_prpval	Property values
362	prrate		Project rates
363	prrcca		Cost category (Results)
364	prrcyp		Cost category budgets (By period)
365	prreason		Project budget (Change codes)
366	prrhca		Employee forecast
367	prrhyp		Employee budgets (By period)
368	prritm		Item forecast
369	prriyp		Item budgets (By period)
370	prrmch		Machinery forecast
371	prrmyp		Machinery budgets (By period)
372	prrprj		Result project
373	prrpyp		Project budgets (By period)
374	prrtcca		History: Cost category budgets
375	prrtcyp		History: Cost category budgets per period
376	prrthca		History: Employee budgets
377	prrthyp		History: Employee budgets per period
378	prrtitm		History: Machinery budgets
379	prrtiyp		History: Machinery budgets per period
380	prrtmch		History: Item budgets
381	prrtmyp		History: Item budgets per period
382	prrtprj		Result project
383	prrtpyp		Result project per period
384	prrtty	y_prrtty	Project rate priority (Lines)
385	prsccn	y_prsccn	Cost center structures
386	prsdep	y_prsdep	Department structures
387	prstat	y_prstat	Statuses (Project)
388	prsurc	y_prsurc	Surcharge codes
389	prtlpf		Project - Financial (Link transaction)
390	prtrs		Project transactions
391	prtype	y_prtype	Project types
392	prunit	y_prunit	Project units
393	prwiph		Work in progress (Header)
394	prwipl		Work in progress (Lines)
395	prxes		Project entries (External)
396	prxlf		Link to finance
397	prxlp		Link purchase
398	prxlsi		Link sales invoice
399	prxlso		Link sales order
400	prxtrs		Project transactions (External)
401	scencode	y_scencode	Scenario entries
402	scentry	y_scentry	Scenario entry lines
403	stalog		Notes (Extended)
404	stappl		Applications (Menu)
405	stbent	y_stbent	Base entities
406	stbic	y_stbic	BIC codes
407	stblev	y_stblev	Base levels
408	stbrlay		Layouts
409	stbrlayf		Layout fields
410	stcumdat		Cumulative data
411	stcumdef		Cumulative definitions
412	stdefchg	y_stdefchg	Defaults and changeability
413	stdefico		Default icons
414	stestrh		Structure entry header
415	stestrl		Structure entry line
416	stetask		Tasks (current)
417	stexca		External categories
418	stexob		Documents
419	stextend		Table extensions
420	stformula		Formulas
421	stgdprdata		GDPR: Data
422	stgdprh		GDPR: Settings
423	stgdprl		GDPR: Settings (Line)
424	stgrp	y_stgrp	User groups
425	stgrpworksp		User groups per workspace
426	sthtask		Tasks (current)
427	stifex		External calls
428	stjobh	y_stjobh	Scheduled jobs
429	stjobl	y_stjobl	Scheduled job (Parameters)
430	stlang		Languages (Application)
431	stlnglay	y_stlnglay	Layouts per language
432	stltrm		Link terms to master data
433	stmnu		menu definition
434	stmnutxt		menutext
435	stnactype	y_stnactype	Address types
436	stpostal		Postal codes
437	stprg	y_stprggrp	programs
438	stprggrp	y_stprggrp	Menu authorization
439	stprocess		Process history
440	strecent		Recent
441	strule	y_strule	Rules
442	struleusr	y_struleusr	Rule users
443	ststrdet		Structure details
444	ststruc	y_ststruc	Structures
445	sttask		Favorites
446	stterm		Translations (User)
447	sttran		Translations (System)
448	sttsklst		Task lists
449	sttstr		Structure transaction
450	sttstrt		Structure transaction notes
451	stuiprop		User interface properties
452	stuser	y_stuser	Users
453	stuserworksp		Users per workspace
454	stusgrp	y_stusgrp	Users per group
455	stusrol		Licenses per user
456	stusrpwd		User passwords
457	stworkspmemb		Workspace members
458	stxlink		XML import definitions
459	stxlnode		XML definition nodes
460	stxsattp		Schema attribute type
461	stxsattr		Schema attribute
462	stxschem		XML schemas
463	stxselem		Schema element
464	stxseltp		Schema element type
465	t_tdef	y_t_tdef	Test type definitions
466	t_tdfd	y_t_tdfd	Test type descriptions
467	t_tdsc	y_t_tdsc	Test fields (Description)
468	t_test	y_t_test	Companies
469	titles	y_titles	Titles
470	units	y_units	Units
471	usrlay		Form layouts
472	vatbox	y_vatbox	VAT return boxes
473	vatbox_amt		VAT return box: Amounts
474	vathis		VAT history
475	vatlnb	y_vatlnb	VAT linked boxes
476	vatlnt		VAT linked total boxes
477	vatrep	y_vatrep	VAT fiscal representatives
478	vattrs	y_vattrs	VAT codes
479	xrates		Exchange rates
480	z_findat		Financial years
481	z_link		Restrictions
482	z_sett	y_z_sett	Settings
483	z_sev		Several data
484	z_uset	y_z_uset	user settings

Main Category:	Support Product Know How	Document Type:	Online help main
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	28.884.562
Assortment:	Exact Financials	Date:	19-02-2019
Release:		Attachment:
Disclaimer

Tags	Support Product Know How-On-line help files-Details

Data dictionary exactcs - 7.26

admdat - Company data

Indexes

admdatix - primary - unique

admdat02ix

admnac - Company: Delivery addresses

Indexes

admnacix - primary - unique

admnac02ix

admnac03ix

admnac04ix

atrsh - Financial entries

Indexes

atrsh01ix - primary - unique

atrsh02ix

atrsh03ix

atrsh04ix

atrss - Financial entry lines

Indexes

atrssix - primary - unique

atrss09ix

atrss2ix

atrss3ix

atrss4ix

atrss5ix

atrss6ix

atrss7ix

atrss8ix

balcen - Cost center balances

Indexes

balcenix - primary - unique

balcen2ix

balcen3ix

balcun - Consolidated balance sheet

Indexes

balcunix - primary - unique

balcun2ix

balcun3ix

balsht - Balance sheet

Indexes

balshtix - primary - unique

balsht2ix

bdalcch - Budget: Cost center allocations

Indexes

bdalcch01ix - primary - unique

bdalccl - Budget: Cost center allocation (Lines)

Indexes

bdalccl01ix - primary - unique

bdalcuh - Budget: Cost unit allocations

Indexes

bdalcuh01ix - primary - unique

bdalcul - Budget: Cost unit allocation (Lines)

Indexes

bdalcul01ix - primary - unique

bdalloch - Budget ccent allocation header

Indexes

bdalloch01ix - primary - unique

bdallocl - Budget ccent allocation line

Indexes

bdallocl01ix - primary - unique

bdalph - Budget: Period allocations

Indexes

bdalph01ix - primary - unique

bdalpl - Budget: Period allocation (Lines)

Indexes

bdalpl01ix - primary - unique

bdcumdat - Budget cumulative data

Indexes

bdcumdat01ix - primary - unique

bdeauth - Budget authorization entries

Indexes

bdeauth01ix - primary - unique

bdeautl - Budget authorization entry (Lines)

Indexes

bdeautl01ix - primary - unique

bdenth - Budget entries

Indexes

bdenth01ix - primary - unique

bdenth02ix

bdentl - Budget entry (Lines)