[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 |