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: PA.PA_BC_COMMITMENTS_ALL#

Source

View Text - Preformatted


select BC_COMMITMENT_ID BC_COMMITMENT_ID, PACKET_ID PACKET_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PERIOD_NAME PERIOD_NAME, PERIOD_NUM PERIOD_NUM, BUDGET_VERSION_ID BUDGET_VERSION_ID, JE_CATEGORY_NAME JE_CATEGORY_NAME, JE_SOURCE_NAME JE_SOURCE_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, DOCUMENT_TYPE DOCUMENT_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, TOP_TASK_ID TOP_TASK_ID, PARENT_RESOURCE_ID PARENT_RESOURCE_ID, PA_DATE PA_DATE, GL_DATE GL_DATE, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TRANSFERRED_DATE TRANSFERRED_DATE, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, PROJECT_BATCH_NAME PROJECT_BATCH_NAME, PROJ_TRANSFER_REJ_REASON PROJ_TRANSFER_REJ_REASON, PROJ_ENCUMBRANCE_TYPE_ID PROJ_ENCUMBRANCE_TYPE_ID, PROCESS_EXP_ITEM_ID PROCESS_EXP_ITEM_ID, PROCESS_CCID PROCESS_CCID, PERIOD_YEAR PERIOD_YEAR, ORG_ID ORG_ID, LIQUIDATE_GL_DATE LIQUIDATE_GL_DATE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, COMMITMENT_BATCH_NAME COMMITMENT_BATCH_NAME, COMM_TRANSFER_REJ_REASON COMM_TRANSFER_REJ_REASON, BURDEN_COST_FLAG BURDEN_COST_FLAG, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, BUDGET_CCID BUDGET_CCID, TXN_CCID TXN_CCID, BC_PACKET_ID BC_PACKET_ID, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID, FUNDS_PROCESS_MODE FUNDS_PROCESS_MODE, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID, BUD_TASK_ID BUD_TASK_ID, REQUEST_ID REQUEST_ID, ACTUAL_FLAG ACTUAL_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DOCUMENT_LINE_ID DOCUMENT_LINE_ID, COMPILED_MULTIPLIER COMPILED_MULTIPLIER, FC_START_DATE FC_START_DATE, FC_END_DATE FC_END_DATE, COMM_TOT_RAW_AMT COMM_TOT_RAW_AMT, COMM_TOT_BD_AMT COMM_TOT_BD_AMT, COMM_RAW_AMT_RELIEVED COMM_RAW_AMT_RELIEVED, COMM_BD_AMT_RELIEVED COMM_BD_AMT_RELIEVED, SUMMARY_RECORD_FLAG SUMMARY_RECORD_FLAG, EXP_ITEM_ID EXP_ITEM_ID, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, BC_EVENT_ID BC_EVENT_ID, BUDGET_LINE_ID BUDGET_LINE_ID, VENDOR_ID VENDOR_ID, BURDEN_METHOD_CODE BURDEN_METHOD_CODE, DOCUMENT_HEADER_ID_2 DOCUMENT_HEADER_ID_2, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE from "PA"."PA_BC_COMMITMENTS_ALL"

View Text - HTML Formatted

SELECT BC_COMMITMENT_ID BC_COMMITMENT_ID
, PACKET_ID PACKET_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PERIOD_NAME PERIOD_NAME
, PERIOD_NUM PERIOD_NUM
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, JE_SOURCE_NAME JE_SOURCE_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, TOP_TASK_ID TOP_TASK_ID
, PARENT_RESOURCE_ID PARENT_RESOURCE_ID
, PA_DATE PA_DATE
, GL_DATE GL_DATE
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TRANSFERRED_DATE TRANSFERRED_DATE
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, PROJECT_BATCH_NAME PROJECT_BATCH_NAME
, PROJ_TRANSFER_REJ_REASON PROJ_TRANSFER_REJ_REASON
, PROJ_ENCUMBRANCE_TYPE_ID PROJ_ENCUMBRANCE_TYPE_ID
, PROCESS_EXP_ITEM_ID PROCESS_EXP_ITEM_ID
, PROCESS_CCID PROCESS_CCID
, PERIOD_YEAR PERIOD_YEAR
, ORG_ID ORG_ID
, LIQUIDATE_GL_DATE LIQUIDATE_GL_DATE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, COMMITMENT_BATCH_NAME COMMITMENT_BATCH_NAME
, COMM_TRANSFER_REJ_REASON COMM_TRANSFER_REJ_REASON
, BURDEN_COST_FLAG BURDEN_COST_FLAG
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, BUDGET_CCID BUDGET_CCID
, TXN_CCID TXN_CCID
, BC_PACKET_ID BC_PACKET_ID
, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID
, FUNDS_PROCESS_MODE FUNDS_PROCESS_MODE
, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID BUD_TASK_ID
, REQUEST_ID REQUEST_ID
, ACTUAL_FLAG ACTUAL_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DOCUMENT_LINE_ID DOCUMENT_LINE_ID
, COMPILED_MULTIPLIER COMPILED_MULTIPLIER
, FC_START_DATE FC_START_DATE
, FC_END_DATE FC_END_DATE
, COMM_TOT_RAW_AMT COMM_TOT_RAW_AMT
, COMM_TOT_BD_AMT COMM_TOT_BD_AMT
, COMM_RAW_AMT_RELIEVED COMM_RAW_AMT_RELIEVED
, COMM_BD_AMT_RELIEVED COMM_BD_AMT_RELIEVED
, SUMMARY_RECORD_FLAG SUMMARY_RECORD_FLAG
, EXP_ITEM_ID EXP_ITEM_ID
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, BC_EVENT_ID BC_EVENT_ID
, BUDGET_LINE_ID BUDGET_LINE_ID
, VENDOR_ID VENDOR_ID
, BURDEN_METHOD_CODE BURDEN_METHOD_CODE
, DOCUMENT_HEADER_ID_2 DOCUMENT_HEADER_ID_2
, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE
FROM "PA"."PA_BC_COMMITMENTS_ALL"