VIEW: PA.PA_BC_PACKETS_HIST#

Source

View Text - Preformatted

select PACKET_ID PACKET_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, JE_CATEGORY_NAME JE_CATEGORY_NAME, JE_SOURCE_NAME JE_SOURCE_NAME, STATUS_CODE STATUS_CODE, DOCUMENT_TYPE DOCUMENT_TYPE, FUNDS_PROCESS_MODE FUNDS_PROCESS_MODE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, BURDEN_COST_FLAG BURDEN_COST_FLAG, BC_PACKET_ID BC_PACKET_ID, BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG, ACTUAL_FLAG ACTUAL_FLAG, GL_DATE GL_DATE, PA_DATE PA_DATE, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, BC_COMMITMENT_ID BC_COMMITMENT_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, PROJ_ENCUMBRANCE_TYPE_ID PROJ_ENCUMBRANCE_TYPE_ID, TOP_TASK_ID TOP_TASK_ID, PARENT_RESOURCE_ID PARENT_RESOURCE_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE, RESULT_CODE RESULT_CODE, TASK_BUDGET_POSTED TASK_BUDGET_POSTED, TASK_ENC_POSTED TASK_ENC_POSTED, TASK_ENC_APPROVED TASK_ENC_APPROVED, TASK_ACTUAL_POSTED TASK_ACTUAL_POSTED, TASK_ACTUAL_APPROVED TASK_ACTUAL_APPROVED, TASK_RESULT_CODE TASK_RESULT_CODE, RES_GRP_BUDGET_POSTED RES_GRP_BUDGET_POSTED, RES_GRP_ENC_POSTED RES_GRP_ENC_POSTED, RES_GRP_ENC_APPROVED RES_GRP_ENC_APPROVED, RES_GRP_ACTUAL_POSTED RES_GRP_ACTUAL_POSTED, RES_GRP_ACTUAL_APPROVED RES_GRP_ACTUAL_APPROVED, RES_GRP_RESULT_CODE RES_GRP_RESULT_CODE, RES_BUDGET_POSTED RES_BUDGET_POSTED, RES_ENC_POSTED RES_ENC_POSTED, RES_ENC_APPROVED RES_ENC_APPROVED, RES_ACTUAL_POSTED RES_ACTUAL_POSTED, RES_ACTUAL_APPROVED RES_ACTUAL_APPROVED, RES_RESULT_CODE RES_RESULT_CODE, RES_BUDGET_BAL RES_BUDGET_BAL, RES_GRP_BUDGET_BAL RES_GRP_BUDGET_BAL, TASK_BUDGET_BAL TASK_BUDGET_BAL, TOP_TASK_BUDGET_BAL TOP_TASK_BUDGET_BAL, PROJECT_BUDGET_BAL PROJECT_BUDGET_BAL, GL_ROW_NUMBER GL_ROW_NUMBER, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID, BUD_TASK_ID BUD_TASK_ID, R_FUNDS_CONTROL_LEVEL_CODE R_FUNDS_CONTROL_LEVEL_CODE, RG_FUNDS_CONTROL_LEVEL_CODE RG_FUNDS_CONTROL_LEVEL_CODE, T_FUNDS_CONTROL_LEVEL_CODE T_FUNDS_CONTROL_LEVEL_CODE, TT_FUNDS_CONTROL_LEVEL_CODE TT_FUNDS_CONTROL_LEVEL_CODE, P_FUNDS_CONTROL_LEVEL_CODE P_FUNDS_CONTROL_LEVEL_CODE, TOP_TASK_BUDGET_POSTED TOP_TASK_BUDGET_POSTED, TOP_TASK_ENC_POSTED TOP_TASK_ENC_POSTED, TOP_TASK_ENC_APPROVED TOP_TASK_ENC_APPROVED, TOP_TASK_ACTUAL_POSTED TOP_TASK_ACTUAL_POSTED, TOP_TASK_ACTUAL_APPROVED TOP_TASK_ACTUAL_APPROVED, TOP_TASK_RESULT_CODE TOP_TASK_RESULT_CODE, PROJECT_BUDGET_POSTED PROJECT_BUDGET_POSTED, PROJECT_ENC_POSTED PROJECT_ENC_POSTED, PROJECT_ENC_APPROVED PROJECT_ENC_APPROVED, PROJECT_ACTUAL_POSTED PROJECT_ACTUAL_POSTED, PROJECT_ACTUAL_APPROVED PROJECT_ACTUAL_APPROVED, PROJECT_RESULT_CODE PROJECT_RESULT_CODE, PROJECT_ACCT_RESULT_CODE PROJECT_ACCT_RESULT_CODE, REQUEST_ID REQUEST_ID, BUDGET_CCID BUDGET_CCID, OLD_BUDGET_CCID OLD_BUDGET_CCID, TXN_CCID TXN_CCID, ORG_ID ORG_ID, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, EXT_BDGT_FLAG EXT_BDGT_FLAG, 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, FUNDS_PROCESSING_SEQ FUNDS_PROCESSING_SEQ, TXN_INTERFACE_ID TXN_INTERFACE_ID, BC_EVENT_ID BC_EVENT_ID, SESSION_ID SESSION_ID, SERIAL_ID SERIAL_ID, BUDGET_LINE_ID BUDGET_LINE_ID, VENDOR_ID VENDOR_ID, BURDEN_METHOD_CODE BURDEN_METHOD_CODE, MAIN_OR_BACKING_CODE MAIN_OR_BACKING_CODE, SOURCE_EVENT_ID SOURCE_EVENT_ID, DOCUMENT_HEADER_ID_2 DOCUMENT_HEADER_ID_2, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE from "PA"."PA_BC_PACKETS_HIST"

View Text - HTML Formatted

SELECT PACKET_ID PACKET_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, JE_SOURCE_NAME JE_SOURCE_NAME
, STATUS_CODE STATUS_CODE
, DOCUMENT_TYPE DOCUMENT_TYPE
, FUNDS_PROCESS_MODE FUNDS_PROCESS_MODE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BURDEN_COST_FLAG BURDEN_COST_FLAG
, BC_PACKET_ID BC_PACKET_ID
, BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG
, ACTUAL_FLAG ACTUAL_FLAG
, GL_DATE GL_DATE
, PA_DATE PA_DATE
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, BC_COMMITMENT_ID BC_COMMITMENT_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, PROJ_ENCUMBRANCE_TYPE_ID PROJ_ENCUMBRANCE_TYPE_ID
, TOP_TASK_ID TOP_TASK_ID
, PARENT_RESOURCE_ID PARENT_RESOURCE_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, RESULT_CODE RESULT_CODE
, TASK_BUDGET_POSTED TASK_BUDGET_POSTED
, TASK_ENC_POSTED TASK_ENC_POSTED
, TASK_ENC_APPROVED TASK_ENC_APPROVED
, TASK_ACTUAL_POSTED TASK_ACTUAL_POSTED
, TASK_ACTUAL_APPROVED TASK_ACTUAL_APPROVED
, TASK_RESULT_CODE TASK_RESULT_CODE
, RES_GRP_BUDGET_POSTED RES_GRP_BUDGET_POSTED
, RES_GRP_ENC_POSTED RES_GRP_ENC_POSTED
, RES_GRP_ENC_APPROVED RES_GRP_ENC_APPROVED
, RES_GRP_ACTUAL_POSTED RES_GRP_ACTUAL_POSTED
, RES_GRP_ACTUAL_APPROVED RES_GRP_ACTUAL_APPROVED
, RES_GRP_RESULT_CODE RES_GRP_RESULT_CODE
, RES_BUDGET_POSTED RES_BUDGET_POSTED
, RES_ENC_POSTED RES_ENC_POSTED
, RES_ENC_APPROVED RES_ENC_APPROVED
, RES_ACTUAL_POSTED RES_ACTUAL_POSTED
, RES_ACTUAL_APPROVED RES_ACTUAL_APPROVED
, RES_RESULT_CODE RES_RESULT_CODE
, RES_BUDGET_BAL RES_BUDGET_BAL
, RES_GRP_BUDGET_BAL RES_GRP_BUDGET_BAL
, TASK_BUDGET_BAL TASK_BUDGET_BAL
, TOP_TASK_BUDGET_BAL TOP_TASK_BUDGET_BAL
, PROJECT_BUDGET_BAL PROJECT_BUDGET_BAL
, GL_ROW_NUMBER GL_ROW_NUMBER
, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID
, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID BUD_TASK_ID
, R_FUNDS_CONTROL_LEVEL_CODE R_FUNDS_CONTROL_LEVEL_CODE
, RG_FUNDS_CONTROL_LEVEL_CODE RG_FUNDS_CONTROL_LEVEL_CODE
, T_FUNDS_CONTROL_LEVEL_CODE T_FUNDS_CONTROL_LEVEL_CODE
, TT_FUNDS_CONTROL_LEVEL_CODE TT_FUNDS_CONTROL_LEVEL_CODE
, P_FUNDS_CONTROL_LEVEL_CODE P_FUNDS_CONTROL_LEVEL_CODE
, TOP_TASK_BUDGET_POSTED TOP_TASK_BUDGET_POSTED
, TOP_TASK_ENC_POSTED TOP_TASK_ENC_POSTED
, TOP_TASK_ENC_APPROVED TOP_TASK_ENC_APPROVED
, TOP_TASK_ACTUAL_POSTED TOP_TASK_ACTUAL_POSTED
, TOP_TASK_ACTUAL_APPROVED TOP_TASK_ACTUAL_APPROVED
, TOP_TASK_RESULT_CODE TOP_TASK_RESULT_CODE
, PROJECT_BUDGET_POSTED PROJECT_BUDGET_POSTED
, PROJECT_ENC_POSTED PROJECT_ENC_POSTED
, PROJECT_ENC_APPROVED PROJECT_ENC_APPROVED
, PROJECT_ACTUAL_POSTED PROJECT_ACTUAL_POSTED
, PROJECT_ACTUAL_APPROVED PROJECT_ACTUAL_APPROVED
, PROJECT_RESULT_CODE PROJECT_RESULT_CODE
, PROJECT_ACCT_RESULT_CODE PROJECT_ACCT_RESULT_CODE
, REQUEST_ID REQUEST_ID
, BUDGET_CCID BUDGET_CCID
, OLD_BUDGET_CCID OLD_BUDGET_CCID
, TXN_CCID TXN_CCID
, ORG_ID ORG_ID
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, EXT_BDGT_FLAG EXT_BDGT_FLAG
, 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
, FUNDS_PROCESSING_SEQ FUNDS_PROCESSING_SEQ
, TXN_INTERFACE_ID TXN_INTERFACE_ID
, BC_EVENT_ID BC_EVENT_ID
, SESSION_ID SESSION_ID
, SERIAL_ID SERIAL_ID
, BUDGET_LINE_ID BUDGET_LINE_ID
, VENDOR_ID VENDOR_ID
, BURDEN_METHOD_CODE BURDEN_METHOD_CODE
, MAIN_OR_BACKING_CODE MAIN_OR_BACKING_CODE
, SOURCE_EVENT_ID SOURCE_EVENT_ID
, DOCUMENT_HEADER_ID_2 DOCUMENT_HEADER_ID_2
, DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE
FROM "PA"."PA_BC_PACKETS_HIST"