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_ENCUMBRANCE_ITEMS_ALL

Object Details

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

GMS_ENCUMBRANCE_ITEMS_ALL stores the manual encumbrance transactions for a sponsored project by task, award, encumbrance type, and organization. Encumbrances are similar to expenditures except that encumbrances are allowed in currency only and cannot be billed or generate revenue.
Encumbrances can be manual (pre-approved) or interfaced from Oracle Labor Distribution.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_ENCUMBRANCE_ITEMS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_ITEM_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_TRANSACTION_REFERENCE
GMS_ENCUMBRANCE_ITEMS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_ITEM_DATE
GMS_ENCUMBRANCE_ITEMS_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENC_DISTRIBUTED_FLAG
GMS_ENCUMBRANCE_ITEMS_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IND_COMPILED_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENCUMBRANCE_ITEM_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies the encumbrance item
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ENCUMBRANCE_ID	NUMBER	(15)	Yes	Identifier of the encumbrance to which the encumbrance item belongs
TASK_ID	NUMBER	(15)	Yes	Identifier of the task to which the encumbrance item is charged
ENCUMBRANCE_ITEM_DATE	DATE		Yes	Date on which the work occurred
ENCUMBRANCE_TYPE	VARCHAR2	(30)	Yes	Encumbrance type that classifies the type of work performed
ENC_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes	Encumbrance type that classifies the type of work performed
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)		Identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the encumbrance organization entered in Oracle Payables.
ADJUSTED_ENCUMBRANCE_ITEM_ID	NUMBER	(15)		Identifier of the encumbrance item adjusted by this encumbrance item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item.
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)		Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice.
TRANSFERRED_FROM_ENC_ITEM_ID	NUMBER	(15)		Identifier of the encumbrance item from which this encumbrance item originated. This encumbrance item is the new item that is system created when an item is transferred and is charged to the new project/task.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield context field
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield context field
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(30)		Only populated for encumbrance items created from transactions imported into Projects from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the encumbrance item created after import.
TRANSACTION_SOURCE	VARCHAR2	(30)		Only populated for encumbrance items created from transactions imported into Projects from an external system. Used by Project's encumbrance item adjustment modules and costing programs to ensure the proper processing on imported items.
PROJECT_ID	NUMBER	(15)		The project_id of the event that the encumbrance item is FIFO marked by
SOURCE_ENCUMBRANCE_ITEM_ID	NUMBER	(15)		Only populated for related items created in Project's Labor Extensions. This number is the identifier of the source encumbrance item to which this item is related.
JOB_ID	NUMBER	(15)		Identifier of the job of an employee as of the encumbrance item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts.
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)	Yes	System linkage that classifies the encumbrance type in order to drive system processing for the items classified by the encumbrance type
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the transaction
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Account currency code of the transaction
ACCT_RATE_DATE	DATE			Functional rate date for the transaction
ACCT_RATE_TYPE	VARCHAR2	(30)		Functional rate type for the transaction
ACCT_EXCHANGE_RATE	NUMBER			Functional exchange rate for the transaction
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER			Rounding limit for imported transaction
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code of transaction
PROJECT_RATE_DATE	DATE			Project rate date for transaction
PROJECT_RATE_TYPE	VARCHAR2	(30)		Project rate type for transaction
PROJECT_EXCHANGE_RATE	NUMBER			Project exchange rate for transaction
DENOM_TP_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE	NUMBER			Transfer price in the transaction currency
PROJACCT_TRANSFER_PRICE	NUMBER			Transfer price in functional currency of the provider operating unit
AMOUNT	NUMBER	(22)		Amount of the particular encumbrance item
ENCUMBRANCE_COMMENT	VARCHAR2	(240)		Comments for encumbrance item
IND_COMPILED_SET_ID	NUMBER	(15)		Ind Compiled set identifier for encumbrance
PA_DATE	DATE			Projects period end date for the encumbrance item
GL_DATE	DATE			General Ledger period end date for the encumbrance item
LINE_NUM	NUMBER			Reference line number stored in GMS_AWARD_DISTRIBUTIONS table for encumbrance item
BURDEN_SUM_DEST_RUN_ID	NUMBER	(15)		Burden summarization run identifier. Identifier identifies all the encumbrance items created by burden component summarization. This is used to identify all the cost distribution lines summarized together to create an encumbrance item.
BURDEN_SUM_SOURCE_RUN_ID	NUMBER	(4)		Identifies group of Encumbrance Distribution Lines that were summarized to create summarized burden components encumbrance items (EI). The same run_id is populated in the EI table to identify all EI created during a run.
DENOM_RAW_AMOUNT	NUMBER			For future use
INCURRED_BY_PERSON_ID	NUMBER	(9)		Not currently used
PERSON_ID	NUMBER	(9)		Not currently used
ACCT_RAW_COST	NUMBER			Raw cost of the encumbrance item in accounting currency
ADJUSTMENT_TYPE	VARCHAR2	(150)		Adjustment Type Code

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ENCUMBRANCE_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ENCUMBRANCE_ID
,      TASK_ID
,      ENCUMBRANCE_ITEM_DATE
,      ENCUMBRANCE_TYPE
,      ENC_DISTRIBUTED_FLAG
,      OVERRIDE_TO_ORGANIZATION_ID
,      ADJUSTED_ENCUMBRANCE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_ENC_ITEM_ID
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORIG_TRANSACTION_REFERENCE
,      TRANSACTION_SOURCE
,      PROJECT_ID
,      SOURCE_ENCUMBRANCE_ITEM_ID
,      JOB_ID
,      ORG_ID
,      SYSTEM_LINKAGE_FUNCTION
,      DENOM_CURRENCY_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      PROJACCT_TRANSFER_PRICE
,      AMOUNT
,      ENCUMBRANCE_COMMENT
,      IND_COMPILED_SET_ID
,      PA_DATE
,      GL_DATE
,      LINE_NUM
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_SOURCE_RUN_ID
,      DENOM_RAW_AMOUNT
,      INCURRED_BY_PERSON_ID
,      PERSON_ID
,      ACCT_RAW_COST
,      ADJUSTMENT_TYPE
FROM GMS.GMS_ENCUMBRANCE_ITEMS_ALL;

Dependencies

[top of page]

GMS.GMS_ENCUMBRANCE_ITEMS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_ITEMS_ALL is referenced by following:

APPS: GMS_ENCUMBRANCE_ITEMS; GMS_ENCUMBRANCE_ITEMS_ALL