Entity Definition

Logical Name : PhysicalCountDocument
Physical Name : DO_CNT_PHY

The document on which the actual ITEM counts are recorded on the day of the Physical Inventory. This is raw/ unedited data captured during the Inventory.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer BusinessUnit(LO_BSN_UN)
PhysicalCountDocumentID (PK) The identifier for the physical count document on which the actual item counts are recorded. ID_DCM_PHY_CNT Identity integer
CreationTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_CRT IdentityUUID char(32) PhysicalCountTransaction(TR_PHY_CNT)


Parent Entity Verb Phrase Child Entity
BusinessUnit records inventory counts via PhysicalCountDocument
PhysicalCountTransaction creates PhysicalCountDocument
PhysicalCountDocument includes PhysicalCountLineItem

Logical Views containing PhysicalCountDocument

Logical View
Logical 02010 - Item Inventory - Adjustments View
Logical 02600 - Inventory Control Transaction View