CALL

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