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

Source

View Text - Preformatted


select ARCHIVE_ID ARCHIVE_ID, PERIOD_NUMBER PERIOD_NUMBER, PERIOD_NAME PERIOD_NAME, INVOICES_CNT INVOICES_CNT, CREDIT_MEMOS_CNT CREDIT_MEMOS_CNT, DEBIT_MEMOS_CNT DEBIT_MEMOS_CNT, CHARGEBACKS_CNT CHARGEBACKS_CNT, DEPOSITS_CNT DEPOSITS_CNT, ADJUSTMENTS_CNT ADJUSTMENTS_CNT, CASH_RECEIPTS_CNT CASH_RECEIPTS_CNT, INVOICES_NO_REC_CNT INVOICES_NO_REC_CNT, CREDIT_MEMOS_NO_REC_CNT CREDIT_MEMOS_NO_REC_CNT, DEBIT_MEMOS_NO_REC_CNT DEBIT_MEMOS_NO_REC_CNT, CHARGEBACKS_NO_REC_CNT CHARGEBACKS_NO_REC_CNT, DEPOSITS_NO_REC_CNT DEPOSITS_NO_REC_CNT, GUARANTEES_CNT GUARANTEES_CNT, MISC_RECEIPTS_CNT MISC_RECEIPTS_CNT, INVOICES_TOTAL INVOICES_TOTAL, CREDIT_MEMOS_TOTAL CREDIT_MEMOS_TOTAL, DEBIT_MEMOS_TOTAL DEBIT_MEMOS_TOTAL, CHARGEBACKS_TOTAL CHARGEBACKS_TOTAL, DEPOSITS_TOTAL DEPOSITS_TOTAL, ADJUSTMENTS_TOTAL ADJUSTMENTS_TOTAL, CASH_RECEIPTS_TOTAL CASH_RECEIPTS_TOTAL, DISCOUNTS_TOTAL DISCOUNTS_TOTAL, EXCHANGE_GAIN_LOSS_TOTAL EXCHANGE_GAIN_LOSS_TOTAL, INVOICES_NO_REC_TOTAL INVOICES_NO_REC_TOTAL, CREDIT_MEMOS_NO_REC_TOTAL CREDIT_MEMOS_NO_REC_TOTAL, DEBIT_MEMOS_NO_REC_TOTAL DEBIT_MEMOS_NO_REC_TOTAL, CHARGEBACKS_NO_REC_TOTAL CHARGEBACKS_NO_REC_TOTAL, DEPOSITS_NO_REC_TOTAL DEPOSITS_NO_REC_TOTAL, GUARANTEES_TOTAL GUARANTEES_TOTAL, MISC_RECEIPTS_TOTAL MISC_RECEIPTS_TOTAL from "AR"."AR_ARCHIVE_CONTROL_DETAIL"

View Text - HTML Formatted

SELECT ARCHIVE_ID ARCHIVE_ID
, PERIOD_NUMBER PERIOD_NUMBER
, PERIOD_NAME PERIOD_NAME
, INVOICES_CNT INVOICES_CNT
, CREDIT_MEMOS_CNT CREDIT_MEMOS_CNT
, DEBIT_MEMOS_CNT DEBIT_MEMOS_CNT
, CHARGEBACKS_CNT CHARGEBACKS_CNT
, DEPOSITS_CNT DEPOSITS_CNT
, ADJUSTMENTS_CNT ADJUSTMENTS_CNT
, CASH_RECEIPTS_CNT CASH_RECEIPTS_CNT
, INVOICES_NO_REC_CNT INVOICES_NO_REC_CNT
, CREDIT_MEMOS_NO_REC_CNT CREDIT_MEMOS_NO_REC_CNT
, DEBIT_MEMOS_NO_REC_CNT DEBIT_MEMOS_NO_REC_CNT
, CHARGEBACKS_NO_REC_CNT CHARGEBACKS_NO_REC_CNT
, DEPOSITS_NO_REC_CNT DEPOSITS_NO_REC_CNT
, GUARANTEES_CNT GUARANTEES_CNT
, MISC_RECEIPTS_CNT MISC_RECEIPTS_CNT
, INVOICES_TOTAL INVOICES_TOTAL
, CREDIT_MEMOS_TOTAL CREDIT_MEMOS_TOTAL
, DEBIT_MEMOS_TOTAL DEBIT_MEMOS_TOTAL
, CHARGEBACKS_TOTAL CHARGEBACKS_TOTAL
, DEPOSITS_TOTAL DEPOSITS_TOTAL
, ADJUSTMENTS_TOTAL ADJUSTMENTS_TOTAL
, CASH_RECEIPTS_TOTAL CASH_RECEIPTS_TOTAL
, DISCOUNTS_TOTAL DISCOUNTS_TOTAL
, EXCHANGE_GAIN_LOSS_TOTAL EXCHANGE_GAIN_LOSS_TOTAL
, INVOICES_NO_REC_TOTAL INVOICES_NO_REC_TOTAL
, CREDIT_MEMOS_NO_REC_TOTAL CREDIT_MEMOS_NO_REC_TOTAL
, DEBIT_MEMOS_NO_REC_TOTAL DEBIT_MEMOS_NO_REC_TOTAL
, CHARGEBACKS_NO_REC_TOTAL CHARGEBACKS_NO_REC_TOTAL
, DEPOSITS_NO_REC_TOTAL DEPOSITS_NO_REC_TOTAL
, GUARANTEES_TOTAL GUARANTEES_TOTAL
, MISC_RECEIPTS_TOTAL MISC_RECEIPTS_TOTAL
FROM "AR"."AR_ARCHIVE_CONTROL_DETAIL"