VIEW: AR.AR_TRX_SUMMARY#

Source

View Text - Preformatted

select CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SITE_USE_ID SITE_USE_ID, ORG_ID ORG_ID, CURRENCY CURRENCY, AS_OF_DATE AS_OF_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OP_BAL_HIGH_WATERMARK OP_BAL_HIGH_WATERMARK, OP_BAL_HIGH_WATERMARK_DATE OP_BAL_HIGH_WATERMARK_DATE, TOTAL_CASH_RECEIPTS_VALUE TOTAL_CASH_RECEIPTS_VALUE, TOTAL_CASH_RECEIPTS_COUNT TOTAL_CASH_RECEIPTS_COUNT, TOTAL_INVOICES_VALUE TOTAL_INVOICES_VALUE, TOTAL_INVOICES_COUNT TOTAL_INVOICES_COUNT, INV_PAID_AMOUNT INV_PAID_AMOUNT, INV_INST_PMT_DAYS_SUM INV_INST_PMT_DAYS_SUM, TOTAL_BILLS_RECEIVABLES_VALUE TOTAL_BILLS_RECEIVABLES_VALUE, TOTAL_BILLS_RECEIVABLES_COUNT TOTAL_BILLS_RECEIVABLES_COUNT, TOTAL_CREDIT_MEMOS_VALUE TOTAL_CREDIT_MEMOS_VALUE, TOTAL_CREDIT_MEMOS_COUNT TOTAL_CREDIT_MEMOS_COUNT, TOTAL_DEBIT_MEMOS_VALUE TOTAL_DEBIT_MEMOS_VALUE, TOTAL_DEBIT_MEMOS_COUNT TOTAL_DEBIT_MEMOS_COUNT, TOTAL_CHARGEBACK_VALUE TOTAL_CHARGEBACK_VALUE, TOTAL_CHARGEBACK_COUNT TOTAL_CHARGEBACK_COUNT, TOTAL_EARNED_DISC_VALUE TOTAL_EARNED_DISC_VALUE, TOTAL_EARNED_DISC_COUNT TOTAL_EARNED_DISC_COUNT, TOTAL_UNEARNED_DISC_VALUE TOTAL_UNEARNED_DISC_VALUE, TOTAL_UNEARNED_DISC_COUNT TOTAL_UNEARNED_DISC_COUNT, TOTAL_ADJUSTMENTS_VALUE TOTAL_ADJUSTMENTS_VALUE, TOTAL_ADJUSTMENTS_COUNT TOTAL_ADJUSTMENTS_COUNT, TOTAL_DEPOSITS_VALUE TOTAL_DEPOSITS_VALUE, TOTAL_DEPOSITS_COUNT TOTAL_DEPOSITS_COUNT, SUM_APP_AMT_DAYS_LATE SUM_APP_AMT_DAYS_LATE, SUM_APP_AMT SUM_APP_AMT, COUNT_OF_TOT_INV_INST_PAID COUNT_OF_TOT_INV_INST_PAID, COUNT_OF_INV_INST_PAID_LATE COUNT_OF_INV_INST_PAID_LATE, COUNT_OF_DISC_INV_INST COUNT_OF_DISC_INV_INST, LARGEST_INV_AMOUNT LARGEST_INV_AMOUNT, LARGEST_INV_DATE LARGEST_INV_DATE, LARGEST_INV_CUST_TRX_ID LARGEST_INV_CUST_TRX_ID, DAYS_CREDIT_GRANTED_SUM DAYS_CREDIT_GRANTED_SUM, NSF_STOP_PAYMENT_COUNT NSF_STOP_PAYMENT_COUNT, NSF_STOP_PAYMENT_AMOUNT NSF_STOP_PAYMENT_AMOUNT, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5 from "AR"."AR_TRX_SUMMARY"

View Text - HTML Formatted

SELECT CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SITE_USE_ID SITE_USE_ID
, ORG_ID ORG_ID
, CURRENCY CURRENCY
, AS_OF_DATE AS_OF_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OP_BAL_HIGH_WATERMARK OP_BAL_HIGH_WATERMARK
, OP_BAL_HIGH_WATERMARK_DATE OP_BAL_HIGH_WATERMARK_DATE
, TOTAL_CASH_RECEIPTS_VALUE TOTAL_CASH_RECEIPTS_VALUE
, TOTAL_CASH_RECEIPTS_COUNT TOTAL_CASH_RECEIPTS_COUNT
, TOTAL_INVOICES_VALUE TOTAL_INVOICES_VALUE
, TOTAL_INVOICES_COUNT TOTAL_INVOICES_COUNT
, INV_PAID_AMOUNT INV_PAID_AMOUNT
, INV_INST_PMT_DAYS_SUM INV_INST_PMT_DAYS_SUM
, TOTAL_BILLS_RECEIVABLES_VALUE TOTAL_BILLS_RECEIVABLES_VALUE
, TOTAL_BILLS_RECEIVABLES_COUNT TOTAL_BILLS_RECEIVABLES_COUNT
, TOTAL_CREDIT_MEMOS_VALUE TOTAL_CREDIT_MEMOS_VALUE
, TOTAL_CREDIT_MEMOS_COUNT TOTAL_CREDIT_MEMOS_COUNT
, TOTAL_DEBIT_MEMOS_VALUE TOTAL_DEBIT_MEMOS_VALUE
, TOTAL_DEBIT_MEMOS_COUNT TOTAL_DEBIT_MEMOS_COUNT
, TOTAL_CHARGEBACK_VALUE TOTAL_CHARGEBACK_VALUE
, TOTAL_CHARGEBACK_COUNT TOTAL_CHARGEBACK_COUNT
, TOTAL_EARNED_DISC_VALUE TOTAL_EARNED_DISC_VALUE
, TOTAL_EARNED_DISC_COUNT TOTAL_EARNED_DISC_COUNT
, TOTAL_UNEARNED_DISC_VALUE TOTAL_UNEARNED_DISC_VALUE
, TOTAL_UNEARNED_DISC_COUNT TOTAL_UNEARNED_DISC_COUNT
, TOTAL_ADJUSTMENTS_VALUE TOTAL_ADJUSTMENTS_VALUE
, TOTAL_ADJUSTMENTS_COUNT TOTAL_ADJUSTMENTS_COUNT
, TOTAL_DEPOSITS_VALUE TOTAL_DEPOSITS_VALUE
, TOTAL_DEPOSITS_COUNT TOTAL_DEPOSITS_COUNT
, SUM_APP_AMT_DAYS_LATE SUM_APP_AMT_DAYS_LATE
, SUM_APP_AMT SUM_APP_AMT
, COUNT_OF_TOT_INV_INST_PAID COUNT_OF_TOT_INV_INST_PAID
, COUNT_OF_INV_INST_PAID_LATE COUNT_OF_INV_INST_PAID_LATE
, COUNT_OF_DISC_INV_INST COUNT_OF_DISC_INV_INST
, LARGEST_INV_AMOUNT LARGEST_INV_AMOUNT
, LARGEST_INV_DATE LARGEST_INV_DATE
, LARGEST_INV_CUST_TRX_ID LARGEST_INV_CUST_TRX_ID
, DAYS_CREDIT_GRANTED_SUM DAYS_CREDIT_GRANTED_SUM
, NSF_STOP_PAYMENT_COUNT NSF_STOP_PAYMENT_COUNT
, NSF_STOP_PAYMENT_AMOUNT NSF_STOP_PAYMENT_AMOUNT
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
FROM "AR"."AR_TRX_SUMMARY"