Asset Revaluation

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	arev_acc_bal_tmp		timestamp	int	Time Stamp	No	No
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			depr_book		Depreciation Book
			asset_number		Asset Number
			tag_number	int	Tag Number
			fin_year	sql_variant	Finance Year
			fin_period		Finance Period
			rev_cost	bigint	Reversal Cost
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			tran_number	sql_variant	Transaction Number
			drcr_flag		Debit Credit Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_accounting_info_dtl	This table will store all asset revaluation accounting details rules will be stored.	tran_number	sql_variant	Transaction Number	Yes
			tran_type		Transaction Type
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ou_id	int	Organization Unit Id
			timestamp		Time Stamp	No
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			run_date	datetime	Run Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			account_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_accounting_info_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			tran_number	sql_variant	Transaction Number
			tran_type		Transaction Type
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			run_date	datetime	Run Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			account_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_error_log		guid	sql_variant	Guid	Yes
			asset_class		Asset Class
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			depr_category	sql_variant	Depreciation Category
			cost_center		Cost Center
			error_desc		Error Description
			rev_run_no		Reversal Run Number
			error_no	int	Error Number
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_fbpostings_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			company_code		Company Code
			component_name		Component Name
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			tran_ou	int	Transaction Organization Unit
			fb_voucher_no	sql_variant	Finance Book Voucher Number
			fb_voucher_date	datetime	Finance Book Voucher Date
			document_no	sql_variant	Document Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			exchange_rate		Exchange Rate
			ou_id	int	Organization Unit Id
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			par_base_amount	bigint	Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			mac_flag	sql_variant	Management Account Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_index_tmp		timestamp	int	Time Stamp
			arev_indexyear	sql_variant	Asset Revaluation Index Year
			ains_indexes	bigint	Asset Insurance Indexes
			arev_start_date	datetime	Asset Revaluation Start Date
			arev_end_date		Asset Revaluation End Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_notes_dtl	This table will store all asset revaluation note details rules will be stored.	timestamp	int	Time Stamp
			ouid		Organization Unit Id
			revalution_run_number	sql_variant	Revaluation Run Number
			note_id		Notes Id
			notes_desc		Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_notes_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			notes_id		Notes Id
			notes_desc		Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_revaluation_batch_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			rev_run_no	sql_variant	Reversal Run Number
			timestamp	int	Time Stamp	No
			run_date	datetime	Run Date
			fb_id	sql_variant	Finance Book Id
			tags_selected		Tags Selected
			rev_type		Reversal Type
			processing_status		Processing Status
			tags_processed		Tags Processed
			tags_rejected		Tags Rejected
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_revaluation_dtl	This table will store all asset revaluation details rules will be stored.	ou_id	int	Organization Unit Id	Yes
			rev_run_no	sql_variant	Reversal Run Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			org_asset_cost	bigint	Organization Asset Cost
			last_rev_asset_cost		Last Reversal Asset Cost
			asset_book_val		Asset Book Value
			rev_costby		Reversal Cost By
			rev_costto		Reversal Cost To
			rev_depr_category	sql_variant	Reversal Depreciation Category
			asset_desc		Asset Description
			tag_desc		Tag Description
			gross_revalued_cost	bigint	Gross Revalued Cost
			rev_dep_cost		Reversal Depreciation Cost
			rev_net_cost		Reversal Net Cost
			tag_status	sql_variant	Tag Status. Values AC-Active, IA- InActive, RV- Reversed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_revaluation_hdr		ou_id	int	Organization Unit Id	Yes
			rev_run_no	sql_variant	Reversal Run Number
			timestamp	int	Time Stamp	No
			softrev_run_no	sql_variant	Soft Reverse Run Number
			run_date	datetime	Run Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			insval_rule_no		Instance Value Rule Number
			depr_category		Depreciation Category
			depr_book		Depreciation Book
			currency		Currency
			assets_selected		Assets Selected
			tags_selected		Tags Selected
			rec_selected		Record Selected
			rev_total	bigint	Reversal Total
			rev_type	sql_variant	Reversal Type
			run_basis		Run Basis
			pcost_center		Processing Cost Center
			processing_status		Processing Status. Values DE-Deleted,AB-Aborted,PR-Processed,IP-In Process,CO-Confirmed,RT-Returned,RV-Reversed
			tags_processed		Tags Processed
			tags_rejected		Tags Rejected
			rev_gross_total	bigint	Reversal Gross Total
			rev_depr_total		Reversal Depreciation Total
			rev_net_total		Reversal Net Total
			rev_option	sql_variant	Reversal Option
			rev_rule_no		Reversal Rule Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			guid	sql_variant	Guid
	arev_revaluation_tmp					Yes
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			rev_run_no	sql_variant	Revaluation Run Number
			org_asset_cost	bigint	Organization Asset Cost
			last_rev_asset_cost		Last Revaluation Asset Cost
			asset_book_val		Asset Book Value
			rev_costby		Revaluation Cost By
			rev_costto		Revaluation Cost To
			rev_depr_category	sql_variant	Revaluation Depreciation Category
			asset_desc		Asset Description
			tag_desc		Tag Description
			gross_revalued_cost	bigint	Gross Revalued Cost
			rev_dep_cost		Revaluation Depreciation Cost
			rev_net_cost		Revaluation Net Cost
			tag_status	sql_variant	Tag Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_reverse_dtl	This table will store all reverse asset revaluation details rules will be stored.	ou_id	int	Organization Unit Id	Yes
			rev_doc_no	sql_variant	Reversal Document Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			org_asset_cost	bigint	Organization Asset Cost
			asset_book_value		Asset Book Value
			gross_revalued_cost		Gross Revalued Cost
			rev_dep_cost		Revaluation Depreciation Cost
			rev_net_cost		Revaluation Net Cost
			rev_depr_category	sql_variant	Revaluation Depreciation Category
			softrev_run_no		Soft Reverse Run Number
			last_rev_asset_cost	bigint	Last Reverse Asset Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_reverse_hdr	This table will store all reverse asset revaluation details rules will be stored.	ou_id	int	Organization Unit Id	Yes
			rev_doc_no	sql_variant	Reverse Document Number
			timestamp	int	Time Stamp	No
			revr_option	sql_variant	Reversal Option
			rev_run_no		Reverse Run Number
			reversal_date	datetime	Reversal Date
			num_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			revr_status		Reverse Status.Values AC-Active,IA-InActive,RV-Reversed
			currency		Currency
			pcost_center		Cost Center
			rev_gross_total	bigint	Reversal Gross Total
			rev_net_total		Reversal Net Total
			rev_depr_total		Reversal Depreciation Total
			softrev_run_no	sql_variant	Soft Reversal Run Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_reverse_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			rev_doc_no	sql_variant	Reverse Document Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			org_asset_cost	bigint	Organization Asset Cost
			asset_book_value		Asset Book Value
			gross_revalued_cost		Gross Revalued Cost
			rev_dep_cost		Reverse Depreciation Cost
			rev_net_cost		Reverse Net Cost
			rev_depr_category	sql_variant	Reverse Depreciation Category
			softrev_run_no		Soft Reverse Run Number
			last_rev_asset_cost	bigint	Last Reverse Asset Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_rule_dtl	This table will store all asset revaluation rule details rules will be stored.	ou_id	int	Organization Unit Id	Yes
			rev_rule_no	sql_variant	Reverse Rule Number
			index_year		Index Year
			timestamp	int	Time Stamp	No
			start_date	datetime	Start Date
			end_date		End Date
			rev_index	bigint	Reversal Index
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	arev_rule_hdr		ou_id	int	Organization Unit Id	Yes
			rev_rule_no	sql_variant	Reversal Rule Number
			timestamp	int	Time Stamp	No
			rev_type	sql_variant	Reverse Type
			asset_class		Asset Class
			rev_rule_desc		Reverse Rule Description
			rev_cum_depr		Reverse Cumulative Description
			depr_book		Depreciation Book
			rev_basis		Reverse Basis
			rev_option		Reverse Option
			rev_percent	bigint	Reverse Percentage
			rev_link_prev	sql_variant	Reverse Link Previous
			rev_index_option		Reverse Index Option
			rev_index_yrs	bigint	Reverse Index Years
			start_year	sql_variant	Start Year
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date