Entity Definition

Logical Name : Currency
Physical Name : CO_CNY

Specifies the national designation and quantitative value of monetary media used as tender in the processing of this TENDER LINE ITEM. This entity will be replaced by ISO4217CurrencyType. We need to review this entity's dependent relationships and repoint them to ISO4217CurrencyType before deleting it.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CurrencyID (PK) The unique identifier of the Currency. ID_CNY Identity integer
Description A description of the currency, i.e. pounds sterling, US dollars, Canadian dollars, etc. DE_CNY DescriptionShort varchar(255)
Symbol National symbol for the main unit of currency, e.g. , $, etc SY_CNY Name varchar(40)
ISO4217CurrencyCode (AK) ISO 4217 standard world wide currency code identifies national currenctyy. CD_ISO4217_CNY Code4 char(4)


Parent Entity Verb Phrase Child Entity
Currency may denominate InventoryControlDocument
Currency defines measure of AnnualIncomeRange
Currency applies to Nozzle
Currency local currency assigned to BusinessUnit

Logical Views containing Currency

Logical View
Logical 06310 - Party - Role View