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: PSPBV_PAYROLL_TRANS_CONTROLS

Product:	PSP - Labor Distribution
Description:	PSPBV_PAYROLL_TRANS_CONTROLS displays information about the payroll transaction control.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPC.PAYROLL_CONTROL_ID
, PPC.RUN_ID
, PPC.BATCH_NAME
, PPC.PAYROLL_SOURCE_CODE
, '_LA:SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PPC.NUMBER_OF_CR
, PPC.NUMBER_OF_DR
, PPC.TOTAL_DR_AMOUNT
, PPC.TOTAL_CR_AMOUNT
, PPC.SUBLINES_DR_AMOUNT
, PPC.SUBLINES_CR_AMOUNT
, PPC.DIST_DR_AMOUNT
, PPC.DIST_CR_AMOUNT
, PPC.OGM_DR_AMOUNT
, PPC.OGM_CR_AMOUNT
, PPC.GL_DR_AMOUNT
, PPC.GL_CR_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPC.PAYROLL_ACTION_ID
, PPC.TIME_PERIOD_ID
, PPC.PAYROLL_ID
, PPC.SET_OF_BOOKS_ID
, PPC.BUSINESS_GROUP_ID
, PPC.GL_PHASE
, PPC.GMS_PHASE
, PPC.ADJ_SUM_BATCH_NAME
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATED_BY
, PPC.CREATION_DATE
FROM PSP_PAYROLL_CONTROLS PPC WITH READ ONLY

Columns

Name
PAYROLL_CONTROL_ID
BATCH_RUN_ID
BATCH_NAME
PAYROLL_SOURCE_CODE
"_LA:PAYROLL_SOURCE_TYPE"
NUMBER_OF_CREDIT_TRANSACTIONS
NUMBER_OF_DEBIT_TRANSACTIONS
TOTAL_DEBIT_AMOUNT
TOTAL_CREDIT_AMOUNT
TOTAL_SUBLINES_DEBIT_AMOUNT
TOTAL_SUBLINES_CREDIT_AMOUNT
TOTAL_DIST_DEBIT_AMOUNT
TOTAL_DIST_CREDIT_AMOUNT
GRANTS_TOTAL_DEBIT__AMOUNT
GRANTS_TOTAL_CREDIT_AMOUNT
GL_TOTAL_DEBIT_SHARE_AMOUNT
GL_TOTAL_CREDIT_SHARE_AMOUNT
"_LA:BATCH_STATUS_FLAG"
PAYROLL_ACTION_ID
TIME_PERIOD_ID
PAYROLL_ID
SET_OF_BOOKS_ID
BUSINESS_GROUP_ID
GL_PHASE
GMS_PHASE
ADJ_SUM_BATCH_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE