Build 
Definition  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. 

TouchedBy 
Definition  Information about the user that last updated 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. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

CreatedBy 
Definition  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. 

CreatedWhenUTC 
Definition  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

RecipeID 
Definition  Auto generated unique primary key value. 

RecipeName 
Definition  This column holds the recipe name of the recipe 

AlternateName 
Definition  This column holds the alternate name of the recipe 

IsInventoryTracking 
Definition  This column indicates whether this recipe is being tracked in inventory or not 

MasterItemId 
Definition  This column holds the inventory item identifier with which the recipe is tracked in inventory 

PrepSizeQty 
Definition  This column holds the quantity of single preparation using the recipe 

PrepUOMCode 
Definition  This column holds the unit of measure of the recipe 

Directions 
Definition  This column holds the recipe directions 

CustomBarcodeIdentifier 
Definition  Recipe's custom barcode 

ExpirationUnitValue 
Definition  This column holds the expiration value of the recipe 

ExpirationUOMCode 
Definition  This column holds the expiration unit of measure (days, hours, months) 

ShowOnManufQueue 
Definition  This column indicates whether the recipe needs to be sent to manuf queue when being prepared 

IsPreChkRequired 
Definition  This column indicates whether the recipe needs to be prechecked when being prepared 

WLPrepareUnits 
Definition  This columns indicates the workload units to be assigned for preparing this recipe 

WLPreCheckUnits 
Definition  This columns indicates the workload units to be assigned for precheck of this recipe 

WLFinalCheckUnits 
Definition  This columns indicates the workload units to be assigned for final check of this recipe 

StorageConditionID 
Definition  This column holds the foreign key ref to SXAMMStorageCondition Table 

IsForAllLocations 
Definition  Flag indicating whether the recipe is available to all locations 

IsPatientSpecific 
Definition  Indicates whether the recipe is patient specific 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.