[Home] [Help] [Dependency Information]
Object Name: | FV_FACTSI_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_FACTSI_TEMP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | Yes | Set of books identifier | |
CCID | NUMBER | (15) | Yes | Code combination ID |
TREASURY_SYMBOL_ID | NUMBER | (15) | Yes | Treasury Symbol ID |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
DOCUMENT_SOURCE | VARCHAR2 | (80) | Document Source | |
DOCUMENT_NUMBER | VARCHAR2 | (240) | Document Number | |
TRANSACTION_DATE | DATE | Transaction Date | ||
CREATION_DATE_TIME | DATE | Journal Creation Date Time | ||
ENTRY_USER | VARCHAR2 | (100) | User name of the user who created the journal | |
FED_NON_FED | VARCHAR2 | (1) | Federal/Non-Federal Attribute | |
TRADING_PARTNER | VARCHAR2 | (2) | Trading Partner | |
EXCH_NON_EXCH | VARCHAR2 | (1) | Exchage/Non-Exchange Attribute | |
CUST_NON_CUST | VARCHAR2 | (1) | Custodial/Non-Custodial Attribute | |
BUDGET_SUBFUNCTION | VARCHAR2 | (3) | Budget Subfunction Attribute | |
FUND_VALUE | VARCHAR2 | (30) | Fund Value/Balancing segment | |
DEBIT | NUMBER | Entered Debit | ||
CREDIT | NUMBER | Entered credit |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, CCID
, TREASURY_SYMBOL_ID
, ACCOUNT_NUMBER
, DOCUMENT_SOURCE
, DOCUMENT_NUMBER
, TRANSACTION_DATE
, CREATION_DATE_TIME
, ENTRY_USER
, FED_NON_FED
, TRADING_PARTNER
, EXCH_NON_EXCH
, CUST_NON_CUST
, BUDGET_SUBFUNCTION
, FUND_VALUE
, DEBIT
, CREDIT
FROM FV.FV_FACTSI_TEMP;
FV.FV_FACTSI_TEMP does not reference any database object
FV.FV_FACTSI_TEMP is referenced by following:
|
|
|