Exact Financials

Data dictionary exactcs - 7.29

#	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	y_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
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	jrnlexca		Category (Mandatory)
143	lang	y_lang	Languages
144	laydeb	y_laydeb	Reminder profile: Language (Line)
145	layfdc		Layout flag descriptions
146	layfgr		Layout fields per group
147	layfld		Fields per layout
148	layflg		Flags per layout
149	laygdc		Layout group descriptions
150	laygfl		Flags per layout per group
151	laygrf		Layout group flags
152	laygrp		Layout groups
153	laytfl		Layout type flags
154	ledbal		G/L account balances
155	ledger	y_ledger	G/L accounts
156	ledmch		Matching transactions
157	ledrev		G/L revaluations
158	ledtrs		General ledger transaction
159	licdat	y_licdat	Licenses
160	llcoc	y_llcoc	Cost codes
161	llcocd	y_llcocd	Cost code details
162	llcoct	y_llcoct	Cost code details
163	lldesc	y_lldesc	Extra description codes
164	lldome	y_lldome	Delivery/Order methods
165	llicnt		Take on inventory
166	llides	y_llides	Extra item descriptions
167	lligrp	y_lligrp	Item groups
168	llinvc	y_llinvc	Invoice codes
169	llitcr	y_llitcr	Creditor/item data
170	llitem	y_llitem	Items
171	llitxt	y_llitxt	Text items
172	lllgrr		Link recurring to generated
173	lllrr		Link recurring to relations
174	llpdig	y_llpdig	Price lists (Per item group detail)
175	llpdit	y_llpdit	Price lists (Per item detail)
176	llplig	y_llplig	Price lists (Per item group)
177	llplit	y_llplit	Price lists (Per item)
178	llplst	y_llplst	Price lists
179	llrech		Recurring (Invoices)
180	llrecht		Recurring notes
181	llrecl		Recurring lines
182	llrect		Recurring text lines
183	lltext	y_lltext	General text codes
184	logfield		Logging (Fields)
185	loghist		Deleted (Logging)
186	logrec		Logging (Records)
187	logsett	y_logsett	Logging settings
188	logtable		Logging (Tables)
189	lpech		Purchase order counters
190	lpecih		Purchase invoice counters
191	lpecil		Purchase invoice counter lines
192	lpecl		Manual matching: Purchase order (Purchase invoice)
193	lpecrh		Receipt counters
194	lpecrl		Manual matching: Receipt lines
195	lpeih		Purchase invoices
196	lpeiht		Purchase invoice notes
197	lpeil		Purchase invoice lines
198	lpeit		Purchase invoice text lines
199	lpelic		Link invoices to commitments
200	lpelif		Link purchase invoices to fina
201	lpelio		Purchase order - Purchase invoice history
202	lpelir		Receipt - Purchase invoice
203	lpelmf		Link matching to finance
204	lpeloc		Link orders to commitments
205	lpelof		Link purchase orders to financ
206	lpelrf		Link receipts to finance
207	lpelro		Purchase order - Receipt history
208	lpelsp		Link sales to purchase
209	lpemio		Matching purchase invoices/ord
210	lpemro		Matching receipts/purchase ord
211	lpeoh		Purchase orders
212	lpeoht		Purchase order notes
213	lpeol		Purchase order lines
214	lpeot		Purchase order text lines
215	lperh		Receipts
216	lperht		Receipt notes
217	lperl		Receipt lines
218	lpert		Receipt text lines
219	lphch		Purchase order counters (Historical)
220	lphcih		Purchase invoice counters (Historical)
221	lphcil		Purchase invoice counter lines (Historical)
222	lphcl		Purchase order counter lines (Historical)
223	lphcrh		Receipt counters (Historical)
224	lphcrl		Receipt counter lines (Historical)
225	lphih		Purchase invoices (Historical)
226	lphiht		Purchase invoice notes
227	lphil		Purchase invoice lines (Historical)
228	lphit		Purchase invoice text line his
229	lphlic		Link lphil to comsl
230	lphlif		Link purchase invoices to fina
231	lphlio		Link purchase invoices to purc
232	lphlir		Link purchase invoices to rece
233	lphlmf		Link matching to finance
234	lphloc		Link lphol to comsl
235	lphlof		Link purchase orders to financ
236	lphlrf		Link receipts to finance
237	lphlro		Link receipt history to purcha
238	lphlsp		Link sales to purchase
239	lphmil		Purchase invoice matching line
240	lphmio		Matching purchase invoice/orde
241	lphmoh		Purchase order matching
242	lphmoi		Matching purchase order/invoic
243	lphmol		Purchase order matching lines
244	lphmor		Matching purchase order/receip
245	lphmrl		Receipt matching lines
246	lphmro		Matching receipt/purchase orde
247	lphoh		Purchase orders (Historical)
248	lphoht		Purchase order history notes
249	lphol		Purchase order lines (Historical)
250	lphot		Purchase order history text li
251	lphrh		Receipts (Historical)
252	lphrht		Receipt history notes
253	lphrl		Receipt lines (Historical)
254	lphrt		Receipt history text lines
255	lseih		Sales invoices
256	lseil		Sales invoice lines
257	lseit		Sales invoice text lines
258	lselif		Link sales to finance
259	lselof		Link sales orders to finance
260	lseoh		Sales orders
261	lseol		Sales order lines
262	lseot		Sales order text lines
263	lshih		Sales invoices (Historical)
264	lshil		Sales invoice lines (Historical)
265	lshit		Invoice history texts
266	lshlif		Link sales to finance
267	lshlof		Link sales orders to finance
268	lshoh		Sales orders (Historical)
269	lshol		Sales order lines (Historical)
270	lshot		Sales order history text lines
271	lsitst	y_lsitst	Stock changes
272	lsrep	y_lsrep	Representatives
273	lsrevs		Revenue statistics
274	mcomp	y_mcomp	Main classifications
275	mdim1	y_mdim1	Dimension 1
276	mdim2	y_mdim2	Dimension 2
277	mdim3	y_mdim3	Dimension 3
278	mdim4	y_mdim4	Dimension 4
279	mdim5	y_mdim5	Dimension 5
280	paycon	y_paycon	Payment conditions
281	payext		Payment extra data
282	payfmt		Payment formats
283	paymen		payments
284	payord		Payment orders
285	payout		Payment outstanding items
286	paysel		Payment runs
287	percls	y_percls	Closed periods
288	perdat	y_perdat	Period date tables
289	pochl		Payment over companies: Headers
290	pocsl		Payment over companies: Details
291	practv		Activities
292	prbudget		Project budgets
293	prcajt	y_prcajt	Cost allocations per journalizing type
294	prcall	y_prcall	Cost allocations
295	prccat	y_prccat	Cost categories
296	prccma	y_prccma	Cost center manager
297	prdeb	y_prdeb	Project debtors
298	prdeh		Project entries (Direct revenue)
299	prdep	y_prdep	Project: Departments
300	prdes		Project entry lines (Direct revenue)
301	prdhrt	y_prdhrt	Debtor hour category rates
302	prdprt	y_prdprt	Debtor position rates
303	prdtrs		Project transactions (Direct)
304	prelpf		Link project to finance
305	premp	y_premp	Project employees
306	premrt	y_premrt	Employee rates per project
307	prghrt	y_prghrt	Project group hour category rates
308	prgprt	y_prgprt	Project group position rates
309	prgrp	y_prgrp	Project groups
310	prhcat	y_prhcat	Hour categories
311	prhcrt	y_prhcrt	Hour category rates per project
312	prheh		Project entries (Hour)
313	prhes		Project entry lines (Hour)
314	prhrat	y_prhrat	Employee-hour category rates
315	prhrpr	y_prhrpr	Employee-hour category rates per project
316	prhtrs		Project transactions (Hour)
317	prieh		Project entries (Item)
318	pries		Project entry lines (Item)
319	prinam		To be invoiced
320	prinfi		Final invoices
321	prinfi_t		Final invoice text
322	pringc	y_pringc	Invoice groups: Cost category
323	pringh	y_pringh	Invoice groups
324	pringl	y_pringl	Invoice group: Lines
325	pringl_t		Invoice group line text
326	prinph		Invoice proposals
327	prinps		Invoice proposal lines
328	prinsh	y_prinsh	Project installments
329	prinss	y_prinss	Project installment lines
330	prinss_t		Installment line text
331	printr		To be invoiced transactions
332	printr_t		Amounts to be invoiced text
333	pritrs		Project transactions (Item)
334	prjamt		Amounts (Journalize/Release)
335	prjtcc	y_prjtcc	Journalizing types per cost category
336	prjtgr	y_prjtgr	Journalizing types per project group
337	prjtyp	y_prjtyp	Journalizing types
338	prloc	y_prloc	Project: Locations
339	prmach	y_prmach	Machinery
340	prmeh		Project entries (Machinery)
341	prmes		Project entry lines (Machinery)
342	prmrat	y_prmrat	Machinery-unit rates
343	prmst	y_prmst	Project master cards
344	prmstdeb	y_prmstdeb	Debtors per project
345	prmtrs		Project transactions (Machinery)
346	prndef	y_prndef	Printer definitions
347	prnfrm	y_prnfrm	Form printers
348	prnusr	y_prnusr	User printers
349	props	y_props	Properties
350	props_t		Properties texts
351	prphdf	y_prphdf	Phase list descriptions
352	prphlp	y_prphlp	Phase list definitions
353	prphse	y_prphse	Phases
354	prphsn	y_prphsn	Phase lists
355	prpmc	y_prpmc	Property choices
356	prpmrt	y_prpmrt	Machinery rates per project
357	prpmst	y_prpmst	Project structures
358	prpmur	y_prpmur	Machinery-unit rates per project
359	prpos	y_prpos	Project positions
360	prpsrt	y_prpsrt	Position rates per project
361	prpurt	y_prpurt	Unit rates per project
362	prpval	y_prpval	Property values
363	prrate		Project rates
364	prrcca		Cost category (Results)
365	prrcyp		Cost category budgets (By period)
366	prreason		Project budget (Change codes)
367	prrhca		Employee forecast
368	prrhyp		Employee budgets (By period)
369	prritm		Item forecast
370	prriyp		Item budgets (By period)
371	prrmch		Machinery forecast
372	prrmyp		Machinery budgets (By period)
373	prrprj		Result project
374	prrpyp		Project budgets (By period)
375	prrtcca		History: Cost category budgets
376	prrtcyp		History: Cost category budgets per period
377	prrthca		History: Employee budgets
378	prrthyp		History: Employee budgets per period
379	prrtitm		History: Machinery budgets
380	prrtiyp		History: Machinery budgets per period
381	prrtmch		History: Item budgets
382	prrtmyp		History: Item budgets per period
383	prrtprj		Result project
384	prrtpyp		Result project per period
385	prrtty	y_prrtty	Project rate priority (Lines)
386	prsccn	y_prsccn	Cost center structures
387	prsdep	y_prsdep	Department structures
388	prstat	y_prstat	Statuses (Project)
389	prsurc	y_prsurc	Surcharge codes
390	prtlpf		Project - Financial (Link transaction)
391	prtrs		Project transactions
392	prtype	y_prtype	Project types
393	prunit	y_prunit	Project units
394	prwiph		Work in progress (Header)
395	prwipl		Work in progress (Lines)
396	prxes		Project entries (External)
397	prxlf		Link to finance
398	prxlp		Link purchase
399	prxlsi		Link sales invoice
400	prxlso		Link sales order
401	prxtrs		Project transactions (External)
402	scencode	y_scencode	Scenario entries
403	scentry	y_scentry	Scenario entry lines
404	stalog		Notes (Extended)
405	stappl		Applications (Menu)
406	stapplog		Application log
407	stbent	y_stbent	Base entities
408	stbic	y_stbic	BIC codes
409	stblev	y_stblev	Base levels
410	stbrlay		Layouts
411	stbrlayf		Layout fields
412	stcumdat		Cumulative data
413	stcumdef		Cumulative definitions
414	stdefchg	y_stdefchg	Defaults and changeability
415	stdefico		Default icons
416	stestrh		Structure entry header
417	stestrl		Structure entry line
418	stetask		Tasks (current)
419	stexca		External categories
420	stexob		Documents
421	stextend		Table extensions
422	stformula		Formulas
423	stgateway		Gateway
424	stgdprdata		GDPR: Data
425	stgdprh		GDPR: Settings
426	stgdprl		GDPR: Settings (Line)
427	stgrp	y_stgrp	User groups
428	stgrpworksp		User groups per workspace
429	sthtask		Tasks (current)
430	stidp		Identity provider
431	stifex		External calls
432	stjobh	y_stjobh	Scheduled jobs
433	stjobl	y_stjobl	Scheduled job (Parameters)
434	stlang		Languages (Application)
435	stlnglay	y_stlnglay	Layouts per language
436	stltrm		Link terms to master data
437	stmnu		menu definition
438	stmnutxt		menutext
439	stnactype	y_stnactype	Address types
440	stpostal		Postal codes
441	stprg	y_stprggrp	programs
442	stprggrp	y_stprggrp	Menu authorization
443	stprocess		Process history
444	strecent		Recent
445	strule	y_strule	Rules
446	struleusr	y_struleusr	Rule users
447	ststrdet		Structure details
448	ststruc	y_ststruc	Structures
449	sttask		Favorites
450	stterm		Translations (User)
451	sttran		Translations (System)
452	sttsklst		Task lists
453	sttstr		Structure transaction
454	sttstrt		Structure transaction notes
455	stuiprop		User interface properties
456	stuser	y_stuser	Users
457	stuserworksp		Users per workspace
458	stusgrp	y_stusgrp	Users per group
459	stusrol		Licenses per user
460	stusrpwd		User passwords
461	stworkspmemb		Workspace members
462	stxlink		XML import definitions
463	stxlnode		XML definition nodes
464	stxsattp		Schema attribute type
465	stxsattr		Schema attribute
466	stxschem		XML schemas
467	stxselem		Schema element
468	stxseltp		Schema element type
469	t_tdef	y_t_tdef	Test type definitions
470	t_tdfd	y_t_tdfd	Test type descriptions
471	t_tdsc	y_t_tdsc	Test fields (Description)
472	t_test	y_t_test	Companies
473	titles	y_titles	Titles
474	units	y_units	Units
475	usrlay		Form layouts
476	vatbox	y_vatbox	VAT return boxes
477	vatbox_amt		VAT return box: Amounts
478	vathis		VAT history
479	vatlnb	y_vatlnb	VAT linked boxes
480	vatlnt		VAT linked total boxes
481	vatrep	y_vatrep	VAT fiscal representatives
482	vattrs	y_vattrs	VAT codes
483	xrates		Exchange rates
484	z_findat		Financial years
485	z_link		Restrictions
486	z_sett	y_z_sett	Settings
487	z_sev		Several data
488	z_uset	y_z_uset	user settings

Main Category:	Attachments & notes	Document Type:	Online help main
Category:		Security level:	All - 0
Sub category:		Document ID:	29.728.511
Assortment:	Exact Financials	Date:	22-09-2020
Release:		Attachment:
Disclaimer

Tags	No tags added

Data dictionary exactcs - 7.29

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

bdeauth02ix

bdeautl - Budget authorization entry (Lines)

Indexes

bdeautl01ix - primary - unique

bdenth - Budget entries

Indexes

bdenth01ix - primary - unique

bdenth02ix