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

Source

View Text - Preformatted


select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_NUMBER TRX_NUMBER, CUSTOMER_NAME CUSTOMER_NAME, CUST_ADDRESS1 CUST_ADDRESS1, CUST_ADDRESS2 CUST_ADDRESS2, CUST_ADDRESS3 CUST_ADDRESS3, CUST_CITY CUST_CITY, CUST_STATE CUST_STATE, CUST_POSTAL_CODE CUST_POSTAL_CODE, TAX_REFERENCE TAX_REFERENCE, TREASURY_SYMBOL TREASURY_SYMBOL, AMOUNT AMOUNT, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, TRX_DATE TRX_DATE, ALC_CODE ALC_CODE from "FV"."FV_SF1081_TEMP"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_NUMBER TRX_NUMBER
, CUSTOMER_NAME CUSTOMER_NAME
, CUST_ADDRESS1 CUST_ADDRESS1
, CUST_ADDRESS2 CUST_ADDRESS2
, CUST_ADDRESS3 CUST_ADDRESS3
, CUST_CITY CUST_CITY
, CUST_STATE CUST_STATE
, CUST_POSTAL_CODE CUST_POSTAL_CODE
, TAX_REFERENCE TAX_REFERENCE
, TREASURY_SYMBOL TREASURY_SYMBOL
, AMOUNT AMOUNT
, BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, TRX_DATE TRX_DATE
, ALC_CODE ALC_CODE
FROM "FV"."FV_SF1081_TEMP"