Entity Definition

Logical Name : FoodServiceLineItem
Physical Name : TR_LTM_FD_SV

A sub-type of SaleReturnLineItem recording how the Item being sold is to be processed in the Food Services environment.

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
TableID (FK) A unique retailer assigned identifier for a particular table, at which Customers sit to eat food purchased in a FoodServiceTransaction. ID_TB Identity integer Table(LO_TB)
ProcessModeCode A mnemonic code denoting how this SaleReturnLineItem is to be processed in the kitchen. Example values include: Normal, Expedite, Delay. CD_PCS Code4 char(4)
DestinationTypeCode A mnemonic code denoting where the food is being served. e.g. Other, DineIn, ToGo, DriveThru, Pickup, Delivery, Patio, Catering, Garden. TY_DST Code4 char(4)
SalesMetricsCode A mnemonic code denoting the type of SalesMetrics that this line item may be applied to. e.g. Suggested, Normal. CD_SLS_MTC Code4 char(4)
DelayUntilDateTime The date and time this line item should be ready for pickup by or delivery to the Customer. DT_DLY_UNTL DateTime datetime


Parent Entity Verb Phrase Child Entity
Table was location for FoodServiceLineItem
SaleReturnLineItem can be a FoodServiceLineItem

Logical Views containing FoodServiceLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02360 - Retail Transaction - Food Service View