MAT

Table Owner	Table Name	Table Comment	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