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: AP.AP_PAYMENT_DISTRIBUTIONS_ALL#

Source

View Text - Preformatted


select INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, PAYMENT_LINE_NUMBER PAYMENT_LINE_NUMBER, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, INVOICE_DISTR_LINE_NUMBER INVOICE_DISTR_LINE_NUMBER, UNBUILT_FLEX UNBUILT_FLEX, UNBUILT_FLEX_REASON UNBUILT_FLEX_REASON, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ORG_ID ORG_ID, INV_CURR_AMOUNT INV_CURR_AMOUNT, INV_CURR_BASE_AMOUNT INV_CURR_BASE_AMOUNT from "AP"."AP_PAYMENT_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, PAYMENT_LINE_NUMBER PAYMENT_LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, INVOICE_DISTR_LINE_NUMBER INVOICE_DISTR_LINE_NUMBER
, UNBUILT_FLEX UNBUILT_FLEX
, UNBUILT_FLEX_REASON UNBUILT_FLEX_REASON
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ORG_ID ORG_ID
, INV_CURR_AMOUNT INV_CURR_AMOUNT
, INV_CURR_BASE_AMOUNT INV_CURR_BASE_AMOUNT
FROM "AP"."AP_PAYMENT_DISTRIBUTIONS_ALL"