Entity Definition

Logical Name : SupplierItemCountryOrigin
Physical Name : CO_SPR_ITM_CY_ORG

A cross reference of supplier items to country of origin types.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SupplierID (FK)(PK) A unique system assigned identifier for the Supplier. ID_SPR Identity integer SupplierItem(AS_ITM_SPR)
SupplierItemID (FK)(PK) The code assigned by the supplier to uniquely identify the ITEM ID_ITM_SPR Identity integer SupplierItem(AS_ITM_SPR)
CountryOriginTypeCode (FK)(PK) 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)


Parent Entity Verb Phrase Child Entity
CountryOriginRoleType defines role of SupplierItemCountryOrigin
SupplierItem comes from SupplierItemCountryOrigin
ISO3166-1Country is origin of SupplierItemCountryOrigin

Logical Views containing SupplierItemCountryOrigin

Logical View
Logical 01500 - Item Supplier View
Logical 21000 - Fresh Item Management Macro View