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

Source

View Text - Preformatted


select CHECKRUN_NAME CHECKRUN_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ORG_ID ORG_ID, PAYMENT_FORMAT_NAME PAYMENT_FORMAT_NAME, FORMAT_PAYMENTS_FRIENDLY_NAME FORMAT_PAYMENTS_FRIENDLY_NAME, PAY_GROUP_CODE PAY_GROUP_CODE, RFC_IDENTIFIER RFC_IDENTIFIER, FED_EMPLOYER_ID_NUMBER FED_EMPLOYER_ID_NUMBER, AGENCY_ID AGENCY_ID, AGENCY_ALC_CODE AGENCY_ALC_CODE, AGENCY_NAME AGENCY_NAME, AGENCY_ADDRESS_LINE_1 AGENCY_ADDRESS_LINE_1, AGENCY_ADDRESS_LINE_2 AGENCY_ADDRESS_LINE_2, AGENCY_CITY_STATE_ZIP AGENCY_CITY_STATE_ZIP, AGENCY_TELEPHONE_NUMBER1 AGENCY_TELEPHONE_NUMBER1, CHECK_DATE CHECK_DATE, EMP_ECS_PAY_TYPE_CODE EMP_ECS_PAY_TYPE_CODE, SCHEDULE_RECORD_COUNT SCHEDULE_RECORD_COUNT, TOTAL_SCHEDULE_AMOUNT TOTAL_SCHEDULE_AMOUNT from "FV"."FV_TP_BULK_FMT_DATA"

View Text - HTML Formatted

SELECT CHECKRUN_NAME CHECKRUN_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ORG_ID ORG_ID
, PAYMENT_FORMAT_NAME PAYMENT_FORMAT_NAME
, FORMAT_PAYMENTS_FRIENDLY_NAME FORMAT_PAYMENTS_FRIENDLY_NAME
, PAY_GROUP_CODE PAY_GROUP_CODE
, RFC_IDENTIFIER RFC_IDENTIFIER
, FED_EMPLOYER_ID_NUMBER FED_EMPLOYER_ID_NUMBER
, AGENCY_ID AGENCY_ID
, AGENCY_ALC_CODE AGENCY_ALC_CODE
, AGENCY_NAME AGENCY_NAME
, AGENCY_ADDRESS_LINE_1 AGENCY_ADDRESS_LINE_1
, AGENCY_ADDRESS_LINE_2 AGENCY_ADDRESS_LINE_2
, AGENCY_CITY_STATE_ZIP AGENCY_CITY_STATE_ZIP
, AGENCY_TELEPHONE_NUMBER1 AGENCY_TELEPHONE_NUMBER1
, CHECK_DATE CHECK_DATE
, EMP_ECS_PAY_TYPE_CODE EMP_ECS_PAY_TYPE_CODE
, SCHEDULE_RECORD_COUNT SCHEDULE_RECORD_COUNT
, TOTAL_SCHEDULE_AMOUNT TOTAL_SCHEDULE_AMOUNT
FROM "FV"."FV_TP_BULK_FMT_DATA"