Entity Definition

Logical Name : POSDepartment
Physical Name : ID_DPT_PS

A grouping of items with similar point of sale control and processing attributes. This entity type may also be used to control sales that are not properly identified at the item-level.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
POSDepartmentID (PK) A unique system-assigned identifier for the POSDepartment ID_DPT_PS Identity integer
ItemSellingRuleID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_RU_ITM_SL Identity integer ItemSellingRule(RU_ITM_SL)
ParentPOSDepartmentID (FK) A unique system-assigned identifier for the parent POSDepartment. ID_DPT_PS_PRNT Identity integer POSDepartment(ID_DPT_PS)
Name The human readable name for the POSDepartment NM_DPT_PS Name varchar(40)


Parent Entity Verb Phrase Child Entity
POSDepartment contains POSDepartment
ItemSellingRule is default setting for all items in POSDepartment
POSDepartment is tracked via POSDepartmentHistory
POSDepartment contains POSDepartment
POSDepartment identifies SaleReturnLineItem
POSDepartment carries BusinessUnitGroupPOSDepartment
POSDepartment classifies Item

Logical Views containing POSDepartment

Logical View
Logical 01020 - Item Description - Enterprise View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 10300 - Enterprise - POS Department View