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

TABLE: GMS.GMS_BALANCES

Object Details
Object Name: GMS_BALANCES
Object Type: TABLE
Owner: GMS
FND Design Data: TableGMS.GMS_BALANCES
Subobject Name:
Status: VALID


GMS_BALANCES stores actual, budget, and encumbrance balance per project, task, award, period, budget version, and resource. Budget lines are created during the budget baseline process. Actual, encumbrance, and revenue records are created by the update actual and encumbrance balance process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMS_BALANCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnAWARD_ID
ColumnTASK_ID
ColumnSET_OF_BOOKS_ID
ColumnBUDGET_VERSION_ID
ColumnRESOURCE_LIST_MEMBER_ID
ColumnBALANCE_TYPE
ColumnSTART_DATE
ColumnEND_DATE
GMS_BALANCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
ColumnTASK_ID
ColumnRESOURCE_LIST_MEMBER_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Project defining column
TASK_ID NUMBER (15) Yes Task defining column
AWARD_ID NUMBER (15) Yes Award defining column
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes Resource list member defining column
SET_OF_BOOKS_ID NUMBER (15) Yes Accounting books defining column
BUDGET_VERSION_ID NUMBER (15) Yes Budget version
START_DATE DATE
Yes Accounting period start date
END_DATE DATE
Yes Accounting period end date
BALANCE_TYPE VARCHAR2 (3) Yes Balance type indicates the balance is for any of the following categories. BGT (budget), REQ (Requisition), PO (Purchase Order), AP (Supplier invoice), EXP (expenditure) ENC (encumbrance), REV (Revenue).
TOP_TASK_ID NUMBER (15)
Top task identifier for task level balances
PARENT_MEMBER_ID NUMBER (15)
Parent member defining column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
PERIOD_NAME VARCHAR2 (15)
Accounting period name
ACTUAL_PERIOD_TO_DATE NUMBER

Actuals period to date
REVENUE_PERIOD_TO_DATE NUMBER

Revenue period to date
BUDGET_PERIOD_TO_DATE NUMBER

Budget period to date
ENCUMB_PERIOD_TO_DATE NUMBER

Encumbrances period to date
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      RESOURCE_LIST_MEMBER_ID
,      SET_OF_BOOKS_ID
,      BUDGET_VERSION_ID
,      START_DATE
,      END_DATE
,      BALANCE_TYPE
,      TOP_TASK_ID
,      PARENT_MEMBER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERIOD_NAME
,      ACTUAL_PERIOD_TO_DATE
,      REVENUE_PERIOD_TO_DATE
,      BUDGET_PERIOD_TO_DATE
,      ENCUMB_PERIOD_TO_DATE
FROM GMS.GMS_BALANCES;

Dependencies

[top of page]

GMS.GMS_BALANCES does not reference any database object

GMS.GMS_BALANCES is referenced by following:

SchemaGMS
ViewGMS_BALANCES#