[Home] [Help] [Dependency Information]
Object Name: | GMS_BC_PACKETS# |
---|---|
Object Type: | VIEW |
Owner: | GMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKET_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
AWARD_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | Yes | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | |
EXPENDITURE_ITEM_DATE | DATE | Yes | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | |
STATUS_CODE | VARCHAR2 | (1) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
JE_CATEGORY_NAME | VARCHAR2 | (30) | Yes | |
JE_SOURCE_NAME | VARCHAR2 | (30) | Yes | |
TRANSFERED_FLAG | VARCHAR2 | (1) | Yes | |
DOCUMENT_TYPE | VARCHAR2 | (3) | Yes | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
DOCUMENT_HEADER_ID | NUMBER | (15) | ||
DOCUMENT_DISTRIBUTION_ID | NUMBER | (15) | ||
TOP_TASK_ID | NUMBER | (15) | ||
PARENT_RESOURCE_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
TOLERANCE_AMOUNT | NUMBER | |||
TOLERANCE_PERCENTAGE | NUMBER | |||
OVERRIDE_AMOUNT | NUMBER | |||
EFFECT_ON_FUNDS_CODE | VARCHAR2 | (1) | ||
RESULT_CODE | VARCHAR2 | (3) | ||
GL_BC_PACKETS_ROWID | VARCHAR2 | (30) | ||
AWARD_BUDGET_POSTED | NUMBER | |||
AWARD_BUDGET_APPROVED | NUMBER | |||
AWARD_BUDGET_PENDING | NUMBER | |||
AWARD_ENC_POSTED | NUMBER | |||
AWARD_ENC_APPROVED | NUMBER | |||
AWARD_ENC_PENDING | NUMBER | |||
AWARD_ACTUAL_POSTED | NUMBER | |||
AWARD_ACTUAL_APPROVED | NUMBER | |||
AWARD_ACTUAL_PENDING | NUMBER | |||
AWARD_RESULT_CODE | VARCHAR2 | (3) | ||
TASK_BUDGET_POSTED | NUMBER | |||
TASK_BUDGET_APPROVED | NUMBER | |||
TASK_BUDGET_PENDING | NUMBER | |||
TASK_ENC_POSTED | NUMBER | |||
TASK_ENC_APPROVED | NUMBER | |||
TASK_ENC_PENDING | NUMBER | |||
TASK_ACTUAL_POSTED | NUMBER | |||
TASK_ACTUAL_APPROVED | NUMBER | |||
TASK_ACTUAL_PENDING | NUMBER | |||
TASK_RESULT_CODE | VARCHAR2 | (3) | ||
RES_GRP_BUDGET_POSTED | NUMBER | |||
RES_GRP_BUDGET_APPROVED | NUMBER | |||
RES_GRP_BUDGET_PENDING | NUMBER | |||
RES_GRP_ENC_POSTED | NUMBER | |||
RES_GRP_ENC_APPROVED | NUMBER | |||
RES_GRP_ENC_PENDING | NUMBER | |||
RES_GRP_ACTUAL_POSTED | NUMBER | |||
RES_GRP_ACTUAL_APPROVED | NUMBER | |||
RES_GRP_ACTUAL_PENDING | NUMBER | |||
RES_GRP_RESULT_CODE | VARCHAR2 | (3) | ||
RES_BUDGET_POSTED | NUMBER | |||
RES_BUDGET_APPROVED | NUMBER | |||
RES_BUDGET_PENDING | NUMBER | |||
RES_ENC_POSTED | NUMBER | |||
RES_ENC_APPROVED | NUMBER | |||
RES_ENC_PENDING | NUMBER | |||
RES_ACTUAL_POSTED | NUMBER | |||
RES_ACTUAL_APPROVED | NUMBER | |||
RES_ACTUAL_PENDING | NUMBER | |||
RES_RESULT_CODE | VARCHAR2 | (3) | ||
STATUS_FLAG | VARCHAR2 | (2) | ||
RES_BUDGET_BAL | NUMBER | |||
RES_GRP_BUDGET_BAL | NUMBER | |||
TASK_BUDGET_BAL | NUMBER | |||
TOP_TASK_BUDGET_BAL | NUMBER | |||
AWARD_BUDGET_BAL | NUMBER | |||
GL_ROW_NUMBER | NUMBER | |||
BC_PACKET_ID | NUMBER | |||
PARENT_BC_PACKET_ID | NUMBER | |||
BURDENABLE_RAW_COST | NUMBER | |||
BUD_RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | ||
BUD_TASK_ID | NUMBER | (15) | ||
FUNDING_PATTERN_ID | NUMBER | (15) | ||
FUNDING_SEQUENCE | NUMBER | (15) | ||
FP_STATUS | VARCHAR2 | (1) | ||
R_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | ||
RG_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | ||
T_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | ||
TT_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | ||
A_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | ||
TOP_TASK_BUDGET_POSTED | NUMBER | |||
TOP_TASK_BUDGET_APPROVED | NUMBER | |||
TOP_TASK_BUDGET_PENDING | NUMBER | |||
TOP_TASK_ENC_POSTED | NUMBER | |||
TOP_TASK_ENC_APPROVED | NUMBER | |||
TOP_TASK_ENC_PENDING | NUMBER | |||
TOP_TASK_ACTUAL_POSTED | NUMBER | |||
TOP_TASK_ACTUAL_APPROVED | NUMBER | |||
TOP_TASK_ACTUAL_PENDING | NUMBER | |||
TOP_TASK_RESULT_CODE | VARCHAR2 | (3) | ||
REQUEST_ID | NUMBER | (15) | ||
BALANCE_POSTED_FLAG | VARCHAR2 | (1) | ||
BURDEN_POSTED_FLAG | VARCHAR2 | (1) | ||
BURDENED_COST | NUMBER | (22) | ||
FUNDS_CHECK_SEQ | NUMBER | (15) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
BOUNDARY_CODE | VARCHAR2 | (2) | ||
BUDGET_PERIOD_START_DATE | DATE | |||
BUDGET_PERIOD_END_DATE | DATE | |||
CATEGORIZATION_CODE | VARCHAR2 | (30) | ||
PARENT_TASK_ID | NUMBER | (15) | ||
RESOURCE_LIST_ID | NUMBER | (15) | ||
TIME_PHASED_TYPE_CODE | VARCHAR2 | (1) | ||
BUDGETED_AT_RESOURCE_LEVEL | VARCHAR2 | (1) | ||
FC_ERROR_MESSAGE | VARCHAR2 | (2000) | ||
IND_COMPILED_SET_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (9) | ||
JOB_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
REVENUE_CATEGORY | VARCHAR2 | (30) | ||
ADJUSTED_DOCUMENT_HEADER_ID | NUMBER | (15) | ||
AWARD_SET_ID | NUMBER | (15) | ||
TRANSACTION_SOURCE | VARCHAR2 | (30) | ||
BURDEN_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
BURDEN_ADJ_BC_PACKET_ID | NUMBER | |||
BURDEN_CALCULATION_SEQ | NUMBER | |||
TXN_INTERFACE_ID | NUMBER | (15) | ||
SESSION_ID | NUMBER | (38) | ||
SERIAL_ID | NUMBER | (38) | ||
SOURCE_EVENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PACKET_ID
, PROJECT_ID
, AWARD_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ACTUAL_FLAG
, STATUS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID
, JE_CATEGORY_NAME
, JE_SOURCE_NAME
, TRANSFERED_FLAG
, DOCUMENT_TYPE
, EXPENDITURE_ORGANIZATION_ID
, PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, TOP_TASK_ID
, PARENT_RESOURCE_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, ACCOUNT_TYPE
, ENTERED_DR
, ENTERED_CR
, TOLERANCE_AMOUNT
, TOLERANCE_PERCENTAGE
, OVERRIDE_AMOUNT
, EFFECT_ON_FUNDS_CODE
, RESULT_CODE
, GL_BC_PACKETS_ROWID
, AWARD_BUDGET_POSTED
, AWARD_BUDGET_APPROVED
, AWARD_BUDGET_PENDING
, AWARD_ENC_POSTED
, AWARD_ENC_APPROVED
, AWARD_ENC_PENDING
, AWARD_ACTUAL_POSTED
, AWARD_ACTUAL_APPROVED
, AWARD_ACTUAL_PENDING
, AWARD_RESULT_CODE
, TASK_BUDGET_POSTED
, TASK_BUDGET_APPROVED
, TASK_BUDGET_PENDING
, TASK_ENC_POSTED
, TASK_ENC_APPROVED
, TASK_ENC_PENDING
, TASK_ACTUAL_POSTED
, TASK_ACTUAL_APPROVED
, TASK_ACTUAL_PENDING
, TASK_RESULT_CODE
, RES_GRP_BUDGET_POSTED
, RES_GRP_BUDGET_APPROVED
, RES_GRP_BUDGET_PENDING
, RES_GRP_ENC_POSTED
, RES_GRP_ENC_APPROVED
, RES_GRP_ENC_PENDING
, RES_GRP_ACTUAL_POSTED
, RES_GRP_ACTUAL_APPROVED
, RES_GRP_ACTUAL_PENDING
, RES_GRP_RESULT_CODE
, RES_BUDGET_POSTED
, RES_BUDGET_APPROVED
, RES_BUDGET_PENDING
, RES_ENC_POSTED
, RES_ENC_APPROVED
, RES_ENC_PENDING
, RES_ACTUAL_POSTED
, RES_ACTUAL_APPROVED
, RES_ACTUAL_PENDING
, RES_RESULT_CODE
, STATUS_FLAG
, RES_BUDGET_BAL
, RES_GRP_BUDGET_BAL
, TASK_BUDGET_BAL
, TOP_TASK_BUDGET_BAL
, AWARD_BUDGET_BAL
, GL_ROW_NUMBER
, BC_PACKET_ID
, PARENT_BC_PACKET_ID
, BURDENABLE_RAW_COST
, BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID
, FUNDING_PATTERN_ID
, FUNDING_SEQUENCE
, FP_STATUS
, R_FUNDS_CONTROL_LEVEL_CODE
, RG_FUNDS_CONTROL_LEVEL_CODE
, T_FUNDS_CONTROL_LEVEL_CODE
, TT_FUNDS_CONTROL_LEVEL_CODE
, A_FUNDS_CONTROL_LEVEL_CODE
, TOP_TASK_BUDGET_POSTED
, TOP_TASK_BUDGET_APPROVED
, TOP_TASK_BUDGET_PENDING
, TOP_TASK_ENC_POSTED
, TOP_TASK_ENC_APPROVED
, TOP_TASK_ENC_PENDING
, TOP_TASK_ACTUAL_POSTED
, TOP_TASK_ACTUAL_APPROVED
, TOP_TASK_ACTUAL_PENDING
, TOP_TASK_RESULT_CODE
, REQUEST_ID
, BALANCE_POSTED_FLAG
, BURDEN_POSTED_FLAG
, BURDENED_COST
, FUNDS_CHECK_SEQ
, AMOUNT_TYPE
, BOUNDARY_CODE
, BUDGET_PERIOD_START_DATE
, BUDGET_PERIOD_END_DATE
, CATEGORIZATION_CODE
, PARENT_TASK_ID
, RESOURCE_LIST_ID
, TIME_PHASED_TYPE_CODE
, BUDGETED_AT_RESOURCE_LEVEL
, FC_ERROR_MESSAGE
, IND_COMPILED_SET_ID
, PERSON_ID
, JOB_ID
, VENDOR_ID
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, ADJUSTED_DOCUMENT_HEADER_ID
, AWARD_SET_ID
, TRANSACTION_SOURCE
, BURDEN_ADJUSTMENT_FLAG
, BURDEN_ADJ_BC_PACKET_ID
, BURDEN_CALCULATION_SEQ
, TXN_INTERFACE_ID
, SESSION_ID
, SERIAL_ID
, SOURCE_EVENT_ID
FROM GMS.GMS_BC_PACKETS#;
|
|
|