[Home] [Help] [Dependency Information]
Object Name: | FII_GL_ENC_CARRYFWD_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_GL_ENC_CARRYFWD_F |
Subobject Name: | |
Status: | VALID |
This is a table for storing the encumbrance carry forward data.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | (15) | Time Identifier | |
PERIOD_TYPE_ID | NUMBER | (15) | Period Type Identifier | |
JE_SOURCE | VARCHAR2 | (25) | Journal Source | |
JE_CATEGORY | VARCHAR2 | (25) | Journal Category | |
SET_OF_BOOKS_ID | NUMBER | (15) | No longer used. | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of Accounts Identifier | |
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Functional Currency | |
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 |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
COMPANY_ID | NUMBER | (15) | Company Identifier | |
COST_CENTER_ID | NUMBER | (15) | Cost Center Identifier | |
FIN_CATEGORY_ID | NUMBER | (15) | Financial Category Identifier | |
PROD_CATEGORY_ID | NUMBER | (15) | Product Category Identifier | |
USER_DIM1_ID | NUMBER | (15) | User Defined Dimension 1 Identifier | |
USER_DIM2_ID | NUMBER | (15) | User Defined Dimension 2 Identifier | |
POSTED_DATE | DATE | Posted Date | ||
COMMITTED_AMOUNT_B | NUMBER | Committed Amount Base Currency | ||
COMMITTED_AMOUNT_PRIM | NUMBER | Committed Amount Primary Currency | ||
OBLIGATED_AMOUNT_B | NUMBER | Obligated Amount Base Currency | ||
OBLIGATED_AMOUNT_PRIM | NUMBER | Obligated Amount Primary Currency | ||
OTHER_AMOUNT_B | NUMBER | Other Amount Base Currency | ||
OTHER_AMOUNT_PRIM | NUMBER | Other Amount Primary Currency | ||
LEDGER_ID | NUMBER | (15) | Ledger Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, JE_SOURCE
, JE_CATEGORY
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMPANY_ID
, COST_CENTER_ID
, FIN_CATEGORY_ID
, PROD_CATEGORY_ID
, USER_DIM1_ID
, USER_DIM2_ID
, POSTED_DATE
, COMMITTED_AMOUNT_B
, COMMITTED_AMOUNT_PRIM
, OBLIGATED_AMOUNT_B
, OBLIGATED_AMOUNT_PRIM
, OTHER_AMOUNT_B
, OTHER_AMOUNT_PRIM
, LEDGER_ID
FROM FII.FII_GL_ENC_CARRYFWD_F;
FII.FII_GL_ENC_CARRYFWD_F does not reference any database object
FII.FII_GL_ENC_CARRYFWD_F is referenced by following:
|
|
|