[Home] [Help] [Dependency Information]
Object Name: | GL_HISTORICAL_RATES# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | Yes | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_NUM | NUMBER | (15) | Yes | |
PERIOD_YEAR | NUMBER | (15) | Yes | |
CODE_COMBINATION_ID | NUMBER | Yes | ||
TARGET_CURRENCY | VARCHAR2 | (15) | Yes | |
UPDATE_FLAG | VARCHAR2 | (1) | Yes | |
USAGE_CODE | VARCHAR2 | (1) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RATE_TYPE | VARCHAR2 | (1) | ||
TRANSLATED_RATE | NUMBER | |||
TRANSLATED_AMOUNT | NUMBER | |||
ACCOUNT_TYPE | VARCHAR2 | (1) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
CONTEXT | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, PERIOD_NAME
, PERIOD_NUM
, PERIOD_YEAR
, CODE_COMBINATION_ID
, TARGET_CURRENCY
, UPDATE_FLAG
, USAGE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RATE_TYPE
, TRANSLATED_RATE
, TRANSLATED_AMOUNT
, ACCOUNT_TYPE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, CONTEXT
FROM GL.GL_HISTORICAL_RATES#;
|
|
|