ADEP

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	adep_asset_life_tmp		timestamp	int	Time Stamp	No	No
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			simulateyr	bigint	Simulate Year
			asset_life		Asset Life
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_assign_rules_mst	This table will store all depreciation books and rules will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			depr_category		Depreciation Category
			depr_rule_number		Depreciation Rule Number
			eff_date	datetime	Effective Date
			status	sql_variant	Status.Values A-Active,I-Inactive
			timestamp	int	Time Stamp	No
			exp_date	datetime	Expiry Date
			action_date		Action Date
			asset_class	sql_variant	Asset Class
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depPr_depr_param_map		depPr_ou_id	int	Process Depreciation Organization Unit Id
			depPr_book	sql_variant	Process Depreciation Book
			depPr_bk_yrsale		Process Depreciation Book Keeping Year Sale
			depPr_createdby		Process Depreciation Created By
			depPr_createddate	datetime	Process Depreciation Created Date
			depPr_modifiedby	sql_variant	Process Depreciation Modified By
			depPr_modifieddate	datetime	Process Depreciation Modified Date
	adep_depr_book_mst	This table will store all user define books will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			timestamp	int	Time Stamp	No
			depr_book_desc	sql_variant	Depreciation Book Description
			depr_bel_bkval		Depreciation Value
			eff_from_date	datetime	Effective From Date
			depr_book_status	sql_variant	Depreciation Book Status.Values A-Active,I-Inactive
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_book_mst_tmp		guid	sql_variant	Guid	Yes
			depr_book		Depreciation Book
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			depr_book_desc	sql_variant	Depreciation Book Description
			depr_bel_bkval		Depreciation Value
			eff_from_date	datetime	Effective From Date
			depr_book_status	sql_variant	Depreciation Book Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_calendar_dtl	This table will store all user define calendar details wise will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			financial_year		Financial Year
			fp_code		Finance Posting Code
			timestamp	int	Time Stamp	No
			fp_desc	sql_variant	Finance Posting Description
			fp_start_date	datetime	Finance Posting Start Date
			fp_end_date		Finance Posting End Date
			legacy_date	sql_variant	Legacy Date
			fp_status		Finance Posting Status.Values A-Active,I-Inactive.
			closure_type		Closure Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_calendar_dtl_tmp		guid	sql_variant	Guid	Yes
			depr_book		Depreciation Book
			financial_year		Financial Year
			fp_code		Finance Posting Code
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			fp_desc	sql_variant	Finance Posting Description
			fp_start_date	datetime	Finance Posting Start Date
			fp_end_date		Finance Posting End Date
			legacy_date	sql_variant	Legacy Date
			fp_status		Finance Status
			closure_type		Closure Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_calendar_hdr	This table will store all user define calendar year wise will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			financial_year		Financial Year
			timestamp	int	Time Stamp	No
			financial_year_desc	sql_variant	Financial Year Description
			start_date	datetime	Start Date
			end_date		End Date
			depr_cal_status	sql_variant	Depreciation Calculation Status.Values A-Active,I-Inactive.
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_calendar_hdr_tmp		guid	sql_variant	Guid	Yes
			depr_book		Depreciation Book
			financial_year		Financial Year
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			financial_year_desc	sql_variant	Financial Year Description
			start_date	datetime	Start Date
			end_date		End Date
			depr_cal_status	sql_variant	Depreciation Calculation Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_category_mst	This table will store all asset class and depr category will be stored.	ou_id	int	Organization Unit Id	Yes
			asset_class	sql_variant	Asset Class
			depr_category		Depreciation Category
			timestamp	int	Time Stamp	No
			depr_cat_desc	sql_variant	Depreciation Category Description
			depr_cat_status		Depreciation Category Status.Values A-Active, I-Inactive,F-Fresh.
			default_category		Default Category
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_category_mst_tmp		guid	sql_variant	Guid	Yes
			asset_class		Asset Class
			depr_category		Depreciation Category
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			depr_cat_desc	sql_variant	Depreciation Category Description
			depr_cat_status		Depreciation Category Status
			default_category		Default Category
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_rate_dtl	This table will store all asset class wise depr rate ids will be stored.	ou_id	int	Organization Unit Id	Yes
			asset_class	sql_variant	Asset Class
			depr_rate_id		Depreciation Rate Id
			eff_date	datetime	Effective Date
			depr_rate	bigint	Depreciation Rate
			timestamp	int	Time Stamp	No
			exp_date	datetime	Expiry Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modfied By
			modifieddate	datetime	Modfied Date
	adep_depr_rate_hdr		ou_id	int	Organization Unit Id	Yes
			asset_class	sql_variant	Asset Class
			depr_rate_id		Depreciation Rate Id
			timestamp	int	Time Stamp	No
			depr_rate_desc	sql_variant	Depreciation Rate Description
			depr_rate_status		Depreciation Rate Status.Values A-Active
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_rule_dtl	This table will store all asset class wise depr rules will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_rule_number	sql_variant	Depreciation Rule Number
			year	bigint	Year
			timestamp	int	Time Stamp	No
			yearly_percent	bigint	Yearly Percentage
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_rule_dtl_tmp		guid	sql_variant	Guid	Yes
			depr_rule_number		Depreciation Rule Number
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			year	bigint	Year
			yearly_percent		Yearly Percentage
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_rule_hdr	This table will store all asset class wise depr rules will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_rule_number	sql_variant	Depreciation Rule Number
			timestamp	int	Time Stamp	No
			asset_class	sql_variant	Asset Class
			eff_date	datetime	Effective Date
			depr_rule_desc	sql_variant	Depreciation Rule Description
			depr_method		Depreciation Method
			depr_basis		Depreciation Basis
			yearly_percent		Yearly Percentage
			depr_rate_id		Depreciation Rate Id
			useful_asset_life	bigint	Useful Asset Life
			depr_conv	sql_variant	Depreciation Convention
			fy_conv	bigint	Finance Year Convention
			max_depr		Maximum Depreciation
			min_depr		Minimum Depreciation
			rule_status	sql_variant	Rule Status.Values A-Active,I-Inactive.
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_depr_rule_hdr_tmp		guid	sql_variant	Guid	Yes
			depr_rule_number		Depreciation Rule Number
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			asset_class	sql_variant	Asset Class
			eff_date	datetime	Effective Date
			depr_rule_desc	sql_variant	Depreciation Rule Description
			depr_method		Depreciation Method
			depr_basis		Depreciation Basis
			yearly_percent		Yearly Percentage
			depr_rate_id		Depreciation Rate Id
			useful_asset_life	bigint	Useful Asset Life
			depr_conv	sql_variant	Depreciation Convention
			fy_conv	bigint	Finance Year Convention
			max_depr		Maximum Depreciation
			min_depr		Minimum Depreciation
			rule_status	sql_variant	Rule Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_notes_dtl	This table will store all depreciation note will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			notes_desc	sql_variant	Notes Description
			financial_calendar		Financial Calendar
			depr_rule_number		Depreciation Rule Number
			depr_rate_id		Depreciation Rate Id
			depr_book		Depreciation Book
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_notes_dtl_his		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			notes_desc	sql_variant	Notes Description
			financial_calendar		Financial Calendar
			depr_book		Depreciation Book
			depr_rule_number		Depreciation Rule Number
			depr_rate_id		Depreciation Rate Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_notes_dtl_tmp		guid	sql_variant	Guid
			timestamp	int	Time Stamp
			notes_id	sql_variant	Notes Id
			notes_desc		Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_process_parameter_his	This table will store all depreciation process parameter history details will be stored.	ou_id	int	Organization Unit Id	Yes
			parameter_type	sql_variant	Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			action_date	datetime	Action Date
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			action_flag		Action Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adep_process_parameter_sys	This table will store all depreciation process parameter history details will be stored.	ou_id	int	Organization Unit Id	Yes
			parameter_type	sql_variant	Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date