RoundingLineItem

Entity Definition

Logical Name : RoundingLineItem
Physical Name : TR_LTM_RND

A line item component of a RetailTransaction that records the Adjustment of the Transaction Total to match the available Denominations of the Currency being used to tender the transaction. e.g. In New Zealand round up or down to nearest 10c, when Cash is being tendered.

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)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
RoundUpFlag A flag denoting that the TransactionTotal was rounded up by the given Amount so that it matched the available Denominations of the Currency being tendered. FL_RND_UP Flag integer
Amount The amount by which the TransactionTotal was rounded so that it matched the available Denominations of the Currency being tendered. MO_RND MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
RetailTransactionLineItem can be a RoundingLineItem

Logical Views containing RoundingLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View