Exact Financials

Data dictionary invhsl - Invoice history lines - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	XXXbase_adm_nr	integer	>>>>>9		0	XXXBase company
3	invoice_nr	int64	>>>>>>>>>>>9		?	Invoice number
4	seqnr_invhhl	integer	>>>>>>>9		?	Sequence number
5	linenr_lsisl	integer	>>>9		?	Invoice line
6	item_code	character	X(20)			Item
7	discount_calculation	integer	>>>>>9		0	Discount calculation
8	descr	character	X(60)			Description
9	XXXdeliv_week	integer	>9		0	XXXDelivery week
10	delivery_date	date	99/99/9999			Delivery date
11	quantity	decimal	->>>,>>>,>>9.999	6	0	Quantity
12	XXXunit_code	character	X(8)			XXXUnit
13	seqnr_lsohl	int64	>>>>>>>>>>>9		0	Order number
14	linenr_horitm	integer	>>>9		0	Order line
15	vat_code	character	X(3)			VAT code
16	pricelist_code	character	X(3)			Price list
17	price	decimal	->>>,>>>,>>9.999	6	0	Price
18	line_discount	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount
19	discount_type	integer	>>>>>9		0	Discount type
20	line_disc_amt_ex_vat	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Line discount
21	price_ex_vat_inc_disc	decimal	->>>,>>>,>>9.999	4	0	Net price
22	XXXapp	decimal	>>>,>>>,>>9.999	9	0.0	XXXAverage purchase price
23	scp	decimal	->>>,>>>,>>9.999	6	0	Standard cost price
24	cost_unit	character	x(12)			Cost unit
25	cost_center	character	x(12)			Cost center
26	price_surcharge	decimal	->>>,>>>,>>9.999	6	0	Surcharge
27	XXXhas_width	decimal	>>>,>>>,>>9.999	9	0.0	XXXWidth
28	XXXhas_height	decimal	>>>,>>>,>>9.999	9	0.0	XXXHeight
29	XXXdimension	integer	>>9		0	XXXDimension
30	XXXprice_agr_his_nr	integer	>>>>>>>>9		0	XXXPrice agreement history number
31	XXXexplos_item_type	integer	>>>>>>>>>9		20501	XXXExplosion item type
32	XXXstatistnr	decimal	>>>>>>>>9	9	0.0	XXXStatistics number
33	XXXline_main_item	integer	>>>9		1	XXXLine number main item
34	amt_ex_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Net line amount
35	euserid_cr	character	X(12)			User creation
36	date_cr	date	99/99/9999			Date creation
37	time_cr	integer	>>>>>9		?	Time creation
38	source_cr	character	X(12)			Source creation
39	euserid_lc	character	X(12)			User last changed
40	date_lc	date	99/99/9999			Date last changed
41	time_lc	integer	>>>>>9		?	Time last changed
42	source_lc	character	X(12)			Source last changed
43	XXXdebtor	integer	>>>>>>>9		0	XXXDebtor
44	XXXcase_number	character	X(15)			XXXCase number
45	XXXconsultant	character	X(8)			XXXConsultant
46	XXXapproval_nr	character	X(15)			XXXApproval number
47	XXXdate_of_birth	date	99/99/9999			XXXDate of birth
48	XXXintra_nr	integer	>>>>>>>>9		0	XXXINTRASTAT number
49	XXXsu_quantity	decimal	>>>,>>>,>>9.999	9	0.0	XXXSlave unit quantity
50	XXXqty_pieces	decimal	>>>,>>>,>>9.999	9	0.0	XXXQuantity in pieces
51	XXXgross_weight	decimal	>>>,>>>,>>9.999	9	0.0	XXXGross weight
52	XXXnet_weight	decimal	>>>,>>>,>>9.999	9	0.0	XXXNet weight
53	XXXslave_unit	character	X(8)			XXXSlave unit
54	line_vat_amt_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT amount
55	price_ex_vat_ex_disc	decimal	->>>,>>>,>>9.999	4	0	Price
56	amt_ex_vat_ex_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Gross line amount
57	XXXamt_inc_vat_exc_disc	decimal	->>>,>>>,>>9.99	9	0.0	XXXAmount incl VAT excl Discount
58	amt_inc_vat_inc_disc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Net line amount inc VAT
59	XXXinv_disc_line_amt	decimal	->>>,>>>,>>9.99	9	0.0	XXXInvoice discount line amount
60	mdim_code_1	character	x(12)			Mdim 1
61	mdim_code_2	character	x(12)			Mdim 2
62	mdim_code_3	character	x(12)			Mdim 3
63	mdim_code_4	character	x(12)			Mdim 4
64	mdim_code_5	character	x(12)			Mdim 5

Indexes

invhsl - 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
4	linenr_lsisl	integer	>>>9	Invoice line

invhsl2ix

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

Contents > invhsl

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

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