Entity Definition

Logical Name : GiftRegistryLineItem
Physical Name : AS_ITM_GF_RGST

A customer's selection of an item for inclusion in his or her gift registry.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GiftRegistryID (FK)(PK) A unique system assigned identifier for this particular CustomerGiftRegistry. ID_RGST_CT_GF Identity integer CustomerGiftRegistry(TR_RGST_CT_GF)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
DesiredQuantity The quantity of Itemss that are asked for in the GiftRegistry. QU_ITM_DR QuantityShortCount decimal(3,0)


Parent Entity Verb Phrase Child Entity
Item is registered as GiftRegistryLineItem
CustomerGiftRegistry registers GiftRegistryLineItem
GiftRegistryLineItem is satisfied by GiftRegistryLineItemAssociation

Logical Views containing GiftRegistryLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View