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![]() |
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 ' |
|
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 |