One moment please...

Exact Financials

Data dictionary lpemro - Matching receipts/purchase ord - 7.20

#	Field name	Data type	Format	Dec	Extent	Default	Label
1	adm_nr	integer	>>>>>9			?	Company
2	seqnr_lperh	int64	>>>>>>>>>>>9			?	Receipt number
3	linenr_lperl	integer	>>>9			?	Receipt line
4	seqnr_lpeoh	int64	>>>>>>>>>>>9			?	Purchase order number
5	linenr_lpeol	integer	>>>9			?	Purchase order line
6	quantity_to_match	decimal	->>>,>>>,>>9.999	6		0	Quantity to match
7	amount_to_match	decimal	->>>,>>>,>>>,>>>,>>9.99	4		0	Amount to match
8	curr_code	character	X(3)				Currency
9	amount_to_match_dc	decimal	->>>,>>>,>>>,>>>,>>9.99	4		0	Amount to match
10	euserid_cr	character	X(12)				User creation
11	date_cr	date	99/99/9999				Date creation
12	time_cr	integer	>>>>>9			?	Time creation
13	source_cr	character	x(12)				Source creation
14	euserid_lc	character	X(12)				User last changed
15	date_lc	date	99/99/9999				Date last changed
16	time_lc	integer	>>>>>9			?	Time last changed
17	source_lc	character	x(12)				Source last changed

Indexes

lpemroix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_lperh	int64	>>>>>>>>>>>9	Receipt number
3	linenr_lperl	integer	>>>9	Receipt line
4	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number
5	linenr_lpeol	integer	>>>9	Purchase order line

lpemro2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number
3	linenr_lpeol	integer	>>>9	Purchase order line
4	seqnr_lperh	int64	>>>>>>>>>>>9	Receipt number
5	linenr_lperl	integer	>>>9	Receipt line

Contents > lpemro

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

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