Exact Financials

Data dictionary ledtrs - general ledger transactions - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_ledtrs	int64	>>>>>>>>>9		?	Sequence number
3	fin_yr	integer	9999		0	Financial year
4	fin_yr2	integer	9999		0	Second financial year field
5	acc_nr	character	x(12)			Account
6	date	date	99/99/9999			Date
7	period	integer	>>9		0	Period
8	entry_nr_type	integer	>>>>>9		1	Entry type
9	entry_nr	int64	>>>>>>>>>>>9		0	Entry number
10	journal_nr	integer	>>9		0	Journal
11	descr	character	X(60)			Description
12	amt_def_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount DC
13	vat_code	character	x(3)		0	VAT code
14	vat_amt_3	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT amount
15	vat_basis	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT basis amount
16	acc_nr_contra	character	x(12)			Offset account
17	debtor	int64	>>>>>>>>>9		0	Debtor
18	creditor	int64	>>>>>>>>>9		0	Creditor
19	cost_center	character	x(12)			Cost center
20	cost_unit	character	x(12)			Cost unit
21	qty	decimal	->>>>>>>>>9.99	4	0	Quantity
22	curr_code	character	x(3)			Currency
23	curr_code_extra	character	x(3)			Extra currency
24	exch_rate	decimal	>>>>9.999999	6	1	Exchange rate
25	exch_rate_2	decimal	>>>>9.999999	6	1	Exchange rate
26	exch_rate3	decimal	>>>>9.999999	6	1	Exchange rate outstanding items
27	amt_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount FC
28	posting_nr_journal	integer	>>>>>>>>>9		0	Unique posting number journal
29	check_number	integer	->>>>>>>>>9		0	Unique check number
30	closing_transac	logical	yes/no		no	Transactions closed in this posting
31	revalue_transact	logical	yes/no		no	Revaluation transaction
32	seqnr_boe	int64	>>>>>>>>>9		0	Internal document number
33	posting_nr	int64	>>>>>>>>>9		0	Unique posting number
34	seqnr_atrsh	integer	>>>>>>9		0	Sequence number
35	linenr_atrss	integer	>>>>>9		0	Line
36	line_code	integer	999		0	Code generated lines
37	rev_entry	logical	yes/no		no	Reversal entry
38	entry_nr_sub_type	integer	>>>>>9		1	Entry number subtype
39	entry_nr_sub	int64	>>>>>>>>>>>9		0	Entry number
40	check_number_2	integer	->>>>>>>>>9		0	Check number
41	pay_condition	character	X(4)			Payment condition
42	transit_trs	logical	yes/no		no	Transitory transactions
43	vat_perc	decimal	->>9.99	2	0	VAT percentage
44	vat_failed	logical	yes/no		no	VAT failed
45	origin	integer	>>>>>9		0	Package of origin of transaction
46	seqnr_debtrs	int64	>>>>>>>>>9		0	Sequence number
47	seqnr_crdtrs	int64	>>>>>>>>>9		0	Sequence number
48	seqnr_vathis	int64	>>>>>>>>>9		0	Sequence number
49	seqnr_ledtrs_2	int64	>>>>>>>>>9		0	Second GBKMUT sequence number
50	mcode1	character	x(12)			Mdim 1
51	mcode2	character	x(12)			Mdim 2
52	mcode3	character	x(12)			Mdim 3
53	mcode4	character	x(12)			Mdim 4
54	mcode5	character	x(12)			Mdim 5
55	source_lc	character	x(12)
56	time_lc	integer	->,>>>,>>9		?
57	date_lc	date	99/99/9999
58	euserid_lc	character	X(12)
59	type_lc	character	x(8)
60	acc_nr_type	integer	>>>>>9		0	Type of purchase vat return
61	delacq_code	integer	>>>>>9		0	Delivery or acquisition
62	banksubtyp	integer	>>>>>9		0	Type of bank entry
63	recon_stat	integer	>>>>>9		0	Reconciliation status
64	date_rec	date	99/99/9999			Date of reconciliation
65	amt_rec	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Reconciliation amount
66	rec_curr_code	character	X(3)			Reconciliation currency
67	vat_basis_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT basis amount FC
68	ext_entry_nr	character	X(10)			External entry number

Indexes

ledtrs01ix - primary - unique

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

ledtrs02ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	acc_nr	character	x(12)	Account
4	date	date	99/99/9999	Date

ledtrs03ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	acc_nr	character	x(12)	Account
4	period	integer	>>9	Period
5	date	date	99/99/9999	Date

ledtrs04ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	journal_nr	integer	>>9	Journal
4	entry_nr	int64	>>>>>>>>>>>9	Entry number
5	acc_nr	character	x(12)	Account

ledtrs05ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	cost_center	character	x(12)	Cost center
4	acc_nr	character	x(12)	Account
5	period	integer	>>9	Period

ledtrs06ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	cost_unit	character	x(12)	Cost unit
4	acc_nr	character	x(12)	Account
5	period	integer	>>9	Period

ledtrs07ix

#	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
5	line_code	integer	999	Code generated lines
6	fin_yr	integer	9999	Financial year
7	seqnr_ledtrs	int64	>>>>>>>>>9	Sequence number

ledtrs08ix

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

Contents > ledtrs

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

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