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. 

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. 

RecipeReportID 
Definition  Auto generated unique primary key value. 

RecipeID 
Definition  A foreign key to the RecipeID column in the SXAMMRecipe table. 

RecipePrepID 
Definition  A foreign key to the RecipePrepID column in the SXAMMRecipePrep table. 

IsPreview 
Definition  This column value indicate whether the record is for label preview 

ReportDataType 
Definition  0 = Recipe Label; 1 = Recipe Prep Lable, 2, RecipeWorksheet, 3 = RecipeWorksheetDetail 

RecipeName 
Definition  This column holds the name of the recipe 

AlternateName 
Definition  This column holds the alternate name of the recipe 

PrepSizeQty 
Definition  This column holds the preparation size of the recipe 

PrepUOMCode 
Definition  This column holds the unit of measure of the prep size 

PreparationDateTimeUTC 
Definition  Facility TimeZone - Preparation Date and time 

LotNum 
Definition  This column holds the lot number of the recipe 

StorageDescription 
Definition  Recipe's storage condition 

ExpDateTimeUTC 
Definition  Facility TimeZone - Date and time the recipe expired 

ShowPreparedBy 
Definition  Indicating whether to show the PreparedBy field on labels 

ShowCheckedBy 
Definition  Indicating whether to show the CheckedBy field on labels 

CustomBarcodeIdentifier 
Definition  Recipe's custom barcode 

LabelComment 
Definition  This column holds the label comment of the recipe 

FacilityName 
Definition  This column holds Facility Name of Pharmacy Location 

StreetAddress 
Definition  This column holds the Address of Pharmacy Location 

City 
Definition  This column holds the City of Pharmacy Location 

CountryDvsnCode 
Definition  This column holds the State/Province of Pharmacy Location 

ZipCode 
Definition  This column holds the Zipcode of Pharmacy Location 

PrepQty 
Definition  This column holds the quantity of the recipe 

PreCheckedDateTimeUTC 
Definition  Facility TimeZone - PreChecked Date and time 

FinalCheckedDateTimeUTC 
Definition  Facility TimeZone - Date and time the recipe had final check 

EnteredDateTimeUTC 
Definition  Facility TimeZone - Date and time the recipe was entered 

Expiration 
Definition  This column holds the expiration period of the recipe - Example 30 days or 5 hours 

EnteredBy 
Definition  This column holds the user GUID of a user who entered the recipe 

PreparedBy 
Definition  This column holds the user GUID of a user who prepared the recipe 

PreCheckedBy 
Definition  This column holds the user GUID of a user who prechecked the recipe 

FinalCheckedBy 
Definition  This column holds the user GUID of a user who final-checked the recipe 

PhoneNumber 
Definition  This column holds the Phone Number of Pharmacy Location 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.