BusinessUnitGroupPOSDepartment

Entity Definition

Logical Name : BusinessUnitGroupPOSDepartment
Physical Name : ID_BSNGP_DPT_PS

An associative entity showing which POSDepartments are valid in which BusinessUnitGroups

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)
POSDepartmentID (FK)(PK) A unique system-assigned identifier for the POSDepartment ID_DPT_PS Identity integer POSDepartment(ID_DPT_PS)
EffectiveDateTime (PK) The date from which the BusinessUnits in the group carry the POSDepartment. TS_EF EffectiveDateTime datetime
ExpirationDateTime The date until which the BusinessUnits in the group carry the POSDepartment. TS_EP ExpirationDateTime datetime
ItemSellingRuleID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_RU_ITM_SL Identity integer ItemSellingRule(RU_ITM_SL)
ItemSellingPricesID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_ITM_SL_PRC Identity integer ItemSellingPrices(RU_ITM_SL_PRC)
Name The title or label given to a point-of-sale department. NM_DPT_POS Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
POSDepartment carries BusinessUnitGroupPOSDepartment
ItemSellingPrices is assigned to BusinessUnitGroupPOSDepartment
BusinessUnitGroup houses BusinessUnitGroupPOSDepartment
ItemSellingRule is assigned to BusinessUnitGroupPOSDepartment

Logical Views containing BusinessUnitGroupPOSDepartment

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10300 - Enterprise - POS Department View