Entity Definition

Logical Name : SerializedUnitModifier
Physical Name : CO_MDFR_SRZ

A record of the serial number of some item that is related to a particular SaleItem. Eg: Sale of camera & service contract may result in two SaleReturnLineItems each with an instance of SerializedUnitSaleModeifier - one for the camera and one for the related service contract

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) SaleReturnLineItem(TR_LTM_SLS_RTN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) SerializedUnit(AS_UN_SRZ)
SerialNumber (FK) A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual instance of an ITEM. ID_NMB_SRZ Name varchar(40) SerializedUnit(AS_UN_SRZ)
TypeCode A code denoting if this is a sale, rental or sale of a related item (eg: Service Contract) TY_SRZ Code2 char(2)


Parent Entity Verb Phrase Child Entity
SaleReturnLineItem refers to SerializedUnitModifier
SerializedUnit sells SerializedUnitModifier

Logical Views containing SerializedUnitModifier

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02370 - Retail Transaction - Rental View
Logical 21000 - Fresh Item Management Macro View