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_SUMMARY_LINES_D_V

Product:	PSP - Labor Distribution
Description:	Shows summary lines that are for debit
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUMMARY_LINE_ID
, PERSON_ID
, ASSIGNMENT_ID
, SOURCE_CODE
, SOURCE_TYPE
, TIME_PERIOD_ID
, INTERFACE_BATCH_NAME BATCH_NAME
, SUMMARY_AMOUNT
, GL_CODE_COMBINATION_ID
, PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, TASK_ID
, AWARD_ID
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_SUMMARY_LINES A
WHERE A.DR_CR_FLAG = 'D'
AND A.STATUS_CODE = 'A'

Columns

Name
SUMMARY_LINE_ID
PERSON_ID
ASSIGNMENT_ID
SOURCE_CODE
SOURCE_TYPE
TIME_PERIOD_ID
BATCH_NAME
SUMMARY_AMOUNT
GL_CODE_COMBINATION_ID
PROJECT_ID
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_TYPE
TASK_ID
AWARD_ID
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID