Exact Financials

Data dictionary invhhl - Invoice history

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		0	Company
2	XXXbase_adm_nr	integer	>>>>>9		0	XXXBase company
3	invoice_nr	int64	>>>>>>>>>>>9		0	Invoice number
4	seqnr_invhhl	integer	>>>>>>>9		0	Sequence number
5	invoice_date	date	99/99/9999			Invoice date
6	debtor	int64	>>>>>>>>>9		0	Debtor
7	invoice_debtor	int64	>>>>>>>>>9		0	Invoice debtor
8	XXXend_user_debtor	int64	>>>>>>>>>9		0	XXXEnd-user debtor
9	reference	character	X(60)			Reference
10	reference_1	character	X(60)			Reference
11	reference_2	character	X(60)			Reference
12	reference_3	character	X(60)			Reference
13	order_date	date	99/99/9999			Order date
14	delivery_date	date	99/99/9999			Delivery date
15	exdescr_code	character	X(2)			Extra description code
16	representative	character	X(12)		0	Representative
17	sel_code	character	X(2)			Selection code
18	curr_code	character	X(3)			Currency
19	exch_rate	decimal	>>,>>9.999999	6	0	Exchange rate
20	pay_condition	character	X(4)			Payment condition
21	delivery_method	character	X(8)			Delivery method
22	cost_code	character	X(8)			Cost code
23	freight_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
24	order_costs	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
25	vat_code_freight_costs	character	X(3)			VAT code
26	vat_code_order_costs	character	X(3)			VAT code
27	XXXcost_center	character	X(8)			XXXCost center
28	XXXcost_unit	character	X(8)			XXXCost unit
29	invoice_discount_perc	decimal	->>9.99	4	0	Order discount
30	line_amt_ex_vat_inc_ldisc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line amount
31	fin_yr	integer	9999		0	Year of entry
32	amt_inc_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order amount
33	invoice_discount_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order discount
34	userid_approve	character	X(12)			Approved by
35	invoice_type	integer	>>>>>9		0	Invoice type
36	XXXiso_langcode	character	X(2)			XXXISO Language
37	original_invoice_nr	int64	>>>>>>>>>>>9		0	Original invoice number
38	delivery_address	character	X(8)			Delivery address
39	delivery_debtor	int64	>>>>>>>>>9		0	Delivery debtor
40	XXXdeliv_week	integer	>9		0	XXXDelivery week
41	XXXroute_code	character	X(2)			XXXRoute
42	XXXgroup_invoice_nr	integer	>>>>>>>>9		0	XXXGroup invoice number
43	euserid_cr	character	X(12)			User creation
44	date_cr	date	99/99/9999			Date creation
45	time_cr	integer	>>>>>9		0	Time creation
46	source_cr	character	X(12)			Source creation
47	euserid_lc	character	X(12)			User last changed
48	date_lc	date	99/99/9999			Date last changed
49	time_lc	integer	>>>>>9		0	Time last changed
50	source_lc	character	X(12)			Source last changed
51	XXXrecognition_code	character	X(2)			XXXRecognition code
52	XXXbatch_number	character	X(15)			XXXBatch number
53	XXXdescr	character	X(80)			XXXDescription
54	XXXexplos_calc_method	integer	>>>>>>>>>9		30201	XXXExplosion calculation method
55	XXXflow_num	decimal	>>>>>>>>>>>>9	9	0.0	XXXFlow number
56	seqnr_lsohl	int64	>>>>>>>>>>>9		0	Order number
57	text_code	character	X(8)			Text code
58	pay_method	integer	>>>>>9		1	Payment method
59	period	integer	>>9		0	Period of entry
60	order_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT order costs
61	freight_costs_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT freight costs
62	o_costs_ex_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Order costs
63	f_costs_ex_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Freight costs
64	nr_periods_allocation	integer	>>9		0	Number of periods
65	start_year_allocation	integer	9999		0	Start year period allocation
66	start_period_allocation	integer	>>9		0	Start period period allocation
67	invoice_code	integer	>>9		0	Invoice code
68	bank_acc_nr	character	x(34)			Bank account
69	curr_code_bank_acc_nr	character	x(3)			Currency
70	collection_code	character	X(8)			Collection code
71	mandate_ref	character	X(35)			Mandate reference

Indexes

invhhl - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
3	seqnr_invhhl	integer	>>>>>>>9	Sequence number

invhhl1

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	representative	character	X(12)	Representative
3	invoice_debtor	int64	>>>>>>>>>9	Invoice debtor
4	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
5	seqnr_invhhl	integer	>>>>>>>9	Sequence number

invhhl2

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	invoice_debtor	int64	>>>>>>>>>9	Invoice debtor
3	invoice_date	date	99/99/9999	Invoice date
4	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
5	seqnr_invhhl	integer	>>>>>>>9	Sequence number

invhhl3

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	invoice_date	date	99/99/9999	Invoice date
3	invoice_debtor	int64	>>>>>>>>>9	Invoice debtor
4	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
5	seqnr_invhhl	integer	>>>>>>>9	Sequence number

invhhl4

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	representative	character	X(12)	Representative
3	invoice_date	date	99/99/9999	Invoice date
4	invoice_debtor	int64	>>>>>>>>>9	Invoice debtor
5	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
6	seqnr_invhhl	integer	>>>>>>>9	Sequence number

invhhl5ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_lsohl	int64	>>>>>>>>>>>9	Order number
3	invoice_nr	int64	>>>>>>>>>>>9	Invoice number
4	seqnr_invhhl	integer	>>>>>>>9	Sequence number

Contents > invhhl

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:	25.809.311
Assortment:	Exact Financials	Date:	30-04-2014
Release:		Attachment:
Disclaimer

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