diff --git a/003.Cashflow Report/report_parameters.txt b/003.Cashflow Report/report_parameters.txt new file mode 100644 index 0000000..8953e0b --- /dev/null +++ b/003.Cashflow Report/report_parameters.txt @@ -0,0 +1,76 @@ +Scenario - to be removed +Only if deatails conplete - just a flag - to be presented +Include Cash Management Flows - to be removed +Domestic - to be removed + + +1. What parameters to include and check in report: + -- Report Title - 0 - OK + -- Start Date (Inclusive) - 1 - OK + -- End Date (Inclusive) - 2 - OK + -- Exclude If Contracted After - 3 - OK + -- Include Contracts Based On - 4 - OK + -- Entity - 5 - OK + -- Counterparty - 6 - OK + -- Contract Number List - 7 - + -- Portfolio Code - 8 - OK + -- Portfolio Sub Code - 9 - OK + -- Contract Code - 10 - OK + + -- Contract Sub Code - 11 - OK + + -- Currencies - 12 - OK + -- Folder - 13 - OK + -- Cash Flow Status - 14 - OK + -- Flow Direction - 15 - OK + -- Base Currency - 16 - OK + -- FX Conversion - 17 - ??? - това не съм сигурен дали е сетнато правилно - за момента не ми трябва !!!! + -- Spot FX rates on - 18 - OK + -- Exchange Rate Type - 19 - input param in func + -- Rounding - 20 - OK + -- Include Contingent Liabilities - 21 - OK + + +Параметри: + +2. Да премахна параметри. Да създам скрип за Прод за параметрите. - OK +3. Да оправя новото т.е. в OTHER да се слагат 2 нови категории. - тези категории трябва да се отлюспят +от куеритата за другите неща + + + + + v_start_date := star_reporting_pack.get_parameter_value('Start_Date_(Inclusive)_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_end_date := star_reporting_pack.get_parameter_value('End_Date_(Inclusive)_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_exclude_if_contr_after := star_reporting_pack.get_parameter_value('Exclude_If_Contracted_After_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_contingent_liabilities := star_reporting_pack.get_parameter_value('Contingent_Liabilities_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_details_complete := star_reporting_pack.get_parameter_value('Details_Complete_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_incl_excl_contr := star_reporting_pack.get_parameter_value('Include_Contracts_Based_On_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + + v_include_cmf := star_reporting_pack.get_parameter_value('Include_Cash_Management_Flows_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_fx_type := star_reporting_pack.get_parameter_value('FX_Conversion_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); + + v_domestic := star_reporting_pack.get_parameter_value('Domestic_V1', + star_exceloutput_pack.GLB_PARAMETERS, + star_exceloutput_pack.GLB_NO_PARAMETERS); \ No newline at end of file