eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: IBY.IBY_INSTR_CREATION_RULES#

Source

View Text - Preformatted


select SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, GROUP_BY_PAYMENT_DATE GROUP_BY_PAYMENT_DATE, GROUP_BY_PAYMENT_CURRENCY GROUP_BY_PAYMENT_CURRENCY, GROUP_BY_INTERNAL_BANK_ACCOUNT GROUP_BY_INTERNAL_BANK_ACCOUNT, GROUP_BY_MAX_PAYMENTS_FLAG GROUP_BY_MAX_PAYMENTS_FLAG, GROUP_BY_PAY_SERVICE_REQUEST GROUP_BY_PAY_SERVICE_REQUEST, GROUP_BY_LEGAL_ENTITY GROUP_BY_LEGAL_ENTITY, GROUP_BY_BILL_PAYABLE GROUP_BY_BILL_PAYABLE, GROUP_BY_ORGANIZATION GROUP_BY_ORGANIZATION, GROUP_BY_MAX_INSTRUCTION_FLAG GROUP_BY_MAX_INSTRUCTION_FLAG, GROUP_BY_PAYMENT_FUNCTION GROUP_BY_PAYMENT_FUNCTION, GROUP_BY_PAYMENT_REASON GROUP_BY_PAYMENT_REASON, GROUP_BY_RFC GROUP_BY_RFC, MAX_PAYMENTS_PER_INSTRUCTION MAX_PAYMENTS_PER_INSTRUCTION, MAX_AMOUNT_PER_INSTR_VALUE MAX_AMOUNT_PER_INSTR_VALUE, MAX_AMOUNT_PER_INSTR_CURR_CODE MAX_AMOUNT_PER_INSTR_CURR_CODE, MAX_AMOUNT_FX_RATE_TYPE MAX_AMOUNT_FX_RATE_TYPE, SORT_OPTION_1 SORT_OPTION_1, SORT_ORDER_1 SORT_ORDER_1, SORT_OPTION_2 SORT_OPTION_2, SORT_ORDER_2 SORT_ORDER_2, SORT_OPTION_3 SORT_OPTION_3, SORT_ORDER_3 SORT_ORDER_3, GROUP_BY_PAYMENT_METHOD GROUP_BY_PAYMENT_METHOD, ZD_EDITION_NAME ZD_EDITION_NAME from "IBY"."IBY_INSTR_CREATION_RULES"

View Text - HTML Formatted

SELECT SYSTEM_PROFILE_CODE SYSTEM_PROFILE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, GROUP_BY_PAYMENT_DATE GROUP_BY_PAYMENT_DATE
, GROUP_BY_PAYMENT_CURRENCY GROUP_BY_PAYMENT_CURRENCY
, GROUP_BY_INTERNAL_BANK_ACCOUNT GROUP_BY_INTERNAL_BANK_ACCOUNT
, GROUP_BY_MAX_PAYMENTS_FLAG GROUP_BY_MAX_PAYMENTS_FLAG
, GROUP_BY_PAY_SERVICE_REQUEST GROUP_BY_PAY_SERVICE_REQUEST
, GROUP_BY_LEGAL_ENTITY GROUP_BY_LEGAL_ENTITY
, GROUP_BY_BILL_PAYABLE GROUP_BY_BILL_PAYABLE
, GROUP_BY_ORGANIZATION GROUP_BY_ORGANIZATION
, GROUP_BY_MAX_INSTRUCTION_FLAG GROUP_BY_MAX_INSTRUCTION_FLAG
, GROUP_BY_PAYMENT_FUNCTION GROUP_BY_PAYMENT_FUNCTION
, GROUP_BY_PAYMENT_REASON GROUP_BY_PAYMENT_REASON
, GROUP_BY_RFC GROUP_BY_RFC
, MAX_PAYMENTS_PER_INSTRUCTION MAX_PAYMENTS_PER_INSTRUCTION
, MAX_AMOUNT_PER_INSTR_VALUE MAX_AMOUNT_PER_INSTR_VALUE
, MAX_AMOUNT_PER_INSTR_CURR_CODE MAX_AMOUNT_PER_INSTR_CURR_CODE
, MAX_AMOUNT_FX_RATE_TYPE MAX_AMOUNT_FX_RATE_TYPE
, SORT_OPTION_1 SORT_OPTION_1
, SORT_ORDER_1 SORT_ORDER_1
, SORT_OPTION_2 SORT_OPTION_2
, SORT_ORDER_2 SORT_ORDER_2
, SORT_OPTION_3 SORT_OPTION_3
, SORT_ORDER_3 SORT_ORDER_3
, GROUP_BY_PAYMENT_METHOD GROUP_BY_PAYMENT_METHOD
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IBY"."IBY_INSTR_CREATION_RULES"