Entity Definition

Logical Name : ItemProcessingTransaction
Physical Name : TR_ITM_PRCS

A type of transaction that records the processing applied to an item. Examples include rewrapping items, producing new items, aggregating items from other items and item lots, etc. This transaction supports traceability of items from receipt from a supplier to retailing to a customer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
ItemProcessTypeCode (FK) Three/four character lookup code TY_ITM_PCS Code4 CHAR(4) ItemProcessType(LY_ITM_PRC_TY)
LocationID (FK) A unique system assigned identifier for the Location. ID_LCN Identity integer Location(LO_LCN)


Parent Entity Verb Phrase Child Entity
ItemProcessType categorizes ItemProcessingTransaction
Location is location of ItemProcessingTransaction
ItemProcessingTransaction uses ItemProcessingEquipment
ItemProcessingTransaction contains ItemProcessingLineItem
ItemProcessingTransaction uses ItemProcessingWorker
Transaction can be a ItemProcessingTransaction

Logical Views containing ItemProcessingTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 21000 - Fresh Item Management Macro View