VIEW: GMS.GMS_AWARD_DISTRIBUTIONS#

Source

View Text - Preformatted

select AWARD_SET_ID AWARD_SET_ID, ADL_LINE_NUM ADL_LINE_NUM, FUNDING_PATTERN_ID FUNDING_PATTERN_ID, DISTRIBUTION_VALUE DISTRIBUTION_VALUE, RAW_COST RAW_COST, DOCUMENT_TYPE DOCUMENT_TYPE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, CDL_LINE_NUM CDL_LINE_NUM, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, GL_DATE GL_DATE, REQUEST_ID REQUEST_ID, LINE_NUM_REVERSED LINE_NUM_REVERSED, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER, ADL_STATUS ADL_STATUS, FC_STATUS FC_STATUS, LINE_TYPE LINE_TYPE, CAPITALIZED_FLAG CAPITALIZED_FLAG, CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG, REVERSED_FLAG REVERSED_FLAG, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG, BILLED_FLAG BILLED_FLAG, BILL_HOLD_FLAG BILL_HOLD_FLAG, DISTRIBUTION_ID DISTRIBUTION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, PARENT_AWARD_SET_ID PARENT_AWARD_SET_ID, INVOICE_ID INVOICE_ID, PARENT_ADL_LINE_NUM PARENT_ADL_LINE_NUM, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, BURDENABLE_RAW_COST BURDENABLE_RAW_COST, COST_DISTRIBUTED_FLAG COST_DISTRIBUTED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BUD_TASK_ID BUD_TASK_ID, BILLABLE_FLAG BILLABLE_FLAG, ACCUMULATED_FLAG ACCUMULATED_FLAG, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE, PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG from "GMS"."GMS_AWARD_DISTRIBUTIONS"

View Text - HTML Formatted

SELECT AWARD_SET_ID AWARD_SET_ID
, ADL_LINE_NUM ADL_LINE_NUM
, FUNDING_PATTERN_ID FUNDING_PATTERN_ID
, DISTRIBUTION_VALUE DISTRIBUTION_VALUE
, RAW_COST RAW_COST
, DOCUMENT_TYPE DOCUMENT_TYPE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, CDL_LINE_NUM CDL_LINE_NUM
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, GL_DATE GL_DATE
, REQUEST_ID REQUEST_ID
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID
, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER
, ADL_STATUS ADL_STATUS
, FC_STATUS FC_STATUS
, LINE_TYPE LINE_TYPE
, CAPITALIZED_FLAG CAPITALIZED_FLAG
, CAPITALIZABLE_FLAG CAPITALIZABLE_FLAG
, REVERSED_FLAG REVERSED_FLAG
, REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG
, BILLED_FLAG BILLED_FLAG
, BILL_HOLD_FLAG BILL_HOLD_FLAG
, DISTRIBUTION_ID DISTRIBUTION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, PARENT_AWARD_SET_ID PARENT_AWARD_SET_ID
, INVOICE_ID INVOICE_ID
, PARENT_ADL_LINE_NUM PARENT_ADL_LINE_NUM
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, BURDENABLE_RAW_COST BURDENABLE_RAW_COST
, COST_DISTRIBUTED_FLAG COST_DISTRIBUTED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BUD_TASK_ID BUD_TASK_ID
, BILLABLE_FLAG BILLABLE_FLAG
, ACCUMULATED_FLAG ACCUMULATED_FLAG
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
, PAYMENT_STATUS_FLAG PAYMENT_STATUS_FLAG
FROM "GMS"."GMS_AWARD_DISTRIBUTIONS"