Entity Definition

Logical Name : ItemCountryOrigin
Physical Name : CO_ITM_CY_ORG

A cross refrence of country of origin types to items. This supports the tracking of a variety of origin types (packaged in, product of, produced in) for an item or inventory item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemCountryOriginID (PK) A token used to identify an object, represented as an Integer. ID_CY_ORG Identity integer
CountryOriginTypeCode (FK) A code that identifies the country of origin. The ISO country code standard is recommended as the value list for this attribute type. CD_CY_ORG ISOCountryCode CHAR(3) CountryOriginRoleType(LU_CY_ORG_RO_TY)
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)
ItemTraceableUnitID (FK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_ITM_UN_TRC IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)


Parent Entity Verb Phrase Child Entity
CountryOriginRoleType describes ItemCountryOrigin
ItemTraceableUnit has and origin of ItemCountryOrigin
ISO3166-1Country is origin for ItemCountryOrigin

Logical Views containing ItemCountryOrigin

Logical View
Logical 21000 - Fresh Item Management Macro View