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