CustomerInformationLineItem

Entity Definition

Logical Name : CustomerInformationLineItem
Physical Name : TR_LTM_CT_INF

A retail transaction line item component that captures different kinds of customer information required to fulfill a retail transaction. Examples include customer address, customer account, delivery directions, special handling instructions and so on.

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
TypeCode Defines the type of customer information captured in this line item instance. Valid examples include: Customer Name, Customer Address, Delivery Address, Customer Account, and Special Handling Instructions. TY_INF_CT Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerInformationLineItem is composed of CustomerInformationLineModifier
RetailTransactionLineItem can be a CustomerInformationLineItem

Logical Views containing CustomerInformationLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 07200 - Customer Purchase Transaction History View