VIEW: GMS.GMS_TRANSACTION_INTERFACE_ALL#

Source

View Text - Preformatted

select TXN_INTERFACE_ID TXN_INTERFACE_ID, BATCH_NAME BATCH_NAME, TRANSACTION_SOURCE TRANSACTION_SOURCE, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, AWARD_ID AWARD_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE, ORG_ID ORG_ID, SYSTEM_LINKAGE SYSTEM_LINKAGE, USER_TRANSACTION_SOURCE USER_TRANSACTION_SOURCE, TRANSACTION_TYPE TRANSACTION_TYPE, BURDENABLE_RAW_COST BURDENABLE_RAW_COST, FUNDING_PATTERN_ID FUNDING_PATTERN_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, AWARD_NUMBER AWARD_NUMBER, ORIGINAL_ENCUMBRANCE_ITEM_ID ORIGINAL_ENCUMBRANCE_ITEM_ID from "GMS"."GMS_TRANSACTION_INTERFACE_ALL"

View Text - HTML Formatted

SELECT TXN_INTERFACE_ID TXN_INTERFACE_ID
, BATCH_NAME BATCH_NAME
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, AWARD_ID AWARD_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE
, ORIG_TRANSACTION_REFERENCE ORIG_TRANSACTION_REFERENCE
, ORG_ID ORG_ID
, SYSTEM_LINKAGE SYSTEM_LINKAGE
, USER_TRANSACTION_SOURCE USER_TRANSACTION_SOURCE
, TRANSACTION_TYPE TRANSACTION_TYPE
, BURDENABLE_RAW_COST BURDENABLE_RAW_COST
, FUNDING_PATTERN_ID FUNDING_PATTERN_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, AWARD_NUMBER AWARD_NUMBER
, ORIGINAL_ENCUMBRANCE_ITEM_ID ORIGINAL_ENCUMBRANCE_ITEM_ID
FROM "GMS"."GMS_TRANSACTION_INTERFACE_ALL"