[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS1_PERIOD_BALANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains records for GTAS processing
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CCID | NUMBER | (15) | Ccid | |
SET_OF_BOOKS_ID | NUMBER | (15) | Set Of Books Id | |
PERIOD_YEAR | NUMBER | (15) | Period Year | |
PERIOD_NUM | NUMBER | (15) | Period Num | |
PERIOD_NAME | VARCHAR2 | (15) | Period Name | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Account Number | |
FUND_VALUE | VARCHAR2 | (30) | Fund Value | |
REPORTED_STATUS | CHAR | (1) | Reported Status | |
USSGL_ACCOUNT | VARCHAR2 | (6) | Ussgl Account | |
EXCH_NON_EXCH | VARCHAR2 | (1) | Exch Non Exch | |
CUST_NON_CUST | VARCHAR2 | (1) | Cust Non Cust | |
ACCOUNT_TYPE | VARCHAR2 | (1) | Account Type | |
AMOUNT | NUMBER | Amount | ||
BEGINNING_BALANCE | NUMBER | Beginning Balance | ||
PERIOD_DR | NUMBER | Period Dr | ||
PERIOD_CR | NUMBER | Period Cr | ||
PERIOD_BEGIN_BAL | NUMBER | Period Begin Bal | ||
D_C_INDICATOR | VARCHAR2 | (1) | D C Indicator | |
BALANCE_TYPE | CHAR | (1) | Balance Type | |
DIRECT_OR_REIMB_CODE | VARCHAR2 | (1) | Direct Or Reimb Code | |
APPOR_CAT_CODE | VARCHAR2 | (1) | Appor Cat Code | |
APPOR_CAT_B_CODE | VARCHAR2 | (4) | Appor Cat B Code | |
PROGRAM_REPT_CODE | VARCHAR2 | (4) | Program Rept Code | |
BEA_CAT_CODE | VARCHAR2 | (1) | Bea Cat Code | |
BORR_SRC_CODE | VARCHAR2 | (1) | Borr Src Code | |
NEW_BAL_CODE | VARCHAR2 | (3) | New Bal Code | |
CUR_SUBSEQUENT_CODE | VARCHAR2 | (1) | Cur Subsequent Code | |
PYA_CODE | VARCHAR2 | (1) | Pya Code | |
CREDIT_COHORT_YR | VARCHAR2 | (150) | Credit Cohort Yr | |
PROGRAM_COST_IND | VARCHAR2 | (4) | Program Cost Ind | |
TREASURY_SYMBOL_ID | NUMBER | (15) | Treasury Symbol Id | |
BUDGET_IMPACT_IND | VARCHAR2 | (1) | Budget Impact Ind | |
AUTHORITY_TYPE_CODE | VARCHAR2 | (1) | Authority Type Code | |
FED_NON_FED | VARCHAR2 | (1) | Fed Non Fed | |
TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | Trading Partner Agency Id | |
TRADING_PARTNER_MAIN_ACCOUNT | VARCHAR2 | (4) | Trading Partner Main Account | |
END_BAL_IND | VARCHAR2 | (1) | End Bal Ind | |
BEGIN_END | CHAR | (1) | Begin or End Balance |
Cut, paste (and edit) the following text to query this object:
SELECT CCID
, SET_OF_BOOKS_ID
, PERIOD_YEAR
, PERIOD_NUM
, PERIOD_NAME
, ACCOUNT_NUMBER
, FUND_VALUE
, REPORTED_STATUS
, USSGL_ACCOUNT
, EXCH_NON_EXCH
, CUST_NON_CUST
, ACCOUNT_TYPE
, AMOUNT
, BEGINNING_BALANCE
, PERIOD_DR
, PERIOD_CR
, PERIOD_BEGIN_BAL
, D_C_INDICATOR
, BALANCE_TYPE
, DIRECT_OR_REIMB_CODE
, APPOR_CAT_CODE
, APPOR_CAT_B_CODE
, PROGRAM_REPT_CODE
, BEA_CAT_CODE
, BORR_SRC_CODE
, NEW_BAL_CODE
, CUR_SUBSEQUENT_CODE
, PYA_CODE
, CREDIT_COHORT_YR
, PROGRAM_COST_IND
, TREASURY_SYMBOL_ID
, BUDGET_IMPACT_IND
, AUTHORITY_TYPE_CODE
, FED_NON_FED
, TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT
, END_BAL_IND
, BEGIN_END
FROM APPS.FV_GTAS1_PERIOD_BALANCES_V;
|
|
|