Mat_ast_Asset  

Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
Mat_Ast_Asset_Template		Ast_PartNo	nvarchar(40)		No	No
		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