Exact Financials

Data dictionary lphmol - Purchase order matching lines - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_lphmoh	int64	>>>>>>>>>>>9		?	Match number
3	seqnr_lpeoh	int64	>>>>>>>>>>>9		?	Purchase order number
4	linenr_lpeol	integer	>>>9		?	Purchase order line
5	quantity_matched_rec	decimal	->>>,>>>,>>9.999	6	0	Quantity received
6	quantity_matched_inv	decimal	->>>,>>>,>>9.999	6	0	Quantity invoiced
7	line_amount_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line amount matched
8	line_amount_entry	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Entry amount
9	line_vat_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line VAT matched
10	line_discount_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount matched
11	line_discount_vat_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount VAT matched
12	order_costs_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs matched
13	order_costs_vat_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs VAT matched
14	freight_costs_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs matched
15	freight_costs_vat_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs VAT matched
16	invoice_discount_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount matched
17	inv_discount_vat_matched	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount VAT matched
18	euserid_cr	character	X(12)			User creation
19	date_cr	date	99/99/9999			Date creation
20	time_cr	integer	>>>>>9		?	Time creation
21	source_cr	character	x(12)			Source creation
22	euserid_lc	character	X(12)			User last changed
23	date_lc	date	99/99/9999			Date last changed
24	time_lc	integer	>>>>>9		?	Time last changed
25	source_lc	character	x(12)			Source last changed

Indexes

lphmolix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_lphmoh	int64	>>>>>>>>>>>9	Match number
3	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number
4	linenr_lpeol	integer	>>>9	Purchase order line

lphmol2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	euserid_cr	character	X(12)	User creation
3	seqnr_lphmoh	int64	>>>>>>>>>>>9	Match number
4	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number
5	linenr_lpeol	integer	>>>9	Purchase order line

lphmol3ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	date_cr	date	99/99/9999	Date creation
3	time_cr	integer	>>>>>9	Time creation
4	seqnr_lphmoh	int64	>>>>>>>>>>>9	Match number
5	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number
6	linenr_lpeol	integer	>>>9	Purchase order line

Contents > lphmol

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

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