Entity Definition

Logical Name : BusinessUnitGroupItem
Physical Name : AS_BSNGP_ITM

An association between an Item and a BusinessUnit within a retailer that carries that item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)
EffectiveDateTime (PK) The date from which the BusinessUnits in the group carry the Item. TS_EF EffectiveDateTime datetime
ExpirationDateTime The date until which the BusinessUnits in the group carry the POSDepartment. TS_EP ExpirationDateTime datetime
ItemSellingPricesID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_ITM_SL_PRC Identity integer ItemSellingPrices(RU_ITM_SL_PRC)
ItemSellingRuleID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_RU_ITM_SL Identity integer ItemSellingRule(RU_ITM_SL)
SellingStatusCode Defines the selling status of the item. Examples include active, discontinued, seasonal, to be discontinued, held for future release, etc. SC_ITM_SLS Code2Status char(2)
StatusCode This code defines the current state of an item within the retail store. An item's state limits what actions may be taken on an item in terms of ordering, receiving, selling, returns, transfers, counting and so on. Sample statuses include active, inactive, discontinued, pending, etc. SC_ITM Code2Status char(2)
SellingStatusCodeEffectiveDate The date the current item selling status code became effective. DC_ITM_SLS EffectiveDate date
UpdateStockOnHandFlag A flag that determines whether the POS sale or return of an item will be posted to the stock ledger for each transaction so that a perpetual inventory for that item can be maintained. For SERVICE ITEMs the flag will be set to .FALSE. For most merchandise carried on the stock ledger the flag will be set to .TRUE. For consignment items, the supplier may assume responsibility for maintaining a perpetual inventory and the store may set the flag to .FALSE. FL_STK_UPDT_ON_HD Flag integer


Parent Entity Verb Phrase Child Entity
ItemSellingRule is assigned to BusinessUnitGroupItem
ItemSellingPrices is assigned to BusinessUnitGroupItem
BusinessUnitGroup carries BusinessUnitGroupItem
Item is carried by BusinessUnitGroupItem
BusinessUnitGroupItem is offered by CompetitorRetailItem
BusinessUnitGroupItem is created via ItemCreation
BusinessUnitGroupItem defines content of ItemLabel
BusinessUnitGroupItem is identified via POSIdentity
BusinessUnitGroupItem has price changed by TemporaryPriceChangeItem
BusinessUnitGroupItem is deleted via ItemDeletion
BusinessUnitGroupItem has price changed by PermanentPriceChangeItemE
BusinessUnitGroupItem is changed via ItemDescriptonUpdate

Logical Views containing BusinessUnitGroupItem

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01020 - Item Description - Enterprise View
Logical 01030 - Item Description - Recipe View
Logical 01050 - Item Description - Labelling View
Logical 01100 - Item Selling Rules - Macro View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 01300 - Item Price Maintenance View
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 02370 - Retail Transaction - Rental View
Logical 02395 - Retail Transaction - Deposit Redemption View
Logical 05000 - Taxation - Macro View
Logical 05300 - Taxation - Inventory Control Document View
Logical 06700 - Event Scheduler View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10200 - Enterprise - Merchandise View
Logical 10300 - Enterprise - POS Department View