AMIG

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	amig_account_balance	This table will store all migrated asset class wise details and account codes will be stored.	ou_id	int	Organization Unit Id	Yes	No
			depr_book	sql_variant	Depreciation Book
			fb_id		Finance Book Id
			asset_class		Asset Class
			account_code		Account Code
			timestamp	int	Time Stamp	No
			account_desc	sql_variant	Account Description
			balance_gl	bigint	Balance General Ledger
			balance_fa		Balance Fixed Asset
			diff_amount		Difference Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_account_balance_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			depr_book	sql_variant	Depreciation Book
			fb_id		Finance Book Id
			asset_class		Asset Class
			account_code		Account Code
			account_desc		Account Description
			balance_gl	bigint	Balance General Ledger
			balance_fa		Balance Fixed Asset
			diff_amount		Difference Amount
			assetusage	sql_variant	Asset Usage
			currency_code		Currency Code
			createdby		Create By
			createddate	datetime	Create Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_asset_doc_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_type	sql_variant	Document Type
			doc_number		Document Number
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			doc_amount	bigint	Document Amount
			currency	sql_variant	Currency
			exchange_rate	bigint	Exchange Rate
			gr_date	datetime	Goods Receipt Date
			cap_amount	bigint	Capitalization Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_asset_tag_dtl	This table will store all migrated asset number and document details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_type	sql_variant	Document Type	No
			doc_number		Document Number
			timestamp	int	Time Stamp
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			doc_amount	bigint	Document Amount
			currency	sql_variant	Currency
			exchange_rate	bigint	Exchange Rate
			gr_date	datetime	Good Receipt Date
			cap_amount	bigint	Capitalization Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_asset_tag_dtl_tmp		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_type	sql_variant	Document Type	No
			doc_number		Document Number
			timestamp	int	Time Stamp
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			doc_amount	bigint	Document Amount
			currency	sql_variant	Currency
			exchange_rate	bigint	Exchange Rate
			gr_date	datetime	Good Receipt Date
			cap_amount	bigint	Capitalization Amount
			status	sql_variant	Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_asset_tag_hdr	This table will store all migrated asset details will be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			legacy_asset_number	sql_variant	Lagacy Asset Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			depr_category		Depreciation Category
			asset_cost	bigint	Asset Cost
			asset_status	sql_variant	Asset Status.Values "A-Active,R-Retired"
			asset_class		Asset Class
			asset_group		Asset Group
			asset_location		Asset Location
			cost_center		Cost Center
			inv_cycle		Invoice Cycle
			inservice_date	datetime	Inservice Date
			cap_date		Capitalization Date
			bar_code	sql_variant	Bar Code
			serial_num		Serial Number
			warranty_no		Warranty Number
			model		Model
			manufacturer		Manufacturer
			custodian		Custodian
			business_use	bigint	Business Use
			salvage_val		Salvage Value
			retire_type	sql_variant	Retire Type
			retire_date	datetime	Retire Date
			sale_value	bigint	Sale Value
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_asset_tag_tmp		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			legacy_asset_number	sql_variant	Legacy Asset Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			depr_category		Depreciation Category
			asset_cost	bigint	Asset Cost
			asset_status	sql_variant	Asset Status
			asset_class		Asset Class
			asset_group		Asset Group
			asset_location		Asset Location
			cost_center		Cost Center
			inv_cycle		Invoice Cycle
			inservice_date	datetime	Inservice Date
			cap_date		Capitalization Date
			bar_code	sql_variant	Bar Code
			serial_num		Serial Number
			warranty_no		Warranty Number
			model		Model
			manufacturer		Manufacturer
			custodian		Custodian
			business_use	bigint	Business Use
			salvage_val		Salvage Value
			retire_type	sql_variant	Retire Type
			retire_date	datetime	Retire Date
			sale_value	bigint	Sale Value
			status	sql_variant	Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_assettag_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			legacy_asset_number	sql_variant	Legacy Asset Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			depr_category		Depreciation Category
			asset_cost	bigint	Asset Cost
			asset_status	sql_variant	Asset Status
			asset_class		Asset Class
			asset_group		Asset Group
			asset_location		Asset Location
			cost_center		Cost Center
			inv_cycle		Invoice Cycle
			inservice_date	datetime	Inservice Date
			cap_date		Capitalization Date
			bar_code	sql_variant	Bar Code
			serial_num		Serial Number
			warranty_no		Warranty Number
			model		Model
			manufacturer		Manufacturer
			custodian		Custodian
			business_use	bigint	Business Use
			salvage_val		Salvage Value
			retire_type	sql_variant	Retire Type
			retire_date	datetime	Retire Date
			sale_value	bigint	Sale Value
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			capnum	int	Capitalization Number
	amig_error_log		ou_id		Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			fin_year		Finance Year
			fin_period		Finance Period
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			error_id		Error Id
			error_desc	sql_variant	Error Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_initial_balance	This table will store all migrated asset details will be stored.	ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			fin_year		Finance Year
			fin_period		Finance Period
			asset_number		Asset Number
			tag_number	int	Tag Number
			fb_id	sql_variant	Finance Book Id
			asset_class		Asset Class
			timestamp	int	Time Stamp	No
			asset_cost	bigint	Asset Cost
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			reval_type	sql_variant	Revaluation Type
			reval_date	datetime	Revaluation Date
			reval_amount	bigint	Revaluation Amount
			rev_dep_cost		Reversal Depreciation Cost
			asset_book_val		Asset Book Value
			complete_status	sql_variant	Complete Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_initial_balance_cpt_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			depr_book	sql_variant	Depreciation Book
			fin_year		Finance Year
			fin_period		Finance Period
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			asset_cost	bigint	Asset Cost
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			reval_type	sql_variant	Revaluation Type
			reval_date	datetime	Revaluation Date
			reval_amount	bigint	Revaluation Amount
			rev_dep_cost		Revalue Depreciation Cost
			asset_book_val		Asset Book Value
			fb_id	sql_variant	Finance Book Id
			asset_class		Asset Class
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_initial_balance_tmp		ou_id	int	Organization Unit Id	Yes
			depr_book	sql_variant	Depreciation Book
			fin_year		Finance Year
			fin_period		Finance Period
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			asset_cost	bigint	Asset Cost
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			reval_type	sql_variant	Revaluation Type
			reval_date	datetime	Revaluation Date
			reval_amount	bigint	Revaluation Amount
			rev_dep_cost		Revalue Depreciation Cost
			asset_book_val		Asset Book Value
			fb_id	sql_variant	Finance Book Id
			asset_class		Asset Class
			status		Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_is_initial_balance_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			depr_book	sql_variant	Depreciation Book
			fb_id		Finance Book Id
			asset_class		Asset Class
			asset_number		Asset Number
			tag_number	int	Tag Number
			fin_year	sql_variant	Finance Year
			fin_period		Finance Period
			asset_cost	bigint	Asset Cost
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			reval_type	sql_variant	Revaluation Type
			reval_date	datetime	Revaluation Date
			reval_amount	bigint	Revaluation Amount
			rev_dep_cost		Reversal Depreciation Cost
			asset_book_val		Asset Book Value
			status	sql_variant	Status
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			account_type		Account Type
			pbasset_cost	bigint	Parallel Base Asset Code
			pbbook_value		Parallel Base Book Value
			pbcurrency_code	sql_variant	Parallel Base Currency Code
			base_curr_code		Base Currency Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	amig_process_parameter_sys	This table will store all migrated asset process parameter 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