eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMS.GMS_AWARD_DISTRIBUTIONS

Object Details

Object Name:	GMS_AWARD_DISTRIBUTIONS
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_AWARD_DISTRIBUTIONS
Subobject Name:
Status:	VALID

GMS_AWARD_DISTRIBUTIONS stores distribution lines for requisitions, purchase orders, invoices, encumbrances, and Project expenditure items charged to awards.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_AWARD_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_SET_ID ADL_LINE_NUM
GMS_AWARD_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID ADL_LINE_NUM DOCUMENT_TYPE ADL_STATUS
GMS_AWARD_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_DISTRIBUTION_ID DISTRIBUTION_LINE_NUMBER
GMS_AWARD_DISTRIBUTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID PROJECT_ID DOCUMENT_TYPE
GMS_AWARD_DISTRIBUTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID DOCUMENT_TYPE REVENUE_DISTRIBUTED_FLAG FC_STATUS BILLABLE_FLAG
GMS_AWARD_DISTRIBUTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID DOCUMENT_TYPE FC_STATUS BILLED_FLAG BILLABLE_FLAG COST_DISTRIBUTED_FLAG ADL_STATUS
GMS_AWARD_DISTRIBUTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IND_COMPILED_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_SET_ID	NUMBER	(15)	Yes	System generated number for a distribution set
ADL_LINE_NUM	NUMBER	(15)	Yes	Sequence number of a distribution within a distribution set
FUNDING_PATTERN_ID	NUMBER	(15)		Identifier of funding pattern used for generating the distribution set
DISTRIBUTION_VALUE	NUMBER	(3)		Distribution value is the percentage of the funding distribution.
RAW_COST	NUMBER	(22)		Raw cost of the source transaction
DOCUMENT_TYPE	VARCHAR2	(3)	Yes	Source document type of transactions
PROJECT_ID	NUMBER	(15)		Project identifier for the distribution
TASK_ID	NUMBER	(15)		Task identifier for the distribution
AWARD_ID	NUMBER	(15)	Yes	Award identifier of the award to which the distribution is assigned
EXPENDITURE_ITEM_ID	NUMBER	(15)		Expenditure item identifier or encumbrance item identifier of the source transaction
CDL_LINE_NUM	NUMBER	(15)		Sequential number that identifies the cost distribution line for an expenditure item
IND_COMPILED_SET_ID	NUMBER	(15)		Identifier of the compiled set that is used to calculate the burden cost
GL_DATE	DATE			End date of General Ledger accounting period to which cost is posted
REQUEST_ID	NUMBER	(15)		Standard Who column
LINE_NUM_REVERSED	NUMBER	(15)		Distribution line number; reversed by this distribution line
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member identifier to which the distribution is mapped to for fundschecking purpose
OUTPUT_VAT_TAX_ID	NUMBER
OUTPUT_TAX_EXEMPT_FLAG	VARCHAR2	(1)		Indicates whether the distribution is exempt from tax
OUTPUT_TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Tax exemption reason code
OUTPUT_TAX_EXEMPT_NUMBER	VARCHAR2	(80)		Tax exemption number
ADL_STATUS	VARCHAR2	(3)		Status of the distribution. A is for Active; I is for Invalid.
FC_STATUS	VARCHAR2	(1)		Flag indicating the fundscheck status of the distribution. A is for Approved; R is for Rejected; and P is for Pending.
LINE_TYPE	VARCHAR2	(1)		Indicates the distribution; represents raw cost or burden cost line. R is for R and B is for Burden.
CAPITALIZED_FLAG	VARCHAR2	(1)		Indicates whether distribution has been capitalized
CAPITALIZABLE_FLAG	VARCHAR2	(1)		Indicates capitalizable status of this distribution
REVERSED_FLAG	VARCHAR2	(1)		Reversed item identifier
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)		Indicates revenue distributed status
BILLED_FLAG	VARCHAR2	(1)		Indicates billed status
BILL_HOLD_FLAG	VARCHAR2	(1)		For future use only
DISTRIBUTION_ID	NUMBER	(15)		Requisition distribution unique identifier
PO_DISTRIBUTION_ID	NUMBER	(15)		Purchasing distribution unique identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice identifier
PARENT_AWARD_SET_ID	NUMBER	(15)		Parent distribution set identifier used for tracking reversed distributions
INVOICE_ID	NUMBER	(15)		Invoice identifier for the distribution
PARENT_ADL_LINE_NUM	NUMBER	(15)		Parent distribution line number used for tracking reversed distributions
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Invoice distribution line number for this record
BURDENABLE_RAW_COST	NUMBER			Part of the raw cost used for calculating burden cost
COST_DISTRIBUTED_FLAG	VARCHAR2	(1)		Indicates whether the item has been cost distributed. N indicates the item is marked for cost distribution. When the item is cost distributed, the flag is set to Y.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
BUD_TASK_ID	NUMBER	(15)		Budgeted task identifier of the distribution
BILLABLE_FLAG	VARCHAR2	(1)		Billable flag. Used by Revenue or Invoice generation. Status of this flag mapped to corresponding cost distribution line.
ACCUMULATED_FLAG	VARCHAR2	(1)		Flag indicating whether the distribution has been posted in balances
OUTPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Tax code used for Invoicing.
PAYMENT_STATUS_FLAG	VARCHAR2	(1)		Flag that indicates if the Paid invoice Distribution in Cash Based Accounting has been fully relieved

Query Text

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;

Dependencies

[top of page]

GMS.GMS_AWARD_DISTRIBUTIONS does not reference any database object

GMS.GMS_AWARD_DISTRIBUTIONS is referenced by following:

GMS: GMS_AWARD_DISTRIBUTIONS#