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_HIST_DISTS#

Source

View Text - Preformatted


select PAYMENT_HIST_DIST_ID PAYMENT_HIST_DIST_ID, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, PAY_DIST_LOOKUP_CODE PAY_DIST_LOOKUP_CODE, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, AMOUNT AMOUNT, PAYMENT_HISTORY_ID PAYMENT_HISTORY_ID, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, BANK_CURR_AMOUNT BANK_CURR_AMOUNT, CLEARED_BASE_AMOUNT CLEARED_BASE_AMOUNT, HISTORICAL_FLAG HISTORICAL_FLAG, INVOICE_DIST_AMOUNT INVOICE_DIST_AMOUNT, INVOICE_DIST_BASE_AMOUNT INVOICE_DIST_BASE_AMOUNT, INVOICE_ADJUSTMENT_EVENT_ID INVOICE_ADJUSTMENT_EVENT_ID, MATURED_BASE_AMOUNT MATURED_BASE_AMOUNT, PAID_BASE_AMOUNT PAID_BASE_AMOUNT, ROUNDING_AMT ROUNDING_AMT, REVERSAL_FLAG REVERSAL_FLAG, REVERSED_PAY_HIST_DIST_ID REVERSED_PAY_HIST_DIST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, AWT_RELATED_ID AWT_RELATED_ID, RELEASE_INV_DIST_DERIVED_FROM RELEASE_INV_DIST_DERIVED_FROM, PA_ADDITION_FLAG PA_ADDITION_FLAG, AMOUNT_VARIANCE AMOUNT_VARIANCE, INVOICE_BASE_AMT_VARIANCE INVOICE_BASE_AMT_VARIANCE, QUANTITY_VARIANCE QUANTITY_VARIANCE, INVOICE_BASE_QTY_VARIANCE INVOICE_BASE_QTY_VARIANCE, GAIN_LOSS_INDICATOR GAIN_LOSS_INDICATOR from "AP"."AP_PAYMENT_HIST_DISTS"

View Text - HTML Formatted

SELECT PAYMENT_HIST_DIST_ID PAYMENT_HIST_DIST_ID
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, PAY_DIST_LOOKUP_CODE PAY_DIST_LOOKUP_CODE
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, AMOUNT AMOUNT
, PAYMENT_HISTORY_ID PAYMENT_HISTORY_ID
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, BANK_CURR_AMOUNT BANK_CURR_AMOUNT
, CLEARED_BASE_AMOUNT CLEARED_BASE_AMOUNT
, HISTORICAL_FLAG HISTORICAL_FLAG
, INVOICE_DIST_AMOUNT INVOICE_DIST_AMOUNT
, INVOICE_DIST_BASE_AMOUNT INVOICE_DIST_BASE_AMOUNT
, INVOICE_ADJUSTMENT_EVENT_ID INVOICE_ADJUSTMENT_EVENT_ID
, MATURED_BASE_AMOUNT MATURED_BASE_AMOUNT
, PAID_BASE_AMOUNT PAID_BASE_AMOUNT
, ROUNDING_AMT ROUNDING_AMT
, REVERSAL_FLAG REVERSAL_FLAG
, REVERSED_PAY_HIST_DIST_ID REVERSED_PAY_HIST_DIST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, AWT_RELATED_ID AWT_RELATED_ID
, RELEASE_INV_DIST_DERIVED_FROM RELEASE_INV_DIST_DERIVED_FROM
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, AMOUNT_VARIANCE AMOUNT_VARIANCE
, INVOICE_BASE_AMT_VARIANCE INVOICE_BASE_AMT_VARIANCE
, QUANTITY_VARIANCE QUANTITY_VARIANCE
, INVOICE_BASE_QTY_VARIANCE INVOICE_BASE_QTY_VARIANCE
, GAIN_LOSS_INDICATOR GAIN_LOSS_INDICATOR
FROM "AP"."AP_PAYMENT_HIST_DISTS"