Table Owner | Table Name | Table Comment | Table Column Name | Table Column Datatype | Table Column Comment | Table Column Is PK | Table Column Is FK |
---|---|---|---|---|---|---|---|
dbo | call_notes_his | History table for notes for CALL component | ou_id | int | Organization Unit Id | No | No |
  |   |   | run_no |   | Run Number |   |   |
  |   |   | sequence_no |   | Sequence Number |   |   |
  |   |   | status | sql_variant | Status.Values A-Active,I-InActive,B-Both |   |   |
  |   |   | timestamp | int | Time Stamp |   |   |
  |   |   | stdnotesid | sql_variant | Standard Note Id |   |   |
  |   |   | stdnotesiddesc |   | Standard Note Id Description |   |   |
  |   |   | notes_desc |   | Notes Description |   |   |
  |   |   | createdby |   | Created By |   |   |
  |   |   | createddate | datetime | Created Date |   |   |
  |   |   | modifiedby | sql_variant | Modified By |   |   |
  |   |   | modifieddate | datetime | Modified Date |   |   |
  | call_notes_mst | Master table for notes for CALL component | ou_id | int | Organization Unit Id |   |   |
  |   |   | run_no |   | Run Number |   |   |
  |   |   | sequence_no |   | Sequence Number |   |   |
  |   |   | status | sql_variant | Status.Values A-Active,I-InActive,B-Both |   |   |
  |   |   | timestamp | int | Time Stamp |   |   |
  |   |   | stdnotesid | sql_variant | Standard Note Id |   |   |
  |   |   | stdnotesiddesc |   | Standard Note Id Description |   |   |
  |   |   | notes_desc |   | Description |   |   |
  |   |   | createdby |   | Created By |   |   |
  |   |   | createddate | datetime | Created Date |   |   |
  |   |   | modifiedby | sql_variant | Modified By |   |   |
  |   |   | modifieddate | datetime | Modified Date |   |   |
  | call_notes_tmp | timestamp | int | Time Stamp |   |   | |
  |   | notes_id | sql_variant | Notes Id |   |   | |
  |   | notes_desc |   | Notes Description |   |   | |
  |   | notes |   | Notes |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | createdby |   | Created By |   |   | |
  |   | createddate | datetime | Created Date |   |   | |
  |   | modifiedby | sql_variant | Modified By |   |   | |
  |   | modifieddate | datetime | Modified Date |   |   | |
  | call_parameters | System Parameters table for CALL component | ma_company_code | sql_variant | Management Accounting Company Code |   |   |
  |   |   | ma_ou_id | int | Organization Unit |   |   |
  |   |   | ma_bu_id | sql_variant | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistic Organization Id |   |   |
  |   |   | ma_component_id |   | Component I d |   |   |
  |   |   | 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 |   |   |
  | FIN_REPORT_PARAM_DTL | Parameters table for CALL component | rpd_language_id | int | Language Id |   |   |
  |   |   | rpd_ou_id |   | Organization Unit Id |   |   |
  |   |   | rpd_company_code | sql_variant | Company Code |   |   |
  |   |   | rpd_component_id |   | Component Id |   |   |
  |   |   | rpd_activity_name |   | Activity Name |   |   |
  |   |   | rpd_report_name |   | Detail Name |   |   |
  |   |   | rpd_parameter_category |   | Category |   |   |
  |   |   | rpd_parameter_code |   | Parameter Code |   |   |
  |   |   | rpd_report_detail |   | Report Detail |   |   |
  |   |   | rpd_sequence_no | int | Sequence Number |   |   |
  |   |   | rpd_report_type | sql_variant | Report Type |   |   |
  |   |   | rpd_dtl_status |   | Detail  Status. Values A - Active, I - Inactive |   |   |
  |   |   | rpd_remarks |   | Detail Remarks |   |   |
  |   |   | rpd_timestamp | int | Time Stamp |   |   |
  |   |   | rpd_createdby | sql_variant | Created By |   |   |
  |   |   | rpd_createddate | datetime | Created Date |   |   |
  |   |   | rpd_modifiedby | sql_variant | Modified By |   |   |
  |   |   | rpd_modifieddate | datetime | Modified Date |   |   |
  | FIN_REPORT_PARAM_HDR |   | rph_component_id | sql_variant | Component Id |   |   |
  |   |   | rph_parameter_type |   | Parameter Type |   |   |
  |   |   | rph_parameter_category |   | Parameter Category |   |   |
  |   |   | rph_parameter_code |   | Parameter Code |   |   |
  |   |   | rph_parameter_text |   | Parameter Text |   |   |
  |   |   | rph_timestamp | int | Time Stamp |   |   |
  |   |   | rph_language_id |   | Language Id |   |   |
  |   |   | rph_extension_flag | sql_variant | Extension Flag |   |   |
  |   |   | rph_sequence_no | int | Sequence Number |   |   |
  |   |   | rph_createdby | sql_variant | Created By |   |   |
  |   |   | rph_createddate | datetime | Created Date |   |   |
  |   |   | rph_modifiedby | sql_variant | Modified By |   |   |
  |   |   | rph_modifieddate | datetime | Modified Date |   |   |
  | FIN_REPORT_PARAM_MAP | Parameter Mapping table for CALL component | rpm_language_id | int | Language Id |   |   |
  |   |   | rpm_ou_id |   | Organization Unit Id |   |   |
  |   |   | rpm_company_code | sql_variant | Company Code |   |   |
  |   |   | rpm_component_id |   | Company Id |   |   |
  |   |   | rpm_activity_name |   | Activity Name |   |   |
  |   |   | rpm_report_name |   | Report Name |   |   |
  |   |   | rpm_report_desr |   | Report Description |   |   |
  |   |   | rpm_parameter_category |   | Parameter Category |   |   |
  |   |   | rpm_parameter_code |   | Parameter Code |   |   |
  |   |   | rpm_dtl_status |   | Detail Status. Values A- Active, I-InActive |   |   |
  |   |   | rpm_timestamp | int | Time Stamp |   |   |
  |   |   | rpm_createdby | sql_variant | Created By |   |   |
  |   |   | rpm_createddate | datetime | Created Date |   |   |
  |   |   | rpm_modifiedby | sql_variant | Modified By |   |   |
  |   |   | rpm_modifieddate | datetime | Modified Date |   |   |
  | mac_accounting_period_tmp | ma_acc_yr_no | sql_variant | Accounting Year Number |   |   | |
  |   | ma_acc_prd_no |   | Accounting Period Number |   |   | |
  |   | ma_host_id |   | Accounting  Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_alloc_act_from_tmp | ma_from_id | int | From Id |   |   | |
  |   | ma_from_center | sql_variant | From Center |   |   | |
  |   | ma_from_ce |   | From Cost Element |   |   | |
  |   | ma_percent | bigint | Percentage |   |   | |
  |   | ma_update_flag | sql_variant | Update Flag |   |   | |
  |   | ma_host_id |   | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_alloc_basis | To store allocation basis details. | ma_company_code |   | Company Code |   |   |
  |   |   | ma_ou_id | int | Organization Unit Id |   |   |
  |   |   | ma_bu_id | sql_variant | Organization Business Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organisation Id |   |   |
  |   |   | ma_run_no | int | Organization Run Id |   |   |
  |   |   | ma_sequence_no |   | Sequence Number |   |   |
  |   |   | ma_acc_yr_no | sql_variant | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_basis_element |   | Basic Element |   |   |
  |   |   | ma_percentage_flag |   | Percentage Flag |   |   |
  |   |   | ma_qtyval_flag |   | Quantity Value Flag |   |   |
  |   |   | ma_actbud_flag |   | Account Budget Flag |   |   |
  |   |   | ma_budget_no |   | Account Budget Number |   |   |
  |   |   | ma_amount | bigint | Amount |   |   |
  |   |   | ma_createdate | datetime | Created Date |   |   |
  |   |   | ma_createdby | sql_variant | Created By |   |   |
  |   |   | ma_fin_macdate | datetime | Finance Management Accounting  Date |   |   |
  |   |   | ma_modified_by | sql_variant | Modified By |   |   |
  |   |   | ma_modified_date | datetime | Modified Date |   |   |
  |   |   | ma_uom | sql_variant | Unit Of Measurement |   |   |
  |   |   | ma_timestamp | int | Time Stamp |   |   |
  |   |   | ma_from_center | sql_variant | From Center |   |   |
  |   |   | ma_fb_id |   | Finance Book Id |   |   |
  | mac_alloc_basis_tmp | ma_basis_id | int | Basis Id |   |   | |
  |   | costclass | sql_variant | Cost Class |   |   | |
  |   | ma_percent | bigint | Percent |   |   | |
  |   | ma_qtyval_flag | sql_variant | Quantity Flag |   |   | |
  |   | ma_actbud_flag |   | Actual Budget Flag |   |   | |
  |   | ma_budget_no |   | Actual Budget Number |   |   | |
  |   | ma_version_no |   | Version Number |   |   | |
  |   | ma_update_flag |   | Update Flag |   |   | |
  |   | ma_host_id |   | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_alloc_cost_class_tmp | ma_to_center |   | To Center |   |   | |
  |   | ma_to_ce |   | Logistics Organisation Id |   |   | |
  |   | costclass |   | Cost Class |   |   | |
  |   | tranamt | bigint | Transaction Amount |   |   | |
  |   | ma_host_id | sql_variant | Management Accounting Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Parallel Base Balance Value |   |   | |
  | mac_alloc_from_tmp | ma_from_id | int | From Id |   |   | |
  |   | ma_from_center | sql_variant | From Center |   |   | |
  |   | ma_from_ce |   | From Cost Element |   |   | |
  |   | ma_percent | bigint | Percent |   |   | |
  |   | sequence_no | int | Sequence Number |   |   | |
  |   | table_id | sql_variant | Table Id |   |   | |
  |   | ma_update_flag |   | Update Flag |   |   | |
  |   | host_id |   | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_alloc_jrnl | To store allocation journal details. | ma_company_no |   | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organisation Id |   |   |
  |   |   | ma_ou_id | int | Organisation Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book Id |   |   |
  |   |   | ma_actbud_flag |   | Actual Budget Flag |   |   |
  |   |   | ma_budget_no |   | Actual Budget  Number |   |   |
  |   |   | ma_version_no | int | Version Number |   |   |
  |   |   | ma_acc_yr_no | sql_variant | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_run_no | int | Run Number |   |   |
  |   |   | ma_sequence_no |   | Sequence Number |   |   |
  |   |   | ma_cr_ele_flag | sql_variant | Credit Element Flag |   |   |
  |   |   | ma_tran_no | int | Transaction Number |   |   |
  |   |   | ma_from_center | sql_variant | From Center |   |   |
  |   |   | ma_from_ce |   | From Cost Element |   |   |
  |   |   | ma_to_center |   | To Center |   |   |
  |   |   | ma_to_ce |   | To Cost Element |   |   |
  |   |   | ma_tran_amt | bigint | Transaction Amount |   |   |
  |   |   | ma_user_id | sql_variant | Managemnet Accounting User Id |   |   |
  |   |   | ma_fin_macdate | datetime | Allocation Date |   |   |
  |   |   | ma_par_tran_amt | bigint | Parallel Transaction Amount |   |   |
  | mac_alloc_jrnl_from_tmp | ma_from_center | sql_variant | From Center |   |   | |
  |   | ma_from_ce |   | From Cost Element |   |   | |
  |   | ma_tran_amt | bigint | Transaction Amount |   |   | |
  |   | ma_user_id | sql_variant | User Id |   |   | |
  |   | ma_fin_macdate | datetime | Finance Date |   |   | |
  |   | guid | sql_variant | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Current Parallel Base Amount Balance Value |   |   | |
  | mac_alloc_jrnl_sum_tmp | ma_bu_id | sql_variant | Business Unit Id |   |   | |
  |   | ma_lo_id |   | Logistics Organisation Id |   |   | |
  |   | ma_ou_id | int | Organisation Id |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_center |   | Center |   |   | |
  |   | ma_element |   | Element |   |   | |
  |   | ma_tran_amt | bigint | Transaction Amount |   |   | |
  |   | ma_exist_flag | sql_variant | Exist Flag |   |   | |
  |   | ma_hostid |   | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Current Parallel Base  Balance Value |   |   | |
  | mac_alloc_second_tmp | ma_company_no | sql_variant | Company Number |   |   | |
  |   | ma_bu_id |   | Business Unit Id |   |   | |
  |   | ma_lo_id |   | Logistics Organisation Id |   |   | |
  |   | ma_ou_id | int | Organisation Uint Id |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_to_center |   | To Center |   |   | |
  |   | ma_to_ce |   | To Cost Element |   |   | |
  |   | ma_to_percent | bigint | To Percentage |   |   | |
  |   | ma_host_id | sql_variant | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Current Parallel Base Balance Value |   |   | |
  | mac_alloc_to_tmp | ma_company_no | sql_variant | Company Number |   |   | |
  |   | ma_bu_id |   | Business Unit Id |   |   | |
  |   | ma_lo_id |   | Logistic Organisation  Id |   |   | |
  |   | ma_ou_id | int | Organisation  Unit Id |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_to_center |   | To Center |   |   | |
  |   | ma_to_ce |   | To Cost Element |   |   | |
  |   | ma_to_percent | bigint | To Percent |   |   | |
  |   | ma_host_id | sql_variant | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Current Parallel Base Balance Value |   |   | |
  | mac_allocated_budget | To store allocated budget details. | ma_company_no | sql_variant | Company Number |   |   |
  |   |   | ma_location_no |   | Location Number |   |   |
  |   |   | ma_budget_no |   | 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 |   | Account Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_quantity | bigint | Quantity |   |   |
  |   |   | ma_fix_amount |   | Fix Amount |   |   |
  |   |   | ma_var_amount |   | Variant Amount |   |   |
  |   |   | ma_user_id | int | User Id |   |   |
  |   |   | ma_fin_macdate | datetime | Finance  Management Accounting  Date |   |   |
  |   |   | guid | sql_variant | Guid |   |   |
  | mac_allocations_basis_tmp | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | ma_basis_element | sql_variant | Basis Element |   |   | |
  |   | ma_budget_no |   | Budget Number |   |   | |
  |   | host_id | int | Host Id |   |   | |
  |   | ma_processed_flag | sql_variant | Processed Flag |   |   | |
  |   | ma_from_center |   | From Center |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_allocations_detail | To store allocation details. | ma_company_no |   | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organisation Id |   |   |
  |   |   | ma_ou_id | int | Organisation Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book Id |   |   |
  |   |   | ma_acc_yr_no |   | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_run_no | int | Account Run Number |   |   |
  |   |   | ma_sequence_no |   | Sequence  Number |   |   |
  |   |   | ma_to_center | sql_variant | To Center |   |   |
  |   |   | ma_to_element |   | To Element |   |   |
  |   |   | ma_percentage_flag |   | Percentage Flag |   |   |
  |   |   | ma_percentage | bigint | Percentage |   |   |
  |   |   | ma_ratio |   | Ratio |   |   |
  |   |   | ma_user_id | int | User Id |   |   |
  |   |   | ma_timestamp |   | Time Stamp |   |   |
  |   |   | 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_basis_flg | sql_variant | Basis Flag |   |   |
  | mac_allocations_detail_tmp | ma_to_center |   | To Center |   |   | |
  |   | ma_to_element |   | To Element |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | host_id |   | Host Id |   |   | |
  |   | ma_processed_flag | sql_variant | Processed Flag |   |   | |
  |   | ma_percentage | bigint | Percentage |   |   | |
  | mac_allocations_header | To store allocation details. | ma_company_no | sql_variant | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organisation Id |   |   |
  |   |   | ma_ou_id | int | Organisation Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book Id |   |   |
  |   |   | ma_acc_yr_no |   | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_run_no | int | Run Number |   |   |
  |   |   | ma_sequence_no |   | Sequence Number |   |   |
  |   |   | ma_credit_element | sql_variant | Credit Element |   |   |
  |   |   | ma_debit_element |   | Debit Element |   |   |
  |   |   | ma_from_center |   | From Center |   |   |
  |   |   | ma_from_element |   | From Element |   |   |
  |   |   | ma_elem_percentage | bigint | Element Percentage |   |   |
  |   |   | ma_allocate_flag | sql_variant | Allocate Flag |   |   |
  |   |   | ma_active_status |   | Active Status. Values A- Active , I - InActive |   |   |
  |   |   | ma_user_id | int | User Id |   |   |
  |   |   | ma_timestamp |   | Time Stamp |   |   |
  |   |   | 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 |   |   |
  |   |   | simulation_status | sql_variant | Simulation Status.Values Y-Yes,N-No |   |   |
  | mac_allocations_header_tmp | ma_from_center |   | From Center |   |   | |
  |   | ma_from_element |   | From Element |   |   | |
  |   | ma_credit_element |   | Credit Element |   |   | |
  |   | ma_debit_element |   | Debit Element |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | host_id |   | Host Id |   |   | |
  |   | ma_processed_flag | sql_variant | Processed Flag |   |   | |
  | mac_ap_fb_tmp | ma_acc_yr_no |   | Accounting Year Number |   |   | |
  |   | ma_acc_prd_no |   | Accounting Period Number |   |   | |
  |   | ma_start_date | datetime | Start Date |   |   | |
  |   | ma_end_date |   | End Date |   |   | |
  |   | ma_status | sql_variant | Status |   |   | |
  |   | fb_id |   | Finance Book Id |   |   | |
  |   | ma_processed_flag |   | Processed Flag |   |   | |
  |   | ma_fin_guid |   | Finance Guid |   |   | |
  | MAC_BUDGET_DETAIL | To store budget details. | MA_COMPANY_NO | varchar(10) | Company Number |   |   |
  |   |   | MA_BU_ID | varchar(20) | Business Unit Id |   |   |
  |   |   | MA_OU_ID | decimal(10) | Organization Unit Id |   |   |
  |   |   | MA_LO_ID | varchar(20) | Logistics Organization Id |   |   |
  |   |   | MA_APPL_OU | decimal(10) | Application Organization Uint Id |   |   |
  |   |   | MA_BUDGET_NO | varchar(10) | Budget Number |   |   |
  |   |   | MA_VERSION_NO | decimal(10) | Version Number |   |   |
  |   |   | MA_CENTER_NO | varchar(32) | Center Number |   |   |
  |   |   | MA_ELEMENT_NO |   | Element Number |   |   |
  |   |   | MA_STOCK_NO | varchar(40) | Stock Number |   |   |
  |   |   | MA_STOCK_VARIANT | varchar(36) | Stock Variant |   |   |
  |   |   | MA_ACC_YR_NO | varchar(15) | Accounting Year Number |   |   |
  |   |   | MA_ACC_PRD_NO |   | Accounting Period Number |   |   |
  |   |   | MA_QUANTITY | decimal(28,8) | Quantity |   |   |
  |   |   | MA_FIX_AMOUNT |   | Fix  Amount |   |   |
  |   |   | MA_VAR_AMOUNT |   | Variance Amount |   |   |
  |   |   | MA_CREATED_BY | varchar(40) | Created By |   |   |
  |   |   | MA_CREATED_DATE | datetime | Created Date |   |   |
  |   |   | MA_MODIFIED_BY | varchar(40) | Modified By |   |   |
  |   |   | MA_MODIFIED_DATE | datetime | Modified Date |   |   |
  |   |   | MA_TIMESTAMP | decimal(10) | Time Stamp |   |   |
  |   |   | MA_VAR_FLEX | decimal(28,8) | Flex Variance Option |   |   |
  |   |   | MA_VAR_PROPORTION |   | Variance Proportion |   |   |
  | mac_budget_detail_aloc_tmp | 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_fix_amount | bigint | Fix Amount |   |   | |
  |   | ma_quantity |   | Quantity |   |   | |
  |   | ma_host_id | sql_variant | Host Id |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_call_cc_ce_tmp | ma_cost_center |   | Cost Center |   |   | |
  |   | ma_cost_element |   | Cost Element |   |   | |
  |   | ma_ratiopercent | bigint | Ratio Percentage |   |   | |
  |   | ma_guid | sql_variant | Guid |   |   | |
  | mac_call_mlcheck_tmp | ma_flag |   | Flag |   |   | |
  |   | ma_guid |   | Guid |   |   | |
  | mac_call_rep_tmp | ma_acc_yr |   | Accounting Year |   |   | |
  |   | ma_acc_pr |   | Accounting Period |   |   | |
  |   | ma_tranou | int | Transaction Oragranization Unit |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | ma_source_cc | sql_variant | Source Cost Center |   |   | |
  |   | ma_target_cc |   | Target Cost Center |   |   | |
  |   | ma_source_ce |   | Source Cost Element |   |   | |
  |   | ma_target_ce |   | Target Cost Element |   |   | |
  |   | ma_open_bal | bigint | Opening Balance |   |   | |
  |   | ma_tran_amt |   | Transaction Amount |   |   | |
  |   | ma_curr_bal |   | Current Balance |   |   | |
  |   | ma_cr_ele_flag | sql_variant | Credit Element Flag |   |   | |
  |   | ma_guid |   | Guid |   |   | |
  |   | ma_alloc_flag |   | Allocation Flag |   |   | |
  | mac_call_rep_tmp1 | ma_acc_yr |   | Accounting  Year |   |   | |
  |   | ma_acc_pr |   | Accounting Period |   |   | |
  |   | ma_tranou | int | Transaction Organization Unit |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | ma_cc | sql_variant | Cost Center |   |   | |
  |   | ma_ce |   | Cost Element |   |   | |
  |   | ma_ce_desc |   | Cost Element Descripiton |   |   | |
  |   | ma_open_bal | bigint | Opening Balabnce |   |   | |
  |   | ma_tran_amt |   | Transaction Amount |   |   | |
  |   | ma_curr_bal |   | Current Balance |   |   | |
  |   | ma_flag | sql_variant | Flag |   |   | |
  |   | ma_cr_ele_flag |   | Credit Element Flag |   |   | |
  |   | ma_processed |   | Processed |   |   | |
  |   | ma_guid |   | Guid |   |   | |
  | mac_call_rep_tmp2 | ma_acc_yr |   | Accounting  Year |   |   | |
  |   | ma_acc_pr |   | Accounting  Period |   |   | |
  |   | ma_tranou | int | Accounting  Transaction Organization Unit |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_sequence_no |   | Sequence Number |   |   | |
  |   | ma_flag | sql_variant | Flag |   |   | |
  |   | ma_source_cc |   | Source Cost Center |   |   | |
  |   | ma_source_ce |   | Source Cost Element |   |   | |
  |   | ma_target_cc |   | Target Cost Center |   |   | |
  |   | ma_target_ce |   | Target Cost Element |   |   | |
  |   | ma_sourcece_desc |   | Source Cost Center Description |   |   | |
  |   | ma_targetce_desc |   | Target Cost Element Description |   |   | |
  |   | ma_tran_amt | bigint | Transaction Amount |   |   | |
  |   | ma_open_bal |   | Opening Balance |   |   | |
  |   | ma_run_bal |   | Run Balance |   |   | |
  |   | ma_cr_ele_flag | sql_variant | Credir Element Flag |   |   | |
  |   | ma_processed |   | Processed |   |   | |
  |   | ma_guid |   | Guid |   |   | |
  | mac_cmplx_alloc_header | To store complex allocation details | ma_company_no |   | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organization Id |   |   |
  |   |   | ma_ou_id | int | Organization Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book Id |   |   |
  |   |   | ma_acc_yr_no |   | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_run_no | int | Run  Number |   |   |
  |   |   | ma_run_desc | sql_variant | Run  Description |   |   |
  |   |   | ma_rpt_type |   | Report Type |   |   |
  |   |   | ma_alloc_level |   | Allocation Level |   |   |
  |   |   | ma_scc_type |   | Source Cost Center Type |   |   |
  |   |   | ma_scc_from |   | Source Cost Center From |   |   |
  |   |   | ma_scc_to |   | Source Cost Center To |   |   |
  |   |   | ma_sce_from |   | Source Cost Element From |   |   |
  |   |   | ma_sce_to |   | Source Cost Element To |   |   |
  |   |   | ma_from_center |   | From Center |   |   |
  |   |   | ma_from_element |   | From Element |   |   |
  |   |   | ma_elem_percentage | bigint | Element Percentage |   |   |
  |   |   | ma_allocate_flag | sql_variant | Allocate Flag |   |   |
  |   |   | ma_status |   | Status.Values Y-Yes,N-No |   |   |
  |   |   | ma_sim_status |   | Simulation Status |   |   |
  |   |   | ma_timestamp | int | Time Stamp |   |   |
  |   |   | 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_ratio_per | bigint | Ratio Percentage |   |   |
  | mac_cmplx_alloc_jrnl | To store complex journal datas | ma_company_no | sql_variant | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organization Id |   |   |
  |   |   | ma_ou_id | int | Organization Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book Id |   |   |
  |   |   | ma_actbud_flag |   | Actual Budget Flag |   |   |
  |   |   | ma_budget_no |   | Budget Number |   |   |
  |   |   | ma_version_no | int | Version Number |   |   |
  |   |   | ma_acc_yr_no | sql_variant | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting  Period Number |   |   |
  |   |   | ma_run_no | int | Run Number |   |   |
  |   |   | ma_rpt_type | sql_variant | Report Type |   |   |
  |   |   | ma_app_basis |   | Application Basis |   |   |
  |   |   | ma_from_center |   | From  Center |   |   |
  |   |   | ma_from_ce |   | From Cost Center |   |   |
  |   |   | ma_to_center |   | To Center |   |   |
  |   |   | ma_to_ce |   | From Cost Element |   |   |
  |   |   | ma_tran_amt | bigint | Transaction Amount |   |   |
  |   |   | ma_ratio_per |   | Ratio Percentage |   |   |
  |   |   | ma_user_id | sql_variant | User Id |   |   |
  |   |   | ma_fin_macdate | datetime | Finance Management Accounting Date |   |   |
  |   |   | ma_par_tran_amt | bigint | Parallel Transaction Amount |   |   |
  |   |   | ma_guid | sql_variant | Guid |   |   |
  | mac_cmplx_alloc_jrnl_tmp | ma_company_no |   | Company Number |   |   | |
  |   | ma_bu_id |   | Business Unit Id |   |   | |
  |   | ma_lo_id |   | Logistics Organization Id |   |   | |
  |   | ma_ou_id | int | Organization Unit Id |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_actbud_flag |   | Actual Budget Flag |   |   | |
  |   | ma_budget_no |   | Budget Number |   |   | |
  |   | ma_version_no | int | Version Number |   |   | |
  |   | ma_acc_yr_no | sql_variant | Accounting Year Number |   |   | |
  |   | ma_acc_prd_no |   | Accounting Period Number |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_rpt_type | sql_variant | Report Type |   |   | |
  |   | ma_from_center |   | From Center |   |   | |
  |   | ma_from_ce |   | From Cost Center |   |   | |
  |   | ma_to_center |   | To Center |   |   | |
  |   | ma_to_ce |   | From Cost Element |   |   | |
  |   | ma_tran_amt | bigint | Transaction Amount |   |   | |
  |   | ma_lineno | int | Line Number |   |   | |
  |   | ma_guid | sql_variant | Guid |   |   | |
  | mac_post_alloc | To store MAC posting allocation details |   |   |   |   |   |
  |   |   | ma_company_no |   | Number |   |   |
  |   |   | ma_lo_id |   | Logistics Organization Id |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_ou_id | int | Organization Unit Id |   |   |
  |   |   | ma_fb_id | sql_variant | Finance Book  Id |   |   |
  |   |   | ma_acc_yr_no |   | Accounting Year Number |   |   |
  |   |   | ma_acc_prd_no |   | Accounting Period Number |   |   |
  |   |   | ma_from_center |   | From Center |   |   |
  |   |   | ma_from_element |   | From Element |   |   |
  |   |   | ma_base_amount | bigint | Base Amount |   |   |
  |   |   | ma_par_base_amt |   | Parallel Base Amount |   |   |
  |   |   | ma_doc_type | sql_variant | Document Type |   |   |
  |   |   | ma_tran_no |   | Transaction Number |   |   |
  |   |   | ma_tran_date | datetime | Transaction Date |   |   |
  |   |   | ma_acc_code | sql_variant | Accounting Code |   |   |
  |   |   | cont_ac_type |   | Contact Account Type |   |   |
  |   |   | ma_auto_post_type |   | Auto Post Type |   |   |
  |   |   | ma_drcr_flag |   | Debit Credit Flag |   |   |
  |   |   | ma_analy |   | Analysis |   |   |
  |   |   | ma_subanal |   | Subanalysis |   |   |
  |   |   | ma_base_curr |   | Base Currency |   |   |
  |   |   | ma_par_base_curr |   | Parallel Base Currency |   |   |
  |   |   | currency_code |   | Currency Code |   |   |
  | mac_pre_alloc_bal | To store allocation balance | ma_company_no |   | Company Number |   |   |
  |   |   | ma_bu_id |   | Business Unit Id |   |   |
  |   |   | ma_lo_id |   | Logistics Organization Id |   |   |
  |   |   | ma_ou_id | int | Organization Unit Id |   |   |
  |   |   | ma_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_balance | bigint | Balance |   |   |
  |   |   | ma_user_id | int | User Id |   |   |
  |   |   | ma_fin_macdate | datetime | Finance Management Accounting Date |   |   |
  |   |   | guid | sql_variant | Guid |   |   |
  | mac_ratio_percentage_check | To store details of ratio check datas | ma_percentage_flag |   | Percentage Flag |   |   |
  |   |   | ma_percentage | bigint | Percentage |   |   |
  |   |   | ma_guid | sql_variant | Guid |   |   |
  | mac_temptable | guid |   |   |   |   | |
  |   | status |   | Status.Values Y-Yes,N-No |   |   | |
  |   | ma_center_no |   | Center Number |   |   | |
  |   | ma_element_no |   | Element Number |   |   | |
  |   | ou_id | int | Organization Unit Id |   |   | |
  | mac_totmp | ma_bu_id | sql_variant | Business Id |   |   | |
  |   | ma_lo_id |   | Logistics Organization Id |   |   | |
  |   | ma_ou_id | int | Organization Unit Id |   |   | |
  |   | ma_fb_id | sql_variant | Finance Book Id |   |   | |
  |   | ma_run_no | int | Run Number |   |   | |
  |   | ma_to_cc | sql_variant | To Cost Center |   |   | |
  |   | ma_to_ce |   | To Cost Element |   |   | |
  |   | guid |   | Guid |   |   | |
  | mac_tran_balance_tmp | ma_company_no |   | Company Number |   |   | |
  |   | ma_bu_id |   | Business Unit Id |   |   | |
  |   | ma_lo_id |   | Logistics Organization Id |   |   | |
  |   | ma_ou_id | int | Organization Unit Id |   |   | |
  |   | ma_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_curr_bal_val |   | Current Balance Value |   |   | |
  |   | ma_user_id | int | User Id |   |   | |
  |   | ma_fin_macdate | datetime | Finance Management Accounting Date |   |   | |
  |   | guid | sql_variant | Guid |   |   | |
  |   | ma_curr_par_bas_bal_val | bigint | Current Parallel Basae Value |   |   | |
  | rep_quick_code_met | To store quick code datas | component_id | sql_variant | 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 |   |   |