Exact Financials

Data dictionary lpeoh - Purchase order headers - 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	order_status	integer	>>>>>9		0	Status
4	creditor	int64	>>>>>>>>>9		0	Creditor
5	sel_code	character	X(2)			Selection code
6	external_sales_order_nr	character	x(12)			External sales order number
7	buyer_code	character	X(12)		0	Buyer
8	curr_code	character	X(3)			Currency
9	exch_rate	decimal	>>,>>9.999999	6	0	Exchange rate
10	pay_condition	character	X(4)			Payment condition
11	pay_method	integer	>>>>>9		1	Payment method
12	reference	character	X(60)			Reference
13	reference_1	character	X(60)			Reference
14	reference_2	character	X(60)			Reference
15	reference_3	character	X(60)			Reference
16	exdescr_code	character	X(2)			Extra description code
17	text_code	character	x(12)			Text code
18	order_date	date	99/99/9999			Purchase order date
19	order_method	character	x(12)			Purchase order method
20	order_address	character	x(12)			Purchase order address
21	delivery_date	date	99/99/9999			Required delivery date
22	delivery_method	character	x(12)			Delivery method
23	delivery_address	character	x(12)			Delivery address
24	line_amt_ex_vat_ex_ldisc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line amount
25	line_discount_amt_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount amount
26	cost_code	character	x(12)			Cost code
27	order_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
28	vat_code_order_costs	character	X(3)			VAT code
29	order_costs_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
30	freight_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
31	vat_code_freight_costs	character	X(3)			VAT code
32	freight_costs_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
33	invoice_discount_perc	decimal	->>9.99	4	0	Invoice discount
34	invoice_discount_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount
35	line_vat_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT line amount
36	order_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT order costs
37	freight_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT freight costs
38	invoice_discount_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT invoice discount
39	amt_inc_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Purchase order amount
40	userid_approve	character	X(12)			Approved by
41	origin	integer	>>>>>9		0	Origin
42	euserid_cr	character	X(12)			User creation
43	date_cr	date	99/99/9999			Date creation
44	time_cr	integer	>>>>>9		?	Time creation
45	source_cr	character	x(12)			Source creation
46	euserid_lc	character	X(12)			User last changed
47	date_lc	date	99/99/9999			Date last changed
48	time_lc	integer	>>>>>9		?	Time last changed
49	source_lc	character	x(12)			Source last changed
50	bank_acc_nr	character	x(34)			Bank account
51	curr_code_bank_acc_nr	character	x(3)			Currency

Indexes

lpeohix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number

lpeoh2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	order_status	integer	>>>>>9	Status
3	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number

lpeoh3ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Creditor
3	seqnr_lpeoh	int64	>>>>>>>>>>>9	Purchase order number

Contents > lpeoh

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

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