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: AR.AR_CASH_BASIS_DISTS_ALL#

Source

View Text - Preformatted


select CASH_BASIS_DISTRIBUTION_ID CASH_BASIS_DISTRIBUTION_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_UPDATE_DATE PROGRAM_UPDATE_DATE, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID, SOURCE SOURCE, SOURCE_ID SOURCE_ID, TYPE TYPE, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, GL_DATE GL_DATE, CURRENCY_CODE CURRENCY_CODE, AMOUNT AMOUNT, ACCTD_AMOUNT ACCTD_AMOUNT, CODE_COMBINATION_ID CODE_COMBINATION_ID, POSTING_CONTROL_ID POSTING_CONTROL_ID, GL_POSTED_DATE GL_POSTED_DATE, RECEIVABLE_APPLICATION_ID_CASH RECEIVABLE_APPLICATION_ID_CASH, ORG_ID ORG_ID, ACTIVITY_BUCKET ACTIVITY_BUCKET, REF_ACCOUNT_CLASS REF_ACCOUNT_CLASS, REF_CUSTOMER_TRX_ID REF_CUSTOMER_TRX_ID, REF_CUSTOMER_TRX_LINE_ID REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID REF_CUST_TRX_LINE_GL_DIST_ID, REF_LINE_ID REF_LINE_ID, FROM_AMOUNT FROM_AMOUNT, FROM_ACCTD_AMOUNT FROM_ACCTD_AMOUNT, LEDGER_ID LEDGER_ID, BASE_CURRENCY BASE_CURRENCY from "AR"."AR_CASH_BASIS_DISTS_ALL"

View Text - HTML Formatted

SELECT CASH_BASIS_DISTRIBUTION_ID CASH_BASIS_DISTRIBUTION_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_UPDATE_DATE PROGRAM_UPDATE_DATE
, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID
, SOURCE SOURCE
, SOURCE_ID SOURCE_ID
, TYPE TYPE
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, GL_DATE GL_DATE
, CURRENCY_CODE CURRENCY_CODE
, AMOUNT AMOUNT
, ACCTD_AMOUNT ACCTD_AMOUNT
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, GL_POSTED_DATE GL_POSTED_DATE
, RECEIVABLE_APPLICATION_ID_CASH RECEIVABLE_APPLICATION_ID_CASH
, ORG_ID ORG_ID
, ACTIVITY_BUCKET ACTIVITY_BUCKET
, REF_ACCOUNT_CLASS REF_ACCOUNT_CLASS
, REF_CUSTOMER_TRX_ID REF_CUSTOMER_TRX_ID
, REF_CUSTOMER_TRX_LINE_ID REF_CUSTOMER_TRX_LINE_ID
, REF_CUST_TRX_LINE_GL_DIST_ID REF_CUST_TRX_LINE_GL_DIST_ID
, REF_LINE_ID REF_LINE_ID
, FROM_AMOUNT FROM_AMOUNT
, FROM_ACCTD_AMOUNT FROM_ACCTD_AMOUNT
, LEDGER_ID LEDGER_ID
, BASE_CURRENCY BASE_CURRENCY
FROM "AR"."AR_CASH_BASIS_DISTS_ALL"