[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS_ENDING_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Table used by GTAS Processes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_TYPE | VARCHAR2 | (1) | Account Type | |
AMOUNT | NUMBER | Yes | Amount | |
AUTHORITY_TYPE_CODE | VARCHAR2 | (1) | Authority Type Code | |
BEGINNING_BALANCE | NUMBER | Beginning Balance | ||
BUDGET_IMPACT_IND | VARCHAR2 | (1) | Budget Impact Ind | |
CCID | NUMBER | (15) | Yes | Ccid |
CUST_NON_CUST | VARCHAR2 | (1) | Cust Non Cust | |
D_C_INDICATOR | VARCHAR2 | (1) | Yes | D C Indicator |
END_BAL_IND | VARCHAR2 | (1) | End Bal Ind | |
EXCH_NON_EXCH | VARCHAR2 | (1) | Exch Non Exch | |
FED_NON_FED | VARCHAR2 | (1) | Fed Non Fed | |
FISCAL_YEAR | NUMBER | (4) | Yes | Fiscal Year |
FUND_VALUE | VARCHAR2 | (30) | Yes | Fund Value |
RECIPIENT_NAME | VARCHAR2 | (120) | Recipient Name | |
RECORD_CATEGORY | VARCHAR2 | (25) | Record Category | |
REPORTED_STATUS | VARCHAR2 | (1) | Reported Status | |
SET_OF_BOOKS_ID | NUMBER | Yes | Set of Books Id | |
TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | Trading Partner Agency Id | |
TRADING_PARTNER_MAIN_ACCOUNT | VARCHAR2 | (4) | Trading Partner Main Account | |
USSGL_ACCOUNT | VARCHAR2 | (6) | Ussgl Account | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
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;
FV.FV_GTAS_ENDING_BALANCES does not reference any database object
FV.FV_GTAS_ENDING_BALANCES is referenced by following:
|
|
|