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.

VIEW: PSP.PSP_PRE_GEN_DIST_LINES_ARCH#

Source

View Text - Preformatted


select PRE_GEN_DIST_LINE_ID PRE_GEN_DIST_LINE_ID, DISTRIBUTION_INTERFACE_ID DISTRIBUTION_INTERFACE_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, DISTRIBUTION_DATE DISTRIBUTION_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, DR_CR_FLAG DR_CR_FLAG, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID, SOURCE_TYPE SOURCE_TYPE, SOURCE_CODE SOURCE_CODE, TIME_PERIOD_ID TIME_PERIOD_ID, BATCH_NAME BATCH_NAME, STATUS_CODE STATUS_CODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, PROJECT_ID PROJECT_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, TASK_ID TASK_ID, AWARD_ID AWARD_ID, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG, EFFORT_REPORT_ID EFFORT_REPORT_ID, VERSION_NUM VERSION_NUM, SUMMARY_LINE_ID SUMMARY_LINE_ID, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG, USER_DEFINED_FIELD USER_DEFINED_FIELD, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE from "PSP"."PSP_PRE_GEN_DIST_LINES_ARCH"

View Text - HTML Formatted

SELECT PRE_GEN_DIST_LINE_ID PRE_GEN_DIST_LINE_ID
, DISTRIBUTION_INTERFACE_ID DISTRIBUTION_INTERFACE_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DISTRIBUTION_DATE DISTRIBUTION_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, DR_CR_FLAG DR_CR_FLAG
, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_CODE SOURCE_CODE
, TIME_PERIOD_ID TIME_PERIOD_ID
, BATCH_NAME BATCH_NAME
, STATUS_CODE STATUS_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, PROJECT_ID PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID
, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE
, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG
, EFFORT_REPORT_ID EFFORT_REPORT_ID
, VERSION_NUM VERSION_NUM
, SUMMARY_LINE_ID SUMMARY_LINE_ID
, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG
, USER_DEFINED_FIELD USER_DEFINED_FIELD
, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID
, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE
FROM "PSP"."PSP_PRE_GEN_DIST_LINES_ARCH"