One moment please...

Exact Financials

Data dictionary lphmio - Matching purchase invoice/orde - 7.20

#	Field name	Data type	Format	Dec	Extent	Default	Label
1	adm_nr	integer	>>>>>9			?	Company
2	entry_number	int64	>>>>>>>>>>>9			?	Purchase invoice number
3	linenr_lpeil	integer	>>>9			?	Purchase invoice line
4	seqnr_lpeoh	int64	>>>>>>>>>>>9			?	Purchase order number
5	linenr_lpeol	integer	>>>9			?	Purchase order line
6	quantity_matched	decimal	->>>,>>>,>>9.999	6		0	Quantity matched
7	amount_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4		0	Amount matched
8	curr_code	character	X(3)				Currency
9	amount_matched_dc	decimal	->>>,>>>,>>>,>>>,>>9.99	4		0	Amount matched
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

lphmioix - primary - unique

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

lphmio2ix

#	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	entry_number	int64	>>>>>>>>>>>9	Purchase invoice number
5	linenr_lpeil	integer	>>>9	Purchase invoice line

Contents > lphmio

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

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