Exact Financials

Data dictionary exactcs - 7.23

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

Tags	No tags added

Data dictionary exactcs - 7.23

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)