|
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 |
||
|
|
|
|
created by |
|
Created By |
||
|
|
|
|
created date |
datetime |
Created Date |
||
|
|
|
|
modified by |
sql_variant |
Modified By |
||
|
|
|
|
modified date |
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 |
||
|
|
|
|
created by |
|
Created By |
||
|
|
|
|
created date |
datetime |
Created Date |
||
|
|
|
|
modified by |
sql_variant |
Modified By |
||
|
|
|
|
modified date |
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_created by |
sql_variant |
Created By |
||
|
|
|
|
rph_created date |
datetime |
Created Date |
||
|
|
|
|
rph_modified by |
sql_variant |
Modified By |
||
|
|
|
|
rph_modified date |
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 Organisations 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 |
Management 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 Organisations Id |
||
|
|
|
|
ma_ou_id |
int |
Organisations 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 |
Organization 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 Organization Id |
||
|
|
|
|
ma_ou_id |
int |
Organization 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 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 |
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 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_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 Organization 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 Description |
||
|
|
|
|
ma_open_bal |
bigint |
Opening Balance |
||
|
|
|
|
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 |
Credit 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 |
|
Sub analysis |
||
|
|
|
|
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 |