Entity Definition

Logical Name : SaleReturnItemModification
Physical Name : TR_LTM_SLS_MDFN

SaleReturnItemModification entity type identifies, defines and describes a change to a sale/return item made at the time the retail transaction is created. The change may be a supplementary instruction prescribing how an item is to be altered in form, fit or function or, for aggregate items, components to be added or omitted, or other kinds of changes appropriate to an item. It may also list the individual items that make up an aggregate item for presentation on a sales receipt.

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)
SaleReturnModificationSequenceNumber (PK) The sequence number for this SaleReturnInstruction allowing more than instruction to be attached to each retail transaction line item. AI_MDFN LineNumber smallint
AdjustmentCode A mnemonic code denoting what kind of adjustment is being made to the Item being sold. e.g. Add, Remove, Alter,List Components CD_ADJT Code2 char(2)
UnitOfMeasureCode (FK) The code used to specify the units which apply to the Quantity attribute. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
ModificationQuantity The number of Item's being added or withheld from the AggregateItem being sold. QU_MDFN Quantity DECIMAL(9,3)
ItemID (FK) A unique system assigned identifier for the Item that is being removed from the AggregateItem being sold. ID_ITM IdentityUUID char(32) Item(AS_ITM)
AdjustmentDescription A narrative describing the required modification. e.g. Hold the Pickle, Cuffs on Trousers etc... DE_ADJT DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines SaleReturnItemModification
Item applies to SaleReturnItemModification
SaleReturnLineItem includes SaleReturnItemModification

Logical Views containing SaleReturnItemModification

Logical View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02360 - Retail Transaction - Food Service View
Logical 07040 - Customer Segment Dependent Behavior
Logical 10400 - Enterprise - Channels
Logical 21000 - Fresh Item Management Macro View