MENT

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_ment_view_tmp bfgcode sql_variant Business Function Group Code No No
    bfgdesc   Business Function Group Description    
    statusdesc   Status Description    
    statuscode   Status Code    
    voucheramountml bigint Voucher Amount Multiline    
    voucherdate datetime Voucher Date    
    voucherno sql_variant Voucher Number    
    guid   Guid    
  mac_trans_wf_temp ou_id int Organization Unit Id    
    ma_tran_date datetime Management Accounting  Transaction Date    
    guid sql_variant Guid    
    ma_mactran_no   Transaction Number    
    ma_createdby   Created By    
    ma_amount bigint Amount    
    doc_para sql_variant Document Parameter    
    doc_status   Document Status.Values A-Active,I-InActive    
  ment_notes_his To store history about Notes. ma_ou_id int Organization Unit Id    
      ma_mactran_no sql_variant Transaction Number    
      ma_status   Status.Values A-Active,I-InActive    
      ma_timestamp int Time Stamp    
      ma_stdnotesid sql_variant Standard Notes Id    
      ma_stdnotesiddesc   Standard Notes Id Description    
      ma_notes_desc   Notes Description    
      ma_createdby   Created By    
      ma_createddate datetime Created Date    
      ma_modifiedby sql_variant Modified By    
      ma_modifieddate datetime Modified Date    
  ment_notes_mst To store information about Notes. ma_ou_id int Organization Unit Id    
      ma_mactran_no sql_variant Transaction Number    
      ma_status   Status.Values A-Active,I-InActive    
      ma_timestamp int Time Stamp    
      ma_stdnotesid sql_variant Standard Notes Id    
      ma_stdnotesiddesc   Standard Notes Id Description    
      ma_notes_desc   Notes Description    
      ma_createdby   Created By    
      ma_createddate datetime Created Date    
      ma_modifiedby sql_variant Modified By    
      ma_modifieddate datetime Modified Date