Maintenance Asset Tracker

Table Owner	Table Name	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	mat_asset_cmn_tmp	guid	nvarchar(40)	guid	No	No
		fb_id	nvarchar(20)	fb_id
		Tran_no	nvarchar(18)	Tran_no
		Partno_from	nvarchar(40)	Partno_from
		Partno_to		Partno_to
		Serialno_from		Serialno_from
		Serialno_to		Serialno_to
		CompId_from	nvarchar(90)	CompId_from
		Compid_to	nvarchar(40)	Compid_to
		facno_from	nvarchar(100)	facno_from
		facno_to		facno_to
		facobjno_from		facobjno_from
		facobjno_to		facobjno_to
		Assetno	nvarchar(18)	Assetno
		Tagno	int	Tagno
		rowno		rowno
	mat_asst_Hist_dtl	LoginOU		loginou
		Fb_id	nvarchar(20)	fbid
		Aircraft_ou	int	Aircraft_ou
		AircraftReg_no	nvarchar(30)	aircraft regno
		smn_ou	int	smn_ou
		Component_id	nvarchar(40)	component id
		Part_no		partno
		Serial_no		serial no
		Facility_ou	int	facility ou
		Facility_type	nvarchar(25)	facility type
		Facility_code	nvarchar(100)	facility code
		Facility_Object		facility object
		Asset_no	nvarchar(18)	asset no
		Asset_Tagno	int	asset tagno
		Manufacturer_Serialno	nvarchar(40)	manufacturer serialno
		Mapping_date	datetime	mapping date
		Unmapped_date		unmapped date
		flag	nvarchar(5)	flag
		LastModifiedby	nvarchar(30)	LastModifiedby
	mat_asst_main_dtl	LoginOU	int	login ou
		Fb_id	nvarchar(20)	Fb_id
		Aircraft_ou	int	Aircraft_ou
		AircraftReg_no	nvarchar(30)	AircraftReg_no
		smn_ou	int	smn_ou
		Component_id	nvarchar(90)	Component_id
		Part_no	nvarchar(40)	Part_no
		Serial_no		Serial_no
		Facility_ou	int	Facility_ou
		Facility_type	nvarchar(25)	Facility_type
		Facility_code	nvarchar(100)	Facility_code
		Facility_Object		Facility_Object
		Asset_no	nvarchar(18)	Asset_no
		Asset_Tagno	int	Asset_Tagno
		Manufacturer_Serialno	nvarchar(40)	Manufacturer_Serialno
		Mapping_date	datetime	Mapping_date
		flag	nvarchar(5)	flag
		LastModifiedby	nvarchar(30)	LastModifiedby
	Mat_Ast_Asset_Template	Ast_PartNo	nvarchar(40)
		Ast_Part_CreatedOU	nvarchar(32)
		Ast_PlanningOU
		Ast_Generation_Rule	nvarchar(5)
		Ast_Numbering_Type
		Ast_Asset_Desc	nvarchar(40)
		Ast_Tag_Desc
		Ast_Asset_Class	nvarchar(20)
		Ast_Asset_Group	nvarchar(25)
		Ast_Location_Code	nvarchar(20)
		Ast_Cost_Center	nvarchar(10)
		Ast_Salvage_Value	bigint
		Ast_Depreciation_Category	nvarchar(20)
		Ast_Custodian	nvarchar(77)
		Ast_Inventory_Cycle	nvarchar(5)
		Ast_Recording_FB
		Ast_Named_FB	nvarchar(20)
		Ast_created_by	nvarchar(30)
		Ast_created_date	nvarchar(15)
		Ast_modified_by	nvarchar(30)
		Ast_modified_date	nvarchar(15)
		Ast_timestamp	int
	mat_astupdtmp_asst_updation_tmp	astupdtmp_guid	nvarchar(40)
		astupdtmp_mode_flag	nvarchar(5)
		astupdtmp_aircraft_ou	int
		astupdtmp_aircraft_regno	nvarchar(30)
		astupdtmp_smn_ou	int
		astupdtmp_component	nvarchar(90)
		astupdtmp_part_no	nvarchar(40)
		astupdtmp_part_serial
		astupdtmp_facility_ou	int
		astupdtmp_facility_type	nvarchar(25)
		astupdtmp_facility_code	nvarchar(40)
		astupdtmp_facility_obj
		astupdtmp_update_flag	nvarchar(5)
		astupdtmp_asset_no	nvarchar(18)
		astupdtmp_asset_tag	int
		astupdtmp_modified_by	nvarchar(30)
		astupdtmp_modified_date
	mat_matprm_parameter_details	matprm_componentname	nvarchar(20)
		matprm_paramcategory	nvarchar(10)
		matprm_paramtype	nvarchar(25)
		matprm_paramcode	nvarchar(5)
		matprm_paramdesc	nvarchar(80)
		matprm_langid	int
		matprm_sortby
		matprm_creationdate	nvarchar(15)
	mat_matsop_set_options	matsop_ou_instance	int
		matsop_asset_modify_flag	nvarchar(5)
		matsop_asset_sharing_flag
		matsop_asset_fbcheck_flag
		matsop_assettag_aircraft_flag
		matsop_assetgen_compexng_flag
		matsop_timestamp	int
		matsop_created_by	nvarchar(30)
		matsop_created_date
		matsop_modified_by
		matsop_modified_date
	mat_matsrctmp_search_tmp	matsrctmp_guid	nvarchar(40)
		matsrctmp_aircraft_ou	int
		matsrctmp_aircraft_regno	nvarchar(30)
		matsrctmp_aircraft_model	nvarchar(20)
		matsrctmp_planning_base	nvarchar(256)
		matsrctmp_poss_status	nvarchar(25)
		matsrctmp_part_ou	int
		matsrctmp_part_no	nvarchar(40)
		matsrctmp_serial_no
		matsrctmp_part_type	nvarchar(25)
		matsrctmp_part_cntrl_type
		matsrctmp_part_status	nvarchar(40)
		matsrctmp_component_ou	int
		matsrctmp_component	nvarchar(90)
		matsrctmp_warehouse	nvarchar(10)
		matsrctmp_wh_zone
		matsrctmp_bin
		matsrctmp_stocking_point	nvarchar(32)
		matsrctmp_facility	nvarchar(40)
		matsrctmp_fac_type	nvarchar(25)
		matsrctmp_fac_object_code	nvarchar(40)
		matsrctmp_fac_category	nvarchar(25)
		matsrctmp_maint_base	nvarchar(32)
		matsrctmp_object	nvarchar(90)
		matsrctmp_object_type	nvarchar(25)
		matsrctmp_object_class	nvarchar(40)
		matsrctmp_object_status	nvarchar(15)
		matsrctmp_holding_ou	nvarchar(32)
		matsrctmp_object_condtn	nvarchar(25)
		matsrctmp_manf_serial	nvarchar(40)
		matsrctmp_part_desc	nvarchar(150)
		matsrctmp_serial_crtdat	nvarchar(32)
		matsrctmp_object_crtdat
		matsrctmp_asset_no	nvarchar(18)
		matsrctmp_asset_tag	int
		matsrctmp_fin_book	nvarchar(20)
		matsrctmp_cost_center	nvarchar(10)
		matsrctmp_asset_location	nvarchar(20)
		matsrctmp_book_value	bigint
		matsrctmp_tag_status	nvarchar(25)
		matsrctmp_last_mod_by	nvarchar(30)
		matsrctmp_last_mod_date