[Home] [Help]
View: IGC_CC_INTERFACE_V
View Text
SELECT CC_HEADER_ID
, CC_ACCT_LINE_ID
, CC_DET_PF_LINE_ID
, CODE_COMBINATION_ID
, BATCH_LINE_NUM
, CC_TRANSACTION_DATE
, CC_FUNC_DR_AMT
, CC_FUNC_CR_AMT
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, PERIOD_SET_NAME
, PERIOD_NAME
, ACTUAL_FLAG
, BUDGET_DEST_FLAG
, SET_OF_BOOKS_ID
, ENCUMBRANCE_TYPE_ID
, CBC_RESULT_CODE
, STATUS_CODE
, BUDGET_VERSION_ID
, BUDGET_AMT
, COMMITMENT_ENCMBRNC_AMT
, OBLIGATION_ENCMBRNC_AMT
, FUNDS_AVAILABLE_AMT
, CURRENCY_CODE
, DOCUMENT_TYPE
, TRANSACTION_DESCRIPTION
, PA_FLAG
, RESULT_CODE_SOURCE
, BATCH_ID
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, REFERENCE_6
, REFERENCE_7
, REFERENCE_8
, REFERENCE_9
, REFERENCE_10
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CC_VERSION_NUM
, CC_ENCMBRNC_DATE
FROM IGC_CC_INTERFACE
Columns
Name |
CC_HEADER_ID |
CC_ACCT_LINE_ID |
CC_DET_PF_LINE_ID |
CODE_COMBINATION_ID |
BATCH_LINE_NUM |
CC_TRANSACTION_DATE |
CC_FUNC_DR_AMT |
CC_FUNC_CR_AMT |
JE_SOURCE_NAME |
JE_CATEGORY_NAME |
PERIOD_SET_NAME |
PERIOD_NAME |
ACTUAL_FLAG |
BUDGET_DEST_FLAG |
SET_OF_BOOKS_ID |
ENCUMBRANCE_TYPE_ID |
CBC_RESULT_CODE |
STATUS_CODE |
BUDGET_VERSION_ID |
BUDGET_AMT |
COMMITMENT_ENCMBRNC_AMT |
OBLIGATION_ENCMBRNC_AMT |
FUNDS_AVAILABLE_AMT |
CURRENCY_CODE |
DOCUMENT_TYPE |
TRANSACTION_DESCRIPTION |
PA_FLAG |
RESULT_CODE_SOURCE |
BATCH_ID |
REFERENCE_1 |
REFERENCE_2 |
REFERENCE_3 |
REFERENCE_4 |
REFERENCE_5 |
REFERENCE_6 |
REFERENCE_7 |
REFERENCE_8 |
REFERENCE_9 |
REFERENCE_10 |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |
CC_VERSION_NUM |
CC_ENCMBRNC_DATE |