MiscellaneousFeeLineItem

Entity Definition

Logical Name : MiscellaneousFeeLineItem
Physical Name : TR_LTM_MSC_FE

A line item component of a RETAIL TRANSACTION that records a fee added to the transaction net total and reflects a non-item income or reimbursable expense to the retailer.

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
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) MiscellaneousFee(TR_FE_MSC)
Amount The amount of the miscellaneous fee to be booked. MO_FE_MSC Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
MiscellaneousFee validates MiscellaneousFeeLineItem
RetailTransactionLineItem can be a MiscellaneousFeeLineItem

Logical Views containing MiscellaneousFeeLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 04100 - Financial Ledger - Retail Transaction View