VIEW: GMS.GMS_BC_PACKETS#

Source

View Text - Preformatted

select PACKET_ID PACKET_ID, PROJECT_ID PROJECT_ID, AWARD_ID AWARD_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, ACTUAL_FLAG ACTUAL_FLAG, STATUS_CODE STATUS_CODE, 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, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, JE_CATEGORY_NAME JE_CATEGORY_NAME, JE_SOURCE_NAME JE_SOURCE_NAME, TRANSFERED_FLAG TRANSFERED_FLAG, DOCUMENT_TYPE DOCUMENT_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, TOP_TASK_ID TOP_TASK_ID, PARENT_RESOURCE_ID PARENT_RESOURCE_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, ACCOUNT_TYPE ACCOUNT_TYPE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, TOLERANCE_AMOUNT TOLERANCE_AMOUNT, TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE, OVERRIDE_AMOUNT OVERRIDE_AMOUNT, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE, RESULT_CODE RESULT_CODE, GL_BC_PACKETS_ROWID GL_BC_PACKETS_ROWID, AWARD_BUDGET_POSTED AWARD_BUDGET_POSTED, AWARD_BUDGET_APPROVED AWARD_BUDGET_APPROVED, AWARD_BUDGET_PENDING AWARD_BUDGET_PENDING, AWARD_ENC_POSTED AWARD_ENC_POSTED, AWARD_ENC_APPROVED AWARD_ENC_APPROVED, AWARD_ENC_PENDING AWARD_ENC_PENDING, AWARD_ACTUAL_POSTED AWARD_ACTUAL_POSTED, AWARD_ACTUAL_APPROVED AWARD_ACTUAL_APPROVED, AWARD_ACTUAL_PENDING AWARD_ACTUAL_PENDING, AWARD_RESULT_CODE AWARD_RESULT_CODE, TASK_BUDGET_POSTED TASK_BUDGET_POSTED, TASK_BUDGET_APPROVED TASK_BUDGET_APPROVED, TASK_BUDGET_PENDING TASK_BUDGET_PENDING, TASK_ENC_POSTED TASK_ENC_POSTED, TASK_ENC_APPROVED TASK_ENC_APPROVED, TASK_ENC_PENDING TASK_ENC_PENDING, TASK_ACTUAL_POSTED TASK_ACTUAL_POSTED, TASK_ACTUAL_APPROVED TASK_ACTUAL_APPROVED, TASK_ACTUAL_PENDING TASK_ACTUAL_PENDING, TASK_RESULT_CODE TASK_RESULT_CODE, RES_GRP_BUDGET_POSTED RES_GRP_BUDGET_POSTED, RES_GRP_BUDGET_APPROVED RES_GRP_BUDGET_APPROVED, RES_GRP_BUDGET_PENDING RES_GRP_BUDGET_PENDING, RES_GRP_ENC_POSTED RES_GRP_ENC_POSTED, RES_GRP_ENC_APPROVED RES_GRP_ENC_APPROVED, RES_GRP_ENC_PENDING RES_GRP_ENC_PENDING, RES_GRP_ACTUAL_POSTED RES_GRP_ACTUAL_POSTED, RES_GRP_ACTUAL_APPROVED RES_GRP_ACTUAL_APPROVED, RES_GRP_ACTUAL_PENDING RES_GRP_ACTUAL_PENDING, RES_GRP_RESULT_CODE RES_GRP_RESULT_CODE, RES_BUDGET_POSTED RES_BUDGET_POSTED, RES_BUDGET_APPROVED RES_BUDGET_APPROVED, RES_BUDGET_PENDING RES_BUDGET_PENDING, RES_ENC_POSTED RES_ENC_POSTED, RES_ENC_APPROVED RES_ENC_APPROVED, RES_ENC_PENDING RES_ENC_PENDING, RES_ACTUAL_POSTED RES_ACTUAL_POSTED, RES_ACTUAL_APPROVED RES_ACTUAL_APPROVED, RES_ACTUAL_PENDING RES_ACTUAL_PENDING, RES_RESULT_CODE RES_RESULT_CODE, STATUS_FLAG STATUS_FLAG, 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, AWARD_BUDGET_BAL AWARD_BUDGET_BAL, GL_ROW_NUMBER GL_ROW_NUMBER, BC_PACKET_ID BC_PACKET_ID, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID, BURDENABLE_RAW_COST BURDENABLE_RAW_COST, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID, BUD_TASK_ID BUD_TASK_ID, FUNDING_PATTERN_ID FUNDING_PATTERN_ID, FUNDING_SEQUENCE FUNDING_SEQUENCE, FP_STATUS FP_STATUS, 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, A_FUNDS_CONTROL_LEVEL_CODE A_FUNDS_CONTROL_LEVEL_CODE, TOP_TASK_BUDGET_POSTED TOP_TASK_BUDGET_POSTED, TOP_TASK_BUDGET_APPROVED TOP_TASK_BUDGET_APPROVED, TOP_TASK_BUDGET_PENDING TOP_TASK_BUDGET_PENDING, TOP_TASK_ENC_POSTED TOP_TASK_ENC_POSTED, TOP_TASK_ENC_APPROVED TOP_TASK_ENC_APPROVED, TOP_TASK_ENC_PENDING TOP_TASK_ENC_PENDING, TOP_TASK_ACTUAL_POSTED TOP_TASK_ACTUAL_POSTED, TOP_TASK_ACTUAL_APPROVED TOP_TASK_ACTUAL_APPROVED, TOP_TASK_ACTUAL_PENDING TOP_TASK_ACTUAL_PENDING, TOP_TASK_RESULT_CODE TOP_TASK_RESULT_CODE, REQUEST_ID REQUEST_ID, BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG, BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG, BURDENED_COST BURDENED_COST, FUNDS_CHECK_SEQ FUNDS_CHECK_SEQ, AMOUNT_TYPE AMOUNT_TYPE, BOUNDARY_CODE BOUNDARY_CODE, BUDGET_PERIOD_START_DATE BUDGET_PERIOD_START_DATE, BUDGET_PERIOD_END_DATE BUDGET_PERIOD_END_DATE, CATEGORIZATION_CODE CATEGORIZATION_CODE, PARENT_TASK_ID PARENT_TASK_ID, RESOURCE_LIST_ID RESOURCE_LIST_ID, TIME_PHASED_TYPE_CODE TIME_PHASED_TYPE_CODE, BUDGETED_AT_RESOURCE_LEVEL BUDGETED_AT_RESOURCE_LEVEL, FC_ERROR_MESSAGE FC_ERROR_MESSAGE, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, PERSON_ID PERSON_ID, JOB_ID JOB_ID, VENDOR_ID VENDOR_ID, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, ADJUSTED_DOCUMENT_HEADER_ID ADJUSTED_DOCUMENT_HEADER_ID, AWARD_SET_ID AWARD_SET_ID, TRANSACTION_SOURCE TRANSACTION_SOURCE, BURDEN_ADJUSTMENT_FLAG BURDEN_ADJUSTMENT_FLAG, BURDEN_ADJ_BC_PACKET_ID BURDEN_ADJ_BC_PACKET_ID, BURDEN_CALCULATION_SEQ BURDEN_CALCULATION_SEQ, TXN_INTERFACE_ID TXN_INTERFACE_ID, SESSION_ID SESSION_ID, SERIAL_ID SERIAL_ID, SOURCE_EVENT_ID SOURCE_EVENT_ID from "GMS"."GMS_BC_PACKETS"

View Text - HTML Formatted

SELECT PACKET_ID PACKET_ID
, PROJECT_ID PROJECT_ID
, AWARD_ID AWARD_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, ACTUAL_FLAG ACTUAL_FLAG
, STATUS_CODE STATUS_CODE
, 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
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, JE_SOURCE_NAME JE_SOURCE_NAME
, TRANSFERED_FLAG TRANSFERED_FLAG
, DOCUMENT_TYPE DOCUMENT_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, TOP_TASK_ID TOP_TASK_ID
, PARENT_RESOURCE_ID PARENT_RESOURCE_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, ACCOUNT_TYPE ACCOUNT_TYPE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, TOLERANCE_AMOUNT TOLERANCE_AMOUNT
, TOLERANCE_PERCENTAGE TOLERANCE_PERCENTAGE
, OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, EFFECT_ON_FUNDS_CODE EFFECT_ON_FUNDS_CODE
, RESULT_CODE RESULT_CODE
, GL_BC_PACKETS_ROWID GL_BC_PACKETS_ROWID
, AWARD_BUDGET_POSTED AWARD_BUDGET_POSTED
, AWARD_BUDGET_APPROVED AWARD_BUDGET_APPROVED
, AWARD_BUDGET_PENDING AWARD_BUDGET_PENDING
, AWARD_ENC_POSTED AWARD_ENC_POSTED
, AWARD_ENC_APPROVED AWARD_ENC_APPROVED
, AWARD_ENC_PENDING AWARD_ENC_PENDING
, AWARD_ACTUAL_POSTED AWARD_ACTUAL_POSTED
, AWARD_ACTUAL_APPROVED AWARD_ACTUAL_APPROVED
, AWARD_ACTUAL_PENDING AWARD_ACTUAL_PENDING
, AWARD_RESULT_CODE AWARD_RESULT_CODE
, TASK_BUDGET_POSTED TASK_BUDGET_POSTED
, TASK_BUDGET_APPROVED TASK_BUDGET_APPROVED
, TASK_BUDGET_PENDING TASK_BUDGET_PENDING
, TASK_ENC_POSTED TASK_ENC_POSTED
, TASK_ENC_APPROVED TASK_ENC_APPROVED
, TASK_ENC_PENDING TASK_ENC_PENDING
, TASK_ACTUAL_POSTED TASK_ACTUAL_POSTED
, TASK_ACTUAL_APPROVED TASK_ACTUAL_APPROVED
, TASK_ACTUAL_PENDING TASK_ACTUAL_PENDING
, TASK_RESULT_CODE TASK_RESULT_CODE
, RES_GRP_BUDGET_POSTED RES_GRP_BUDGET_POSTED
, RES_GRP_BUDGET_APPROVED RES_GRP_BUDGET_APPROVED
, RES_GRP_BUDGET_PENDING RES_GRP_BUDGET_PENDING
, RES_GRP_ENC_POSTED RES_GRP_ENC_POSTED
, RES_GRP_ENC_APPROVED RES_GRP_ENC_APPROVED
, RES_GRP_ENC_PENDING RES_GRP_ENC_PENDING
, RES_GRP_ACTUAL_POSTED RES_GRP_ACTUAL_POSTED
, RES_GRP_ACTUAL_APPROVED RES_GRP_ACTUAL_APPROVED
, RES_GRP_ACTUAL_PENDING RES_GRP_ACTUAL_PENDING
, RES_GRP_RESULT_CODE RES_GRP_RESULT_CODE
, RES_BUDGET_POSTED RES_BUDGET_POSTED
, RES_BUDGET_APPROVED RES_BUDGET_APPROVED
, RES_BUDGET_PENDING RES_BUDGET_PENDING
, RES_ENC_POSTED RES_ENC_POSTED
, RES_ENC_APPROVED RES_ENC_APPROVED
, RES_ENC_PENDING RES_ENC_PENDING
, RES_ACTUAL_POSTED RES_ACTUAL_POSTED
, RES_ACTUAL_APPROVED RES_ACTUAL_APPROVED
, RES_ACTUAL_PENDING RES_ACTUAL_PENDING
, RES_RESULT_CODE RES_RESULT_CODE
, STATUS_FLAG STATUS_FLAG
, 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
, AWARD_BUDGET_BAL AWARD_BUDGET_BAL
, GL_ROW_NUMBER GL_ROW_NUMBER
, BC_PACKET_ID BC_PACKET_ID
, PARENT_BC_PACKET_ID PARENT_BC_PACKET_ID
, BURDENABLE_RAW_COST BURDENABLE_RAW_COST
, BUD_RESOURCE_LIST_MEMBER_ID BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID BUD_TASK_ID
, FUNDING_PATTERN_ID FUNDING_PATTERN_ID
, FUNDING_SEQUENCE FUNDING_SEQUENCE
, FP_STATUS FP_STATUS
, 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
, A_FUNDS_CONTROL_LEVEL_CODE A_FUNDS_CONTROL_LEVEL_CODE
, TOP_TASK_BUDGET_POSTED TOP_TASK_BUDGET_POSTED
, TOP_TASK_BUDGET_APPROVED TOP_TASK_BUDGET_APPROVED
, TOP_TASK_BUDGET_PENDING TOP_TASK_BUDGET_PENDING
, TOP_TASK_ENC_POSTED TOP_TASK_ENC_POSTED
, TOP_TASK_ENC_APPROVED TOP_TASK_ENC_APPROVED
, TOP_TASK_ENC_PENDING TOP_TASK_ENC_PENDING
, TOP_TASK_ACTUAL_POSTED TOP_TASK_ACTUAL_POSTED
, TOP_TASK_ACTUAL_APPROVED TOP_TASK_ACTUAL_APPROVED
, TOP_TASK_ACTUAL_PENDING TOP_TASK_ACTUAL_PENDING
, TOP_TASK_RESULT_CODE TOP_TASK_RESULT_CODE
, REQUEST_ID REQUEST_ID
, BALANCE_POSTED_FLAG BALANCE_POSTED_FLAG
, BURDEN_POSTED_FLAG BURDEN_POSTED_FLAG
, BURDENED_COST BURDENED_COST
, FUNDS_CHECK_SEQ FUNDS_CHECK_SEQ
, AMOUNT_TYPE AMOUNT_TYPE
, BOUNDARY_CODE BOUNDARY_CODE
, BUDGET_PERIOD_START_DATE BUDGET_PERIOD_START_DATE
, BUDGET_PERIOD_END_DATE BUDGET_PERIOD_END_DATE
, CATEGORIZATION_CODE CATEGORIZATION_CODE
, PARENT_TASK_ID PARENT_TASK_ID
, RESOURCE_LIST_ID RESOURCE_LIST_ID
, TIME_PHASED_TYPE_CODE TIME_PHASED_TYPE_CODE
, BUDGETED_AT_RESOURCE_LEVEL BUDGETED_AT_RESOURCE_LEVEL
, FC_ERROR_MESSAGE FC_ERROR_MESSAGE
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, PERSON_ID PERSON_ID
, JOB_ID JOB_ID
, VENDOR_ID VENDOR_ID
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, ADJUSTED_DOCUMENT_HEADER_ID ADJUSTED_DOCUMENT_HEADER_ID
, AWARD_SET_ID AWARD_SET_ID
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, BURDEN_ADJUSTMENT_FLAG BURDEN_ADJUSTMENT_FLAG
, BURDEN_ADJ_BC_PACKET_ID BURDEN_ADJ_BC_PACKET_ID
, BURDEN_CALCULATION_SEQ BURDEN_CALCULATION_SEQ
, TXN_INTERFACE_ID TXN_INTERFACE_ID
, SESSION_ID SESSION_ID
, SERIAL_ID SERIAL_ID
, SOURCE_EVENT_ID SOURCE_EVENT_ID
FROM "GMS"."GMS_BC_PACKETS"