Skip to content

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

TABLE: ABM.ABM_CURRS

Object Details
Object Name: ABM_CURRS
Object Type: TABLE
Owner: ABM
Subobject Name:
Status: VALID


Any form of monetary exchange in a country
EXAMPLES
US Dollars
Canadian Dollars


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: ABM_CURRS_PK
  1. ColumnI03_CURRENCY_ID
Indexes
Index Type Uniqueness Tablespace Column
ABM_CURRS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnI03_CURRENCY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableABM_MDLS ABM_MDLS_FK1 ABM_CURRS ABM_MDLS I03_CURRENCY_ID
Columns
Name Datatype Length Mandatory Comments
I03_CURRENCY_ID VARCHAR2 (15) Yes Currency ID
I03_NAME VARCHAR2 (100) Yes Currency Name
I03_COUNTRY VARCHAR2 (250) Yes Country to which the currency belongs
DESCRIPTION_TEXT VARCHAR2 (750)
Currency Description
MAINT_USER_ID VARCHAR2 (11)
Legacy column. No longer used in ABM 11i.
MAINT_EFFECT_CODE VARCHAR2 (1)
Legacy column. No longer used in ABM 11i.
MAINT_TIMESTAMP DATE

Legacy column. No longer used in ABM 11i.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ENABLED_FLAG VARCHAR2 (1)
Currency is Enabled or Not
CURRENCY_FLAG VARCHAR2 (1)
Currency Flag
ISSUING_TERRITORY_CODE VARCHAR2 (2)
Zip Code of the Issuing Territory
PRECISION NUMBER

Precision Value of the Currency
EXTENDED_PRECISION NUMBER

Extended Precision Value of the Currency
SYMBOL VARCHAR2 (4)
Symbol for the Currency
START_DATE_ACTIVE DATE

Date from which this currency becomes active
END_DATE_ACTIVE DATE

Date from which this currency stops being active
MINIMUM_ACCOUNTABLE_UNIT NUMBER

Minimum Accountable Unit
CONTEXT VARCHAR2 (80)
Currency Context
ISO_FLAG VARCHAR2 (1)
ISO Flag
ATTRIBUTE1 VARCHAR2 (150)
Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global Attribute Category
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global Attribute 1
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global Attribute 2
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global Attribute 3
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global Attribute 4
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global Attribute 5
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global Attribute 6
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global Attribute 7
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global Attribute 8
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global Attribute 9
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global Attribute 10
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global Attribute 11
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global Attribute 12
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global Attribute 13
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global Attribute 14
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global Attribute 15
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global Attribute 16
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global Attribute 17
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global Attribute 18
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global Attribute 19
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global Attribute 20
DERIVE_EFFECTIVE DATE

Derive Effective
DERIVE_TYPE VARCHAR2 (8)
Derive Type
DERIVE_FACTOR NUMBER

Derive Factor
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT I03_CURRENCY_ID
,      I03_NAME
,      I03_COUNTRY
,      DESCRIPTION_TEXT
,      MAINT_USER_ID
,      MAINT_EFFECT_CODE
,      MAINT_TIMESTAMP
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      CURRENCY_FLAG
,      ISSUING_TERRITORY_CODE
,      PRECISION
,      EXTENDED_PRECISION
,      SYMBOL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      MINIMUM_ACCOUNTABLE_UNIT
,      CONTEXT
,      ISO_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      DERIVE_EFFECTIVE
,      DERIVE_TYPE
,      DERIVE_FACTOR
FROM ABM.ABM_CURRS;

Dependencies

[top of page]

ABM.ABM_CURRS does not reference any database object

ABM.ABM_CURRS is not referenced by any database object