[Home] [Help] [Dependency Information]
Object Name: | EDW_CURR_CURRENCY_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_CURR_CURRENCY_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the currency level. Before currency information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_CURR_CURRENCY_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | CURRENCY_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the currency dimension | ||
DERIVE_FACTOR | NUMBER | Multiple applied to the base currency to derive this currency. Only used for the derived currency in a relationship. | ||
EXT_PRECISION | NUMBER | Extended precision of the currency | ||
MIN_ACCOUNT_UNIT | NUMBER | Minimum accountable unit for the currency | ||
PRECISION | NUMBER | Maximum number of digits to the right of decimal point | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the currency dimension | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
CURRENCY | VARCHAR2 | (2000) | Currency code | |
CURRENCY_FLAG | VARCHAR2 | (20) | Flag to indicate if the currency is a statistical unit or a currency | |
CURRENCY_PK | VARCHAR2 | (20) | The unique identifier for currency | |
DERIVE_TYPE | VARCHAR2 | (20) | Indicates whether the currency has a special relationship with other currencies. Currently,only EURO (Euro currency), EMU (European Monetary Union currency), and NULL (no specialrelationship) are possible values. | |
DESCRIPTION | VARCHAR2 | (240) | Currency description | |
ENABLED_FLAG | VARCHAR2 | (20) | Enabled Flag | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
ISO_FLAG | VARCHAR2 | (20) | Flag to indicate whether or not the currency is defined in ISO-4217 | |
NAME | VARCHAR2 | (2000) | Currency Name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used during warehouse collection | |
ROW_ID | ROWID | (10) | User defined attribute | |
SYMBOL | VARCHAR2 | (20) | The symbol denoting the currency | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
DATE_EFFECTIVE | DATE | The date when the currency code becomes active | ||
DATE_END | DATE | The date when currency code expires | ||
DELETION_DATE | DATE | Deletion date of the record | ||
DERIVE_EFFT_DATE | DATE | The date from which this currency's value becomes derived from the related currency. If thisvalue is null or later than the computation date, then the other derive_ columns are undefined. |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_FK_KEY
, DERIVE_FACTOR
, EXT_PRECISION
, MIN_ACCOUNT_UNIT
, PRECISION
, REQUEST_ID
, ALL_FK
, COLLECTION_STATUS
, CURRENCY
, CURRENCY_FLAG
, CURRENCY_PK
, DERIVE_TYPE
, DESCRIPTION
, ENABLED_FLAG
, ERROR_CODE
, INSTANCE
, ISO_FLAG
, NAME
, OPERATION_CODE
, ROW_ID
, SYMBOL
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, DATE_EFFECTIVE
, DATE_END
, DELETION_DATE
, DERIVE_EFFT_DATE
FROM FII.EDW_CURR_CURRENCY_LSTG;
FII.EDW_CURR_CURRENCY_LSTG does not reference any database object
FII.EDW_CURR_CURRENCY_LSTG is referenced by following:
|
|
|