[Home] [Help] [Dependency Information]
Object Name: | FV_FACTS1_PERIOD_ATTRIBUTES# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CCID | NUMBER | (15) | Yes | |
PERIOD_NUM | NUMBER | (15) | Yes | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_YEAR | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
FUND_GROUP | NUMBER | (4) | Yes | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | |
FUND_VALUE | VARCHAR2 | (30) | ||
DEPT_ID | VARCHAR2 | (3) | ||
BUREAU_ID | VARCHAR2 | (2) | ||
ELIMINATIONS_DEPT | VARCHAR2 | (6) | ||
G_NG_INDICATOR | VARCHAR2 | (1) | ||
END_BAL_IND | VARCHAR2 | (1) | ||
REPORTED_GROUP | VARCHAR2 | (1) | ||
USSGL_ACCOUNT | VARCHAR2 | (4) | ||
EXCH_NON_EXCH | VARCHAR2 | (1) | ||
CUST_NON_CUST | VARCHAR2 | (1) | ||
BUDGET_SUBFUNCTION | VARCHAR2 | (3) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
NEW_REC_FLAG | VARCHAR2 | (1) | ||
BALANCE_AMOUNT | NUMBER | |||
BEGIN_BALANCE | NUMBER | |||
PERIOD_CY_DR_BAL | NUMBER | |||
PERIOD_CY_CR_BAL | NUMBER | |||
PERIOD_BEGIN_BAL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CCID
, PERIOD_NUM
, PERIOD_NAME
, PERIOD_YEAR
, SET_OF_BOOKS_ID
, FUND_GROUP
, ACCOUNT_NUMBER
, FUND_VALUE
, DEPT_ID
, BUREAU_ID
, ELIMINATIONS_DEPT
, G_NG_INDICATOR
, END_BAL_IND
, REPORTED_GROUP
, USSGL_ACCOUNT
, EXCH_NON_EXCH
, CUST_NON_CUST
, BUDGET_SUBFUNCTION
, ACCOUNT_TYPE
, NEW_REC_FLAG
, BALANCE_AMOUNT
, BEGIN_BALANCE
, PERIOD_CY_DR_BAL
, PERIOD_CY_CR_BAL
, PERIOD_BEGIN_BAL
FROM FV.FV_FACTS1_PERIOD_ATTRIBUTES#;
|
|
|