Entity Definition

Logical Name : FoodServiceTransaction
Physical Name : TR_FD_SV

A sub-type of RetailTransaction specifically for the FoodService segment of the retail industry. Which can be used to record TableNumber, PartySize, Servers, etc...

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)
ServerID (FK) A unique system assigned identifier for the Server. ID_SRV Identity integer Server(PA_SRV)
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)
PartySize The number of people served at the table during the food service transaction. QU_SZ_PRTY QuantityShortCount decimal(3,0)
ProcessModeCode Instructions the Kitchen to expedite the transaction. CD_PCS Code varchar(20)


Parent Entity Verb Phrase Child Entity
Table was location for FoodServiceTransaction
Server Served FoodServiceTransaction
RetailTransaction can be a FoodServiceTransaction

Logical Views containing FoodServiceTransaction

Logical View
Logical 02200 - Transaction Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02360 - Retail Transaction - Food Service View