dbo.CV3OrderSetModificationHistory 
Default Table Name  CV3OrderSetModificationHistory 
Definition  Stores order set modification history 

dbo.CV3OrderSetModificationHistory Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhen    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
OrderSetModificationHistoryID(PK)    int  NO  Auto generated unique primary key value. 
OrderCatalogSetGUID    HVCIDdt  NO  GUID of order catalog set that the modificaotn history is tracked. 
FunctionType    int  NO  Modify function type:
0 - Add Item
1 - Modify Item
2 - Remove Item
3 - Add Reference Set
4 - Remove Reference Set
5 - Add Browse Item
6 - Remove Browse Item 
OrderSetHeader    varchar(30)  YES  Order set header 
Name    varchar(125)  NO  Stores the name of an order template, order set or browse item. 
SummaryLine    varchar(2000)  YES  Stores the summary line of order templates in the order set 
ObjectGUID    HVCIDdt  YES  For order template or order set, this will be the order GUID.
For function type of 'Add Browse Item' and 'Remove Browse Item', this will be the browse item GUID if a browse item is added/removed. This will be '0' if 'Entire Catalog' is added/removed. 
ItemType    int  NO  Type of items added to the set:
0 - order item
1 - order set
2 - browse item 
ReferencedCatalogSetGUID    HVCIDdt  YES  Stores order catalog set GUID. It can be the referenced standard, generic or linked set, or added order set. 
UserGUID    HVCIDdt  YES  GUID of user who modified the order set. 
UserNameAndOccupation    varchar(255)  YES  PHI: Stores name and occupation of user who modified the order set in the format of ' ()'. This field is used for historical purposes. 
FromCatalogSetGUID    HVCIDdt  YES  Stores GUID of order set that the order template is copied from. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3OrderSetModificationHistory Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderSetModificationHistoryPK  PrimaryKey  OrderSetModificationHistoryID