MAC Incorporation

MAC Incorporation

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_inc_error_log	To Stote errors in Log table	incorp_option	sql_variant	Incorporation Option	No	No
			tran_ou		Transaction Organization Unit
			fb_id		Finance Book Id
			bfg_id		Business Function Group Id
			tran_type		Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			quantity	bigint	Quantity
			uom	sql_variant	Unit Of Measurement
			base_amount	bigint	Base Amount
			cost_center	sql_variant	Cost Center
			cost_element		Cost Element
			reason		Reason
dbo	MAC_TRAN_BALANCE	To Store Details for Transactions Balance	OU_ID	decimal(10)	Organization Unit Id
			COMPANY_CODE	varchar(10)	Company Code
			LOGIN_OU	decimal(10)	Login Organization Unit
			LO_ID	varchar(20)	Logistics Organization Id
			BU_ID		Business Unit Id
			TRAN_OU	decimal(10)	Transaction Organization Unit
			FB_ID	varchar(20)	Finance Book Id
			MA_ACC_YR_NO	varchar(15)	Accounting Year Number
			MA_ACC_PRD_NO		Accounting Period Number
			MA_CENTER_NO	varchar(32)	Center Number
			MA_ELEMENT_NO		Element Number
			MA_STOCK_NO		Stock Number
			MA_STOCK_VARIANT	varchar(4)	Stock Variant
			MA_OP_BAL_QTY	decimal(28,8)	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	decimal(10)	User Id
			MA_DATETIME	datetime	Date Time
			MA_TIMESTAMP	decimal(10)	Time Stamp
	mac_transactions	To Store Details for Transactions	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	Orgin 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 Function Group
			ma_rev_date	datetime	Reverse Date
			ma_rev_remarks	sql_variant	Reverse Remarks
			ma_rev_vouch_no		Reverse Voucher Number
			doc_status		Document Status.Values U-Fresh,A-Active,I-Inactive
	mac_analysis_balance		ou_id	int
			company_code	sql_variant
			login_ou	int
			lo_id	sql_variant
			bu_id
			tran_ou	int
			fb_id	sql_variant
			ma_acc_yr_no
			ma_acc_prd_no
			ma_from_cc
			ma_from_ce
			ma_to_cc
			ma_to_ce
			ma_amount	bigint
			ma_par_bas_amount
			ma_datetime	datetime
	mac_analysis_transactions		ou_id	int
			login_ou
			lo_id	sql_variant
			bu_id
			tran_ou	int
			fb_id	sql_variant
			company_code
			tran_no
			ma_mactran_no
			ma_tran_date	datetime
			ma_from_cc	sql_variant
			ma_from_ce
			ma_to_cc
			ma_to_ce
			ma_amount	bigint
			ma_par_bas_amount
			ma_createdby	sql_variant
			ma_creationdate	datetime
			ma_modifiedby	sql_variant
			ma_modificationdate	datetime
			ma_businessfngrp	sql_variant
			ma_remarks	varchar()
dbo	MAC_BU_BALANCE	To Store Details for Business Unit Balance	LO_ID	varchar(20)	Logistics Organization Id
			BU_ID		Business Unit Id
			MA_ACC_YR_NO	varchar(15)	Accounting Year Number
			MA_ACC_PRD_NO		Accounting Period Number
			MA_CENTER_NO	varchar(32)	Center Number
			MA_ELEMENT_NO		Element Number
			MA_STOCK_NO		Stock Number
			MA_STOCK_VARIANT	varchar(4)	Stock Variant Number
			MA_OP_BAL_QTY	decimal(28,8)	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_co_balance	To Store Details for Company Balance	company_code	sql_variant	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 Balance Value