Entity Definition

Logical Name : GiftRegistryLineItemAssociation
Physical Name : AS_LTM_GF_RGST

A linkage of Items in a GiftRegistry that have been purchased.

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)
GiftRegistryID (FK)(PK) A unique system assigned identifier for this particular CustomerGiftRegistry. ID_RGST_CT_GF Identity integer GiftRegistryLineItem(AS_ITM_GF_RGST)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) GiftRegistryLineItem(AS_ITM_GF_RGST)
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
Quantity The number of items purchased for the GiftRegistration on this line item. QU_LTM_GF_RGST Quantity DECIMAL(9,3)


Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines GiftRegistryLineItemAssociation
GiftRegistryLineItem is satisfied by GiftRegistryLineItemAssociation
SaleReturnLineItem is intended for GiftRegistryLineItemAssociation

Logical Views containing GiftRegistryLineItemAssociation

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View