Entity Definition

Logical Name : CustomerInformationLineModifier
Physical Name : CO_MDFR_CT_INF_LN

Provides a specific data element level description and value for customer information line item. This modifier provides a flexible, dictionary driven method for specifying the kind of data captured about a customer.

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) CustomerInformationLineItem(TR_LTM_CT_INF)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint CustomerInformationLineItem(TR_LTM_CT_INF)
CustomerInformationModifierSequenceNumber (PK) A sequential number designed to uniquely identify each modifier for a CUSTOMER INFORMATION LINE item. AI_MDFR LineNumber smallint
DataElementID A dictionary data element identity assigned by each retailer for the type of data they want to collect as part of their CUSTOMER INFORMATION LINE. ID_ELM_DAT Identity integer
DataElementValue The value entered for a data element in a CUSTOMER INFORMATION LINE MODIFIER. MO_ELM_DAT_VL Money decimal(16,5)
DataElementFormatCode Defines how the value of a data element is to be internally represented. Valid examples include TEXT, MONEY, LOGICAL (yes/no), COUNT (integer), FLOAT. LU_FRMT_DAT_ELM Code2 char(2)


Parent Entity Verb Phrase Child Entity
CustomerInformationLineItem is composed of CustomerInformationLineModifier

Logical Views containing CustomerInformationLineModifier

Logical View
Logical 07200 - Customer Purchase Transaction History View