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

TABLE: FV.FV_FACTSII_ENDING_BALANCES

Object Details
Object Name: FV_FACTSII_ENDING_BALANCES
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_FACTSII_ENDING_BALANCES
Subobject Name:
Status: VALID


Stores the period year ending balances for the FACTSII reporting accounts by the 4 attributes namely Public Law, Advance Flag, Transfer Dept Id and Transfer Main Account.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER

Ledger Identifier
FISCAL_YEAR NUMBER

Fiscal Year
CCID NUMBER

General Ledger Code Combination Identifier
USSGL_ACCOUNT VARCHAR2 (30)
USSGL Account
ACCOUNT VARCHAR2 (30)
Account
ENDING_BALANCE_CR NUMBER

Ending Balance Credit
ENDING_BALANCE_DR NUMBER

Ending Balance Debit
PUBLIC_LAW VARCHAR2 (150)
Public Law Code
ADVANCE_FLAG VARCHAR2 (150)
Advance Flag
TRANSFER_DEPT_ID VARCHAR2 (150)
Transfer Dept Id
TRANSFER_MAIN_ACCT VARCHAR2 (150)
Transfer Main Account
RECORD_CATEGORY VARCHAR2 (1)
Record Category
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_BY NUMBER

Standard Who column
REQUEST_ID NUMBER

Request Id
FUND VARCHAR2 (30)
Fund
TREASURY_SYMBOL_ID NUMBER

Treasury Symbol Identifier
FYR VARCHAR2 (30)
FYR
COHORT VARCHAR2 (30)
Cohort
Query Text

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


SELECT SET_OF_BOOKS_ID
,      FISCAL_YEAR
,      CCID
,      USSGL_ACCOUNT
,      ACCOUNT
,      ENDING_BALANCE_CR
,      ENDING_BALANCE_DR
,      PUBLIC_LAW
,      ADVANCE_FLAG
,      TRANSFER_DEPT_ID
,      TRANSFER_MAIN_ACCT
,      RECORD_CATEGORY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      REQUEST_ID
,      FUND
,      TREASURY_SYMBOL_ID
,      FYR
,      COHORT
FROM FV.FV_FACTSII_ENDING_BALANCES;

Dependencies

[top of page]

FV.FV_FACTSII_ENDING_BALANCES does not reference any database object

FV.FV_FACTSII_ENDING_BALANCES is referenced by following:

SchemaAPPS
SynonymFV_FACTSII_ENDING_BALANCES