[Home] [Help] [Dependency Information]
Object Name: | GMS_AWARD_DISTRIBUTIONS# |
---|---|
Object Type: | VIEW |
Owner: | GMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AWARD_SET_ID | NUMBER | (15) | Yes | |
ADL_LINE_NUM | NUMBER | (15) | Yes | |
FUNDING_PATTERN_ID | NUMBER | (15) | ||
DISTRIBUTION_VALUE | NUMBER | (3) | ||
RAW_COST | NUMBER | (22) | ||
DOCUMENT_TYPE | VARCHAR2 | (3) | Yes | |
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
AWARD_ID | NUMBER | (15) | Yes | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
CDL_LINE_NUM | NUMBER | (15) | ||
IND_COMPILED_SET_ID | NUMBER | (15) | ||
GL_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
LINE_NUM_REVERSED | NUMBER | (15) | ||
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | ||
OUTPUT_VAT_TAX_ID | NUMBER | |||
OUTPUT_TAX_EXEMPT_FLAG | VARCHAR2 | (1) | ||
OUTPUT_TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
OUTPUT_TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | ||
ADL_STATUS | VARCHAR2 | (3) | ||
FC_STATUS | VARCHAR2 | (1) | ||
LINE_TYPE | VARCHAR2 | (1) | ||
CAPITALIZED_FLAG | VARCHAR2 | (1) | ||
CAPITALIZABLE_FLAG | VARCHAR2 | (1) | ||
REVERSED_FLAG | VARCHAR2 | (1) | ||
REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
BILLED_FLAG | VARCHAR2 | (1) | ||
BILL_HOLD_FLAG | VARCHAR2 | (1) | ||
DISTRIBUTION_ID | NUMBER | (15) | ||
PO_DISTRIBUTION_ID | NUMBER | (15) | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
PARENT_AWARD_SET_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
PARENT_ADL_LINE_NUM | NUMBER | (15) | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
BURDENABLE_RAW_COST | NUMBER | |||
COST_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
BUD_TASK_ID | NUMBER | (15) | ||
BILLABLE_FLAG | VARCHAR2 | (1) | ||
ACCUMULATED_FLAG | VARCHAR2 | (1) | ||
OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
PAYMENT_STATUS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_SET_ID
, ADL_LINE_NUM
, FUNDING_PATTERN_ID
, DISTRIBUTION_VALUE
, RAW_COST
, DOCUMENT_TYPE
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_ITEM_ID
, CDL_LINE_NUM
, IND_COMPILED_SET_ID
, GL_DATE
, REQUEST_ID
, LINE_NUM_REVERSED
, RESOURCE_LIST_MEMBER_ID
, OUTPUT_VAT_TAX_ID
, OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_TAX_EXEMPT_NUMBER
, ADL_STATUS
, FC_STATUS
, LINE_TYPE
, CAPITALIZED_FLAG
, CAPITALIZABLE_FLAG
, REVERSED_FLAG
, REVENUE_DISTRIBUTED_FLAG
, BILLED_FLAG
, BILL_HOLD_FLAG
, DISTRIBUTION_ID
, PO_DISTRIBUTION_ID
, INVOICE_DISTRIBUTION_ID
, PARENT_AWARD_SET_ID
, INVOICE_ID
, PARENT_ADL_LINE_NUM
, DISTRIBUTION_LINE_NUMBER
, BURDENABLE_RAW_COST
, COST_DISTRIBUTED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, BUD_TASK_ID
, BILLABLE_FLAG
, ACCUMULATED_FLAG
, OUTPUT_TAX_CLASSIFICATION_CODE
, PAYMENT_STATUS_FLAG
FROM GMS.GMS_AWARD_DISTRIBUTIONS#;
|
|
|