Exact Financials

Data dictionary prmach - Machinery - 7.20

#	Field name	Data type	Format	Dec	Extent	Default	Label
1	adm_nr	integer	>>>>>9			?	Company
2	machinery_code	character	x(12)			?	Machinery
3	description	character	X(60)				Description
4	descr_ml	character	X(60)		5		ML Description
5	date_into_use	date	99/99/9999				Into use
6	date_out_of_use	date	99/99/9999				Out of use
7	startdate_guarantee	date	99/99/9999				Startdate guarantee
8	enddate_guarantee	date	99/99/9999				Enddate guarantee
9	date_last_maintenance	date	99/99/9999				Last maintenance
10	date_next_maintenance	date	99/99/9999				Next maintenance
11	cost_center	character	x(12)				Cost center
12	rate_int	decimal	>>>,>>>,>>9.99	2			Internal rate
13	rate_ext	decimal	>>>,>>>,>>9.99	2			External rate
14	curr_code	character	X(3)				Currency
15	euserid_cr	character	X(12)				User creation
16	date_cr	date	99/99/9999				Date creation
17	time_cr	integer	>>>>>9			?	Time creation
18	source_cr	character	X(40)				Source creation
19	euserid_lc	character	X(12)				User last changed
20	date_lc	date	99/99/9999				Date last changed
21	time_lc	integer	>>>>>9			?	Time last changed
22	source_lc	character	X(40)				Source last changed
23	norm	decimal	>>>>>>>>>>>>>>9.999	3		0	Norm
24	search_code	character	X(10)				Search code
25	entity_state	integer	>>>>>9			0	State
26	term_id	integer	>>>>>>>9			0	Term ID

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	machinery_code	character	x(12)	Machinery

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

#	Field name	Data type	Format	Description
1	adm_nr	integer	>>>>>9	Company
2	search_code	character	X(10)	Search code

Contents > prmach

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