Entity Definition

Logical Name : ItemProcessingEquipment
Physical Name : CO_ITM_PRCS_EQ

A cross reference of Equipment to ItemProcesses.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EquipmentID (FK)(PK) The fixed asset number assigned by the retailer for this particular piece of equipment. ID_EQ Identity integer Equipment(AS_EQ)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) ItemProcessingTransaction(TR_ITM_PRCS)


Parent Entity Verb Phrase Child Entity
ItemProcessingTransaction uses ItemProcessingEquipment
Equipment is used in ItemProcessingEquipment

Logical Views containing ItemProcessingEquipment

Logical View
Logical 21000 - Fresh Item Management Macro View