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 |   |   |