Exact Financials

Data dictionary vathis - VAT history - 7.20

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	seqnr_vathis	int64	>>>>>>>>>9		?	Sequence number
3	fin_yr	integer	9999		0	Financial year
4	code_ps	integer	>>>>>9		0	Purchase/Sales
5	vat_nr	character	x(20)			VAT number
6	invoice_nr	int64	>>>>>>>>>>>9		0	Invoice number
7	date	date	99/99/9999			Date
8	vat_code	character	x(3)		0	VAT transaction
9	vat_perc	decimal	->>9.99	2	0	VAT percentage
10	vat_transfer	logical	yes/no		no	VAT charged
11	exclus_yn	integer	>>>>>9		0	Excluding
12	country	character	x(3)			Country
13	country_iso	character	x(2)			ISO country
14	vat_listing	integer	>>>>>9		0	VAT listing
15	period	integer	>>9		0	Period
16	amt_def_cur_excl	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount excluding
17	amt_cur_excl	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Currency amount excluding
18	curr_code	character	x(3)			Currency
19	vat_amt	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT amount
20	vat_amt_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT currency amount
21	xxxrep_nr	character	x(6)			Reporting number
22	debtor	int64	>>>>>>>>>9		0	Debtor
23	creditor	int64	>>>>>>>>>9		0	Creditor
24	vat_amt_extra	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Extra VAT amount
25	vat_amt_cur_extra	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Extra VAT currency amount
26	rep_list	character	x(6)			Report number listing
27	auto_entry	logical	yes/no		yes	Automatically entered
28	acc_nr_type	integer	>>>>>9		0	Type of purchase VAT return
29	decl_year	integer	9999		0	Correction year of return
30	cor_period	integer	>>9		0	Correction quarter of return
31	seqnr_ledtrs	int64	>>>>>>>>>9		0	Sequence number
32	corr_transact	logical	yes/no		yes	Correction transaction quarterly return
33	vat_non_deduct	logical	yes/no		no	Non-deductible VAT N/Y
34	vat_non_deduct_def_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount non-deductible VAT in DC
35	vat_non_deduct_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Amount non-deductible VAT in currency
36	source_lc	character	x(12)
37	time_lc	integer	->,>>>,>>9		?
38	date_lc	date	99/99/9999
39	euserid_lc	character	X(12)
40	type_lc	character	x(8)
41	vat_basis	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT basis amount
42	vat_basis_cur	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	VAT basis amount FC
43	vat_compensation	logical	TRUE/FALSE		FALSE	VAT compensation
44	vat_amt_comp_dc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Compensation amount
45	vat_amt_comp_fc	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Compensation amount
46	decl_comp_year	integer	9999		0	Declaration compensation
47	decl_comp_period	integer	>>9		0	Declaration compensation
48	return_type	integer	>>>>>9		0	Return type
49	vat_perc_claim	decimal	>>9.99	2	0	Percentage VAT to claim
50	vat_perc_comp	decimal	>>9.99	2	0	Compensation percentage
51	decl_period	integer	>>9		0	Period

Indexes

vathis01ix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	seqnr_vathis	int64	>>>>>>>>>9	Sequence number

vathis02ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	vat_nr	character	x(20)	VAT number

vathis03ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	period	integer	>>9	Period
4	code_ps	integer	>>>>>9	Purchase/Sales
5	vat_code	character	x(3)	VAT transaction

vathis05ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	fin_yr	integer	9999	Financial year
3	date	date	99/99/9999	Date
4	vat_code	character	x(3)	VAT transaction
5	vat_nr	character	x(20)	VAT number
6	period	integer	>>9	Period

vathis06ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	decl_year	integer	9999	Correction year of return
3	decl_period	integer	>>9	Period

Contents > vathis

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

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