Entity Definition

Logical Name : PhysicalCountTransaction
Physical Name : TR_PHY_CNT

A type of InventoryControlTransaction that records, the fact that the Operator conducted a Physical Inventory, and created a PhysicalCountDocument at the POS.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
EventID (FK) A unique, automatically assigned identifier for the Event that is being conducted by this PhysicalCountTransaction. ID_EV Identity integer PhysicalInventoryEvent(CO_EV_PHY_INV)


Parent Entity Verb Phrase Child Entity
PhysicalInventoryEvent causes PhysicalCountTransaction
PhysicalCountTransaction creates PhysicalCountDocument
InventoryControlTransaction can be a PhysicalCountTransaction

Logical Views containing PhysicalCountTransaction

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