Exact Financials

Data dictionary crdtrs - creditor transactions - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_crdtrs	int64	>>>>>>>>>9		?	Sequence number
3	fin_yr	integer	9999		0	Financial year
4	creditor	int64	>>>>>>>>>9		0	Supplier
5	date	date	99/99/9999			Date
6	period	integer	>>9		0	Period
7	entry_nr_type	integer	>>>>>9		1	Entry type
8	entry_nr	int64	>>>>>>>>>>>9		0	Entry number
9	journal_nr	integer	>>9		0	Journal
10	descr	character	X(60)			Description
11	amt_def_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount DC
12	curr_code	character	x(3)			Currency
13	curr_code_extra	character	x(3)			Extra currency
14	exch_rate	decimal	>>>>9.999999	6	1	Exchange rate
15	exch_rate_2	decimal	>>>>9.999999	6	1	Exchange rate
16	exch_rate3	decimal	>>>>9.999999	6	1	Exchange rate outstanding items
17	amt_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount FC
18	entry_nr_fin	int64	>>>>>>>>>>>9		0	Entry number FA
19	posting_nr_journal	integer	->>>>>>>>>9		0	Unique posting number journal
20	posting_nr	int64	>>>>>>>>>9		0	Unique posting number
21	check_number	integer	->>>>>>>>>9		0	Unique check number
22	closing_transac	logical	yes/no		no	Transaction after closing
23	revalue_transact	logical	yes/no		no	Revaluation transaction
24	match_inv	int64	>>>>>>>>>>>9		0	Invoice number matching
25	match_trs	logical	yes/no		no	Match transaction
26	rev_entry	logical	yes/no		no	Reversal entry
27	seqnr_ledtrs	int64	>>>>>>>>>9		0	Sequence number
28	pay_condition	character	X(4)			Payment condition
29	mcode1	character	x(12)			Mdim 1
30	mcode2	character	x(12)			Mdim 2
31	mcode3	character	x(12)			Mdim 3
32	mcode4	character	x(12)			Mdim 4
33	mcode5	character	x(12)			Mdim 5
34	match_inv_type	integer	>>>>>9		1	Invoice matching type
35	time_lc	integer	->,>>>,>>9		?
36	date_lc	date	99/99/9999
37	euserid_lc	character	X(12)
38	type_lc	character	x(8)
39	source_lc	character	x(12)
40	ext_entry_nr	character	X(30)			External entry number
41	seqnr_atrsh	integer	>>>>>>9		0	Sequence number
42	linenr_atrss	integer	>>>>>9		0	Line
43	bank_acc_nr	character	x(34)			Bank account
44	curr_code_bank_acc_nr	character	x(3)			Currency

Indexes

crdtrs01ix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_crdtrs	int64	>>>>>>>>>9	Sequence number

crdtrs02ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	creditor	int64	>>>>>>>>>9	Supplier
4	date	date	99/99/9999	Date

crdtrs03ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	creditor	int64	>>>>>>>>>9	Supplier
4	entry_nr_type	integer	>>>>>9	Entry type
5	entry_nr	int64	>>>>>>>>>>>9	Entry number
6	period	integer	>>9	Period

crdtrs04ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	creditor	int64	>>>>>>>>>9	Supplier
4	period	integer	>>9	Period
5	date	date	99/99/9999	Date

crdtrs05ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	posting_nr	int64	>>>>>>>>>9	Unique posting number
3	seqnr_atrsh	integer	>>>>>>9	Sequence number
4	linenr_atrss	integer	>>>>>9	Line

crdtrs06ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Supplier
3	ext_entry_nr	character	X(30)	External entry number

crdtrs07ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Supplier
3	entry_nr	int64	>>>>>>>>>>>9	Entry number
4	entry_nr_type	integer	>>>>>9	Entry type

Contents > crdtrs

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	26.936.229
Assortment:	Exact Financials	Date:	27-01-2016
Release:		Attachment:
Disclaimer

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