VIEW: GMS.GMS_DISTRIBUTION_DETAILS#

Source

View Text - Preformatted

select DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, DOCUMENT_TYPE DOCUMENT_TYPE, FUNDING_PATTERN_ID FUNDING_PATTERN_ID, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER, AWARD_ID AWARD_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, GL_DATE GL_DATE, QUANTITY_DISTRIBUTED QUANTITY_DISTRIBUTED, AMOUNT_DISTRIBUTED AMOUNT_DISTRIBUTED, FC_STATUS FC_STATUS, LINE_STATUS LINE_STATUS, REMARKS REMARKS, CREATION_DATE CREATION_DATE, BURDENED_COST BURDENED_COST, DENOM_BURDENED_COST DENOM_BURDENED_COST, DENOM_RAW_COST DENOM_RAW_COST, ACCT_RAW_COST ACCT_RAW_COST, ACCT_BURDENED_COST ACCT_BURDENED_COST, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT from "GMS"."GMS_DISTRIBUTION_DETAILS"

View Text - HTML Formatted

SELECT DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, FUNDING_PATTERN_ID FUNDING_PATTERN_ID
, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER
, AWARD_ID AWARD_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, GL_DATE GL_DATE
, QUANTITY_DISTRIBUTED QUANTITY_DISTRIBUTED
, AMOUNT_DISTRIBUTED AMOUNT_DISTRIBUTED
, FC_STATUS FC_STATUS
, LINE_STATUS LINE_STATUS
, REMARKS REMARKS
, CREATION_DATE CREATION_DATE
, BURDENED_COST BURDENED_COST
, DENOM_BURDENED_COST DENOM_BURDENED_COST
, DENOM_RAW_COST DENOM_RAW_COST
, ACCT_RAW_COST ACCT_RAW_COST
, ACCT_BURDENED_COST ACCT_BURDENED_COST
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
FROM "GMS"."GMS_DISTRIBUTION_DETAILS"