| 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 |
  |
  |
|   |
  |
  |
createdby |
  |
Created By |
  |
  |
|   |
  |
  |
createddate |
datetime |
Created Date |
  |
  |
|   |
  |
  |
modifiedby |
sql_variant |
Modified By |
  |
  |
|   |
  |
  |
modifieddate |
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 |
  |
  |
|   |
  |
|
createdby |
  |
Created By |
  |
  |
|   |
  |
|
createddate |
datetime |
Created Date |
  |
  |
|   |
  |
|
modifiedby |
sql_variant |
Modified By |
  |
  |
|   |
  |
|
modifieddate |
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_createdby |
sql_variant |
Created By |
  |
  |
|   |
  |
  |
rph_createddate |
datetime |
Created Date |
  |
  |
|   |
  |
  |
rph_modifiedby |
sql_variant |
Modified By |
  |
  |
|   |
  |
  |
rph_modifieddate |
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 Organisation 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 |
Managemnet 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 Organisation Id |
  |
  |
|   |
  |
|
ma_ou_id |
int |
Organisation 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 |
Organisation 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 Organisation  Id |
  |
  |
|   |
  |
|
ma_ou_id |
int |
Organisation  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 Organisation Id |
  |
  |
|   |
  |
  |
ma_ou_id |
int |
Organisation 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 Organisation Id |
  |
  |
|   |
  |
  |
ma_ou_id |
int |
Organisation 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 Oragranization 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 Descripiton |
  |
  |
|   |
  |
|
ma_open_bal |
bigint |
Opening Balabnce |
  |
  |
|   |
  |
|
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 |
Credir 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 |
  |
Subanalysis |
  |
  |
|   |
  |
  |
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 |
  |
  |