DBA Data[Home] [Help] [Dependency Information]


VIEW: FV.FV_GTAS_TRX_REG_TEMP#

Object Details
Object Name: FV_GTAS_TRX_REG_TEMP#
Object Type: VIEW
Owner: FV
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

FV.FV_GTAS_TRX_REG_TEMP# references the following:

SchemaFV
TableFV_GTAS_TRX_REG_TEMP
FV.FV_GTAS_TRX_REG_TEMP# is referenced by following:

SchemaAPPS
SynonymFV_GTAS_TRX_REG_TEMP