Exact Financials

Data dictionary lphcl - Purchase order counter history - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_lpeoh	int64	>>>>>>>>>>>9		?	Purchase order number
3	linenr_lpeol	integer	>>>9		?	Purchase order line
4	quantity_rec	decimal	->>>,>>>,>>9.999	6	0	Quantity received
5	quantity_inv	decimal	->>>,>>>,>>9.999	6	0	Quantity invoiced
6	line_amount_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line amount invoiced
7	line_vat_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line VAT invoiced
8	line_discount_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount invoiced
9	line_discount_vat_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount VAT invoiced
10	order_costs_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs invoiced
11	order_costs_vat_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs VAT invoiced
12	freight_costs_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs invoiced
13	freight_costs_vat_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs VAT invoiced
14	invoice_discount_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount invoiced
15	invoice_discount_vat_inv	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount VAT invoiced
16	quantity_matched	decimal	->>>,>>>,>>9.999	6	0	Quantity matched
17	euserid_cr	character	X(12)			User creation
18	date_cr	date	99/99/9999			Date creation
19	time_cr	integer	>>>>>9		?	Time creation
20	source_cr	character	x(12)			Source creation
21	euserid_lc	character	X(12)			User last changed
22	date_lc	date	99/99/9999			Date last changed
23	time_lc	integer	>>>>>9		?	Time last changed
24	source_lc	character	x(12)			Source last changed

#	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

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