Data Dictionary -- Asset Depreciation Setup

Srl. No.	Table Name	Comment
1	adep_assign_rules_mst	To store information of assignment rules detail
2	adep_depPr_depr_param_map	To store information of depreciation parameter mapping
3	adep_depr_book_mst	To store information of depreciation book detail
4	adep_depr_calendar_dtl	To store information of depreciation calendar detail
5	adep_depr_calendar_hdr	To store information of depreciation calendar header
6	adep_depr_category_mst	To store information of depreciation category detail
7	adep_depr_rate_dtl	To store information of depreciation rate detail
8	adep_depr_rate_hdr	To store information of depreciation rate header
9	adep_depr_rule_dtl	To store information of depreciation rule detail
10	adep_depr_rule_hdr	To store information of depreciation rule header
11	adep_notes_dtl	To store information of notes detail
12	adep_notes_dtl_his	To store history of notes
13	adep_process_parameter_his	To store history of process parameters
14	adep_process_parameter_sys	To store information of system process parameters

Table Name :	adep_assign_rules_mst
Comment :	To store information of assignment rules detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
depr_category	fin_depcategory	varchar(20)	No	Depreciation category	Yes
depr_rule_number	fin_deprkey	varchar(20)	No	Depreciation rule number	Yes
eff_date	fin_datetime	datetime(8)	No	Effective date	Yes
status	fin_status	varchar(25)	No	Status	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
exp_date	fin_datetime	datetime(8)	Yes	Expiry date	No
action_date	fin_datetime	datetime(8)	Yes	Action date	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depPr_depr_param_map
Comment :	To store information of depreciation parameter mapping

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
depPr_ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	No
depPr_book	fin_deprkey	varchar(20)	No	Book	No
depPr_bk_yrsale	fin_flag	varchar(25)	Yes	Book year sale	No
depPr_createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
depPr_createddate	fin_datetime	datetime(8)	Yes	Created date	No
depPr_modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
depPr_modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adep_depr_book_mst
Comment :	To store information of depreciation book detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_book_desc	fin_desc40	varchar(40)	Yes	Depreciation book description	No
depr_bel_bkval	fin_flag	varchar(25)	Yes	Depreciation book value	No
eff_from_date	fin_datetime	datetime(8)	Yes	Effective from date	No
depr_book_status	fin_status	varchar(25)	Yes	Depreciation book status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_calendar_dtl
Comment :	To store information of depreciation calendar detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
financial_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fp_code	fin_calendarcode	varchar(10)	No	Financcial period code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
fp_desc	fin_calendardescription	varchar(40)	Yes	Financial period description	No
fp_start_date	fin_datetime	datetime(8)	Yes	Financial period start date	No
fp_end_date	fin_datetime	datetime(8)	Yes	Financial period end date	No
legacy_date	fin_process	varchar(10)	Yes	Legacy date	No
fp_status	fin_status	varchar(25)	Yes	Financial period status	No
closure_type	fin_desc40	varchar(40)	Yes	Closure type	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_calendar_hdr
Comment :	To store information of depreciation calendar header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
financial_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
financial_year_desc	fin_calendardescription	varchar(40)	Yes	Financial year description	No
start_date	fin_datetime	datetime(8)	Yes	Start date	No
end_date	fin_datetime	datetime(8)	Yes	End date	No
depr_cal_status	fin_status	varchar(25)	Yes	Depreciation calendar status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_category_mst
Comment :	To store information of depreciation category detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset class	Yes
depr_category	fin_deprcategory	varchar(40)	No	Depreciation categroy	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_cat_desc	fin_remarks	varchar(100)	Yes	Depreciation category description	No
depr_cat_status	fin_status	varchar(25)	Yes	Depreciation category status	No
default_category	fin_yesnoflag	varchar(5)	Yes	Default category	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_rate_dtl
Comment :	To store information of depreciation rate detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset class	Yes
depr_rate_id	fin_deprkey	varchar(20)	No	Depreciation rate id	Yes
eff_date	fin_datetime	datetime(8)	No	Effective date	Yes
depr_rate	fin_deprpercent	numeric(13)	No	Depreciation rate	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
exp_date	fin_datetime	datetime(8)	Yes	Expiry date	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_rate_hdr
Comment :	To store information of depreciation rate header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset class	Yes
depr_rate_id	fin_deprkey	varchar(20)	No	Depreciation rate id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_rate_desc	fin_desc40	varchar(40)	Yes	Depreciation rate description	No
depr_rate_status	fin_status	varchar(25)	Yes	Depreciation rate status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_rule_dtl
Comment :	To store information of depreciation rule detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_rule_number	fin_deprkey	varchar(20)	No	Depreciation rule number	Yes
year	fin_assetlife	numeric(13)	No	Year	Yes
timestamp	fin_datetime	datetime(8)	Yes	Timestamp	No
yearly_percent	fin_percentage	numeric(9)	Yes	Yearly percent	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_depr_rule_hdr
Comment :	To store information of depreciation rule header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_rule_number	fin_deprkey	varchar(20)	No	Depreciation rule number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
eff_date	fin_datetime	datetime(8)	Yes	Effective date	No
depr_rule_desc	fin_desc40	varchar(40)	Yes	Depreciation rule description	No
depr_method	fin_deprmethodenu	varchar(25)	Yes	Depreciation method	No
depr_basis	fin_desc40	varchar(40)	Yes	Depreciation basis	No
yearly_percent	fin_flag	varchar(25)	Yes	Yearly percent	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	Depreciation rate id	No
useful_asset_life	fin_assetlife	numeric(13)	Yes	Useful asset life	No
depr_conv	fin_desc40	varchar(40)	Yes	Depreciation conversion	No
fy_conv	fin_deprpercent	numeric(13)	Yes	fy_conv	No
max_depr	fin_amount	numeric(13)	Yes	Maximun depreciation	No
min_depr	fin_amount	numeric(13)	Yes	Minimum depreciation	No
rule_status	fin_status	varchar(25)	Yes	Rule status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_notes_dtl
Comment :	To store information of notes detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes description	No
financial_calendar	fin_financialcalendar	varchar(40)	Yes	Financial calendar	No
depr_rule_number	fin_deprkey	varchar(20)	Yes	Depreciation rule number	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	Depreciation rate id	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adep_notes_dtl_his
Comment :	To store history of notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes description	No
financial_calendar	fin_calendarcode	varchar(10)	Yes	Financial calendar	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
depr_rule_number	fin_deprkey	varchar(20)	Yes	Depreciation rule number	No
depr_rate_id	fin_deprkey	varchar(20)	Yes	Depreciation rate id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	adep_process_parameter_his
Comment :	To store history of process parameters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter category	Yes
parameter_code	fin_param_code	varchar(6)	No	Parameter code	Yes
action_date	fin_datetime	datetime(8)	No	Action date	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_param_text	varchar(255)	Yes	Parameter text	No
action_flag	fin_flag	varchar(25)	Yes	Action flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	adep_process_parameter_sys
Comment :	To store information of system process parameters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter category	Yes
parameter_code	fin_param_code	varchar(6)	No	Parameter code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_param_text	varchar(255)	Yes	Parameter text	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No