Asset Inquiry

Asset Inquiry

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ainq_account_balance	This table will store all asset account details will be stored.	timestamp	int	Time Stamp	No	No
			ou_id		Organization Unit Id
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			asset_class		Asset Class
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			period_credit		Period Credit
			period_debit		Period Debit
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			account_type	sql_variant	Account Type
			currency_type		Currency Type
			currency_code		Currency Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_accounting_info_dtl	This table will store all asset account information details will be stored.	timestamp	int	Time Stamp
			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
			ou_id	int	Organization Unit
			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
			cap_date	datetime	Capitalization 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
			asset_class	sql_variant	asset class
	ainq_asset_hdr	This table will store all active asset details will be stored.	ou_id	int	Organization Unit Id
			cap_number	sql_variant	Capitalization Number
			asset_number		Asset Number
			timestamp	int	Time Stamp
			cap_date	datetime	Capitalization Date
			cap_status	sql_variant	Capitalization Status. Values FR-Fresh.
			fb_id		Finance Book Id
			num_type		Numbering Type
			asset_class		Asset Class
			asset_group		Asset Group
			cost_center		Cost Center
			asset_desc		Asset Description
			asset_cost	bigint	Asset Cost
			asset_location	sql_variant	Asset Location
			seq_no	int	Sequence Number
			as_on_date	datetime	As On Date
			asset_type	sql_variant	Asset Type
			asset_status		Asset Status. Values AC-Active,FR-Fresh,RE-Retire.
			transaction_date	datetime	Transaction Date
			account_code	sql_variant	Account Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_asset_tag_balance	This table will store all depreciation asset details will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			depr_book	sql_variant	Depreciation Book
			asset_number		Asset Number
			asset_book_value	bigint	Asset Book Value
			tag_number	int	Tag Number
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			asset_cost	bigint	Asset Cost
			tag_cost		Tag Cost
			cum_total		Cumulative Total
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			fb_id	sql_variant	Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			reval_depr_charge	bigint	Revalue Depreciation Charge
			reval_cum_depr_charge		Revalue Cumulative Depreciation Charge
			tran_number	sql_variant	Transaction Number
			drcr_flag		Debit Credit Flag
			srno	int	Serial Number
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tag_status	sql_variant	Tag Status
	ainq_asset_tag_balance_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			depr_book	sql_variant	Depreciation Book
			asset_number		Asset Number
			asset_book_value	bigint	Asset Book Value
			tag_number	int	Tag Number
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			asset_cost	bigint	Asset Cost
			tag_cost		Tag Cost
			cum_total		Cumulative Total
			depr_charge		Depreciation Charge
			cum_depr_charge		Cumulative Depreciation Charge
			fb_id	sql_variant	Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			reval_depr_charge	bigint	Revalue Depreciation Charge
			reval_cum_depr_charge		Revalue Cumulative Depreciation Charge
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_asset_tag_dtl	This table will store all active asset tag details will be stored.	ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			cap_number	sql_variant	Capitalization Number
			fb_id		Finance Book Id
			timestamp	int	Time Stamp
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_location		Asset Location
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			tag_status	sql_variant	Tag Status
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			revalued_cost		Revalued Cost
			inv_date	datetime	Invoice Date
			inv_due_date		Invoice Due Date
			inv_status	sql_variant	Invoice Status
			softrev_run_no		Soft Reverse Run Number
			insurable_value	bigint	Insurable Value
			policy_count	int	Policy Count
			dest_fbid	sql_variant	Destination Finance Book Id
			transfer_date	datetime	Transfer Date
			legacy_asset_no	sql_variant	Legacy Asset Number
			migration_status		Migration Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tran_type	sql_variant	Transaction Type
			propos_numbr		Proposed Number
			insp_date	datetime	Inspection Date
			Rev_doc_no	datetime	reversal document no
			expdt_eff_from	datetime	expirydate effective from
			usefullife_expdt	datetime	Useful life expiry date
			salvage_value_orig	bigint	Salvage Value Original
			srno	int	Serial Number
	ainq_asset_tag_his	This table will store all active asset tag details will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			cap_number	sql_variant	Capitalization Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			asset_location		Asset Location
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			tag_status	sql_variant	Tag Status
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			revalued_cost		Revalued Cost
			inv_date	datetime	Invoice Date
			inv_due_date		Invoice Due Date
			inv_status	sql_variant	Invoice Status
			softrev_run_no		Soft Reverse Run Number
			insurable_value	bigint	Insurable Value
			action_time	datetime	Action Time
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_clsgrpsumm_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_name	sql_variant	Company Name
			bu_id		Business Unit Id
			depr_book		Depreciation Book
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			as_on_date	datetime	As On Date
			asset_class	sql_variant	Asset Class
			asset_desc		Asset Description
			asset_group		Asset Group
			group_desc		Group Description
			original_cost	bigint	Original Cost
			cumm_depr_cost		Cumulative Depreciation Cost
			net_book_value		Net Book Value
			cap_wip_cost		Capitalization Work In progress Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_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
	ainq_pending_tran_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			function_name		Function Name
			ou_id	int	Organization Unit Id
			ou_instname	sql_variant	Organization Unit Instance Name
			doc_number		Document Number
			tran_type		Transaction Type
			doc_date	datetime	Document Date
			status	sql_variant	Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_registerastdtl_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_name	sql_variant	Company Name
			bu_id		Business Unit Id
			depr_book		Depreciation Book
			fb_id		Finance Book Id
			fin_year		Finance Year
			asset_class		Asset Class
			asset_group		Asset Group
			asset_no_from		Asset Number From
			asset_no_to		Asset Number To
			cost_center_from		Cost Center From
			cost_center_to		Cost Center To
			fin_period_from		Finance Period From
			fin_period_to		Finance Period To
			asset_number		Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			tran_debit		Transaction Debit
			tran_credit		Transaction Credit
			cl_debit		Closing Debit
			cl_credit		Closing Credit
			date_from	datetime	Date From
			date_to		Date To
			createdby	sql_variant	Created From
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_registertrndtl_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_name	sql_variant	Company Name
			asset_number		Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			tran_number		Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			dr_amt	bigint	Debit Amount
			cr_amt		Credit Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_tag_doc_dtl	This table will store all active asset tag document details will be stored.	ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			cap_number		Capitalization Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_number	sql_variant	Document Number
			line_no	int	Line Number
			timestamp		Time Stamp
			doc_amount	bigint	Document Amount
			doc_type	sql_variant	Document Type
			cap_amount	bigint	Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_transumm_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_name	sql_variant	Company Name
			bu_id		Business Unit Id
			depr_book		Depreciation Book
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			as_on_date	datetime	As On Date
			asset_class	sql_variant	Asset Class
			asset_desc		Asset Description
			asset_group		Asset Group
			group_desc		Group Description
			original_cost	bigint	Original Cost
			cumm_depr_cost		Cumulative Depreciation Cost
			net_book_value		Net Book Value
			cap_wip_cost		Capitalization Work In progress Cost
			op_original_cost		Opening Original Cost
			op_depr_cost		Opening Depreciation Cost
			op_book_cost		Opening Book Cost
			op_wip_cost		Opening Work In progress Cost
			cl_original_cost		Closing Original Cost
			cl_depr_cost		Closing Depreciation Cost
			cl_book_cost		Closing Book Cost
			cl_wip_cost		Closing Work In Progress Cost
			asset_number	sql_variant	Asset Number
			asset_num_desc		Asset Number Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			del_org_cost	bigint	Deletions Original Cost
			del_dep_cost		Deletions Depreciation Cost
			del_book_cost		Deletions Book Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_transummdtl_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_name	sql_variant	Company Name
			bu_id		Business Unit Id
			depr_book		Depreciation Book
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			as_on_date	datetime	As On Date
			asset_class	sql_variant	Asset Class
			asset_desc		Asset Description
			asset_group		Asset Group
			group_desc		Group Description
			original_cost	bigint	Original Cost
			cumm_depr_cost		Cumulative Depreciation Cost
			net_book_value		Net Book Value
			op_original_cost		Opening Original Cost
			op_depr_cost		Opening Depreciation Cost
			op_book_cost		Opening Book Cost
			op_wip_cost		Opening Work In progress Cost
			cl_original_cost		Closing Original Cost
			cl_depr_cost		Closing Depreciation Cost
			cl_book_cost		Closing Book Cost
			cl_wip_cost		Closing Work In progress Cost
			op_rev_cost		Opening Reversal Cost
			ad_tran_amt		Additions Transaction Amount
			dl_rev_amt		Deletions Reversal Amount
			ad_rev_amt		Additions Reversal Amount
			dl_tran_amt		Deletion Transaction Amount
			dl_ret_amt		Deletion Return Amount
			cl_rev_amt		Closing Reversal Amount
			op_rev_depr_cost		Opening Reversal Depreciation Cost
			cl_rev_depr_cost		Closing Reversal Depreciation Cost
			ad_cap_dep_amt		Additions Capitalization Depreciation Cost
			ad_tran_dep_amt		Additions Transaction Depreciation Cost
			dl_rev_dep_amt		Additions Capitalization Depreciation Cost
			dl_tran_dep_amt		Deletions Transaction Depreciation Amount
			dl_ret_dep_amt		Deletions Return Depreciation Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainq_asset_tag_summ		ou_id	int	ou_id
			asset_number	sql_variant	asset_number
			tag_number	int	tag_number
			fb_id	sql_variant	fb_id
			cum_book_value	int	cum_book_value
			cum_tag_cost	int	cum_tag_cost
			cum_depr_charge	int	cum_depr_charge
			tag_Status	sql_variant	tag_Status
			Latest_cap_date	datetime	Latest_cap_date
			Latest_Depp_date	datetime	Latest_Depp_date
			min_cap_number	sql_variant	minimum capitalization number
			min_cap_date	datetime	minimum capitalization date
			min_inservice_date	datetime	minimum inservice date
			latest_cap_number	sql_variant	latest capitalization number
	ainq_tag_prop_tmp		guid	sql_variant
			ou_id	int
			asset_number	sql_variant
			tag_number	int
			cap_number	sql_variant
			cap_date	datetime
			fb_id	sql_variant
			asset_desc	sql_variant
			asset_class	sql_variant
			asset_group	sql_variant
			asset_type	sql_variant
			tag_desc	sql_variant
			asset_location	sql_variant
			cost_center	sql_variant
			inservice_date	datetime
			tag_status	sql_variant
			depr_category	sql_variant
			inv_cycle	sql_variant
			salvage_value	bigint
			manufacturer	sql_variant
			bar_code	sql_variant
			serial_no	sql_variant
			warranty_no	sql_variant
			model	sql_variant
			custodian	sql_variant
			business_use	bigint
			inv_date	datetime
			inv_due_date	datetime
			inv_status	sql_variant
			softrev_run_no	sql_variant
			insurable_value	bigint
			policy_count	int
			dest_fbid	sql_variant
			transfer_date	datetime
			legacy_asset_no	sql_variant
			migration_status	sql_variant
			tran_type	sql_variant
			propos_numbr	sql_variant
			insp_date	datetime
			usefullife_expdt	datetime
			expdt_eff_from	datetime