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

Source

View Text - Preformatted


select CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NUMBER CUSTOMER_NUMBER, SHORT_CUSTOMER_NAME SHORT_CUSTOMER_NAME, SORT_FIELD1 SORT_FIELD1, SORT_FIELD2 SORT_FIELD2, INV_TID_INV INV_TID_INV, CONTACT_SITE_ID CONTACT_SITE_ID, CUSTOMER_STATE CUSTOMER_STATE, CUSTOMER_CITY CUSTOMER_CITY, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CLASS CLASS, DUE_DATE DUE_DATE, AMT_DUE_REMAINING AMT_DUE_REMAINING, TRX_NUMBER TRX_NUMBER, DAYS_PAST_DUE DAYS_PAST_DUE, AMOUNT_ADJUSTED AMOUNT_ADJUSTED, AMOUNT_APPLIED AMOUNT_APPLIED, AMOUNT_CREDITED AMOUNT_CREDITED, GL_DATE GL_DATE, DATA_CONVERTED_FLAG DATA_CONVERTED_FLAG, EXCHANGE_RATE EXCHANGE_RATE, BUCKET_0 BUCKET_0, BUCKET_1 BUCKET_1, BUCKET_2 BUCKET_2, BUCKET_3 BUCKET_3, BUCKET_4 BUCKET_4, BUCKET_5 BUCKET_5, BUCKET_6 BUCKET_6, BAL_SEGMENT_VALUE BAL_SEGMENT_VALUE, INVOICE_TYPE INVOICE_TYPE, CONS_BILLING_NUMBER CONS_BILLING_NUMBER, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE CONTACT_PHONE, CATEGORY CATEGORY, PARENT_REQUEST_ID PARENT_REQUEST_ID, WORKER_ID WORKER_ID from "AR"."AR_AGING_EXTRACT"

View Text - HTML Formatted

SELECT CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, SHORT_CUSTOMER_NAME SHORT_CUSTOMER_NAME
, SORT_FIELD1 SORT_FIELD1
, SORT_FIELD2 SORT_FIELD2
, INV_TID_INV INV_TID_INV
, CONTACT_SITE_ID CONTACT_SITE_ID
, CUSTOMER_STATE CUSTOMER_STATE
, CUSTOMER_CITY CUSTOMER_CITY
, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CLASS CLASS
, DUE_DATE DUE_DATE
, AMT_DUE_REMAINING AMT_DUE_REMAINING
, TRX_NUMBER TRX_NUMBER
, DAYS_PAST_DUE DAYS_PAST_DUE
, AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, AMOUNT_APPLIED AMOUNT_APPLIED
, AMOUNT_CREDITED AMOUNT_CREDITED
, GL_DATE GL_DATE
, DATA_CONVERTED_FLAG DATA_CONVERTED_FLAG
, EXCHANGE_RATE EXCHANGE_RATE
, BUCKET_0 BUCKET_0
, BUCKET_1 BUCKET_1
, BUCKET_2 BUCKET_2
, BUCKET_3 BUCKET_3
, BUCKET_4 BUCKET_4
, BUCKET_5 BUCKET_5
, BUCKET_6 BUCKET_6
, BAL_SEGMENT_VALUE BAL_SEGMENT_VALUE
, INVOICE_TYPE INVOICE_TYPE
, CONS_BILLING_NUMBER CONS_BILLING_NUMBER
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE CONTACT_PHONE
, CATEGORY CATEGORY
, PARENT_REQUEST_ID PARENT_REQUEST_ID
, WORKER_ID WORKER_ID
FROM "AR"."AR_AGING_EXTRACT"