Cost Setup

Cost Setup
Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	CBUD_PARAMETERS		MA_COMPANY_CODE	varchar(10)	Company Code	No	No
			MA_OU_ID	decimal(10)	Organization Unit Id
			MA_BU_ID	varchar(20)	Business Unit Id
			MA_LO_ID		Logistics Organization Id
			MA_COMPONENT_ID		Component Id
			MA_PARAM_GROUP	varchar(4)	Parameter Group
			MA_PARAM_VAR		Parameter Variant
			MA_PARAM_VALUE	varchar(30)	Parameter Value
			MA_PARAM_DESC	varchar(255)	Parameter Description
			MA_STATUS	varchar(1)	Status.Values Y- Yes,N- No
			MA_LANG_ID	decimal(10)	Language Id
			MA_VER_FLAG	varchar(1)	Verification Flag
			MA_CREATED_DATE	datetime	Created Date
			MA_CREATED_BY	varchar(40)	Created By
			MA_MODIFIED_BY		Modified By
			MA_MODIFIED_DATE	datetime	Modified Date
	mac_acc_ce_cc_mapping	To Map Normal/Allocation Cost Elements	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			account_no		Account Number
			element_no		Element Number
			center_no		Center Number
			effective_date	datetime	Effective Date
			expiry_date		Expiry Date
			user_id	int	User Id
			mod_datetime	datetime	Modified Date Time
			timestamp	int	Time Stamp
			bu_id	sql_variant	Business Unit Id
	mac_acc_period_tmp		acc_prd_no		Accounting Period Number
			acc_prd_desc		Accounting Period Description
			start_date	datetime	Start Date
			end_date		End Date
			status	sql_variant	Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			host_id	int	Host Id
			ma_status	sql_variant	Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			ma_guid		Guid
	mac_acc_tmp		ma_cost_center		Cost Center
			ma_cost_element		Cost Element
			ma_acc_no		Number
			ma_eff_date	datetime	Effective Date
			ma_exp_date		Expiry Date
			ma_guid	sql_variant	Guid
			company_code		Company Code
			bu_id		Business Unit Id
	mac_accounting_period	To create MAC Calender	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_acc_prd_desc		Accounting Period Description
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_status	sql_variant	Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
	mac_accounting_year		ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_acc_yr_no		Accounting Year Number
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_status	sql_variant	Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modify Date
			ma_year_desc	sql_variant	Year Description
			bu_id		Business Unit Id
			lo_id		Logistics Organization Id
	mac_act_norm_amt_tmp		nor_elem_no		Normal Element Number
			wgt_factor	bigint	Weightage Factor
			amount		Amount
			guid	sql_variant	Guid
	mac_activity_normal_mapping	To Activate / Inactivate AAP	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		Accounting Element Number
			ma_cost_type		Cost Type
			ma_nor_elem_no		Normal Element Number
			ma_wgt_factor	bigint	Weightage Factor
			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_status	sql_variant	Status.Values F-Fresh,A-Active,I-Inactive
	mac_ap_status_tmp		ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_acc_prd_desc		Accounting Period Description
			ma_start_date	datetime	Start Date
			ma_end_date		End Date
			ma_status	sql_variant	Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			ma_fin_guid		Guid
	mac_as_acctlist_vw_tmp_tbl	To store temporary data for generating Normal Cost Elements	guid
			accgroupdesc		Account Group Description
			acctcode		Account Code
			acctdesc		Account Description
			comp_code		Component Code
	mac_bu_balance	To Store Details for Business Unit Balance	lo_id		Logistics Organization Id
			bu_id		Business Unit Id
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_op_bal_qty	bigint	Opening Balance Quantity
			ma_op_bal_val		Opening Balance Value
			ma_op_par_bas_bal_val		Opening Parallel Base Balance Value
			ma_curr_bal_qty		Current Balance Quantity
			ma_curr_bal_val		Current Balance Value
			ma_curr_par_bas_bal_val		Current Parallel Base Balance Value
	mac_budget_detail	Table used to store the Budget detail	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	Variance Flexible
			ma_var_proportion		Variance Proportion
	mac_budget_header_tmp1		ma_ou_id	int	Organization Unit Id
			ma_budget_no	sql_variant	Budget Number
			ma_version_no	int	Version Number
			ma_ouname	sql_variant	Organization Unit Name
			ma_aggr_flag		Aggregate Flag
			ma_budget_for		Budget For
			ma_budget_type		Budget Type
			ma_budget_resp		Budget Responsibility
			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		General Basis
			ma_incr_decr	bigint	Increment Description
			ma_maint_seas	sql_variant	Maintain Season Adaptation
			ma_basis_parent		Basis Parent
			ma_basis_version	int	Basis Version
			ma_guid	sql_variant	Guid
	mac_budget_ranges	To store the details of Budget for cost center-Structure id combination mapped to the company.	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
			ma_budget_no	sql_variant	Budget Number
			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 Element Structure Id
			ma_ce_from		Cost Element From
			ma_ce_to		Cost Element 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		Variance From
			ma_var_to		Variance 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_bulk_ord_var_fill_tmp		ma_company_no	sql_variant	Company Number
			ma_location_no		Location Number
			ma_order_type		Order Type
			ma_order_no		Order Number
			ma_total_output_amt	bigint	Total Output Amount
			ma_total_input_amt		Total Input Amount
			ma_variance_perc		Variance Percentage
			ma_variance_value		Variance Value
			ma_work_flag	sql_variant	Work Flag
			ma_guid		Guid
	mac_bulk_order_tmp		ma_company_no		Company Number
			ma_location_no		Location Number
			ma_order_type		Order Type
			ma_order_no		Order Number
			ma_est_plan_eff_flag		Estimate Planning Effective Flag
			ma_version_no	int	Version Number
			ma_order_desc	sql_variant	Order Description
			ma_order_status		Order Status.Values F-Fresh,A-Active,I-Inactive
			ma_order_date	datetime	Order Date
			ma_close_date		Close Date
			ma_settle_date		Settlement Date
			ma_work_flag	sql_variant	Work Flag
			ma_guid		Guid
	mac_cc_ce_bunch_mapping_tmp		ma_center_no		Center Number
			ma_element_no		Element Number
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_host_id	int	Host Id
			ma_guid	sql_variant	Guid
	MAC_CC_CE_TMP		CENTER_NO	varchar(32)	Center Number
			ELEMENT_NO		Element Number
			MA_GUID	varchar(40)	Guid
	MAC_CC_TMP		CENTER_NO	varchar(32)	Center Number
			TRAVERSED_FLAG	varchar(1)	Traversed Flag
			MA_GUID	varchar(40)	Guid
	mac_ce_acc_bunch_mapping_tmp		ma_element_no	sql_variant	Element Number
			ma_account_no		Account Number
			ma_host_id	int	Host Id
			ma_center_no	sql_variant	Center Number
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_guid	sql_variant	Guid
	mac_ce_map_na_def_tmp		guid
			cost_element		Cost Element
			ce_description		Cost Element Description
			ce_type		Cost Element Type
			effective_date	datetime	Effective Date
			expiry_date		Expiry Date
			behaviour	sql_variant	Behaviour
			trace		Trace
	mac_ce_struc_dtl	To store cost element structure	ma_structure_id		Structure Id
			ma_company_code		Company Code
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_row_id		Row Id
			ma_line_no	int	Line Number
			ma_parent_id	sql_variant	Parent Id
			ma_row_flag		Row Flag
			ma_group_detail	nchar(1)	Group Detail
			ma_desc	sql_variant	Description
			ma_from_element		From Element
			ma_to_element		To Element
			ma_variable		Variable
			ma_sign_flag		Sign Flag
			ma_round_off	int	Round Off
			ma_print_yn	sql_variant	Prin Year
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
	mac_ce_struc_hdr		ma_structure_id	sql_variant	Structure Id
			ma_company_code		Company Code
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_eff_date	datetime	Effective Date
			ma_exp_date		Expiry Date
			ma_structure_desc	sql_variant	Structure Description
			ma_user_id		User Id
			ma_guid		Guid
			ma_status		Status.Values A-Active,I-InActive
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	mac_ce_struc_tmp		ma_structure_id	sql_variant	Business Structure Id
			ma_guid		Guid
			ma_row_id		Row Id
			ma_line_no	int	Line Number
			ma_parent_id	sql_variant	Parent Id
			ma_row_flag		Row Flag
			ma_group_detail		Group Detail
			ma_desc		Description
			ma_from_element		From Element
			ma_to_element		To Element
			ma_variable		Variable
			ma_sign_flag		Sign Flag
			ma_round_off	int	Round Off
			ma_print_yn	sql_variant	Print Yes Or No
	mac_ce_struc_tree_tmp		ma_guid		Guid
			ma_flag		Flag
	mac_center_activity_mapping	To maintain details of cost center,activity.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_activity_flag		Activity Flag
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_behaviour	sql_variant	Behaviour
			ma_budget_no		Budget Number
			ma_budget_type		Budget Type
			ma_standard_rate	bigint	Standard Rate
			ma_alternate_rate1		Alternate Rate1
			ma_alternate_rate2		Alternate Rate2
			ma_alternate_rate3		Alternate Rate3
			ma_alternate_rate4		Alternate Rate4
			ma_alternate_rate5		Alternate Rate5
			ma_alternate_rate6		Alternate Rate6
			ma_alternate_rate7		Alternate Rate7
			ma_alternate_rate8		Alternate Rate8
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modify Date
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
			bas_act_elem		Base Actual Element
	mac_center_element_mapping	To store details of cost center ,element mapping.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_behaviour	sql_variant	Behaviour
			ma_tracebility		Traceability
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
	mac_cestruc_rtr_tmp		row_id		Row Id
			line_no	int	Line Number
			parent_id	sql_variant	Parent Id
			row_flag		Row Flag
			group_detail		Group Detail
			description		Description
			from_element		From Element
			to_element		To Element
			variable		Variable
			formtext	text	From Text
			sign_flag	sql_variant	Sign Flag
			round_off	int	Round Off
			print_yn	sql_variant	Print Yes Or No
			traversed		Traversed
			ma_guid		Guid
	mac_co_balance	To Store Details for Company Balance	company_code		Company Code
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_op_bal_qty	bigint	Opening Balance Quantity
			ma_op_bas_bal_val		Opening Base Balance Value
			ma_op_par_bas_bal_val		Opening Parallel Base Balance Value
			ma_curr_bal_qty		Current Balance Quantity
			ma_curr_bal_val		Current Balance Value
			ma_curr_par_bas_bal_val		Current Parallel Base Balance Value
			ma_op_bal_val		Opening Base Balance Value
	mac_copied_cost_center	To store details of cost center,user id mapped to the company.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_center_no		Center Number
			ma_to_company		To Company
			ma_to_location	int	To Location
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
	mac_copied_cost_element	To store details of cost center,element,user id mapped to the company.	from_ou_id		From Organization Unit Id
			from_company_code	sql_variant	From Company Code
			ma_element_no		Management Accounting Element Number
			to_ou_id	int	To Organization Unit Id
			to_company_code	sql_variant	To Company Code
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
	mac_cost_center	To store cost center details.	ou_id		Organization Unit Id
			company_code	sql_variant	Company Code
			ma_center_no		Center Number
			ma_center_leaf	nchar(1)	Center Leaf
			ma_center_sdesc	sql_variant	Short Description
			ma_center_ldesc		Long Description
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_center_resp	sql_variant	Responsibility
			ma_ctrl_acc		Control Account
			ma_center_flag		Center Flag
			ma_center_type		Center Type
			ma_par_cmpy_center		Parent Company Center
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_createdby	sql_variant	Created By
			ma_timestamp	int	Time Stamp
			ma_createdate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			ma_status	sql_variant	Status.Values A- Active, I- Inactive
			ma_org_unit	int	Organization Unit
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
	mac_cost_center_tmp		ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_center_no		Center Number
			ma_center_leaf	nchar(1)	Center Leaf
			ma_center_sdesc	sql_variant	Short Description
			ma_center_ldesc		Long Description
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_center_resp	sql_variant	Cost Center Responsibility
			ma_ctrl_acc		Control Account
			ma_center_flag		Center Flag
			ma_center_type		Center Type
			ma_par_cmpy_center		Patent Company Center
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_createdby	sql_variant	Created By
			ma_timestamp	int	Time Stamp
			ma_createdate	datetime	Created Date
			ma_modifiedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			ma_status	sql_variant	Status.Values A- Active, I - Inactive
			ma_org_unit	int	Organization Unit
			ma_guid	sql_variant	Guid
	mac_cost_element	To store cost element details.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_element_no		Element Number
			ma_element_sdesc		Cost Center Short Description
			ma_element_ldesc		Cost Center Long Description
			ma_element_type		Element Type
			ma_element_uom		Element Unit Of Measurement
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_del_status	sql_variant	Deletion Status.Values A-Active,I-InActive
			ma_status		Status.Value A- Active ,I - Inactive
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
	mac_cost_element_tmp		ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_element_no		Element Number
			ma_element_sdesc		Cost Center Short Description
			ma_element_ldesc		Cost Center Long Description
			ma_element_type		Element Type
			ma_element_uom		Element Unit Of Measurement
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_del_status	sql_variant	Deletion Status.Values A-Active,I-InActive
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			bu_id	sql_variant	Business Unit Id
			ma_guid		Guid
			ma_status		Status.Values A-Active,I-InActive
	mac_element_account_mapping	To store cost element account mapping details.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_element_no		Element Number
			ma_account_no		Account Number
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_createdate	datetime	Created Date
			ma_modifedby	sql_variant	Modified By
			ma_modifydate	datetime	Modified Date
			bu_id	sql_variant	Business Unit Id
			lo_id		Logistics Organization Id
	mac_ibu_ccce_map_tmp		ou_id	int	Organization Unit Id
			src_bu_id	sql_variant	Source Business Unit Id
			src_center_no		Source Center Number
			src_center_desc		Source Center Description
			src_element_no		Source Element Number
			src_element_desc		Source Element Description
			trg_bu_id		Target Business Unit Id
			trg_center_no		Target Center Number
			trg_center_desc		Target Center Description
			trg_element_no		Target Element Number
			trg_element_desc		Target Element Description
			map_option		Map Option
			guid		Guid
			scc_f		Source Cost Center From
			scc_t		Source Cost Center To
			scc_desc		Source Cost Center Description
			sce_f		Source Cost Exchange From
			sce_t		Source Cost Exchange To
			sce_desc		Source Cost Exchange Description
			tcc_f		Target Cost Center From
			tcc_t		Target Cost Center To
			tcc_desc		Target Cost Center Description
			tce_f		Target Cost Exchange From
			tce_t		Target Cost Exchange To
			tce_desc		Target Cost Exchange Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	mac_inter_bu_ccce_mapping	To store Inter business unit cost center cost element mapping details.	ou_id	int	Organization Unit Id
			lo_id	sql_variant	Logistics Organization Id
			bu_id		Business Unit Id
			company_code		Company Code
			src_bu_id		Source Business Unit Id
			src_center_no		Source Center Number
			src_element_no		Source Element Number
			trg_bu_id		Target Business Unit Id
			trg_center_no		Target Center Number
			trg_element_no		Target Element Number
			map_option		Map Option
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	mac_parameters	To store system parameters in MAC.	ma_company_no	sql_variant	Management Accounting Company Number
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			component_id	sql_variant	Component Id
			ma_param_group		Parameter Group
			ma_param_var		Parameter Variance
			ma_param_value		Parameter Value
			ma_param_desc		Parameter Description
			ma_status		Status.Values A-Active,I-InActive
			ma_datetime	datetime	Date Time
			ma_lang_id	int	Language Id
			ver_flag	sql_variant	Verified Flag
			created_by		Created By
			created_date	datetime	Created Date
			modified_by	sql_variant	Modified By
			modified_date	datetime	Modified Date
	mac_prd_act_transactions	To store account wise period transactions.	ma_company_no	sql_variant	Company Number
			ma_plant		Plant
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_fb_id		Finance Book Id
			ma_order_type		Order Type
			ma_order_no		Order Number
			ma_version_no		Version Number
			ma_remarks		Remarks
			ma_component_id		Component Id
			ma_item_ou		Item Organization Unit
			ma_tran_ou		Transaction Organization Unit
			ma_mat_res_flag		Resource Flag
			ma_trans_type		Transactions Type
			ma_trans_no		Transactions Number
			ma_trans_date	datetime	Transactions Date
			ma_status	sql_variant	Status.Values A-Active,I-InActive
			ma_from_cc_no		From Cost Center Number
			ma_to_cc_no		To Cost Center Number
			ma_element_no		Element Number
			ma_uom		Unit Of Measurement
			ma_io_flag		Input/Output Flag
			ma_acc_rej_flag		Accounting Rejection Flag
			ma_item_number		Item Number
			ma_item_variant		Item Variant
			ma_acty_short_desc		Activity Short Description
			ma_act_quantity	bigint	Activity Quantity
			ma_perc_finished		Percentage Finished
			ma_act_amount		Actual Amount
			ma_act_calc_rate		Actual Calculate Rate
			ma_std_qty		Standard Quantity
			ma_std_price		Standard Price
			ma_base_cur	sql_variant	Base Currency
			ma_bc_amount	bigint	Base Currency Amount
			ma_pbc_amount		Parallel Base Currency Amount
			ma_pb_cur	sql_variant	Parallel Base Currency
			ma_pbcexchrate	bigint	Parallel Base Currency Exchange Rate
			ma_rm_wip_flag	sql_variant	Resource/Material Work In Progress Flag
			ma_ps_pos_no	int	Posted Number
			ma_ps_pos_var_no		Variant Number
			ma_pp_pos_no		Number
			ma_res_reqmt_slno	sql_variant	Resource Requirement Serial Number
			ma_res_no		Resource Number
			ma_posted_to_fb		Posted To Finance Book
			ma_inc_status		Status.Values Y-Yes,N-No
			ma_level_no	int	Level Number
			ma_stage_id	sql_variant	Stage Id
			ma_acty_start_date	datetime	Activity Start Date
			ma_tgt_item_number	sql_variant	Target Item Number
			ma_tgt_item_variant		Target Item Variant
			ma_rev_tran_no		Reversal Transaction Number
			ma_rev_tran_date	datetime	Reversal Transaction 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_guid	sql_variant	Guid
	mac_prd_est_transactions	To store periodwise transaction details.	ma_company_no		Company Number
			ma_plant		Plant
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_fb_id		Finance Book Id
			ma_order_type		Order Type
			ma_order_no		Order Number
			ma_version_no		Version Number
			ma_remarks		Remarks
			ma_component_id		Component Id
			ma_item_ou		Item Organization Unit
			ma_tran_ou		Transaction Organization Unit
			ma_mat_res_flag		Resource Flag
			ma_trans_type		Transaction Type
			ma_trans_no		Transaction Number
			ma_trans_date	datetime	Transaction Date
			ma_status	sql_variant	Status.Values A-Active,I-InActive
			ma_from_cc_no		From Cost Center Number
			ma_to_cc_no		To Cost Center Number
			ma_element_no		Element Number
			ma_uom		Unit Of Measurement
			ma_io_flag		Input / Output Flag
			ma_acc_rej_flag		Accounting Rejection Flag
			ma_item_number		Item Number
			ma_item_variant		Item Variant
			ma_acty_short_desc		Activity Short Description
			ma_act_quantity	bigint	Actual Quantity
			ma_perc_finished		Percentage Finished
			ma_act_amount		Actual Amount
			ma_act_calc_rate		Actual Calculation Rate
			ma_std_qty		Standard Quantity
			ma_std_price		Standard Price
			ma_base_cur	sql_variant	Base Currency
			ma_bc_amount	bigint	Base Currency Amount
			ma_pbc_amount		Parallel Base Currency Amount
			ma_pb_cur	sql_variant	Parallel Base Currency
			ma_pbcexchrate	bigint	Parallel Base Currency Exchange Rate
			ma_rm_wip_flag	sql_variant	Resource/Material Work In Progress Flag
			ma_ps_pos_no	int	Number
			ma_ps_pos_var_no		Variance Number
			ma_pp_pos_no		Number
			ma_res_reqmt_slno	sql_variant	Resource Requirement Serial Number
			ma_res_no		Resource Number
			ma_posted_to_fb		Posted To Finance Book
			ma_inc_status		Status.Values Y-Yes,N-No
			ma_level_no	int	Level Number
			ma_stage_id	sql_variant	Stage Id
			ma_acty_start_date	datetime	Activity Start Date
			ma_tgt_item_number	sql_variant	Target Item Number
			ma_tgt_item_variant		Target Item Variant
			ma_rev_tran_no		Reversal Transaction Number
			ma_rev_tran_date	datetime	Reversal Transaction 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_guid	sql_variant	Guid
	mac_prd_plan_transactions	To store periodwise planning transaction details.	ma_company_no		Company Number
			ma_plant		Plant
			ma_ou_id	int	Organization Unit Id
			ma_bu_id	sql_variant	Business Unit Id
			ma_lo_id		Logistics Organization Id
			ma_fb_id		Finance Book Id
			ma_order_type		Order Type
			ma_order_no		Order Number
			ma_version_no		Version Number
			ma_remarks		Remarks
			ma_component_id		Component Id
			ma_item_ou		Item Organization Unit
			ma_tran_ou		Transaction Organization Unit
			ma_mat_res_flag		Resource Flag
			ma_trans_type		Transaction Type
			ma_trans_no		Transaction Number
			ma_trans_date	datetime	Transaction Date
			ma_status	sql_variant	Status.Values A-Active,I-InActive
			ma_from_cc_no		From Cost Center Number
			ma_to_cc_no		To Cost Center Number
			ma_element_no		Element Number
			ma_uom		Unit Of Measurement
			ma_io_flag		Input/Output Flag
			ma_acc_rej_flag		Accounting Rejection Flag
			ma_item_number		Item Number
			ma_item_variant		Item Variant
			ma_acty_short_desc		Activity Short Description
			ma_act_quantity	bigint	Actual Quantity
			ma_perc_finished		Percentage Finished
			ma_act_amount		Actual Amount
			ma_act_calc_rate		Actual Calculation Rate
			ma_std_qty		Standard Quantity
			ma_std_price		Standard Price
			ma_base_cur	sql_variant	Base Currency
			ma_bc_amount	bigint	Base Currency Amount
			ma_pbc_amount		Parallel Base Currency Amount
			ma_pb_cur	sql_variant	Parallel Base Currency
			ma_pbcexchrate	bigint	Parallel Base Currency Exchange Rate
			ma_rm_wip_flag	sql_variant	Resource/Material Work In Progress Flag
			ma_ps_pos_no	int	Variance Number
			ma_ps_pos_var_no		Number
			ma_pp_pos_no		Posted Number
			ma_res_reqmt_slno	sql_variant	Resource Requirement Serial Number
			ma_res_no		Resource Number
			ma_posted_to_fb		Posted to Finance Book
			ma_inc_status		Status.Values Y-Yes,N-No
			ma_level_no	int	Level Number
			ma_stage_id	sql_variant	Stage Id
			ma_acty_start_date	datetime	Activity Start Date
			ma_tgt_item_number	sql_variant	Target Item Number
			ma_tgt_item_variant		Target Item Variant
			ma_rev_tran_no		Reversal Transaction Number
			ma_rev_tran_date	datetime	Reversal Transaction 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_guid	sql_variant	Guid
	mac_setparams_tmp		ma_cc_no		Cost Center Number
			ma_guid		Guid
			cc_desc		Cost Center Description
	mac_struc_dtl	To store cost center structure details.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_structure_id		Structure Id
			ma_cost_object_id		Cost Object Id
			ma_parent_object_id		Parent Object Id
			ma_level_no	int	Level Number
			ma_user_id		User Id
			ma_fin_macdate	datetime	Finance Management Accounting Date
			ma_fin_mactimestamp	int	Finance Management Accounting Time Stamp
			bu_id	sql_variant	Business Unit Id
	mac_struc_dtl_tmp		ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_structure_id		Structure Id
			ma_cost_object_id		Cost Object Id
			description		Description
			p_description		Parent Description
			ma_parent_object_id		Parent Object Id
			ma_level_no	int	Level Number
			ma_user_id		User Id
			ma_fin_macdate	datetime	Finance Management Accounting Date
			ma_fin_guid	sql_variant	Finance Guid
			del_col	int	Deletion Column
			ma_status	sql_variant	Status.Values Active,Inactive
			ma_structure_type		Structure Type
	mac_struc_hdr	To store cost center structure details.	ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			ma_structure_id		Structure Id
			ma_structure_desc		Structure Description
			ma_structure_type		Structure Type
			ma_effective_date	datetime	Effective Date
			ma_expiry_date		Expiry Date
			ma_user_id	int	User Id
			ma_fin_macdate	datetime	Finance Management Accounting Date
			ma_fin_mactimestamp	int	Finance Management Accounting Time Stamp
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			timestamp	int	Time Stamp
			ma_status	sql_variant	Status.Values A-Active ,I-Inactive
			bu_id		Business Unit Id
	MAC_TEMPTABLE		GUID	varchar(40)	Guid
			STATUS	varchar(1)	Status.Values Y-Yes, N-No
			MA_CENTER_NO	varchar(32)	Center Number
			MA_ELEMENT_NO		Element Number
			OU_ID	decimal(10)	Organization Unit Id
	mac_tran_balance	To store transaction wise balance.	ou_id	int
			company_code	sql_variant	Company Code
			login_ou	int	Login Organization Unit
			lo_id	sql_variant	Logistics Organization Id
			bu_id		Business Unit Id
			tran_ou	int	Transaction Organization Unit
			fb_id	sql_variant	Finance Book Id
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_op_bal_qty	bigint	Opening Balance Quantity
			ma_curr_bal_qty		Current Balance Quantity
			ma_op_bal_val		Opening Balance Value
			ma_op_bas_bal_val		Opening Base Balance Value
			ma_op_par_bas_bal_val		Opening Parallel Base Balance Value
			ma_curr_bal_val		Current Balance Value
			ma_curr_par_bas_bal_val		Current Parallel Base Balance Value
			ma_consolidated_qty		Consolidated Quantity
			ma_consolidated_amt		Consolidated Amount
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
	mac_transactions_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			login_ou		Login Organization Unit
			lo_id	sql_variant	Logistics Organization Id
			bu_id		Business Unit Id
			tran_ou	int	Transaction Organization Unit
			fb_id	sql_variant	Finance Book Id
			company_code		Company Code
			ma_module_type		Module Type
			ma_mactran_no		Transaction Number
			ma_tran_date	datetime	Transaction Date
			ma_remarks	sql_variant	Remarks
			ma_ref_no		Reference Number
			ma_center_no		Center Number
			ma_element_no		Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_quantity	bigint	Quantity
			ma_amount		Amount
			ma_op_bal_qty		Opening Balance Quantity
			ma_curr_bal_qty		Current Balance Quantity
			ma_op_bal_val		Opening Balance Value
			ma_op_par_bas_bal_val		Opening Parallel Base Balance Value
			ma_curr_bal_val		Current Balance Value
			ma_curr_par_bas_bal_val		Current Parallel Base Balance Value
			ma_consolidated_qty		Consolidated Quantity
			ma_consolidated_amt		Consolidated Amount
			ma_status	sql_variant	Status .Values U-Fresh,A-Active,I-Inactive
			ma_origin_locn_no	int	Origin Location Number
			ma_user_id		User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
			ma_createdby	sql_variant	Created By
			ma_creationdate	datetime	Creation Date
			ma_modifiedby	sql_variant	Modified By
			ma_modificationdate	datetime	Modification Date
			ma_businessfngrp	sql_variant	Business
			ma_rev_date	datetime	Reversal Date
			ma_rev_remarks	sql_variant	Reversal Remarks
			ma_rev_vouch_no		Reversal Voucher Number
			doc_status		Document Status.Values U-Fresh,A-Active,I-Inactive
	mac_yrprd_fbook	To store Finance ,year code ,period code and period status for the company.	ou_id	int	Organization Unit Id
			lo_id	sql_variant	Logistics Organization Id
			bu_id		Business Unit Id
			company_code		Company Code
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_prd_status		Period Status.Values C-Closed,O-Open,P-Provisionally Closed,N-Not Started,I-In Progress
			fb_id		Finance Book Id
			fb_id_status		Finance Book Id Status.Values A-Active,I-InActive
	macfb_formula_master	To store formula details.	fbmst_fb_ouinstance	int	Finance Book Organization Unit Instance
			fbmst_formula_id	sql_variant	Formula Id
			fbmst_component_ouinstance	int	Component Organization Unit Instance
			fbmst_component	sql_variant	Component
			fbmst_formula_status		Formula Status.Values A-Active,I-InActive
			fbmst_formula_desc		Formula Description
			fbmst_formula_content		Formula Content
			fbmst_usage_flag		Usage Flag
			fbmst_created_by		Created By
			fbmst_created_date	datetime	Created Date
			fbmst_modified_by	sql_variant	Modified By
			fbmst_modified_date	datetime	Modified Date
			fbmst_timestamp	int	Time Stamp
	macfb_parameter_details	To store parameters for MAC finance book.	componentname	sql_variant	Component Name
			paramcategory		Parameter Category
			paramtype		Parameter Type
			paramcode		Parameter Code
			langid	int	Langue Id
			paramdesc	sql_variant	Parameter Description
			creationdate	datetime	Creation Date
	macfb_valid_token_list	To store the information about valid token lists in the system.	tknlst_fb_ouinstance	int	Finance Book Organization Unit Instance
			tknlst_component_ouinstance		Component Organization Unit Instance
			tknlst_component	sql_variant	Component
			tknlst_token_code		Token Code
			tknlst_created_by		Created By
			tknlst_created_date	datetime	Created Date
			tknlst_modified_by	sql_variant	Modified By
			tknlst_modified_date	datetime	Modified Date
	minc_mac_tran_balance_temp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			login_ou	int	Login Organization Unit
			lo_id	sql_variant	Logistics Organization Id
			bu_id		Business Unit Id
			tran_ou	int	Transaction Organization Unit
			fb_id	sql_variant	Finance Book Id
			ma_acc_yr_no		Accounting Year Number
			ma_acc_prd_no		Accounting Period Number
			ma_center_no		Center Number
			ma_element_no		Accounting Element Number
			ma_stock_no		Stock Number
			ma_stock_variant		Stock Variant
			ma_op_bal_qty	bigint	Opening Balance Quantity
			ma_curr_bal_qty		Current Balance Quantity
			ma_op_bal_val		Opening Balance Value
			ma_op_bas_bal_val		Opening Base Balance Value
			ma_op_par_bas_bal_val		Opening Parallel Base Balance Value
			ma_curr_bal_val		Current Balance Value
			ma_curr_par_bas_bal_val		Current Parallel Base Balance Value
			ma_consolidated_qty		Consolidated Quantity
			ma_consolidated_amt		Consolidated Amount
			ma_user_id	int	User Id
			ma_datetime	datetime	Date Time
			ma_timestamp	int	Time Stamp
	uom_mas_uommaster		mas_ouinstance		Organization Unit Instance	Yes
			mas_uomcode	sql_variant	Unit Of Measurement Code
			mas_uomdesc		Unit Of Measurement Description	No
			mas_fractions	bigint	Fractions
			mas_status	sql_variant	Status.Values A-Active,I-InActive
			mas_reasoncode		Reason Code
			mas_created_by		Created By
			mas_created_date		Created Date
			mas_modified_by		Modified By
			mas_modified_date		Modified Date
			mas_timestamp	int	Time Stamp

	mac_copycc_ins_log		ouid	int	Organization Unit Instance
			sourcecc	varchar(32)	Source Cost Center
			targetcc	varchar(32)	Target Cost Center
			cpyccrd	varchar(3)	Copy Cost Center Rule Definition
			cpyccstru	varchar(3)	Copy Cost Center Structure Definition
			cpycemap	varchar(3)	Copy Center element Mapping
			createdby	varchar(15)	Created by
			createdtime	datetime	created time