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

Source

View Text - Preformatted


select CHECK_ID CHECK_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, POSTED_FLAG POSTED_FLAG, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG CASH_POSTED_FLAG, ACCOUNTING_DATE ACCOUNTING_DATE, PERIOD_NAME PERIOD_NAME, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, REVERSAL_FLAG REVERSAL_FLAG, ORG_ID ORG_ID, R115_UPG R115_UPG from "AP"."AP_RECON_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT CHECK_ID CHECK_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, POSTED_FLAG POSTED_FLAG
, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, CASH_POSTED_FLAG CASH_POSTED_FLAG
, ACCOUNTING_DATE ACCOUNTING_DATE
, PERIOD_NAME PERIOD_NAME
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, REVERSAL_FLAG REVERSAL_FLAG
, ORG_ID ORG_ID
, R115_UPG R115_UPG
FROM "AP"."AP_RECON_DISTRIBUTIONS_ALL"