[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS1_PERIOD_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Table used by GTAS Processes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_GTAS1_PERIOD_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CCID
PERIOD_YEAR SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
ACCOUNT_TYPE | VARCHAR2 | (1) | Account Type | |
APPOR_CAT_B_CODE | VARCHAR2 | (4) | Appor Cat B Code | |
APPOR_CAT_CODE | VARCHAR2 | (1) | Appor Cat Code | |
BALANCE_AMOUNT | NUMBER | Yes | Balance Amount | |
BEA_CAT_CODE | VARCHAR2 | (1) | BEA Cat Code | |
BEGIN_BALANCE | NUMBER | (22) | Begin Balance | |
BORR_SRC_CODE | VARCHAR2 | (1) | Borr src Code | |
CCID | NUMBER | (15) | Yes | Ccid |
CREDIT_COHORT_YR | VARCHAR2 | (150) | Credit Cohort Yr | |
CUR_SUBSEQUENT_CODE | VARCHAR2 | (1) | Cur Subsequent Code | |
CUST_NON_CUST | VARCHAR2 | (1) | Cust Non Cust | |
DIRECT_OR_REIMB_CODE | VARCHAR2 | (1) | Direct or Reimb Code | |
END_BAL_IND | VARCHAR2 | (1) | End Bal Ind | |
EXCH_NON_EXCH | VARCHAR2 | (1) | Exch Non Exch | |
FUND_VALUE | VARCHAR2 | (30) | Fund Value | |
NEW_BAL_CODE | VARCHAR2 | (3) | New Bal Code | |
NEW_REC_FLAG | VARCHAR2 | (1) | New Rec Flag | |
PERIOD_BEGIN_BAL | NUMBER | (22) | Period Begin Bal | |
PERIOD_CY_CR_BAL | NUMBER | (22) | Period cy Cr Bal | |
PERIOD_CY_DR_BAL | NUMBER | Period cy Dr Bal | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name |
PERIOD_YEAR | NUMBER | (15) | Yes | Period Year |
PROGRAM_COST_IND | VARCHAR2 | (4) | Program Cost Ind | |
PROGRAM_REPT_CODE | VARCHAR2 | (4) | Program Rept Code | |
PYA_CODE | VARCHAR2 | (1) | PYA Code | |
REPORTED_GROUP | VARCHAR2 | (1) | Reported Group | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books Id |
TREASURY_SYMBOL_ID | NUMBER | (15) | Treasury Symbol Id | |
USSGL_ACCOUNT | VARCHAR2 | (6) | Ussgl Account | |
PERIOD_NUM | NUMBER | (15) | Yes | Period Num |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NUMBER
, ACCOUNT_TYPE
, APPOR_CAT_B_CODE
, APPOR_CAT_CODE
, BALANCE_AMOUNT
, BEA_CAT_CODE
, BEGIN_BALANCE
, BORR_SRC_CODE
, CCID
, CREDIT_COHORT_YR
, CUR_SUBSEQUENT_CODE
, CUST_NON_CUST
, DIRECT_OR_REIMB_CODE
, END_BAL_IND
, EXCH_NON_EXCH
, FUND_VALUE
, NEW_BAL_CODE
, NEW_REC_FLAG
, PERIOD_BEGIN_BAL
, PERIOD_CY_CR_BAL
, PERIOD_CY_DR_BAL
, PERIOD_NAME
, PERIOD_YEAR
, PROGRAM_COST_IND
, PROGRAM_REPT_CODE
, PYA_CODE
, REPORTED_GROUP
, SET_OF_BOOKS_ID
, TREASURY_SYMBOL_ID
, USSGL_ACCOUNT
, PERIOD_NUM
FROM FV.FV_GTAS1_PERIOD_ATTRIBUTES;
FV.FV_GTAS1_PERIOD_ATTRIBUTES does not reference any database object
FV.FV_GTAS1_PERIOD_ATTRIBUTES is referenced by following:
|
|
|