Table Name/Column Name

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	mac_budget_header_tmp1		ma_ou_id	int	Organization Unit Id	No	No
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_ouname	sql_variant	Organization Unit Name
			ma_aggr_flag		Aggregated Flag
			ma_budget_for		Budget For
			ma_budget_type		Budget Type
			ma_budget_resp		Budget Response
			ma_budget_ou		Budget Organization Unit
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_status	sql_variant	Status.Values F-Fresh,A-Active,I-Inactive
			ma_defstatus		Default Status .Values F-Fresh,A-Active,I-Inactive
			ma_gen_basis		Generate Basis
			ma_incr_decr	bigint	Increase / Decrease
			ma_maint_seas	sql_variant	Maintenance Seasons
			ma_basis_parent		Basis Parent
			ma_basis_version	int	Basis Version
			ma_guid	sql_variant	Guid
	mac_repmac_bdetlist_tmp		bu_id		Business Unit Id
			bu_desc		Business Unit Description
			budfrom		Budget From
			budto		Budget To
			budgetno		Budget Number
			versionno	int	Verson Number
			buddesc	sql_variant	Budget Description
			budgettype		Budget Type
			budgetfor		Budget For
			aggprd		Aggregated Period
			accperiod		Account Period
			budspan		Budget Span
			budstatus		Budget Status.Values F-Fresh,A-Active,I-Inactive
			amount	bigint	Amount
			ccno	sql_variant	Cost Center Number
			ccdesc		Cost Center Description
			ceno		Cost Exchange Number
			cedesc		Cost Exchange Description
			curstatus		Current Status.Values F-Fresh,A-Active,I-Inactive
			eff_date	datetime	Effective Period
			exp_date		Expiry Date
			defitype	sql_variant	Definition Type
			fixedcost	bigint	Fixed Cost
			itemcode	sql_variant	Item Code
			itemvar		Item Variance
			itemvardesc		Item Variance Description
			qty	bigint	Quantity
			reportid	sql_variant	Report Id
			respons		Response
			respou		Response Organization Unit
			totcost	bigint	Total Cost
			varcost		Variant Cost
			varproportion		Variant Proportion
			guid	sql_variant	Guid
			ma_acc_yr_no		Year Number
			ma_acc_prd_no		Period Number
	mac_repmac_cccemapp_tmp		bu_id		Business Unit Id
			ccfrom		Cost Center From
			ccto		Cost Center To
			cefrom		Cost Exchange From
			ceto		Cost Exchange To
			ccno		Cost Center Numbr
			ceno		Cost Exchange Number
			ccdesc		Cost Center Description
			cedesc		Cost Exchange Description
			accperiodfrom		Account Period From
			accperiodto		Account Period To
			accyearfrom		Account Year From
			accyearto		Account Year To
			budget_no		Budget Number
			behavior		Behavior
			traceablity		Traceabilty
			reportid		Report Id
			cctype		Cost Center Type
			cctypedesc		Cost Center Type Description
			cetype		Cost Exchange Type
			cetypedesc		Cost Exchange Type Description
			defaultrate		Default Rate
			standardrate	bigint	Standard Rate
			AltRate1		Alternate Rate 1
			AltRate2		Alternate Rate 2
			AltRate3		Alternate Rate 3
			AltRate4		Alternate Rate 4
			AltRate5		Alternate Rate 5
			AltRate6		Alternate Rate 6
			AltRate7		Alternate Rate 7
			AltRate8		Alternate Rate 8
			guid	sql_variant	Guid
	mac_repmac_ccentry_tmp		center_no		Center Number
			traversed_flag		Traversed Flag
			strid		Structure Id
			ma_guid		Guid
	mac_repmac_ccstru_entrytmp		budesc		Budget Description
			ccstructurefr		Cost Center Structure From
			ccstructureto		Cost Center Structure To
			centertypenum		Center Type Number
			centerunitfrom		Center Unit From
			costcenterunitml		Cost Center Unit Multiline
			curstatushdr		Current Status Header.Values A-Active,I-Inactive
			effectivedatehdr	datetime	Effective Date Header
			expirydatehdr		Expiry Date Header
			levelnumber	int	Level Number
			parentcostcenter	sql_variant	Parent Cost Center
			parentdescription		Parent Description
			structuredescription		Structured Description
			structureid		Structure Id
			typedesc		Type Description
			guid		Guid
			traversed_flag		Traversed Flag
	mac_repmac_ccstru_tmp		budesc		Budget Description
			ccstructurefr		Cost Center Structure From
			ccstructureto		Cost Center Structure To
			centertypenum		Cost Exchange Type Number
			centerunitfrom		Center Unit From
			costcenterunitml		Cost Center Unit Multiline
			curstatushdr		Current Status Header.Values A-Active,I-Inactive
			effectivedatehdr	datetime	Effective Date Header
			expirydatehdr		Expiry Date Header
			levelnumber	int	Level Number
			parentcostcenter	sql_variant	Parent Cost Center
			parentdescription		Parent Description
			structuredescription		Structured Description
			structureid		Structure Id
			typedesc		Type Description
			guid		Guid
			traversed_flag		Traversed Flag
	mac_repmac_cestr_tmp		budesc		Budget Descripiton
			cestrfrom		Cost Exchange Starts From
			cestrto		Cost Exchange Starts To
			cefrom		Cost Exchange From
			ceto		Cost Exchange To
			curstatus		Current Status.Values A-Active,I-Inactive
			ma_variable		Variable
			ma_ouid	int	Organization Unit Id
			formulacont	sql_variant	Formula Condition
			formuladesc		Formula Description
			formulaid		Formula Id
			printnn		Print Number
			reversenn		Reverse Number
			roundoffnn		Round Off Number
			rowdesc		Row Description
			rowid		Row Id
			structuredesc		Structure Description
			structureid		Structure Id
			rowflag		Row Flag
			typedesc		Type Description
			guid		Guid