cbud

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	bgtcestk_tmp		center_no	sql_variant	Center Number	No	No
			element_no		Element Number
			stock_no		Stock Number
			stock_var		Stock Variant
			tot_qty	bigint	Total Quantity
			fix_cost		Fixed Cost
			var_cost		Variant Cost
			tot_cost		Total Cost
			var_cost_portion		Variant Cost Portion
			start_date	datetime	Start Date
			end_date		End Date
			ma_guid	sql_variant	Management Account Guid
	bud_ac_ia_bud_tmp				Guid
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
	bud_cc_ce_tmp		ma_guid	sql_variant	Guid
			costcenter		Cost Center
			costelement		Cost Element
	cbud_notes_his	To store history information about the notes attached in the system.	ma_ou_id	int	Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_status	sql_variant	Status.Values F-Fresh,A-Active,I-Inactive
			ma_timestamp	int	Time Stamp
			ma_stdnotesid	sql_variant	Standard Notes Id
			ma_stdnotesiddesc		Standard Notes Id Description
			ma_notes_desc		Notes Description
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
	cbud_notes_mst	To store information about the notes attached in the system.	ma_ou_id	int	Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_status	sql_variant	Status.Values P-Posted,U-Unposted.
			ma_timestamp	int	Time Stamp
			ma_stdnotesid	sql_variant	Standard Notes Id
			ma_stdnotesiddesc		Standard Notes Id Description
			ma_notes_desc		Notes Description
			ma_createdby		Created By
			ma_createddate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifieddate	datetime	Modified Date
	cbud_parameters	To store systems parameters for CBUD.	ma_company_code	sql_variant	Company Code
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_component_id		Component Id
			ma_param_group		Parameter Group
			ma_param_var		Parameter Variant
			ma_param_value		Parameter Value
			ma_param_desc		Parameter Description
			ma_status		Status.Values P-Posted,U-Unposted.
			ma_lang_id	int	Language Id
			ma_ver_flag	sql_variant	Verification Flag
			ma_created_date	datetime	Created Date
			ma_created_by	sql_variant	Created By
			ma_modified_by		Modified By
			ma_modified_date	datetime	Modified Date
	itm_tmp_search_results		tmp_guid	sql_variant	Guid
			tmp_itemcode		Item Code
			tmp_stockuom		Stock Unit Of Measurement
			tmp_item_desc		Item Description
	mac_aap_temp		ma_company_code		Company Code
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_act_elem_no		Actual Element Number
			ma_cost_type		Cost Type
			ma_nor_elem_no		Normal Element Number
			ma_wgt_factor	bigint	Weight Factor
			ma_guid	sql_variant	Guid
	mac_activity_normal_mapping	To store component activity mapping	ma_company_code		Company Code
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_act_elem_no		Actual Element  Number
			ma_cost_type		Cost Type
			ma_nor_elem_no		Number
			ma_wgt_factor	bigint	Weight Factor
			ma_created_by	sql_variant	Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modfied By
			ma_modified_date	datetime	Modfied Date
			ma_timestamp	int	Time Stamp
			ma_status	sql_variant	Status.Values F-Fresh,A-Active,I-Inactive
	mac_apply_criteria_tmp		ma_apply_criteria		Apply Criteria
			ma_guid		Guid
	mac_bgt_accprd_tmp		cnt	int	Count
			ma_acc_yr_no	sql_variant	Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_guid		Accounting Guid
	mac_bud_actuals_tmp		center_no		Center Number
			element_no		Element Number
			stock_no		Stock Number
			stock_var		Stock Variant
			qty_perday	bigint	Quantity Per Day
			amount_perday		Amount Per Day
			varamount		Variant Amount
			acc_yr_no	sql_variant	Accounting Year Number
			acc_prd_no		Accounting Period Number
			start_date	datetime	Start Date
			end_date		End Date
			ma_guid	sql_variant	Management Accounting Guid
	mac_bud_consolidate_tmp1		ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_guid	sql_variant	Guid
	mac_bud_consolidate_tmp2		ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_guid	sql_variant	Guid
	mac_bud_use_his	To store history information of budget usage.	ma_company_no		Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_appl_ou	int	Apply Organization Unit
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_budget_desc	sql_variant	Budget Description
			ma_budget_resp		Budget Responsibility
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_budget_type	sql_variant	Budget Type
			ma_budget_for		Budget For
			ma_default_flag		Default Flag
			ma_aggr_flag		Aggree Flag
			ma_bud_gen_flag		Budget Generation Flag
			ma_created_by		Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	mac_budget_detail	To store Budget details.	ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_appl_ou	int	Applicable Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_center_no	sql_variant	Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_quantity	bigint	Quantity
			ma_fix_amount		Fix Amount
			ma_var_amount		Variance Amount
			ma_created_by	sql_variant	Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			ma_var_flex	bigint	Flex Variance Option
			ma_var_proportion		Variance Proportion
	mac_budget_detail_tmp		ma_center_no	sql_variant	Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_acc_yr_no		Accounting  Year Number
			ma_acc_prd_no		Accounting  Period Number
			ma_quantity	bigint	Quantity
			ma_fix_amount		Fix Amount
			ma_var_amount		Variance Amount
			ma_var_proportion		Variance Proportion
			ma_var_rate		Variance Rate
			ma_guid	sql_variant	Guid
			ma_acc_prdml		Period Multiline
			ma_budspanml		Multiline
			ma_var_flex	bigint	Variance Flexible
	mac_budget_dist_tmp		ma_guid	sql_variant	Guid
			ma_dist_status		Status.Values  F-Fresh,A-Active,I-Inactive
	mac_budget_edit	To store editing details for budget.	ma_company_no		Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Management Accounting Logistics Organization Id
			ma_appl_ou	int	Applicable Oraganization Unit
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_budget_for	sql_variant	Budget For
			ma_budget_type		Budget Type
			ma_acc_prd_no		Accounting  Period Number
			ma_acc_start_date	datetime	Accounting  Start Date
			ma_acc_end_date		Accounting  End Date
			ma_edit_det	sql_variant	Edit Detail
			ma_increase_dec	bigint	Increase Descripiton
			ma_inc_dec_stat	sql_variant	Increase Descripiton Status
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_created_by	sql_variant	Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			ma_rangeflag	sql_variant	Range Flag
	mac_budget_header	To store Budget details.	ma_company_no		Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_appl_ou	int	Applicable Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_budget_desc	sql_variant	Budget Description
			ma_budget_resp		Budget Responsible
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_budget_type	sql_variant	Budget Type
			ma_budget_for		Budget For
			ma_default_flag		Default Flag
			ma_aggr_flag		Aggregate Flag
			ma_bud_gen_flag		Budget Generate Flag
			ma_maint_seas		Maintenance Seasions
			ma_gen_basis		Generate Basis
			ma_act_start_date	datetime	Actual Start Date
			ma_act_end_date		Actual End Date
			ma_basis_parent	sql_variant	Basis Parent
			ma_basis_version	int	Basis Version
			ma_basis_start_date	datetime	Basis Start Date
			ma_basis_end_date		Basis End Date
			ma_basis_projection	bigint	Basis Projection
			ma_status	sql_variant	Status. Value F-Fresh,A-Active,I-Inactive
			ma_base_cur		Base Currency
			ma_par_base_cur		Parallel Base Currency
			ma_created_by		Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			ma_rep_org_unit		Unit
			ma_old_status	sql_variant	Old Status.Values F-Fresh,A-Active,I-Inactive
			ma_exchange_amount	bigint	Exchange Amount
	mac_budget_header_tmp		ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_appl_ou	int	Applicable Organization Unit
			ma_budget_no	sql_variant	Logistics Budget Number
			ma_version_no	int	Version Number
			ma_budget_desc	sql_variant	Budget Descripiton
			ma_budget_resp		Budget Responsible
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_budget_type	sql_variant	Budget Type
			ma_budget_for		Budget For
			ma_default_flag		Default Flag
			ma_aggr_flag		Aggregate Flag
			ma_bud_gen_flag		Budget General Flag
			ma_maint_seas		Maintenance Seasons
			ma_gen_basis		General Basis
			ma_act_start_date	datetime	Actual Start Date
			ma_act_end_date		Actual End Date
			ma_basis_parent	sql_variant	Basis Parent
			ma_basis_version	int	Basis Version
			ma_basis_start_date	datetime	Basis Start Date
			ma_basis_end_date		Basis End Date
			ma_basis_projection	bigint	Basis Projection
			ma_status	sql_variant	Status. Value F-Fresh,A-Active,I-Inactive
			ma_base_cur		Base Currency
			ma_par_base_cur		Parallel Base Curency
			ma_created_by		Created By
			ma_created_date	datetime	Created Date
			ma_guid	sql_variant	Guid
			ma_rep_org_unit	int	Reporting Organization Unit
	mac_budget_ranges	To store budget ranges	ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_appl_ou	int	Applicable Organization Unit
			ma_budget_no	sql_variant	Budget Organization Unit
			ma_version_no	int	Version Number
			ma_cc_struc_id	sql_variant	Cost Center Structure Id
			ma_cc_from		Cost Center From
			ma_cc_to		Cost Center To
			ma_entry_point		Entry Point
			ma_ce_struc_id		Cost Exchange Structure Id
			ma_ce_from		Cost Center From
			ma_ce_to		Cost Center To
			ma_item_ou	int	Item Organization Unit
			ma_item_group	sql_variant	Item Group
			ma_item_from		Item From
			ma_item_to		Item To
			ma_var_from		Variant From
			ma_var_to		Variant To
			ma_created_by		Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
	mac_budget_sa_tmp		ma_gu_id	sql_variant	Guid
			ma_acc_prd_seq	int	Accounting Period Sequence
			ma_acc_prd_des	sql_variant	Accounting Period Destination
	mac_cc_ce_tmp		center_no		Center Number
			element_no		Element Number
			ma_guid		Guid
	mac_cc_ce_vali_temp		ma_ou_id	int	Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Verison Number
			ma_center_no	sql_variant	ManCenter Number
			ma_element_no		Element Number
			ma_flag		Flag
			ma_guid		Guid
	mac_cc_tmp		center_no		Center Number
			traversed_flag		Traversed Flag
			ma_guid		Guid
	mac_ce_tmp		element_no		Element Number
			ma_guid		Guid
	mac_cons_bgtdtl_tmp		center_no		Center Number
			element_no		Element Number
			stock_no		Stock Number
			stock_variant		Stock Variant
			acc_yr_no		Accounting Year Number
			acc_prd_no		Accounting Period Number
			quantity	bigint	Quantity
			fix_amount		Fix Amount
			var_amount		Variant Amount
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_guid	sql_variant	Guid
	mac_cons_ccce_tmp		center_no		Center Number
			element_no		Element Number
			acc_yr_no		Accounting Year Number
			acc_prd_no		Accounting Period Number
			quantity	bigint	Quantity
			amount		Amount
			varamt		Variant Amount
			rowcnt	int	Row Count
			traversal_cnt	sql_variant	Traversal Count
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_guid	sql_variant	Guid
	mac_consolidate_budget_tmp		ma_ou_id	int	Organization Unit Id
			ma_budget_for	sql_variant	Budget For
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_guid	sql_variant	Guid
	mac_dist_bud_tmp		startdate	datetime	Start Date
			enddate		End Date
			ma_acc_prd_no	sql_variant	Management Accounting Accounting  Period Number
			ma_seqno	int	Sequence Number
			ma_guid	sql_variant	Guid
	mac_dist_criteria_tmp		ma_ou_id	int	Organization Unit Id
			ma_appl_ou		Applicable Organization Unit
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_cc_struc_id	sql_variant	Cost Center Structure Id
			ma_cost_center		Cost Center
			ma_entry_point		Entry Point
			ma_ce_struc_id		Cost Exchange Structure Id
			ma_cost_element		Cost Element
			ma_item_group		Item Group
			ma_item_code		Item Code
			ma_item_variant		Item Variant
			ma_aggr_budget_no		Aggregate Budget Number
			ma_aggr_bud_version_no	int	Aggregate Budget  Version Number
			ma_round_off		Round Off
			ma_seasonal_id	sql_variant	Management Accounting Seasonal Id
	mac_dist_ml_save_tmp		ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_com_code		Component Code
			ma_guid		Guid
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		StockVariant
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_quantity	bigint	Quantity
			ma_amount		Amount
			ma_var_amount		Variant  Amount
			ma_var_flex		Variant Flex
			ma_var_proportion		Variant Proportion
			startdate	datetime	Start Date
			enddate		End Date
			ma_ratio	bigint	Ratio
			ma_acc_prd_no	sql_variant	Accounting Period Number
			ma_acc_yr_no		Accounting Year Number
			ma_seqno	int	Sequence Number
			ma_base_cur	sql_variant	Base Currency
			ma_par_base_cur		Parallel Base Currency
			ma_var_rate	bigint	Variant Rate
	mac_dist_ml_tmp		ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_com_code		Component Code
			ma_guid		Guid
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_quantity	bigint	Quantity
			ma_amount		Amount
			ma_var_amount		Variant Amount
			ma_var_flex		Variant Flex
			ma_var_proportion		Variant Proportion
			startdate	datetime	Start Date
			enddate		End Date
			ma_ratio	bigint	Ratio
			ma_acc_prd_no	sql_variant	Accounting Period Number
			ma_acc_yr_no		Accounting Year Number
			ma_seqno	int	Sequence Number
			ma_base_cur	sql_variant	Base Currency
			ma_par_base_cur		Parallel Base Currency
			ma_var_rate	bigint	Variant Rate
	mac_flex_actuals_tmp		center_no	sql_variant	Center Number
			element_no		Element Number
			quantity	bigint	Quantity
			amount		Amount
			start_date	datetime	Start Date
			end_date		End Date
			ma_guid	sql_variant	Guid
	mac_flex_bae_tmp
			ma_cost_center		Cost Center
			ma_cost_element		Cost Element
	mac_flex_bu_tmp		guid		Guid
			buid		Business Unit Id
			ou_id	int	Organization Unit Id
	mac_flex_bud_rep_det_tmp		ma_guid	sql_variant	Guid
			ma_company_no		Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_center_no	sql_variant	Center Number
			ma_center_desc		Center Description
			ma_element_no		Element Number
			ma_element_desc		Element Description
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variance Rate
			ma_fix_cost		Fix Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			ma_var_amt	bigint	Variance Amount
			vol_var_qty		Variance Quantity
			flx_var_qty		Flexible Variance Quantity
			tot_var_qty		Total Variance Quantity
			vol_var_val		Variance Value
			flx_var_val		Flexible Variance Value
			tot_var_val		Total Variance Value
			vol_qty_per_var		Quantity Per Variance
			flx_qty_per_var		Flexible Quantity Per Variance
			tot_var_qty_per		Total Variance Per Quantity
			vol_val_per_var		Value per Variance
			flx_val_per_var		Flexible Value Per Variance
			tot_var_val_per		Total Variance Per Value
			ma_acc_yr_no	sql_variant	Accounting  Year Number
			ma_acc_prd_no		Accounting  Period Number
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp		Time Stamp
	mac_flex_cc_tmp		center_no	sql_variant	Center Number
			ma_guid		Guid
	mac_flex_view_detail_tmp
			ma_budget_no		Budget Number
			ma_version_no	int	Variant Number
			ma_acc_ml	sql_variant	Accounting  Multiline
			ma_center_no		Center Number
			ma_element_no		Element Number
	mac_flexbgt_detail_tmp		ma_center_no		Center Number
			ma_element_no		Element Number
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variance Rate
			ma_fix_cost		Fixed Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			vol_qty_per_var	bigint	Quantity per Variance
			flx_qty_per_var		Flexible Quantity Per Variance
			vol_val_per_var		Value per variance
			flx_val_per_var		Flexible Value Per Variance
			ma_guid	sql_variant	Guid
	mac_flexbgt_save_det_tmp		ma_center_no		Cenrter Number
			ma_element_no		Element Number
			ma_element_type		Element Type
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variance Rate
			ma_fix_cost		Fix Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			ma_var_amt	bigint	Variance Amount
			vol_var_qty		Varaince Quantity
			flx_var_qty		Flexible Variance Quantity
			tot_var_qty		Total Variance Quantity
			vol_var_val		Variance Value
			flx_var_val		Flexible Variance Value
			tot_var_val		Total Variance Value
			vol_qty_per_var		Quantity per Variance
			flx_qty_per_var		Flexible Quantity Per Variance
			tot_var_qty_per		Total  Variant Per Quantity
			vol_val_per_var		Value per Variance
			flx_val_per_var		Flexible Value Per Variance
			tot_var_val_per		Total Variance Per Value
			ma_guid	sql_variant	Guid
	mac_flexbgt_save_detail_tmp		ma_center_no		Center Number
			ma_element_no		Element Number
			ma_element_type		Element Type
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		BAE Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variance Rate
			ma_fix_cost		Fixed Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			ma_var_amt	bigint	Variance Amount
			vol_var_qty		Variance Quantity
			flx_var_qty		Flexible Variance Quantity
			tot_var_qty		Total Variantce Quantity
			vol_var_val		Variance Value
			flx_var_val		Flexible Variance Value
			tot_var_val		Total Variance Quantity
			vol_qty_per_var		Quantity per Variance
			flx_qty_per_var		Flexible Quantity Per Variance
			tot_var_qty_per		Total Variance Per Quantity
			vol_val_per_var		Value per variance
			flx_val_per_var		Flexible Value Per Variance
			tot_var_val_per		Total  Variance  Per Value
			ma_guid	sql_variant	Guid
	mac_flexbud_actuals	To store budget actuals	ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			center_no	sql_variant	Center Number
			element_no		Element Number
			quantity	bigint	Quantity
			amount		Amount
			start_date	datetime	Start Date
			end_date		End Date
	mac_flexible_budget_det_tmp		ma_guid	sql_variant	Guid
			ma_company_no		Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_center_no	sql_variant	Center Number
			ma_element_no		Element Number
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variant Rate
			ma_fix_cost		Fixed Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			vol_qty_per_var	bigint	Quantity per Variance
			flx_qty_per_var		Flexible Quantity Per Variant
			vol_val_per_var		Value per variance
			flx_val_per_var		Flexible Value Per Variant
			ma_acc_yr_no	sql_variant	Year Number
			ma_acc_prd_no		Period Number
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp		Time Stamp
	mac_flexible_budget_detail	To store flexible budget details	ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_center_no	sql_variant	Center Number
			ma_element_no		Element Number
			ma_BAE_flag		Flag
			ma_act_qty	bigint	Actual Quantity
			ma_act_val		Actual Value
			ma_BAE_bgt_qty		Budget Quantity
			ma_bgt_qty		Budget Quantity
			ma_bgt_val		Budget Value
			ma_var_rate		Variance Rate
			ma_fix_cost		Fix Cost
			ma_flex_qty		Flexible Quantity
			ma_flex_val		Flexible Value
			ma_BAE_flex_qty		Flexible Quantity
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_BAE_no	sql_variant	Budget Number
			ma_var_amt	bigint	Management Accounting Variance Amount
			vol_var_qty		Variance Quantity
			flx_var_qty		Flexible Variance Quantity
			tot_var_qty		Total Variance Quantity
			vol_var_val		Variance Value
			flx_var_val		Flexible Variance Value
			tot_var_val		Total Variance Value
			vol_qty_per_var		Quantity per variance
			flx_qty_per_var		Flexible Quantity Per Variance
			tot_var_qty_per		Total Variance Per Quantity
			vol_val_per_var		Value per variance
			flx_val_per_var		Flexible Value Per Variance
			tot_var_val_per		Total Variance Per Value
			ma_acc_yr_no	sql_variant	Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp		Time Stamp
	mac_flexible_budget_header		ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_budget_no		Budget Number
			ma_version_no	int	Version Number
			ma_individual_per_var	sql_variant	Individual Per Variance
	mac_item_tmp		item_no		Item Number
			item_variant		Item Variant
			ma_guid		Guid
	mac_period_details_tmp
			ma_acc_prd_no		Accounting Period Number
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
	mac_seasonal_adaptation	To Store Seasonal adaptation	ma_company_no	sql_variant	Company Number
			ma_bu_id		Business Unit Id
			ma_ou_id	int	Organization Unit Id
			ma_lo_id	sql_variant	Logistics Organization Id
			ma_seasonal_id		Seaonal Id
			ma_sea_desc		Seaonal Description
			ma_accprd_no		Account Period Number
			ma_ratio	bigint	Ratio
			ma_created_by	sql_variant	Created By
			ma_created_date	datetime	Created Date
			ma_modified_by	sql_variant	Modified By
			ma_modified_date	datetime	Modified Date
			ma_timestamp	int	Time Stamp
			ma_del_status	sql_variant	Deleted Status.Values F-Fresh,A-Active,I-Inactive
			stdnoteid		Standard Notes Id
			stdnotedes		Standard Notes Id Description
			notes		Notes
	mac_sou_tgt_prd_tmp		seq_no	int	Sequence Number
			s_start_date	datetime	Source Start Date
			s_end_date		Source End Date
			s_acc_yr_no	sql_variant	Source Account Year Number
			s_acc_prd_no		Source Account Period Number
			t_start_date	datetime	Target Start Date
			t_end_date		Target End Date
			ma_guid	sql_variant	Guid
	mac_source_periods_tmp		s_seq_no	int	Source Sequence Number
			s_type	sql_variant	Source Type
			s_acc_yr_no		Source Account Year Number
			s_acc_prd_no		Source Account Period Number
			s_start_date	datetime	Source Start Date
			s_end_date		Source End Date
			ma_guid	sql_variant	Guid
	mac_target_periods_tmp		t_seq_no	int	Target Sequence Number
			t_start_date	datetime	Target Start Date
			t_end_date		Target End Date
			ma_guid	sql_variant	Guid