Entity Definition

Logical Name : RetailTransactionRestrictionValidation

A place to capture a customer's response to a question posed as part of enforcing a retailer's sales restriction rules. An example is the customer's answer when asked his/her age before selling cigarettes or alcoholic beverages. The question is triggered by a specific line item in customer transaction, but it is asked one time within the context of 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) RetailTransaction(TR_RTL)
QuestionID (FK)(PK) A unique identifer for the restriction validation question. ID_QST_RST_VLD Identity integer RestrictionValidationQuestion(CO_VLD_RST_QST)
CustomerResponse A text note that captures the customer's response to a sales restriction question. DE_CT_RSPS DescriptionShort VARCHAR(255)


Parent Entity Verb Phrase Child Entity
RetailTransaction is subject to RetailTransactionRestrictionValidation
RestrictionValidationQuestion applies to RetailTransactionRestrictionValidation
RetailTransactionRestrictionValidation validates compliance of RetailTransactionRestrictionValidationResult

Logical Views containing RetailTransactionRestrictionValidation

Logical View
Logical 02350 - Retail Transaction - Restriction Validation View