Exact Financials

Data dictionary y_vattrs - VAT codes - 7.20

#	Field name	Data type	Format	Dec	Extent	Default	Label
1	seqnr_log	integer	>,>>>,>>9			?	Sequence number
2	adm_nr	integer	>>>>>9			?	Company
3	vat_code	character	x(3)			0	VAT code
4	descr	character	X(60)				Description
5	code_ps	integer	>>>>>9			0	Purchase/Sales
6	vat_transfer	logical	yes/no			no	VAT charged
7	vat_perc	decimal	->>9.99	2		0	VAT percentage
8	vat_descr	character	x(16)				Description VAT percentage
9	exclus	integer	>>>>>9			0	Excluding/Including
10	country	character	x(3)				Country EC sales list
11	vat_listing	integer	>>>>>9			0	EC Sales List
12	acc_nr	character	x(12)				Account VAT to claim
13	acc_nr_vat_sales	character	x(12)				Account VAT to pay
14	acc_nr_contra	character	x(12)				Offset account
15	credit_note	logical	yes/no			no	Credit note
16	cred_vat_code	character	x(3)				VAT code credit notes
17	vat_appro	logical	yes/no			yes	VAT applicable
18	descr_ml	character	X(60)		5		ML description
19	source_lc	character	x(12)
20	time_lc	integer	->,>>>,>>9			?
21	date_lc	date	99/99/9999
22	euserid_lc	character	X(12)
23	type_lc	character	x(8)
24	vat_perc_comp	decimal	>>9.99	2		0	Compensation percentage
25	vat_perc_non_deduct	decimal	>>9.99	2		0	Non deductible
26	acc_nr_comp	character	x(12)				Compensation g/l account
27	vat_perc_claim	decimal	>>9.99	2		0	Percentage VAT to claim
28	entity_state	integer	>>>>>9			0	State
29	term_id	integer	>>>>>>>9			0	Term ID

#	Field name	Data type	Format	Description
1	seqnr_log	integer	>,>>>,>>9	Sequence number

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	vat_code	character	x(3)	VAT code
3	seqnr_log	integer	>,>>>,>>9	Sequence number

Contents > y_vattrs

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