Exact Financials

Data dictionary bnktpe - Bank account types - 7.20

#	Field name	Data type	Format	Extent	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	accncd	character	x(3)		?	Account
3	descr	character	X(60)			Description
4	accnmask	character	x(80)			Mask account
5	control_type	integer	>>>>>9		0	Type of check
6	nr_tests	integer	9		0	Number of tests
7	x_wtable1	integer	->>>>9	34	0	Weighting table 1
8	addinddig1	logical	yes/no		yes	Add up individual figures 1
9	modulus1	integer	>>>>9		0	Modulus 1
10	x_wtable2	integer	->>>>9	34	0	Weighting table 2
11	addinddig2	logical	yes/no		yes	Add up individual figures 2
12	modulus2	integer	>>>>9		0	Modulus 2
13	and_or	integer	>>>>>9		0	Test condition
14	sort_from	integer	>>>>>9		0	From sorting code
15	sort_thru	integer	>>>>>9		0	To sorting code
16	descr_ml	character	X(60)	5		ML description
17	source_lc	character	x(12)
18	time_lc	integer	->,>>>,>>9		?
19	date_lc	date	99/99/9999
20	euserid_lc	character	X(12)
21	type_lc	character	x(8)
22	addzero	integer	>>>>>9		0	Add zero
23	entity_state	integer	>>>>>9		0	State
24	term_id	integer	>>>>>>>9		0	Term ID
25	wtable1_01	integer	->>>>9		0	Weighting table 1.1
26	wtable1_02	integer	->>>>9		0	Weighting table 1.2
27	wtable1_03	integer	->>>>9		0	Weighting table 1.3
28	wtable1_04	integer	->>>>9		0	Weighting table 1.4
29	wtable1_05	integer	->>>>9		0	Weighting table 1.5
30	wtable1_06	integer	->>>>9		0	Weighting table 1.6
31	wtable1_07	integer	->>>>9		0	Weighting table 1.7
32	wtable1_08	integer	->>>>9		0	Weighting table 1.8
33	wtable1_09	integer	->>>>9		0	Weighting table 1.9
34	wtable1_10	integer	->>>>9		0	Weighting table 1.10
35	wtable1_11	integer	->>>>9		0	Weighting table 1.11
36	wtable1_12	integer	->>>>9		0	Weighting table 1.12
37	wtable1_13	integer	->>>>9		0	Weighting table 1.13
38	wtable1_14	integer	->>>>9		0	Weighting table 1.14
39	wtable1_15	integer	->>>>9		0	Weighting table 1.15
40	wtable1_16	integer	->>>>9		0	Weighting table 1.16
41	wtable1_17	integer	->>>>9		0	Weighting table 1.17
42	wtable1_18	integer	->>>>9		0	Weighting table 1.18
43	wtable1_19	integer	->>>>9		0	Weighting table 1.19
44	wtable1_20	integer	->>>>9		0	Weighting table 1.20
45	wtable1_21	integer	->>>>9		0	Weighting table 1.21
46	wtable2_01	integer	->>>>9		0	Weighting table 2.1
47	wtable2_02	integer	->>>>9		0	Weighting table 2.2
48	wtable2_03	integer	->>>>9		0	Weighting table 2.3
49	wtable2_04	integer	->>>>9		0	Weighting table 2.4
50	wtable2_05	integer	->>>>9		0	Weighting table 2.5
51	wtable2_06	integer	->>>>9		0	Weighting table 2.6
52	wtable2_07	integer	->>>>9		0	Weighting table 2.7
53	wtable2_08	integer	->>>>9		0	Weighting table 2.8
54	wtable2_09	integer	->>>>9		0	Weighting table 2.9
55	wtable2_10	integer	->>>>9		0	Weighting table 2.10
56	wtable2_11	integer	->>>>9		0	Weighting table 2.11
57	wtable2_12	integer	->>>>9		0	Weighting table 2.12
58	wtable2_13	integer	->>>>9		0	Weighting table 2.13
59	wtable2_14	integer	->>>>9		0	Weighting table 2.14
60	wtable2_15	integer	->>>>9		0	Weighting table 2.15
61	wtable2_16	integer	->>>>9		0	Weighting table 2.16
62	wtable2_17	integer	->>>>9		0	Weighting table 2.17
63	wtable2_18	integer	->>>>9		0	Weighting table 2.18
64	wtable2_19	integer	->>>>9		0	Weighting table 2.19
65	wtable2_20	integer	->>>>9		0	Weighting table 2.20
66	wtable2_21	integer	->>>>9		0	Weighting table 2.21
67	is_bic_mandatory	logical	true/false		FALSE	Mandatory: BIC

Indexes

bnktpeix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	accncd	character	x(3)	Account

bnktpe02ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	entity_state	integer	>>>>>9	State
3	accncd	character	x(3)	Account

Contents > bnktpe

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

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