[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 |
| REPORTING_TYPE | VARCHAR2 | (1) | Yes | Reporting type |
| 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_ANTICIPATED_FLAG | VARCHAR2 | (1) | Yes | Year ending anticipated flag, Y or N |
| 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 | |
| FUND_BALANCE_ACCOUNT_FLAG | VARCHAR2 | (1) | Yes | Fund balance account flag |
| YE_GENERAL_FLAG | VARCHAR2 | (1) | Yes | Year-ending general flag |
| YE_NEG_RECEIVABLES_FLAG | VARCHAR2 | (1) | Yes | Year-ending negative receivables flag |
| YE_NEG_PAYABLES_FLAG | VARCHAR2 | (1) | Yes | Year-ending negative payable flag |
| DISBURSEMENTS_FLAG | VARCHAR2 | (1) | Yes | Disbursements flag |
| COLLECTIONS_FLAG | VARCHAR2 | (1) | Yes | Collections 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. | |
| ANTICIPATED_UNANTICIPATED | VARCHAR2 | (1) | Yes | Anticipated or unanticipated identification flag. Valid values are Y for Anticipated and N for Unanticipated. |
| CANCELLED_FLAG | VARCHAR2 | (1) | Yes | Cancelled flag |
| EDCK12_BALANCE_TYPE | VARCHAR2 | (1) | Edit Check 12 balance type | |
| CASH_POSITION_FLAG | VARCHAR2 | (1) | Yes | Cash position flag |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT USSGL_ACCOUNT
, DESCRIPTION
, REPORTING_TYPE
, NATURAL_BALANCE
, TOTAL_RESOURCE_BE_FLAG
, TOTAL_RESOURCE_DC_FLAG
, RESOURCE_STATUS_BE_FLAG
, RESOURCE_STATUS_DC_FLAG
, YE_ANTICIPATED_FLAG
, YE_RESOURCE_EQUITY_FLAG
, YE_RESOURCE_EQUITY_BE_FLAG
, FUND_BALANCE_ACCOUNT_FLAG
, YE_GENERAL_FLAG
, YE_NEG_RECEIVABLES_FLAG
, YE_NEG_PAYABLES_FLAG
, DISBURSEMENTS_FLAG
, COLLECTIONS_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
, ANTICIPATED_UNANTICIPATED
, CANCELLED_FLAG
, EDCK12_BALANCE_TYPE
, CASH_POSITION_FLAG
, OBLIGATIONS_INCURRED_FLAG
, SPNDNG_FROM_COLL_AND_PYA_FLAG
, OBLIGATIONS_AS_OF_10_1_FLAG
, OBLIGATIONS_TRANSFERRED_FLAG
, OBLIGATIONS_PERIOD_END_FLAG
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:
APPS
FV_FACTS_USSGL_ACCOUNTS
|
|
|
|