Exact Financials

Data dictionary debtrs - debtor transactions - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_debtrs	int64	>>>>>>>>>9		?	Sequence number
3	fin_yr	integer	9999		0	Financial year
4	debtor	int64	>>>>>>>>>9		0	Debtor
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.99999	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_type	integer	>>>>>9		1	Invoice matching type
25	match_inv	int64	>>>>>>>>>>>9		0	Invoice number matching
26	match_trs	logical	yes/no		no	Match transaction
27	rev_entry	logical	yes/no		no	Reversal entry
28	seqnr_ledtrs	int64	>>>>>>>>>9		0	Sequence number
29	pay_condition	character	X(4)			Payment condition
30	mcode1	character	x(12)			Mdim 1
31	mcode2	character	x(12)			Mdim 2
32	mcode3	character	x(12)			Mdim 3
33	mcode4	character	x(12)			Mdim 4
34	mcode5	character	x(12)			Mdim 5
35	source_lc	character	x(12)
36	time_lc	integer	->,>>>,>>9		?
37	date_lc	date	99/99/9999
38	euserid_lc	character	X(12)
39	type_lc	character	x(8)
40	seqnr_atrsh	integer	>>>>>>9		0	Sequence number
41	linenr_atrss	integer	>>>>>9		0	Line
42	bank_acc_nr	character	x(34)			Bank account
43	curr_code_bank_acc_nr	character	x(3)			Currency
44	mandate_ref	character	X(35)			Mandate reference

Indexes

debtrs01ix - primary - unique

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

debtrs02ix

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

debtrs03ix

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

debtrs04ix

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

debtrs05ix

#	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

debtrs06ix

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

Contents > debtrs

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.245
Assortment:	Exact Financials	Date:	27-01-2016
Release:		Attachment:
Disclaimer

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