ISO4217-CurrencyType

Entity Definition

Logical Name : ISO4217-CurrencyType
Physical Name : LU_CNY_ISO_4217

Reference list of currency using ISO 4217 standard 3 character and 3 digit abbreviations.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ISOCurrencyCode (PK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3)
ISOCurrencyNumber (AK) Numeric code assigned by ISO to identify national currencies CD_CNY_ISO_4217_NBR ISO_4217_CurrencyCodeNumber(3) char(3)
ISOCurrencyName ISO designated currency name NM_CNY Name varchar(40)
ISOCountryCode (FK) The ISO-3166-1 two letter code denoting a locality in which the retailer does business. CD_CY_ISO Code2 char(2) ISO3166-1Country(LO_CY_ISO)
RetailerAssignedCurrencyTypeCode (AK) Retailer assigned currency code that may be used as an alternate key. CD_CY_RTLR_TYP Code varchar(20)
Symbol National symbol for the main unit of currency, e.g. �, $, etc SY_CNY Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
ISO3166-1Country issues ISO4217-CurrencyType
ISO4217-CurrencyType is used in TenderAuthorization
ISO4217-CurrencyType is monetary unit of Measurement
ISO4217-CurrencyType is used in CustomerOrder
ISO4217-CurrencyType is used in Nozzle
ISO4217-CurrencyType is used in TenderAuthorizationReversal
ISO4217-CurrencyType is used in AnnualIncomeRange
ISO4217-CurrencyType local currency assigned to BusinessUnit
ISO4217-CurrencyType defines money units for Tender
ISO4217-CurrencyType is used in RetailTransaction
ISO4217-CurrencyType defines nationay currency of StoredValueInstrument
ISO4217-CurrencyType is used in InventoryControlDocument
ISO4217-CurrencyType defines curency for RebateProgram
ISO4217-CurrencyType exchange from ExchangeRate
ISO4217-CurrencyType is available in Denomination
ISO4217-CurrencyType exchange to ExchangeRate

Logical Views containing ISO4217-CurrencyType

Logical View
Logical 01000 - Item Description - Macro View
Logical 01500 - Item Supplier View
Logical 02120 - Item Inventory - Order View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 03160 - Reporting - Store Operations - Till View
Logical 10104 - Enterprise Currency