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: FV.FV_DELINQ_INVOICES_ALL#

Source

View Text - Preformatted


select CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, PARTY_ID PARTY_ID, PARTY_TYPE PARTY_TYPE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_NUMBER TRX_NUMBER, DEBT_TYPE DEBT_TYPE, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID, TRX_DATE TRX_DATE, TERM_DUE_DATE TERM_DUE_DATE, DAYS_PAST_DUE DAYS_PAST_DUE, ORIGINAL ORIGINAL, PRINCIPAL PRINCIPAL, ADD_INT ADD_INT, ADMIN_COST ADMIN_COST, PEN_CHARGES PEN_CHARGES, TOT_REFERRED TOT_REFERRED, PROGRAM_CODE PROGRAM_CODE, INT_CAL_DATE INT_CAL_DATE, TAX_REFERENCE TAX_REFERENCE, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, PERSON_CITY PERSON_CITY, PERSON_STATE PERSON_STATE, POSTAL_CODE POSTAL_CODE, AREA_CODE AREA_CODE, PHONE_NUMBER PHONE_NUMBER, EXTENSION EXTENSION, BANK_NAME BANK_NAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, CITY CITY, STATE STATE, ZIP ZIP, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, PARTY_NAME PARTY_NAME, DUNS_NUMBER DUNS_NUMBER, RECEIPT_DATE RECEIPT_DATE, AMOUNT AMOUNT, ERR_MSG ERR_MSG, ORG_ID ORG_ID from "FV"."FV_DELINQ_INVOICES_ALL"

View Text - HTML Formatted

SELECT CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, PARTY_ID PARTY_ID
, PARTY_TYPE PARTY_TYPE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_NUMBER TRX_NUMBER
, DEBT_TYPE DEBT_TYPE
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, TRX_DATE TRX_DATE
, TERM_DUE_DATE TERM_DUE_DATE
, DAYS_PAST_DUE DAYS_PAST_DUE
, ORIGINAL ORIGINAL
, PRINCIPAL PRINCIPAL
, ADD_INT ADD_INT
, ADMIN_COST ADMIN_COST
, PEN_CHARGES PEN_CHARGES
, TOT_REFERRED TOT_REFERRED
, PROGRAM_CODE PROGRAM_CODE
, INT_CAL_DATE INT_CAL_DATE
, TAX_REFERENCE TAX_REFERENCE
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, PERSON_CITY PERSON_CITY
, PERSON_STATE PERSON_STATE
, POSTAL_CODE POSTAL_CODE
, AREA_CODE AREA_CODE
, PHONE_NUMBER PHONE_NUMBER
, EXTENSION EXTENSION
, BANK_NAME BANK_NAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, CITY CITY
, STATE STATE
, ZIP ZIP
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, PARTY_NAME PARTY_NAME
, DUNS_NUMBER DUNS_NUMBER
, RECEIPT_DATE RECEIPT_DATE
, AMOUNT AMOUNT
, ERR_MSG ERR_MSG
, ORG_ID ORG_ID
FROM "FV"."FV_DELINQ_INVOICES_ALL"