[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_FACTS_USSGL_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | FV |
| FND Design Data: |  FV.FV_FACTS_USSGL_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
FV_FACTS_USSGL_ACCOUNTS is a base table used to capture information regarding the USSGL accounts.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FV_FACTS_USSGL_ACCOUNTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 USSGL_ACCOUNT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| USSGL_ACCOUNT | VARCHAR2 | (30) | Yes | USSGL account, format 9999 |
| DESCRIPTION | VARCHAR2 | (240) | Yes | Description for USSGL account |
| NATURAL_BALANCE | VARCHAR2 | (1) | Yes | Natural account balance type |
| TOTAL_RESOURCE_BE_FLAG | VARCHAR2 | (1) | Total resources beginning or ending flag | |
| TOTAL_RESOURCE_DC_FLAG | VARCHAR2 | (1) | Total resources debit or credit flag | |
| RESOURCE_STATUS_BE_FLAG | VARCHAR2 | (1) | Resource status flag | |
| RESOURCE_STATUS_DC_FLAG | VARCHAR2 | (1) | Resources debit or credit status flag | |
| YE_RESOURCE_EQUITY_FLAG | VARCHAR2 | (1) | Year ending resource or equity flag | |
| YE_RESOURCE_EQUITY_BE_FLAG | VARCHAR2 | (1) | Year ending resources beginning or ending flag | |
| USSGL_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Account enabled flag |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| EXPENDED_UNEXPENDED | VARCHAR2 | (1) | Expended or unexpended identification flag. Valid values are E for Expended and U for Unexpended. | |
| PAID_UNPAID | VARCHAR2 | (1) | Paid or unpaid identification flag. Valid values are P for Paid and U for Unpaid. | |
| EDCK12_BALANCE_TYPE | VARCHAR2 | (1) | Edit Check 12 balance type | |
| OBLIGATIONS_INCURRED_FLAG | VARCHAR2 | (1) | Obligations Incurred Flag | |
| SPNDNG_FROM_COLL_AND_PYA_FLAG | VARCHAR2 | (1) | Spending from Coll and PYA Flag | |
| OBLIGATIONS_AS_OF_10_1_FLAG | VARCHAR2 | (1) | Obligations as of 10/1 Flag | |
| OBLIGATIONS_TRANSFERRED_FLAG | VARCHAR2 | (1) | Obligations Transferred Flag | |
| OBLIGATIONS_PERIOD_END_FLAG | VARCHAR2 | (1) | Obligations Period End Flag | |
| RECLASSIFICATION_SUM_ACC_FLAG | VARCHAR2 | (1) | Reclassification Sum Acc Flag | |
| RECLASSIFICATION_CTRL_FLAG | VARCHAR2 | (1) | Reclassification Ctrl Flag | |
| SF133_1700_1800 | VARCHAR2 | (1) | Indicates if the account will be considered for calculation in Line 1700 and Line 1800 of Edit Check 18 in FACTS II Edit Check Report | |
| SF133_2004_2104 | VARCHAR2 | (1) | Indicates if the account will be considered for calculation in Line 2004 and Line 2104 of Edit Check 18 in FACTS II Edit Check Report | |
| BEG_END | VARCHAR2 | (2) | Indicates whether the account will be considered in Edit Check 18 based on whether value present is "Ending" or "Ending - Beginning ". | |
| UNEXP_EXP | VARCHAR2 | (2) | Indicates whether the account will be considered in Edit Check 18 based on whether value present is "Unexpired" or "Unexpired/ Expired ". | |
| REPORTING_TYPE#1 | VARCHAR2 | (1) | ||
| YE_ANTICIPATED_FLAG#1 | VARCHAR2 | (1) | ||
| FUND_BALANCE_ACCOUNT_FLAG#1 | VARCHAR2 | (1) | ||
| YE_GENERAL_FLAG#1 | VARCHAR2 | (1) | ||
| YE_NEG_RECEIVABLES_FLAG#1 | VARCHAR2 | (1) | ||
| YE_NEG_PAYABLES_FLAG#1 | VARCHAR2 | (1) | ||
| DISBURSEMENTS_FLAG#1 | VARCHAR2 | (1) | ||
| COLLECTIONS_FLAG#1 | VARCHAR2 | (1) | ||
| ANTICIPATED_UNANTICIPATED#1 | VARCHAR2 | (1) | ||
| CANCELLED_FLAG#1 | VARCHAR2 | (1) | ||
| CASH_POSITION_FLAG#1 | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT USSGL_ACCOUNT
, DESCRIPTION
, NATURAL_BALANCE
, TOTAL_RESOURCE_BE_FLAG
, TOTAL_RESOURCE_DC_FLAG
, RESOURCE_STATUS_BE_FLAG
, RESOURCE_STATUS_DC_FLAG
, YE_RESOURCE_EQUITY_FLAG
, YE_RESOURCE_EQUITY_BE_FLAG
, USSGL_ENABLED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, EXPENDED_UNEXPENDED
, PAID_UNPAID
, EDCK12_BALANCE_TYPE
, OBLIGATIONS_INCURRED_FLAG
, SPNDNG_FROM_COLL_AND_PYA_FLAG
, OBLIGATIONS_AS_OF_10_1_FLAG
, OBLIGATIONS_TRANSFERRED_FLAG
, OBLIGATIONS_PERIOD_END_FLAG
, RECLASSIFICATION_SUM_ACC_FLAG
, RECLASSIFICATION_CTRL_FLAG
, SF133_1700_1800
, SF133_2004_2104
, BEG_END
, UNEXP_EXP
, REPORTING_TYPE#1
, YE_ANTICIPATED_FLAG#1
, FUND_BALANCE_ACCOUNT_FLAG#1
, YE_GENERAL_FLAG#1
, YE_NEG_RECEIVABLES_FLAG#1
, YE_NEG_PAYABLES_FLAG#1
, DISBURSEMENTS_FLAG#1
, COLLECTIONS_FLAG#1
, ANTICIPATED_UNANTICIPATED#1
, CANCELLED_FLAG#1
, CASH_POSITION_FLAG#1
FROM FV.FV_FACTS_USSGL_ACCOUNTS;
FV.FV_FACTS_USSGL_ACCOUNTS does not reference any database object
FV.FV_FACTS_USSGL_ACCOUNTS is referenced by following:
FV
FV_FACTS_USSGL_ACCOUNTS#
|
|
|
|