Entity Definition

Logical Name : RestrictionValidationModifier
Physical Name : CO_VLD_RST

A modifier to a SaleReturnLineItem denoting how a particular SalesRestriction was validated. Eg: In some jurisdictions it is a legal requirement to record the Customer's fire-arms license number in order to sell ammunition.

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) SaleReturnLineItem(TR_LTM_SLS_RTN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
QuestionID (FK) A unique identifer for the restriction validation question. ID_QST_RST_VLD Identity integer RestrictionValidationQuestion(CO_VLD_RST_QST)
AddressID (FK) A unique system allocated identifier for the Address. ID_ADS Identity integer Address(LO_ADS)
Answer The answer given by the customer to the given question. NA_ANS DescriptionShort varchar(255)
EntryMethod A code to denote how the answer to the RestrictionValidationQuestion was entered at the Workstation. Example values include: Keyed, Barcode, MICR, MSR, SmartCard. CD_MTH_ENR Code4 char(4)


Parent Entity Verb Phrase Child Entity
SaleReturnLineItem used RestrictionValidationModifier
RestrictionValidationQuestion was used by RestrictionValidationModifier
Address was supplied or used as RestrictionValidationModifier

Logical Views containing RestrictionValidationModifier

Logical View
Logical 02350 - Retail Transaction - Restriction Validation View