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

Source

View Text - Preformatted


select CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SITE_USE_ID SITE_USE_ID, ORG_ID ORG_ID, CURRENCY CURRENCY, 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, BEST_CURRENT_RECEIVABLES BEST_CURRENT_RECEIVABLES, TOTAL_DSO_DAYS_CREDIT TOTAL_DSO_DAYS_CREDIT, OP_INVOICES_VALUE OP_INVOICES_VALUE, OP_INVOICES_COUNT OP_INVOICES_COUNT, OP_DEBIT_MEMOS_VALUE OP_DEBIT_MEMOS_VALUE, OP_DEBIT_MEMOS_COUNT OP_DEBIT_MEMOS_COUNT, OP_DEPOSITS_VALUE OP_DEPOSITS_VALUE, OP_DEPOSITS_COUNT OP_DEPOSITS_COUNT, OP_BILLS_RECEIVABLES_VALUE OP_BILLS_RECEIVABLES_VALUE, OP_BILLS_RECEIVABLES_COUNT OP_BILLS_RECEIVABLES_COUNT, OP_CHARGEBACK_VALUE OP_CHARGEBACK_VALUE, OP_CHARGEBACK_COUNT OP_CHARGEBACK_COUNT, OP_CREDIT_MEMOS_VALUE OP_CREDIT_MEMOS_VALUE, OP_CREDIT_MEMOS_COUNT OP_CREDIT_MEMOS_COUNT, UNRESOLVED_CASH_VALUE UNRESOLVED_CASH_VALUE, UNRESOLVED_CASH_COUNT UNRESOLVED_CASH_COUNT, RECEIPTS_AT_RISK_VALUE RECEIPTS_AT_RISK_VALUE, INV_AMT_IN_DISPUTE INV_AMT_IN_DISPUTE, DISPUTED_INV_COUNT DISPUTED_INV_COUNT, PENDING_ADJ_VALUE PENDING_ADJ_VALUE, LAST_DUNNING_DATE LAST_DUNNING_DATE, DUNNING_COUNT DUNNING_COUNT, PAST_DUE_INV_VALUE PAST_DUE_INV_VALUE, PAST_DUE_INV_INST_COUNT PAST_DUE_INV_INST_COUNT, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT, LAST_PAYMENT_DATE LAST_PAYMENT_DATE, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5 from "AR"."AR_TRX_BAL_SUMMARY"

View Text - HTML Formatted

SELECT CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SITE_USE_ID SITE_USE_ID
, ORG_ID ORG_ID
, CURRENCY CURRENCY
, 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
, BEST_CURRENT_RECEIVABLES BEST_CURRENT_RECEIVABLES
, TOTAL_DSO_DAYS_CREDIT TOTAL_DSO_DAYS_CREDIT
, OP_INVOICES_VALUE OP_INVOICES_VALUE
, OP_INVOICES_COUNT OP_INVOICES_COUNT
, OP_DEBIT_MEMOS_VALUE OP_DEBIT_MEMOS_VALUE
, OP_DEBIT_MEMOS_COUNT OP_DEBIT_MEMOS_COUNT
, OP_DEPOSITS_VALUE OP_DEPOSITS_VALUE
, OP_DEPOSITS_COUNT OP_DEPOSITS_COUNT
, OP_BILLS_RECEIVABLES_VALUE OP_BILLS_RECEIVABLES_VALUE
, OP_BILLS_RECEIVABLES_COUNT OP_BILLS_RECEIVABLES_COUNT
, OP_CHARGEBACK_VALUE OP_CHARGEBACK_VALUE
, OP_CHARGEBACK_COUNT OP_CHARGEBACK_COUNT
, OP_CREDIT_MEMOS_VALUE OP_CREDIT_MEMOS_VALUE
, OP_CREDIT_MEMOS_COUNT OP_CREDIT_MEMOS_COUNT
, UNRESOLVED_CASH_VALUE UNRESOLVED_CASH_VALUE
, UNRESOLVED_CASH_COUNT UNRESOLVED_CASH_COUNT
, RECEIPTS_AT_RISK_VALUE RECEIPTS_AT_RISK_VALUE
, INV_AMT_IN_DISPUTE INV_AMT_IN_DISPUTE
, DISPUTED_INV_COUNT DISPUTED_INV_COUNT
, PENDING_ADJ_VALUE PENDING_ADJ_VALUE
, LAST_DUNNING_DATE LAST_DUNNING_DATE
, DUNNING_COUNT DUNNING_COUNT
, PAST_DUE_INV_VALUE PAST_DUE_INV_VALUE
, PAST_DUE_INV_INST_COUNT PAST_DUE_INV_INST_COUNT
, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT
, LAST_PAYMENT_DATE LAST_PAYMENT_DATE
, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
FROM "AR"."AR_TRX_BAL_SUMMARY"