VoidsLineItem

Entity Definition

Logical Name : VoidsLineItem
Physical Name : TR_LTM_VD

A sub-type of RetailTransactionLineItem that records the removal of one or more of the items recorded in another RetailTransactionLineItem in the same RetailTransaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransactionLineItem(TR_LTM_RTL_TRN)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
VoidsLineItemSequenceNumber (FK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM_VD LineNumber smallint RetailTransactionLineItem(TR_LTM_RTL_TRN)
ReasonCode (FK) A unique retailer defined reason code for the VoidsLineItem. CD_RSN Code varchar(20) Reason(CO_CD_RSN)
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
VoidQuantity The number of Items within the line item that are being voided. e.g. Original line item is selling 3 x Item, VoidsLineItem voids 2 of them - leaving one still being sold. QU_VD Quantity DECIMAL(9,3)
VoidUnits The number of units voided. Eg: A sale of 20 Gallons of Gas: Quantity=20, Units=1, UnitOfMeasure=Ga Eg: A sale of 3 cans of Beans: Quantity=3, Units=3, UnitOfMeasure=Ea UN_VD QuantityShortCount decimal(3,0)
VoidAmount The monetary value of the Items being voided from the transaction. MO_VD MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
RetailTransactionLineItem effects VoidsLineItem
UnitOfMeasure defines counting units VoidsLineItem
Reason classifies VoidsLineItem
RetailTransactionLineItem can be a VoidsLineItem

Logical Views containing VoidsLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02312 - Retail Transaction - Item Voids View
Logical 02440 - Control Transaction - Voids View