[Home] [Help] [Dependency Information]
Object Name: | GL_BC_PACKETS# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKET_ID | NUMBER | (15) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_YEAR | NUMBER | (15) | Yes | |
PERIOD_NUM | NUMBER | (15) | Yes | |
QUARTER_NUM | NUMBER | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
STATUS_CODE | VARCHAR2 | (1) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
BUDGET_VERSION_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
TEMPLATE_ID | NUMBER | (15) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
ORIGINATING_ROWID | ROWID | (10) | ||
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
AUTOMATIC_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | ||
FUNDING_BUDGET_VERSION_ID | NUMBER | (15) | ||
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
BOUNDARY_CODE | VARCHAR2 | (1) | ||
TOLERANCE_PERCENTAGE | NUMBER | |||
TOLERANCE_AMOUNT | NUMBER | |||
OVERRIDE_AMOUNT | NUMBER | |||
DR_CR_CODE | VARCHAR2 | (1) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
ACCOUNT_CATEGORY_CODE | VARCHAR2 | (1) | ||
EFFECT_ON_FUNDS_CODE | VARCHAR2 | (1) | ||
RESULT_CODE | VARCHAR2 | (3) | ||
BUDGET_POSTED_BALANCE | NUMBER | |||
ACTUAL_POSTED_BALANCE | NUMBER | |||
ENCUMBRANCE_POSTED_BALANCE | NUMBER | |||
BUDGET_APPROVED_BALANCE | NUMBER | |||
ACTUAL_APPROVED_BALANCE | NUMBER | |||
ENCUMBRANCE_APPROVED_BALANCE | NUMBER | |||
BUDGET_PENDING_BALANCE | NUMBER | |||
ACTUAL_PENDING_BALANCE | NUMBER | |||
ENCUMBRANCE_PENDING_BALANCE | NUMBER | |||
REFERENCE1 | VARCHAR2 | (100) | ||
REFERENCE2 | VARCHAR2 | (100) | ||
REFERENCE3 | VARCHAR2 | (100) | ||
REFERENCE4 | VARCHAR2 | (100) | ||
REFERENCE5 | VARCHAR2 | (100) | ||
JE_BATCH_NAME | VARCHAR2 | (100) | ||
JE_BATCH_ID | NUMBER | (15) | ||
JE_HEADER_ID | NUMBER | (15) | ||
JE_LINE_NUM | NUMBER | (15) | ||
JE_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
REFERENCE6 | VARCHAR2 | (100) | ||
REFERENCE7 | VARCHAR2 | (100) | ||
REFERENCE8 | VARCHAR2 | (100) | ||
REFERENCE9 | VARCHAR2 | (100) | ||
REFERENCE10 | VARCHAR2 | (100) | ||
REFERENCE11 | VARCHAR2 | (100) | ||
REFERENCE12 | VARCHAR2 | (100) | ||
REFERENCE13 | VARCHAR2 | (100) | ||
REFERENCE14 | VARCHAR2 | (100) | ||
REFERENCE15 | VARCHAR2 | (100) | ||
REQUEST_ID | NUMBER | (15) | ||
USSGL_PARENT_ID | NUMBER | (15) | ||
USSGL_LINK_TO_PARENT_ID | NUMBER | (15) | ||
EVENT_ID | NUMBER | (15) | ||
AE_HEADER_ID | NUMBER | (15) | ||
AE_LINE_NUM | NUMBER | (15) | ||
BC_DATE | DATE | |||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | (38) | ||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | (38) | ||
SESSION_ID | NUMBER | (38) | Yes | |
SERIAL_ID | NUMBER | (38) | Yes | |
APPLICATION_ID | NUMBER | (15) | Yes | |
ENTITY_ID | NUMBER | (15) | ||
GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PACKET_ID
, LEDGER_ID
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, CODE_COMBINATION_ID
, ACTUAL_FLAG
, PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, CURRENCY_CODE
, STATUS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, USSGL_TRANSACTION_CODE
, ORIGINATING_ROWID
, ACCOUNT_SEGMENT_VALUE
, AUTOMATIC_ENCUMBRANCE_FLAG
, FUNDING_BUDGET_VERSION_ID
, FUNDS_CHECK_LEVEL_CODE
, AMOUNT_TYPE
, BOUNDARY_CODE
, TOLERANCE_PERCENTAGE
, TOLERANCE_AMOUNT
, OVERRIDE_AMOUNT
, DR_CR_CODE
, ACCOUNT_TYPE
, ACCOUNT_CATEGORY_CODE
, EFFECT_ON_FUNDS_CODE
, RESULT_CODE
, BUDGET_POSTED_BALANCE
, ACTUAL_POSTED_BALANCE
, ENCUMBRANCE_POSTED_BALANCE
, BUDGET_APPROVED_BALANCE
, ACTUAL_APPROVED_BALANCE
, ENCUMBRANCE_APPROVED_BALANCE
, BUDGET_PENDING_BALANCE
, ACTUAL_PENDING_BALANCE
, ENCUMBRANCE_PENDING_BALANCE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, JE_BATCH_NAME
, JE_BATCH_ID
, JE_HEADER_ID
, JE_LINE_NUM
, JE_LINE_DESCRIPTION
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, REFERENCE11
, REFERENCE12
, REFERENCE13
, REFERENCE14
, REFERENCE15
, REQUEST_ID
, USSGL_PARENT_ID
, USSGL_LINK_TO_PARENT_ID
, EVENT_ID
, AE_HEADER_ID
, AE_LINE_NUM
, BC_DATE
, SOURCE_DISTRIBUTION_TYPE
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SESSION_ID
, SERIAL_ID
, APPLICATION_ID
, ENTITY_ID
, GROUP_ID
FROM GL.GL_BC_PACKETS#;
|
|
|