dbo.SXAORMMedMatchingSCMOrdersDetail 
Default Table Name  SXAORMMedMatchingSCMOrdersDetail 
Definition  The purpose of this table is to save the info on SCM orders for the patient during med matching porcess 

dbo.SXAORMMedMatchingSCMOrdersDetail Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the version of the software that inserted/updated this row. 
TouchedBy    varchar(50)  NO  The User who last updated the row. IDCode from CV3User table. 
TouchedWhenUTC    datetimeoffset(3)  NO  Date and time the row was last updated. 
CreatedBy    varchar(50)  NO  The User who created the row. IDCode from CV3User table. 
CreatedWhenUTC    datetimeoffset(3)  NO  Date and time the row was created. 
MSRowVersion    timestamp  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Added in order to support Merge Replication. 
Active    bit  NO  Active flag is used for soft deleting or deactivating rows from this table. 
GUID(PK)    bigint  NO  Primary key 
SCMOrderGUID(FK)    HVCIDdt  NO  SCM order - Foreign key from CV3outpatientorder table 
MatchingWindowSessionGUID(FK)    bigint  NO  Foreign key from SXAORMMedMatchingSessionsMaster 

dbo.SXAORMMedMatchingSCMOrdersDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAORMMedMatchingSCMOrdersDetailPK  PrimaryKey  GUID