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