[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_GTAS_ATTRIBUTES# |
|---|---|
| Object Type: | VIEW |
| Owner: | FV |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| SGL_ATTRIBUTES_ID | NUMBER | (15) | Yes | |
| GTAS_ACCT_NUMBER | VARCHAR2 | (30) | Yes | |
| USSGL_ACCT_NUMBER | VARCHAR2 | (30) | ||
| BALANCE_TYPE | VARCHAR2 | (2) | Yes | |
| FED_NON_FED1 | VARCHAR2 | (1) | ||
| FED_NON_FED2 | VARCHAR2 | (1) | ||
| FED_NON_FED3 | VARCHAR2 | (1) | ||
| EXCH_NON_EXCH1 | VARCHAR2 | (1) | ||
| EXCH_NON_EXCH2 | VARCHAR2 | (1) | ||
| EXCH_NON_EXCH3 | VARCHAR2 | (1) | ||
| CUST_NON_CUST1 | VARCHAR2 | (1) | ||
| CUST_NON_CUST2 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE1 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE2 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE3 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE4 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE5 | VARCHAR2 | (1) | ||
| AUTHORITY_TYPE6 | VARCHAR2 | (1) | ||
| APPORTIONMENT_CATEGORY1 | VARCHAR2 | (1) | ||
| APPORTIONMENT_CATEGORY2 | VARCHAR2 | (1) | ||
| APPORTIONMENT_CATEGORY3 | VARCHAR2 | (1) | ||
| NEW_BAL_CODE1 | VARCHAR2 | (3) | ||
| NEW_BAL_CODE2 | VARCHAR2 | (3) | ||
| CUR_SUB_CODE1 | VARCHAR2 | (1) | ||
| CUR_SUB_CODE2 | VARCHAR2 | (1) | ||
| BEA_CATEGORY1 | VARCHAR2 | (1) | ||
| BEA_CATEGORY2 | VARCHAR2 | (1) | ||
| BEA_CATEGORY_ACCT_TYPE | VARCHAR2 | (1) | ||
| BORROWING_SOURCE1 | VARCHAR2 | (1) | ||
| BORROWING_SOURCE2 | VARCHAR2 | (1) | ||
| BORROWING_SOURCE3 | VARCHAR2 | (1) | ||
| PYA_CODE1 | VARCHAR2 | (1) | ||
| PYA_CODE2 | VARCHAR2 | (1) | ||
| PYA_CODE3 | VARCHAR2 | (1) | ||
| DIR_REIMB_CODE1 | VARCHAR2 | (1) | ||
| DIR_REIMB_CODE2 | VARCHAR2 | (1) | ||
| BUD_IMPACT_IND1 | VARCHAR2 | (1) | ||
| BUD_IMPACT_IND2 | VARCHAR2 | (1) | ||
| PROG_COST_IND1 | VARCHAR2 | (1) | ||
| PROG_COST_IND2 | VARCHAR2 | (1) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| DIRECT_OR_REIMB_FLAG | VARCHAR2 | (1) | ||
| APPOR_CAT_B_PROG_FLAG | VARCHAR2 | (1) | ||
| PROG_REP_CAT_FLAG | VARCHAR2 | (1) | ||
| BEA_CATEGORY_FLAG | VARCHAR2 | (1) | ||
| BORROWING_SOURCE_FLAG | VARCHAR2 | (1) | ||
| PROGRAM_COST_IND_FLAG | VARCHAR2 | (1) | ||
| NEW_OR_BAL_FLAG | VARCHAR2 | (1) | ||
| TRADING_PARTNER_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, SGL_ATTRIBUTES_ID
, GTAS_ACCT_NUMBER
, USSGL_ACCT_NUMBER
, BALANCE_TYPE
, FED_NON_FED1
, FED_NON_FED2
, FED_NON_FED3
, EXCH_NON_EXCH1
, EXCH_NON_EXCH2
, EXCH_NON_EXCH3
, CUST_NON_CUST1
, CUST_NON_CUST2
, AUTHORITY_TYPE1
, AUTHORITY_TYPE2
, AUTHORITY_TYPE3
, AUTHORITY_TYPE4
, AUTHORITY_TYPE5
, AUTHORITY_TYPE6
, APPORTIONMENT_CATEGORY1
, APPORTIONMENT_CATEGORY2
, APPORTIONMENT_CATEGORY3
, NEW_BAL_CODE1
, NEW_BAL_CODE2
, CUR_SUB_CODE1
, CUR_SUB_CODE2
, BEA_CATEGORY1
, BEA_CATEGORY2
, BEA_CATEGORY_ACCT_TYPE
, BORROWING_SOURCE1
, BORROWING_SOURCE2
, BORROWING_SOURCE3
, PYA_CODE1
, PYA_CODE2
, PYA_CODE3
, DIR_REIMB_CODE1
, DIR_REIMB_CODE2
, BUD_IMPACT_IND1
, BUD_IMPACT_IND2
, PROG_COST_IND1
, PROG_COST_IND2
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, DIRECT_OR_REIMB_FLAG
, APPOR_CAT_B_PROG_FLAG
, PROG_REP_CAT_FLAG
, BEA_CATEGORY_FLAG
, BORROWING_SOURCE_FLAG
, PROGRAM_COST_IND_FLAG
, NEW_OR_BAL_FLAG
, TRADING_PARTNER_FLAG
FROM FV.FV_GTAS_ATTRIBUTES#;
FV
FV_GTAS_ATTRIBUTES
APPS
FV_GTAS_ATTRIBUTES
|
|
|
|