VIEW: IGC.IGC_CC_INTERFACE#

Source

View Text - Preformatted

select CC_HEADER_ID CC_HEADER_ID, CC_VERSION_NUM CC_VERSION_NUM, CC_ACCT_LINE_ID CC_ACCT_LINE_ID, CC_DET_PF_LINE_ID CC_DET_PF_LINE_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, BATCH_LINE_NUM BATCH_LINE_NUM, CC_TRANSACTION_DATE CC_TRANSACTION_DATE, CC_FUNC_DR_AMT CC_FUNC_DR_AMT, CC_FUNC_CR_AMT CC_FUNC_CR_AMT, JE_SOURCE_NAME JE_SOURCE_NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_NAME PERIOD_NAME, ACTUAL_FLAG ACTUAL_FLAG, BUDGET_DEST_FLAG BUDGET_DEST_FLAG, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, CBC_RESULT_CODE CBC_RESULT_CODE, STATUS_CODE STATUS_CODE, BUDGET_VERSION_ID BUDGET_VERSION_ID, BUDGET_AMT BUDGET_AMT, COMMITMENT_ENCMBRNC_AMT COMMITMENT_ENCMBRNC_AMT, OBLIGATION_ENCMBRNC_AMT OBLIGATION_ENCMBRNC_AMT, CC_ENCMBRNC_DATE CC_ENCMBRNC_DATE, FUNDS_AVAILABLE_AMT FUNDS_AVAILABLE_AMT, CURRENCY_CODE CURRENCY_CODE, DOCUMENT_TYPE DOCUMENT_TYPE, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION, PA_FLAG PA_FLAG, RESULT_CODE_SOURCE RESULT_CODE_SOURCE, BATCH_ID BATCH_ID, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5, REFERENCE_6 REFERENCE_6, REFERENCE_7 REFERENCE_7, REFERENCE_8 REFERENCE_8, REFERENCE_9 REFERENCE_9, REFERENCE_10 REFERENCE_10, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, EVENT_ID EVENT_ID, PROJECT_LINE PROJECT_LINE, PA_BURDEN_FLAG PA_BURDEN_FLAG, ENCUMBRANCE_TYPE_KEY ENCUMBRANCE_TYPE_KEY from "IGC"."IGC_CC_INTERFACE"

View Text - HTML Formatted

SELECT CC_HEADER_ID CC_HEADER_ID
, CC_VERSION_NUM CC_VERSION_NUM
, CC_ACCT_LINE_ID CC_ACCT_LINE_ID
, CC_DET_PF_LINE_ID CC_DET_PF_LINE_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BATCH_LINE_NUM BATCH_LINE_NUM
, CC_TRANSACTION_DATE CC_TRANSACTION_DATE
, CC_FUNC_DR_AMT CC_FUNC_DR_AMT
, CC_FUNC_CR_AMT CC_FUNC_CR_AMT
, JE_SOURCE_NAME JE_SOURCE_NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_NAME PERIOD_NAME
, ACTUAL_FLAG ACTUAL_FLAG
, BUDGET_DEST_FLAG BUDGET_DEST_FLAG
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, CBC_RESULT_CODE CBC_RESULT_CODE
, STATUS_CODE STATUS_CODE
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUDGET_AMT BUDGET_AMT
, COMMITMENT_ENCMBRNC_AMT COMMITMENT_ENCMBRNC_AMT
, OBLIGATION_ENCMBRNC_AMT OBLIGATION_ENCMBRNC_AMT
, CC_ENCMBRNC_DATE CC_ENCMBRNC_DATE
, FUNDS_AVAILABLE_AMT FUNDS_AVAILABLE_AMT
, CURRENCY_CODE CURRENCY_CODE
, DOCUMENT_TYPE DOCUMENT_TYPE
, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION
, PA_FLAG PA_FLAG
, RESULT_CODE_SOURCE RESULT_CODE_SOURCE
, BATCH_ID BATCH_ID
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
, REFERENCE_6 REFERENCE_6
, REFERENCE_7 REFERENCE_7
, REFERENCE_8 REFERENCE_8
, REFERENCE_9 REFERENCE_9
, REFERENCE_10 REFERENCE_10
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, EVENT_ID EVENT_ID
, PROJECT_LINE PROJECT_LINE
, PA_BURDEN_FLAG PA_BURDEN_FLAG
, ENCUMBRANCE_TYPE_KEY ENCUMBRANCE_TYPE_KEY
FROM "IGC"."IGC_CC_INTERFACE"