Exact Financials

Data dictionary scentry - scenario entry lines

#	Field name	Data type	Format	Dec	Default	Label
1	adm_nr	integer	>>>>>9		?	Company
2	journal_nr	integer	>>9		0	Journal
3	scenario_code	character	x(8)			Scenario
4	line_nr	integer	>>>>>9		0	Line
5	linenr_scentry_user	integer	>>>9		0	Line number (User)
6	change_line_nr	logical	yes/no		yes	Change line
7	acc_nr	character	x(9)			Account
8	change_acc_nr	logical	yes/no		yes	Change account
9	descr	character	X(60)			Description
10	change_descr	logical	yes/no		yes	Change description
11	debtor	int64	>>>>>>>>>9		0	Debtor
12	change_debtor	logical	yes/no		yes	Change debtor
13	creditor	int64	>>>>>>>>>9		0	Creditor
14	change_creditor	logical	yes/no		yes	Change creditor
15	vat_code	character	x(3)		0	VAT code
16	change_vat_code	logical	yes/no		yes	Change VAT code
17	curr_code	character	x(3)			Currency
18	change_curr_code	logical	yes/no		yes	Change currency
19	amt_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Currency amount
20	perc_amt_curr	decimal	->>9.99	2	0	Percentage header currency amount
21	change_amt_curr	logical	yes/no		yes	Change Currency amount
22	vat_amt_curr	decimal	->>>,>>>,>>>,>>>,>>9.99	4	0	Currency VAT amount
23	change_vat_amt_curr	logical	yes/no		yes	Change currency VAT amount
24	cost_center	character	x(8)			Cost center
25	change_cost_center	logical	yes/no		yes	Change Cost center
26	cost_unit	character	x(8)			Cost unit
27	change_cost_unit	logical	yes/no		yes	Change cost unit
28	qty	decimal	->>>>>>>>>9.99	4	0	Quantity
29	change_qty	logical	yes/no		yes	Change quantity
30	rev_entry	logical	yes/no		yes	Reversal entry
31	change_rev_entry	logical	yes/no		yes	Change reversal entry
32	del_acq	integer	>>>>>9		0	Supply/acquisition
33	change_del_acq	logical	yes/no		yes	Change Supply/acquisition
34	mcode1	character	X(8)			Mdim 1
35	change_mcode1	logical	yes/no		yes	Change mdim 1
36	mcode2	character	X(8)			Mdim 2
37	change_mcode2	logical	yes/no		yes	Change
38	mcode3	character	X(8)			Mdim 3
39	change_mcode3	logical	yes/no		yes	Change
40	mcode4	character	X(8)			Mdim 4
41	change_mcode4	logical	yes/no		yes	Change
42	mcode5	character	X(8)			Mdim 5
43	change_mcode5	logical	yes/no		yes	Change
44	invoice_nr_type	integer	>>>>>9		1	Invoice type
45	change_invoice_nr_type	logical	yes/no		yes	Change
46	ca_acc_nr	character	X(9)			Account
47	change_ca_acc_nr	logical	yes/no		yes	Change
48	ca_cost_center	character	X(8)			Cost center
49	change_ca_cost_center	logical	yes/no		yes	Change
50	ca_cost_unit	character	X(8)			intercompany cost unit
51	change_ca_cost_unit	logical	yes/no		yes	Change
52	ca_qty	decimal	->>>>>>>>>9.99	4	0	Quantity
53	change_ca_qty	logical	yes/no		yes	Change
54	ca_debtor	int64	>>>>>>>>>9		0	IC debtor
55	change_ca_debtor	logical	yes/no		yes	Change
56	ca_credit	int64	>>>>>>>>>9		0	IC creditor
57	change_ca_credit	logical	yes/no		yes	Change IC creditor
58	ca_invoice_nr_type	integer	>>>>>9		1	IC invoice type
59	change_ca_invoice_nr_type	logical	yes/no		yes	Change IC invoice type
60	time_lc	integer	->,>>>,>>9		0
61	date_lc	date	99/99/9999
62	euserid_lc	character	X(12)
63	type_lc	character	x(8)
64	source_lc	character	x(8)
65	project_code	character	x(10)			Project
66	project_description	character	X(60)			Project description
67	project_cost_center	character	x(8)			Project cost center
68	project_cost_cat_code	character	x(8)			Project cost category
69	result_type	integer	>>>>>9		1	Result type
70	change_project_code	logical	yes/no		yes	Change
71	change_pro_cost_cat_code	logical	yes/no		yes	Change
72	change_project_cost_center	logical	yes/no		yes	Change
73	change_project_description	logical	yes/no		yes	Change
74	change_result_type	logical	yes/no		yes	Change
75	change_ic_acc_nr	logical	yes/no		yes	Change
76	change_ic_cost_center	logical	yes/no		yes	Change
77	change_ic_cost_unit	logical	yes/no		yes	Change
78	change_ic_mdim_code_1	logical	yes/no		yes	Change
79	change_ic_mdim_code_2	logical	yes/no		yes	Change
80	change_ic_mdim_code_3	logical	yes/no		yes	Change
81	change_ic_mdim_code_4	logical	yes/no		yes	Change
82	change_ic_mdim_code_5	logical	yes/no		yes	Change
83	change_ic_project_code	logical	yes/no		yes	Change
84	change_ic_cost_cat_code	logical	yes/no		yes	Change
85	change_ic_pro_cost_center	logical	yes/no		yes	Change
86	change_ic_project_descr	logical	yes/no		yes	Change
87	change_ic_result_type	logical	yes/no		yes	Change
88	change_ic_qty	logical	yes/no		yes	Change
89	nr_periods_allocation	integer	>>9		0	Number of periods
90	change_nr_periods_allocat	logical	yes/no		yes	Change

Indexes

scentryix - primary - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	journal_nr	integer	>>9	Journal
3	scenario_code	character	x(8)	Scenario
4	line_nr	integer	>>>>>9	Line

scentry04ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	journal_nr	integer	>>9	Journal
3	scenario_code	character	x(8)	Scenario
4	linenr_scentry_user	integer	>>>9	Line number (User)

scentry2ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	journal_nr	integer	>>9	Journal
3	debtor	int64	>>>>>>>>>9	Debtor
4	scenario_code	character	x(8)	Scenario
5	line_nr	integer	>>>>>9	Line

scentry3ix

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	journal_nr	integer	>>9	Journal
3	creditor	int64	>>>>>>>>>9	Creditor
4	scenario_code	character	x(8)	Scenario
5	line_nr	integer	>>>>>9	Line

Contents > scentry

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.668
Assortment:	Exact Financials	Date:	01-05-2014
Release:		Attachment:
Disclaimer

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