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: PSP.PSP_PAYROLL_CONTROLS#

Source

View Text - Preformatted


select PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID, PAYROLL_ACTION_ID PAYROLL_ACTION_ID, PAYROLL_ID PAYROLL_ID, NUMBER_OF_CR NUMBER_OF_CR, NUMBER_OF_DR NUMBER_OF_DR, TOTAL_DR_AMOUNT TOTAL_DR_AMOUNT, TOTAL_CR_AMOUNT TOTAL_CR_AMOUNT, SUBLINES_DR_AMOUNT SUBLINES_DR_AMOUNT, SUBLINES_CR_AMOUNT SUBLINES_CR_AMOUNT, DIST_DR_AMOUNT DIST_DR_AMOUNT, DIST_CR_AMOUNT DIST_CR_AMOUNT, OGM_DR_AMOUNT OGM_DR_AMOUNT, OGM_CR_AMOUNT OGM_CR_AMOUNT, GL_DR_AMOUNT GL_DR_AMOUNT, GL_CR_AMOUNT GL_CR_AMOUNT, PAYROLL_SOURCE_CODE PAYROLL_SOURCE_CODE, RUN_ID RUN_ID, TIME_PERIOD_ID TIME_PERIOD_ID, BATCH_NAME BATCH_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SOURCE_TYPE SOURCE_TYPE, PHASE PHASE, STATUS_CODE STATUS_CODE, GL_POSTING_OVERRIDE_DATE GL_POSTING_OVERRIDE_DATE, GMS_POSTING_OVERRIDE_DATE GMS_POSTING_OVERRIDE_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, GL_PHASE GL_PHASE, GMS_PHASE GMS_PHASE, ADJ_SUM_BATCH_NAME ADJ_SUM_BATCH_NAME, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ARCHIVE_FLAG ARCHIVE_FLAG, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, CDL_PAYROLL_ACTION_ID CDL_PAYROLL_ACTION_ID, PARENT_PAYROLL_CONTROL_ID PARENT_PAYROLL_CONTROL_ID from "PSP"."PSP_PAYROLL_CONTROLS"

View Text - HTML Formatted

SELECT PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID
, PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PAYROLL_ID PAYROLL_ID
, NUMBER_OF_CR NUMBER_OF_CR
, NUMBER_OF_DR NUMBER_OF_DR
, TOTAL_DR_AMOUNT TOTAL_DR_AMOUNT
, TOTAL_CR_AMOUNT TOTAL_CR_AMOUNT
, SUBLINES_DR_AMOUNT SUBLINES_DR_AMOUNT
, SUBLINES_CR_AMOUNT SUBLINES_CR_AMOUNT
, DIST_DR_AMOUNT DIST_DR_AMOUNT
, DIST_CR_AMOUNT DIST_CR_AMOUNT
, OGM_DR_AMOUNT OGM_DR_AMOUNT
, OGM_CR_AMOUNT OGM_CR_AMOUNT
, GL_DR_AMOUNT GL_DR_AMOUNT
, GL_CR_AMOUNT GL_CR_AMOUNT
, PAYROLL_SOURCE_CODE PAYROLL_SOURCE_CODE
, RUN_ID RUN_ID
, TIME_PERIOD_ID TIME_PERIOD_ID
, BATCH_NAME BATCH_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_TYPE SOURCE_TYPE
, PHASE PHASE
, STATUS_CODE STATUS_CODE
, GL_POSTING_OVERRIDE_DATE GL_POSTING_OVERRIDE_DATE
, GMS_POSTING_OVERRIDE_DATE GMS_POSTING_OVERRIDE_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GL_PHASE GL_PHASE
, GMS_PHASE GMS_PHASE
, ADJ_SUM_BATCH_NAME ADJ_SUM_BATCH_NAME
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ARCHIVE_FLAG ARCHIVE_FLAG
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, CDL_PAYROLL_ACTION_ID CDL_PAYROLL_ACTION_ID
, PARENT_PAYROLL_CONTROL_ID PARENT_PAYROLL_CONTROL_ID
FROM "PSP"."PSP_PAYROLL_CONTROLS"