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

Source

View Text - Preformatted


select LINE_CLUSTER_ID LINE_CLUSTER_ID, SEND_TO_ADDRESS_ID SEND_TO_ADDRESS_ID, CUSTOMER_ID CUSTOMER_ID, REMIT_TO_ADDRESS_ID REMIT_TO_ADDRESS_ID, STATEMENT_DATE STATEMENT_DATE, CURRENCY_CODE CURRENCY_CODE, BUCKET1_HEADING BUCKET1_HEADING, BUCKET2_HEADING BUCKET2_HEADING, BUCKET3_HEADING BUCKET3_HEADING, BUCKET4_HEADING BUCKET4_HEADING, BUCKET5_HEADING BUCKET5_HEADING, BUCKET1 BUCKET1, BUCKET2 BUCKET2, BUCKET3 BUCKET3, BUCKET4 BUCKET4, BUCKET5 BUCKET5, FINANCE_CHARGES FINANCE_CHARGES, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE, ERROR_AMOUNT_DIFFERENT ERROR_AMOUNT_DIFFERENT, ERROR_NO_SEND_TO ERROR_NO_SEND_TO, ERROR_NO_REMIT_TO ERROR_NO_REMIT_TO, ERROR_NO_LINES ERROR_NO_LINES, MESSAGE1 MESSAGE1, MESSAGE2 MESSAGE2, MESSAGE3 MESSAGE3, MESSAGE4 MESSAGE4, MESSAGE5 MESSAGE5, MESSAGE6 MESSAGE6, MESSAGE7 MESSAGE7, MESSAGE8 MESSAGE8, MESSAGE1_LINE_COUNT MESSAGE1_LINE_COUNT, MESSAGE2_LINE_COUNT MESSAGE2_LINE_COUNT, MESSAGE3_LINE_COUNT MESSAGE3_LINE_COUNT, MESSAGE4_LINE_COUNT MESSAGE4_LINE_COUNT, MESSAGE5_LINE_COUNT MESSAGE5_LINE_COUNT, MESSAGE6_LINE_COUNT MESSAGE6_LINE_COUNT, MESSAGE7_LINE_COUNT MESSAGE7_LINE_COUNT, MESSAGE8_LINE_COUNT MESSAGE8_LINE_COUNT, REQUEST_ID REQUEST_ID, SITE_USE_ID SITE_USE_ID, STATEMENT_TYPE STATEMENT_TYPE, BILL_TO_LOCATION BILL_TO_LOCATION, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS, CUST_CUSTOMER_PROFILE_ID CUST_CUSTOMER_PROFILE_ID, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT, MONTHLY_INTEREST_RATE MONTHLY_INTEREST_RATE, SITE_CUSTOMER_PROFILE_ID SITE_CUSTOMER_PROFILE_ID from "AR"."AR_STATEMENT_HEADERS"

View Text - HTML Formatted

SELECT LINE_CLUSTER_ID LINE_CLUSTER_ID
, SEND_TO_ADDRESS_ID SEND_TO_ADDRESS_ID
, CUSTOMER_ID CUSTOMER_ID
, REMIT_TO_ADDRESS_ID REMIT_TO_ADDRESS_ID
, STATEMENT_DATE STATEMENT_DATE
, CURRENCY_CODE CURRENCY_CODE
, BUCKET1_HEADING BUCKET1_HEADING
, BUCKET2_HEADING BUCKET2_HEADING
, BUCKET3_HEADING BUCKET3_HEADING
, BUCKET4_HEADING BUCKET4_HEADING
, BUCKET5_HEADING BUCKET5_HEADING
, BUCKET1 BUCKET1
, BUCKET2 BUCKET2
, BUCKET3 BUCKET3
, BUCKET4 BUCKET4
, BUCKET5 BUCKET5
, FINANCE_CHARGES FINANCE_CHARGES
, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE
, ERROR_AMOUNT_DIFFERENT ERROR_AMOUNT_DIFFERENT
, ERROR_NO_SEND_TO ERROR_NO_SEND_TO
, ERROR_NO_REMIT_TO ERROR_NO_REMIT_TO
, ERROR_NO_LINES ERROR_NO_LINES
, MESSAGE1 MESSAGE1
, MESSAGE2 MESSAGE2
, MESSAGE3 MESSAGE3
, MESSAGE4 MESSAGE4
, MESSAGE5 MESSAGE5
, MESSAGE6 MESSAGE6
, MESSAGE7 MESSAGE7
, MESSAGE8 MESSAGE8
, MESSAGE1_LINE_COUNT MESSAGE1_LINE_COUNT
, MESSAGE2_LINE_COUNT MESSAGE2_LINE_COUNT
, MESSAGE3_LINE_COUNT MESSAGE3_LINE_COUNT
, MESSAGE4_LINE_COUNT MESSAGE4_LINE_COUNT
, MESSAGE5_LINE_COUNT MESSAGE5_LINE_COUNT
, MESSAGE6_LINE_COUNT MESSAGE6_LINE_COUNT
, MESSAGE7_LINE_COUNT MESSAGE7_LINE_COUNT
, MESSAGE8_LINE_COUNT MESSAGE8_LINE_COUNT
, REQUEST_ID REQUEST_ID
, SITE_USE_ID SITE_USE_ID
, STATEMENT_TYPE STATEMENT_TYPE
, BILL_TO_LOCATION BILL_TO_LOCATION
, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS
, CUST_CUSTOMER_PROFILE_ID CUST_CUSTOMER_PROFILE_ID
, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT
, MONTHLY_INTEREST_RATE MONTHLY_INTEREST_RATE
, SITE_CUSTOMER_PROFILE_ID SITE_CUSTOMER_PROFILE_ID
FROM "AR"."AR_STATEMENT_HEADERS"