Exact Financials

Data dictionary lpeih - Purchase invoice headers - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	entry_number	int64	>>>>>>>>>>>9		?	Purchase invoice number
3	invoice_status	integer	>>>>>9		0	Status
4	creditor	int64	>>>>>>>>>9		0	Creditor
5	external_entry_number	character	X(30)			External invoice number
6	invoice_code	integer	>>9		0	Invoice code
7	description	character	X(60)			Description
8	invoice_date	date	99/99/9999			Invoice date
9	invoice_owner	character	X(12)		0	Invoice owner
10	sel_code	character	X(2)			Selection code
11	curr_code	character	X(3)			Currency
12	exch_rate	decimal	>>,>>9.999999	6	0	Exchange rate
13	pay_condition	character	X(4)			Payment condition
14	pay_reference	character	X(32)			Payment reference
15	pay_method	integer	>>>>>9		1	Payment method
16	due_date	date	99/99/9999			Due date
17	week	integer	>9		0	Week
18	percentage_1	decimal	->>9.99	4	0	Percentage
19	due_date_1	date	99/99/9999			Due date
20	amount_1	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
21	percentage_2	decimal	->>9.99	4	0	Percentage
22	due_date_2	date	99/99/9999			Due date
23	amount_2	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
24	percentage_3	decimal	->>9.99	4	0	Percentage
25	due_date_3	date	99/99/9999			Due date
26	amount_3	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
27	percentage_4	decimal	->>9.99	4	0	Percentage
28	due_date_4	date	99/99/9999			Due date
29	amount_4	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
30	percentage_5	decimal	->>9.99	4	0	Percentage
31	due_date_5	date	99/99/9999			Due date
32	amount_5	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount
33	invoice_discount_perc	decimal	->>9.99	4	0	Invoice discount
34	order_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
35	vat_code_order_costs	character	X(3)			VAT code
36	order_costs_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
37	freight_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
38	vat_code_freight_costs	character	X(3)			VAT code
39	freight_costs_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
40	line_amt_ex_vat_ex_ldisc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line amount
41	line_discount_amt_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount amount
42	invoice_discount_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Invoice discount
43	line_vat_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT line amount
44	order_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT order costs
45	freight_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT freight costs
46	invoice_discount_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT invoice discount
47	payment_difference	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Payment difference
48	amt_inc_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Purchase invoice amount
49	userid_approve	character	X(12)			Approved by
50	origin	integer	>>>>>9		0	Origin
51	euserid_cr	character	X(12)			User creation
52	date_cr	date	99/99/9999			Date creation
53	time_cr	integer	>>>>>9		?	Time creation
54	source_cr	character	x(12)			Source creation
55	euserid_lc	character	X(12)			User last changed
56	date_lc	date	99/99/9999			Date last changed
57	time_lc	integer	>>>>>9		?	Time last changed
58	source_lc	character	x(12)			Source last changed
59	original_entry_number	int64	>>>>>>>>>>>9		0	Original purchase invoice
60	nr_periods_allocation	integer	>>9		0	Number of periods
61	start_year_allocation	integer	9999		0	Start year period allocation
62	start_period_allocation	integer	>>9		0	Start period period allocation
63	amount_inc_vat_inc_disc_bl	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount blocked account
64	external_sales_order_nr	character	x(12)			External sales order number
65	buyer_code	character	X(12)		0	Buyer
66	reference_1	character	X(60)			Reference
67	reference_2	character	X(60)			Reference
68	reference_3	character	X(60)			Reference
69	delivery_date	date	99/99/9999			Required delivery date
70	delivery_method	character	x(12)			Delivery method
71	delivery_address	character	x(12)			Delivery address
72	cost_code	character	x(12)			Cost code
73	bank_acc_nr	character	x(34)			Bank account
74	curr_code_bank_acc_nr	character	x(3)			Currency

Indexes

lpeihix - primary - unique

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

lpeih2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	invoice_status	integer	>>>>>9	Status
3	entry_number	int64	>>>>>>>>>>>9	Purchase invoice number

lpeih3ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	creditor	int64	>>>>>>>>>9	Creditor
3	external_entry_number	character	X(30)	External invoice number

lpeih4ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	original_entry_number	int64	>>>>>>>>>>>9	Original purchase invoice
3	entry_number	int64	>>>>>>>>>>>9	Purchase invoice number

Contents > lpeih

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

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