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

Source

View Text - Preformatted


select COLLECTION_INDICATOR_ID COLLECTION_INDICATOR_ID, 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, REPORT_DATE REPORT_DATE, DSO_DAYS DSO_DAYS, CONVENTIONAL_DSO CONVENTIONAL_DSO, GROSS_RECEIVABLES GROSS_RECEIVABLES, OPEN_CM OPEN_CM, OPEN_PAYMENTS OPEN_PAYMENTS, INVOICE_SPLIT_AMOUNT INVOICE_SPLIT_AMOUNT, INVOICE_AMOUNT_OVER INVOICE_AMOUNT_OVER, INVOICE_AMOUNT_UNDER INVOICE_AMOUNT_UNDER, INVOICE_COUNT_OVER INVOICE_COUNT_OVER, INVOICE_COUNT_UNDER INVOICE_COUNT_UNDER, AMOUNT_COLLECTED AMOUNT_COLLECTED, PAYMENT_PATTERN_CURRENT_SALES PAYMENT_PATTERN_CURRENT_SALES, PAYMENT_PATTERN_1PERIOD_PRIOR PAYMENT_PATTERN_1PERIOD_PRIOR, PAYMENT_PATTERN_2PERIOD_PRIOR PAYMENT_PATTERN_2PERIOD_PRIOR, PAYMENT_PATTERN_3PERIOD_PRIOR PAYMENT_PATTERN_3PERIOD_PRIOR, PAYMENT_PATTERN_4PERIOD_PRIOR PAYMENT_PATTERN_4PERIOD_PRIOR, PAYMENT_PATTERN_5PERIOD_PRIOR PAYMENT_PATTERN_5PERIOD_PRIOR, PAYMENT_PATTERN_6PERIOD_PRIOR PAYMENT_PATTERN_6PERIOD_PRIOR, PAYMENT_PATTERN_7PERIOD_PRIOR PAYMENT_PATTERN_7PERIOD_PRIOR, PAYMENT_PATTERN_8PERIOD_PRIOR PAYMENT_PATTERN_8PERIOD_PRIOR, PAYMENT_PATTERN_9PERIOD_PRIOR PAYMENT_PATTERN_9PERIOD_PRIOR, PAYMENT_PATTERN_10PERIOD_PRIOR PAYMENT_PATTERN_10PERIOD_PRIOR, PAYMENT_PATTERN_11PERIOD_PRIOR PAYMENT_PATTERN_11PERIOD_PRIOR, CREDIT_MEMO_AMOUNT CREDIT_MEMO_AMOUNT, WRITEOFF_AMOUNT WRITEOFF_AMOUNT, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, ORG_ID ORG_ID from "AR"."AR_COLLECTION_INDICATORS_ALL"

View Text - HTML Formatted

SELECT COLLECTION_INDICATOR_ID COLLECTION_INDICATOR_ID
, 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
, REPORT_DATE REPORT_DATE
, DSO_DAYS DSO_DAYS
, CONVENTIONAL_DSO CONVENTIONAL_DSO
, GROSS_RECEIVABLES GROSS_RECEIVABLES
, OPEN_CM OPEN_CM
, OPEN_PAYMENTS OPEN_PAYMENTS
, INVOICE_SPLIT_AMOUNT INVOICE_SPLIT_AMOUNT
, INVOICE_AMOUNT_OVER INVOICE_AMOUNT_OVER
, INVOICE_AMOUNT_UNDER INVOICE_AMOUNT_UNDER
, INVOICE_COUNT_OVER INVOICE_COUNT_OVER
, INVOICE_COUNT_UNDER INVOICE_COUNT_UNDER
, AMOUNT_COLLECTED AMOUNT_COLLECTED
, PAYMENT_PATTERN_CURRENT_SALES PAYMENT_PATTERN_CURRENT_SALES
, PAYMENT_PATTERN_1PERIOD_PRIOR PAYMENT_PATTERN_1PERIOD_PRIOR
, PAYMENT_PATTERN_2PERIOD_PRIOR PAYMENT_PATTERN_2PERIOD_PRIOR
, PAYMENT_PATTERN_3PERIOD_PRIOR PAYMENT_PATTERN_3PERIOD_PRIOR
, PAYMENT_PATTERN_4PERIOD_PRIOR PAYMENT_PATTERN_4PERIOD_PRIOR
, PAYMENT_PATTERN_5PERIOD_PRIOR PAYMENT_PATTERN_5PERIOD_PRIOR
, PAYMENT_PATTERN_6PERIOD_PRIOR PAYMENT_PATTERN_6PERIOD_PRIOR
, PAYMENT_PATTERN_7PERIOD_PRIOR PAYMENT_PATTERN_7PERIOD_PRIOR
, PAYMENT_PATTERN_8PERIOD_PRIOR PAYMENT_PATTERN_8PERIOD_PRIOR
, PAYMENT_PATTERN_9PERIOD_PRIOR PAYMENT_PATTERN_9PERIOD_PRIOR
, PAYMENT_PATTERN_10PERIOD_PRIOR PAYMENT_PATTERN_10PERIOD_PRIOR
, PAYMENT_PATTERN_11PERIOD_PRIOR PAYMENT_PATTERN_11PERIOD_PRIOR
, CREDIT_MEMO_AMOUNT CREDIT_MEMO_AMOUNT
, WRITEOFF_AMOUNT WRITEOFF_AMOUNT
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, ORG_ID ORG_ID
FROM "AR"."AR_COLLECTION_INDICATORS_ALL"