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.

[Home] [Help]

VIEW: AP.JE_DK_PAY_CATEGORIES#

Source

View Text - Preformatted


select PAYMENT_CATEGORY_ID PAYMENT_CATEGORY_ID, PAYMENT_CATEGORY PAYMENT_CATEGORY, PAYMENT_MEANS PAYMENT_MEANS, PAYMENT_CHANNEL PAYMENT_CHANNEL, AGREEMENT_TYPE AGREEMENT_TYPE, PARTY_ID PARTY_ID, SETTLEMENT_CODE SETTLEMENT_CODE, IMPORT_CODE IMPORT_CODE, IMPORT_MONTH IMPORT_MONTH, BANK_CODE BANK_CODE, FOREIGN_PAYMENT_FLAG FOREIGN_PAYMENT_FLAG, SUPPLIER_MESSAGE SUPPLIER_MESSAGE, 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 from "AP"."JE_DK_PAY_CATEGORIES"

View Text - HTML Formatted

SELECT PAYMENT_CATEGORY_ID PAYMENT_CATEGORY_ID
, PAYMENT_CATEGORY PAYMENT_CATEGORY
, PAYMENT_MEANS PAYMENT_MEANS
, PAYMENT_CHANNEL PAYMENT_CHANNEL
, AGREEMENT_TYPE AGREEMENT_TYPE
, PARTY_ID PARTY_ID
, SETTLEMENT_CODE SETTLEMENT_CODE
, IMPORT_CODE IMPORT_CODE
, IMPORT_MONTH IMPORT_MONTH
, BANK_CODE BANK_CODE
, FOREIGN_PAYMENT_FLAG FOREIGN_PAYMENT_FLAG
, SUPPLIER_MESSAGE SUPPLIER_MESSAGE
, 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
FROM "AP"."JE_DK_PAY_CATEGORIES"