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

Source

View Text - Preformatted


select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRX_NUMBER TRX_NUMBER, CUSTOMER_NAME CUSTOMER_NAME, CUST_ADDRESS1 CUST_ADDRESS1, REMIT_TO_ADDRESS_ADDRESS1 REMIT_TO_ADDRESS_ADDRESS1, CUST_ADDRESS2 CUST_ADDRESS2, CUST_ADDRESS3 CUST_ADDRESS3, CUST_ADDRESS4 CUST_ADDRESS4, CUST_CITY CUST_CITY, CUST_STATE CUST_STATE, CUST_POSTAL_CODE CUST_POSTAL_CODE, REMIT_TO_ADDRESS_ADDRESS2 REMIT_TO_ADDRESS_ADDRESS2, REMIT_TO_ADDRESS_ADDRESS3 REMIT_TO_ADDRESS_ADDRESS3, REMIT_TO_ADDRESS_ADDRESS4 REMIT_TO_ADDRESS_ADDRESS4, REMIT_TO_ADDRESS_CITY REMIT_TO_ADDRESS_CITY, REMIT_TO_ADDRESS_STATE REMIT_TO_ADDRESS_STATE, REMIT_TO_ADDRESS_POSTAL_CODE REMIT_TO_ADDRESS_POSTAL_CODE, ACCT_OFC_CHRG ACCT_OFC_CHRG from "FV"."FV_SF1080_HEADER_TEMP"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRX_NUMBER TRX_NUMBER
, CUSTOMER_NAME CUSTOMER_NAME
, CUST_ADDRESS1 CUST_ADDRESS1
, REMIT_TO_ADDRESS_ADDRESS1 REMIT_TO_ADDRESS_ADDRESS1
, CUST_ADDRESS2 CUST_ADDRESS2
, CUST_ADDRESS3 CUST_ADDRESS3
, CUST_ADDRESS4 CUST_ADDRESS4
, CUST_CITY CUST_CITY
, CUST_STATE CUST_STATE
, CUST_POSTAL_CODE CUST_POSTAL_CODE
, REMIT_TO_ADDRESS_ADDRESS2 REMIT_TO_ADDRESS_ADDRESS2
, REMIT_TO_ADDRESS_ADDRESS3 REMIT_TO_ADDRESS_ADDRESS3
, REMIT_TO_ADDRESS_ADDRESS4 REMIT_TO_ADDRESS_ADDRESS4
, REMIT_TO_ADDRESS_CITY REMIT_TO_ADDRESS_CITY
, REMIT_TO_ADDRESS_STATE REMIT_TO_ADDRESS_STATE
, REMIT_TO_ADDRESS_POSTAL_CODE REMIT_TO_ADDRESS_POSTAL_CODE
, ACCT_OFC_CHRG ACCT_OFC_CHRG
FROM "FV"."FV_SF1080_HEADER_TEMP"