REPSFAM

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	aplan_proposal_rpt_tmp		proposal_number	sql_variant	Proposal Number	No	No
			proposal_date	datetime	Proposal Date
			proposal_desc	sql_variant	Proposal Description
			proposal_status		Proposal Status
			cost_center		Cost Center
			proposed_cost	bigint	Proposed Cost
			commited_amount		Committed Amount
			liability_amount		Liability Amount
			utilized_amount		Utilized Amount
			balance_amount		Balance Amount
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			financial_year		Financial Year
			asset_class_code		Asset Class Code
			currency_code		Currency Code
			amendment_number		Amendment Number
			revised_proposal_amt	bigint	Revised Proposal Amount
			liability_booked		Liability Booked
	fam_asi_assetwise_rpt_tmp		actiondate	datetime	Action Date
			afb	sql_variant	Asset Finance Book
			afbml		Asset Finance Book Multiple Line
			assetclassdesc		Asset Class Description
			assetdescription		Asset Description
			assetgrpnum		Asset Group Number
			assetno		Asset Number
			buyfbml		Finance Book Multiline
			closingbalance	bigint	Closing Balance
			companyname	sql_variant	Company Name
			cost	bigint	Cost
			currency_ml	sql_variant	Currency Multiple Line
			deleteamount	bigint	Delete Amount
			depreciation		Depreciation
			deprprocrunno	sql_variant	Depreciation Procurement Number
			fbid		Finance Book Id
			financeyear		Finance Year
			financialperiodml		Financial Period Multiple Line
			itemgroup		Item Group
			openingbalance	bigint	Opening Balance
			orgasscost		Organizations Cost
			reportid	sql_variant	Report Id
			segbu		Segment Business Unit Id
			segstrucid		Structure Id
			segstrucidml		Structure Id in Multiline
			tagdescription		Tag Description
			tagno		Tag Number
			totaladdition	bigint	Total Addition
			totalpayamount		Total Pay Amount
			wdvhdr
			wdvml
			assetbookvalue		Asset Book Value
			assetbookvalueml		Asset Book Value Multiple Line
			assetcost		Asset Cost
			assetcostfrom		Asset Cost From
			assetcostml		Asset Cost Multiple Line
			assetvalue		Asset Value
			capitalwipcosthdr		Capital Work in Progress Cost Header
			capitalwipcostml		Capital Work in Progress Cost in Multiline
			depreciationml		Depreciation Multiple Line
			deprenu
			deprenum		Depreciation Number
			wipassetcost		Work in Progress Asset Cost
			guid	sql_variant	Guid
	fam_asi_dtlcls_rpt_tmp		actiondate	datetime	Action Date
			afb	sql_variant	Asset Finance Book
			afbml		Asset Finance Book Multiple Line
			amount	bigint	Amount
			assetclassdesc	sql_variant	Asset Class Description
			assetgrpnum		Asset Group Number
			buyfbml
			capitalisationamount	bigint	Capitalization Amount
			capitalizationdate	datetime	Capitalization Date
			closingbalance	bigint	Closing Balance
			companyname	sql_variant	Company Name
			cost	bigint	Cost
			currency_ml	sql_variant	Currency Multiple Line
			deleteamount	bigint	Delete Amount
			depreciation		Depreciation
			deprprocrunno	sql_variant	Depreciation Procurement Run Number
			destfbml		Destination Finance Book Multiple Line
			fbid		Finance Book Id
			financeyear		Finance Year
			financialperiodml		Financial Period Multiple Line
			itemgroup		Item Group
			openingbalance	bigint	Opening Balance
			orgasscost		Organizations Cost
			reportid	sql_variant	Report Id
			retirementnum		Retirement Number
			revaluationamount	bigint	Revaluation Amount
			segbu	sql_variant
			segstrucid
			segstrucidml
			totaladdition	bigint	Total Addition
			totalpayamount		Total Pay Amount
			tranamount		Transaction Amount
			wdvhdr
			wdvml
			arevgrasscost
			arevnetasstot
			auth_docamount		Authorized Document Amount
			chargevalue		Charge Value
			discountvalue		Discount Value
			docgrossamounthdnml
			docgrossamountml		Document Gross Amount Multiple Line
			docgrossanounthdnhdr
			docleveldiscount		Document Level Discount
			docpayamount		Document Pay Amount
			doctcd		Document Tax Charge Discount
			doctcdamthr
			doctcdamtml		Document Tax Charge Discount Amount Multiple Line
			doctcdvalueml		Document Tax Charge Discount Value Multiple Line
			documentamount		Document Amount
			documentamountcrml		Document Amount Credit Multiple Line
			documentamountdrml		Document Amount Debit Multiple Line
			documentamountfrom		Document Amount From
			documentamountfrom1		Document Amount From 1
			documentamountml		Document Amount Multiple Line
			documenttotal		Document Total
			docvaluehr
			lastrevasscost		Last Revaluation Asset Cost
			pritmvalue
			quotationvalue		Quotation Value
			referencedocumentamount		Reference Document Amount
			revbalinpbc		Revaluation Balance In Parallel Base Currency
			tcdvalue		Tax Charge Discount Value
			guid	sql_variant	Guid
	fam_asi_grp_rpt_tmp		actiondate	datetime	Action Date
			afb	sql_variant	Asset Finance Book
			afbml		Asset Finance Book Multiple Line
			assetclassdesc		Asset Class Description
			assetgrpnum		Asset Group Number
			buyfbml
			capitalwipcostml	bigint
			closingbalance		Closing Balance
			companyname	sql_variant	Company Name
			cost	bigint	Cost
			currency_ml	sql_variant	Currency Multiple Line
			deleteamount	bigint	Delete Amount
			depreciation		Depreciation
			depreciationml		Depreciation Multiple Line
			depreciationnw
			deprprocrunno	sql_variant	Depreciation Procurement Run Number
			fbid		Finance Book Id
			financeyear		Finance Year
			financialperiodml		Financial Period
			itemgroup		Item Group
			macitemcost	bigint	Management Account Item Cost
			openingbalance		Opening Balance
			reportid	sql_variant	Report Id
			segbu
			segstrucid
			segstrucidml
			totaladdition	bigint	Total Addition
			totalpayamount		Total Pay Amount
			wdvhdr
			wip	sql_variant	Work In Progress
			assetbookvalue	bigint	Asset Book Value
			assetbookvalueml		Asset Book Value Multiple Line
			assetcost		Asset Cost
			assetcostfrom		Asset Cost From
			assetcostml		Asset Cost Multiple Line
			assetvalue		Asset Value
			capitalwipcosthdr
			deprenum		Depreciation Number
			wdvml
			wipassetcost		Work In Progress Asset Cost
			guid	sql_variant	Guid
	fam_asi_sumcls_rpt_tmp		actiondate	datetime	Action Date
			afb	sql_variant	Asset Finance Book
			amount	bigint	Amount
			amountdue		Amount Due
			assetclassdesc	sql_variant	Asset Class Description
			capitalisationamount	bigint	Capitalization Amount
			capitalizationdate	datetime	Capitalization Date
			closingbalance	bigint	Closing Balance
			companyname	sql_variant	Company Name
			cost	bigint	Cost
			deprchnprocrunno	sql_variant	Depreciation Procurement Number
			depreciation	bigint	Depreciation
			financebookid	sql_variant	Finance Book Id
			financeperiodexch		Finance Period Exchange
			financialyearmlt		Financially Year Multiple Line
			openingbalance	bigint	Opening Balance
			orgasscost		Organization Asset Cost
			reportid	sql_variant	Report Id
			retirementnum		Retirement Number
			revaluationamount	bigint	Revaluation Amount
			segbu	sql_variant
			totaladdition	bigint	Total Addition
			totalpayamount		Total Pay Amount
			tranamount		Transaction Amount
			wdvhdr
			wdvml
			currency_ml	sql_variant	Currency Multiple Line
			guid		Guid
	fam_asi_wip_rpt_tmp		actiondate	datetime	Action Date
			afb	sql_variant	Asset Finance Book
			afbml		Asset Finance Book Multiple Line
			assetgrpnum		Asset Group Number
			capitalwipcosthdr	bigint
			capitalwipcostml
			companyname	sql_variant	Company Name
			currency_ml		Currency Multiple Line
			deprprocrunno		Depreciation Procurement Run Number
			descriptions		Description
			fbid		Finance Book Id
			financeyear		Finance Year
			financialperiodml		Financial Period Multiple Line
			group1		Group 1
			groupdescription	bigint	Group Description
			itemgroup	sql_variant	Item Group
			orgasscost	bigint	Organization Asset Cost
			reportid	sql_variant	Report Id
			segbu
			segstrucid
			segstrucidml
			totalpayamount	bigint	Total Pay Amount
			wdvhdr
			assetgrpdescml	sql_variant	Asset Group Description Multiple Line
			cumdeprnamtml	bigint	Cumulative Depreciation Amount Multiple Line
			cumulativetotal		Cumulative Total
			grandtotal		Grand Total
			totalamount		Total Amount
			totalvalue		Total Value
			totcostexpnum
			guid	sql_variant	Guid
			cost_center		Cost Center
	fam_asstlst_rpt_tmp		ason	datetime	As On
			assetbookvalue	bigint	Asset Book Value
			assetclassdepr	sql_variant	Asset Class Depreciation
			assetclassfrom		Asset Class From
			assetclassto		Asset Class To
			assetcost	bigint	Asset Cost
			assetdescription	sql_variant	Asset Description
			assetgrpnum		Asset Group Number
			assetloc		Asset Location
			assetlocml		Asset Location Multiple Line
			assetlocationdesc		Asset Location Description
			assetno		Asset Number
			assetstatus		Asset Status
			bankdescription		Bank Description
			bankdescriptionml		Bank Description Multiple Line
			cc
			companyname		Company Name
			costcenter		Cost Center
			currency_sc
			accountcurrency		Account Currency
			budescription		Business Unit Description
			descriptionhdr		Description Header
			financebook		Finance Book
			locfrom		Location From
			locto		Location To
			orgunit		Organization Unit
			reportdate	datetime	Report Date
			reportid	sql_variant	Report Id
			rundate	datetime	Run Date
			sbusegmentid	sql_variant
			segbu
			segbufrom
			segbuto
			targetccfromcall		Target Cost Center From Call
			targetcctocall		Target Cost Center To Call
			guid		Guid
	repsfam_assdepr_reval_tmp		assetclassml		Asset Class Multiple Line
			assetclassdesc		Asset Class Description
			assetclassdescml		Asset Class Description Multiple Line
			assetidfrom		Asset Id From
			assetidto		Asset Id To
			assetno		Asset Number
			bu		Business Unit
			companycode		Company Code
			companyname		Company Name
			costcenterml		Cost Center Multiple Line
			ccdescription		Cost Center Description
			cumdeprnamt	bigint	Cumulative Depreciation Amount
			cumdeprnamtml		Cumulative Depreciation Amount Multiple Line
			datefrom	datetime	Date From
			date_to		Date To
			deprbookno	sql_variant	Depreciation Book Number
			deprcategory		Depreciation Category
			deprcategoryml		Depreciation Category Multiple Line
			deprbasis		Depreciation Basis
			deprcharge		Depreciation Charge
			deprconv		Depreciation Conversion
			deprenum	bigint
			deprexistingtot		Depreciation Existing Total
			deprmethod	sql_variant	Depreciation Method
			financebook		Finance Book
			orgunit		Organization Unit
			processrunnoml		Process Run Number Multiple Line
			reportid		Report Id
			suspdepr	bigint
			susptotal
			tagdescription	sql_variant	Tag Description
			tagno		Tag Number
			tempinfo		Temporary Information
			tempid		Temporary Id
			templateno		Template Number
			todt	datetime	To Date
			total	bigint	Total
			totalamount		Total Amount
			yearoption	sql_variant	Year Option
			fhead
			curr		Currency
			pfrom	datetime
			pto
			prun	sql_variant
			rdepr	bigint
			guid	sql_variant	Guid
	repsfam_assdepr_tmp		assetclassml		Asset Class Multiple Line
			assetclassdesc		Asset Class Description
			assetclassdescml		Asset Class Description Multiple Line
			assetidfrom		Asset Id From
			assetidto		Asset Id To
			assetno		Asset Number
			bu		Business Unit
			companyname		Company Name
			costcenterml		Cost Center Multiple Line
			ccdescription		Cost Center Description
			cumdeprnamt	bigint	Cumulative Depreciation Amount
			cumdeprnamtml		Cumulative Depreciation Amount Multiple Line
			datefrom	datetime	Date From
			date_to		Date To
			deprbookno	sql_variant	Depreciation Book Number
			deprcategory		Depreciation Category
			deprcategoryml		Depreciation Category Multiple Line
			deprbasis		Depreciation Basis
			deprcharge		Depreciation Charge
			deprconv		Depreciation Conversion
			deprenum	bigint	Depreciation Number
			deprexistingtot		Depreciation Existing Total
			deprmethod	sql_variant	Depreciation Method
			financebook		Finance Book
			orgunit		Organization Unit
			processrunnoml		Process Run Number Multiple Line
			reportid		Report Id
			suspdepr	bigint
			susptotal
			tagdescription	sql_variant	Tag Description
			tagno		Tag Number
			tempinfo		Temporary Information
			templ		Template
			templateno		Template Number
			total	bigint	Total
			totalamount		Total Amount
			yearoption	sql_variant	Year Option
			guid		Guid
	repsfam_assetinvscheet_tmp		assetclass		Asset Class
			assetcost	bigint	Asset Cost
			assetcostfrom		Asset Cost From
			assetcostto
			assetdescriptionml	sql_variant	Asset Description Multiple Line
			assetgrpnumml		Asset Group Number Multiple Line
			assetlocationml		Asset Location Multiple Line
			assetnumberml		Asset Number Multiple Line
			category2		Category 2
			childgrpnumml		Child Group Number Multiple Line
			childlocchkbx		Child Location Cost Center Check Box
			childlocml		Child Location Multiple Line
			costcenterml		Cost Center Multiple Line
			fb		Finance Book
			guid		Guid
			invcycleenn
			invduedate	datetime	Invoice Due Date
			invduedatefrom		Invoice Due Date From
			invduedateto		Invoice Due Date To
			inventorieddate		Inventoried Date
			inventorieddatefrom		Inventoried Date From
			inventorieddateto		Inventoried Date To
			inventorysheet	sql_variant	Inventory Sheet
			inventorysheetfrom		Inventory Sheet From
			inventorysheetto		Inventory Sheet To
			invsheetdate	datetime	Inventory Sheet Date
			invsheetdateml		Inventory Sheet Date Multiple Line
			invsheetstatus	sql_variant	Inventory Sheet Status
			ioparammlthdg
			orgunit		Organization Unit
			reportid		Report Id
			tagdescriptionml		Tag Description Multiple Line
			tagnumber	int	Tag Number
			tagnumberml		Tag Number Multiple Line
			tagstatusml	sql_variant	Tag Status Multiple Line
			userid		User Id
			companyname		Company Name
			transfer_date	datetime	Transfer Date
			inventory_cycle	sql_variant	Inventory Cycle
			inventorysheethdnhr
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			invresultenn	sql_variant
			invresultsml		Invoice Results Multiple Line
			rcnremarksml
			reconstatusenn
	repsfam_assetreg_tmp		guid		Guid
			asset_class		Asset Class
			asset_desc		Asset Description
			asset_location		Asset Location
			asset_number		Asset Number
			business_use	bigint	Business Use
			companycode	sql_variant	Company Code
			costcenter		Cost Center
			currency_ml		Currency Multiple Line
			tran_date	datetime	Transaction Date
			depr_category	sql_variant	Depreciation Category
			fb_id		Finance Book Id
			asset_group		Asset Group
			inservice_date	datetime	Inservice Date
			inv_cycle	sql_variant	Invoice Cycle
			salvage_value	bigint	Salvage Value
			tag_number	int	Tag Number
			tag_cost	bigint	Tag Cost
			tag_desc	sql_variant	Tag Description
			tag_status		Tag Status
			depr_book		Depreciation Book
			tran_type		Transaction Type
			cap_number		Capitalization Number
	repsfam_depsimsumr_rpt_tmp		assetclassml		Asset Class Multiple Line
			assetclassdesc		Asset Class Description
			asset_desc		Asset Description
			asset_class		Asset Class
			idfrom		Id From
			idto		Id To
			assetnumberfrom		Asset Number From
			assetnumberto		Asset Number To
			asset_cost	bigint	Asset Cost
			bucodehdr	sql_variant	Business Unit Code Header
			companycodeml		Company Code Multiple Line
			company_name		Company Name
			costcenter		Cost Center
			currency_ml		Currency Multiple Line
			deprbooknoml		Depreciation Book Number Multiple Line
			depr_category		Depreciation Category
			depcategoryml		Depreciation Category Multiple Line
			depr_rule_number		Depreciation Rule Number
			depr_charge1	bigint	Depreciation Charge 1
			depr_charge2		Depreciation Charge 2
			depr_charge3		Depreciation Charge 3
			existing_depr_charge1		Existing Depreciation Charge 1
			existing_depr_charge2		Existing Depreciation Charge 2
			ccdescription	sql_variant	Cost Center Depreciation
			effectofchange1	bigint	Effect Of Change 1
			effectofchange2		Effect Of Change 2
			effectofchange3		Effect Of Change 3
			fbidml	sql_variant	Finance Book Id Multiple Line
			ouinstname	nchar(64)	Organization Unit Instance Name
			rundate	datetime	Run Date
			salvage_cost	bigint	Salvage Cost
			simulateyr		Simulate Year
			slno_no	sql_variant	Serial Line Number
			existing_susp_charge	bigint
			year_no	int	Year Number
			guid	sql_variant	Guid
	repsfam_locationcheck	This table will store all asset report location details will be stored.
			parentloc_code		Parent Location Code
			loc_code		Location Code
			child		Child
			parent_group		Parent Group
			child_group		Child Group
	repsfam_quick_code_met	This table will store all fixed asset report metadata details will be stored.	component_id		Component Id
			parameter_type		Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			timestamp	int	Time Stamp
			parameter_text	sql_variant	Parameter Text
			language_id	int	Language Id
			extension_flag	sql_variant	Extension Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date