Exact Financials

Data dictionary y_scentry - scenario entry lines - 7.20

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

Indexes

y_scentryix - primary - unique

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

y_scentry1ix - unique

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	journal_nr	integer	>>9	Journal
3	scenario_code	character	x(12)	Scenario
4	line_nr	integer	>>>>>9	Line
5	seqnr_log	integer	>,>>>,>>9	Sequence number

Contents > y_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:	26.936.872
Assortment:	Exact Financials	Date:	27-01-2016
Release:		Attachment:
Disclaimer

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