[Home] [Help]
View: PSPBV_ENC_TRANS_CONTROLS
Product: | PSP - Labor Distribution |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ENC_CONTROL_ID
, PAYROLL_ID
, TIME_PERIOD_ID
, GL_ENC_PERIOD_EXT_VALUE
, OGM_ENC_PERIOD_EXT_VALUE
, ENCUMBRANCE_DATE
, CI_SUMMARIZATION_OPTION
, TIME_SUMMARIZATION_OPTION
, NUMBER_OF_DR
, NUMBER_OF_CR
, TOTAL_DR_AMOUNT
, TOTAL_CR_AMOUNT
, GL_DR_AMOUNT
, GL_CR_AMOUNT
, OGM_DR_AMOUNT
, OGM_CR_AMOUNT
, ACTION_CODE
, RUN_ID
, BATCH_NAME
, SUMM_GL_DR_AMOUNT
, SUMM_GL_CR_AMOUNT
, SUMM_OGM_DR_AMOUNT
, SUMM_OGM_CR_AMOUNT
, BUSINESS_GROUP_ID
, ACTION_TYPE
, SET_OF_BOOKS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSP_ENC_CONTROLS WITH READ ONLY
Columns
Name |
ENC_CONTROL_ID |
PAYROLL_ID |
TIME_PERIOD_ID |
GL_ENC_PERIOD_EXT_VALUE |
OGM_ENC_PERIOD_EXT_VALUE |
ENCUMBRANCE_DATE |
CI_SUMMARIZATION_OPTION |
TIME_SUMMARIZATION_OPTION |
NUMBER_OF_DR |
NUMBER_OF_CR |
TOTAL_DR_AMOUNT |
TOTAL_CR_AMOUNT |
GL_DR_AMOUNT |
GL_CR_AMOUNT |
OGM_DR_AMOUNT |
OGM_CR_AMOUNT |
ACTION_CODE |
RUN_ID |
BATCH_NAME |
SUMM_GL_DR_AMOUNT |
SUMM_GL_CR_AMOUNT |
SUMM_OGM_DR_AMOUNT |
SUMM_OGM_CR_AMOUNT |
BUSINESS_GROUP_ID |
ACTION_TYPE |
SET_OF_BOOKS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |