[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS_ENDING_BALANCES# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
AMOUNT | NUMBER | Yes | ||
AUTHORITY_TYPE_CODE | VARCHAR2 | (1) | ||
BEGINNING_BALANCE | NUMBER | |||
BUDGET_IMPACT_IND | VARCHAR2 | (1) | ||
CCID | NUMBER | (15) | Yes | |
CUST_NON_CUST | VARCHAR2 | (1) | ||
D_C_INDICATOR | VARCHAR2 | (1) | Yes | |
END_BAL_IND | VARCHAR2 | (1) | ||
EXCH_NON_EXCH | VARCHAR2 | (1) | ||
FED_NON_FED | VARCHAR2 | (1) | ||
FISCAL_YEAR | NUMBER | (4) | Yes | |
FUND_VALUE | VARCHAR2 | (30) | Yes | |
RECIPIENT_NAME | VARCHAR2 | (120) | ||
RECORD_CATEGORY | VARCHAR2 | (25) | ||
REPORTED_STATUS | VARCHAR2 | (1) | ||
SET_OF_BOOKS_ID | NUMBER | Yes | ||
TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | ||
TRADING_PARTNER_MAIN_ACCOUNT | VARCHAR2 | (4) | ||
USSGL_ACCOUNT | VARCHAR2 | (6) | ||
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | |
DOLLAR_AMOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_TYPE
, AMOUNT
, AUTHORITY_TYPE_CODE
, BEGINNING_BALANCE
, BUDGET_IMPACT_IND
, CCID
, CUST_NON_CUST
, D_C_INDICATOR
, END_BAL_IND
, EXCH_NON_EXCH
, FED_NON_FED
, FISCAL_YEAR
, FUND_VALUE
, RECIPIENT_NAME
, RECORD_CATEGORY
, REPORTED_STATUS
, SET_OF_BOOKS_ID
, TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT
, USSGL_ACCOUNT
, ACCOUNT_NUMBER
, DOLLAR_AMOUNT
FROM FV.FV_GTAS_ENDING_BALANCES#;
|
|
|