Entity Definition

Logical Name : WriteoffLineItem
Physical Name : TR_LTM_WRF_TRN

A type of retail line item used off-set a sales credit when a normal tender debit (such as cash, credit card, debit card, check, electronic benefit transfer, WIC check, etc.) is unavailable or insufficient to settle a transaction. Within the context of a transaction, a write off represents a loss to the retailer. For example, a fuel transaction that involves a drive off will result in a write off line item to settle the transaction.

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
WriteoffAmount The monetary value of the write off line item. MO_WRF_AMT Money DECIMAL(16,5)
WriteoffAccountNumber The account number used to classify the write off amount. Retailers will designate a range of accounts to address debits for drive off expenses, shop lifting, damaged merchandise and other merchandise losses that are not offset with tender or a recievable of some kind. ID_WRF_ACNT_NMB IdentityAlphaNumeric VARCHAR(20)
WriteoffReasonCode A code that designates a retailer defined standard explanation for creating a write off retail transaction line item. RC_WRF_CD Code4 CHAR(4)


Parent Entity Verb Phrase Child Entity
RetailTransactionLineItem can be a WriteoffLineItem

Logical Views containing WriteoffLineItem

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