[Home] [Help] [Dependency Information]
Object Name: | FV_GTAS_TRX_REG_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | FV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | |
TREASURY_SYMBOL_ID | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
USSGL_ACCOUNT | VARCHAR2 | (6) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
EXCH_NON_EXCH | VARCHAR2 | (1) | ||
CUST_NON_CUST | VARCHAR2 | (1) | ||
FUND_VALUE | VARCHAR2 | (30) | Yes | |
DIRECT_OR_REIMB_CODE | VARCHAR2 | (1) | ||
APPOR_CAT_CODE | VARCHAR2 | (1) | ||
APPOR_CAT_B_CODE | VARCHAR2 | (4) | ||
PROGRAM_REPT_CODE | VARCHAR2 | (4) | ||
BEA_CAT_CODE | VARCHAR2 | (1) | ||
BORR_SRC_CODE | VARCHAR2 | (1) | ||
NEW_BAL_CODE | VARCHAR2 | (3) | ||
CUR_SUBSEQUENT_CODE | VARCHAR2 | (3) | ||
PYA_CODE | VARCHAR2 | (1) | ||
CREDIT_COHORT_YR | VARCHAR2 | (150) | ||
PROGRAM_COST_IND | VARCHAR2 | (4) | ||
BUDGET_IMPACT_IND | VARCHAR2 | (1) | ||
AUTHORITY_TYPE_CODE | VARCHAR2 | (1) | ||
FED_NON_FED | VARCHAR2 | (1) | ||
TRADING_PARTNER_AGENCY_ID | VARCHAR2 | (3) | ||
TRADING_PARTNER_MAIN_ACCOUNT | VARCHAR2 | (4) | ||
ENTRY_USER | VARCHAR2 | (100) | ||
JOURNAL_CREATION_DATE | DATE | |||
JOURNAL_MODIFIED_DATE | DATE | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
GL_DATE | DATE | |||
GL_POSTED_DATE | DATE | |||
DOCUMENT_CATEGORY | VARCHAR2 | (80) | ||
REVERSAL_FLAG | VARCHAR2 | (1) | ||
SLA_HDR_EVENT_ID | NUMBER | |||
SLA_HDR_CREATION_DATE | DATE | |||
SLA_ENTITY_ID | NUMBER | |||
DOCUMENT_NUMBER | VARCHAR2 | (240) | ||
DOCUMENT_DATE | DATE | |||
DOCUMENT_SOURCE | VARCHAR2 | (80) | ||
TRANSACTION_DATE | DATE | |||
CREATION_DATE_TIME | DATE | |||
ADVANCE_FLAG | VARCHAR2 | (1) | ||
TRANSFER_DEPT_ID | VARCHAR2 | (3) | ||
TRANSFER_MAIN_ACCT | VARCHAR2 | (4) | ||
YEAR_BUDGET_AUTH | VARCHAR2 | (3) | ||
PERIOD_ACTIVITY | NUMBER | |||
DEF_LIQUID_FLAG | VARCHAR2 | (1) | ||
DEFICIENCY_FLAG | VARCHAR2 | (1) | ||
AVAILABILITY_FLAG | VARCHAR2 | (1) | ||
LEGISLATION_FLAG | VARCHAR2 | (1) | ||
DEBIT | NUMBER | |||
CREDIT | NUMBER | |||
BEGIN_END | VARCHAR2 | (1) | ||
INDEF_DEF_FLAG | VARCHAR2 | (1) | ||
AUTHORITY_TYPE | VARCHAR2 | (1) | ||
TRANSACTION_PARTNER | VARCHAR2 | (1) | ||
REIMBURSEABLE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NUMBER
, TREASURY_SYMBOL_ID
, SET_OF_BOOKS_ID
, USSGL_ACCOUNT
, CODE_COMBINATION_ID
, EXCH_NON_EXCH
, CUST_NON_CUST
, FUND_VALUE
, 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
, BUDGET_IMPACT_IND
, AUTHORITY_TYPE_CODE
, FED_NON_FED
, TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT
, ENTRY_USER
, JOURNAL_CREATION_DATE
, JOURNAL_MODIFIED_DATE
, PERIOD_NAME
, GL_DATE
, GL_POSTED_DATE
, DOCUMENT_CATEGORY
, REVERSAL_FLAG
, SLA_HDR_EVENT_ID
, SLA_HDR_CREATION_DATE
, SLA_ENTITY_ID
, DOCUMENT_NUMBER
, DOCUMENT_DATE
, DOCUMENT_SOURCE
, TRANSACTION_DATE
, CREATION_DATE_TIME
, ADVANCE_FLAG
, TRANSFER_DEPT_ID
, TRANSFER_MAIN_ACCT
, YEAR_BUDGET_AUTH
, PERIOD_ACTIVITY
, DEF_LIQUID_FLAG
, DEFICIENCY_FLAG
, AVAILABILITY_FLAG
, LEGISLATION_FLAG
, DEBIT
, CREDIT
, BEGIN_END
, INDEF_DEF_FLAG
, AUTHORITY_TYPE
, TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG
FROM FV.FV_GTAS_TRX_REG_TEMP#;
|
|
|