SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

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. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be 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. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

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

OrderOptionID 
Definition  Auto generated unique primary key value. 

OrderID 
Definition  A foreign key to the OrderID column in the SXAMMOrder table. 

TotalDoseNum 
Definition  Identifies the total dose that is to be administered for the Order Option (Route). 

TotalDoseUOMCode 
Definition  Identifies the Unit of Measure associated with the Total Dose. Links to the CV3 Unit of Measure table. 

RouteCode 
Definition  Identifies the Route of the order. ie Oral. Links to the CV3 Route table. 

RouteModifierCode 
Definition  Identifies the Route Modifier. ie Chewed Crushed etc. Links to the CV3 Order Route Modifier table. 

MedicationFormCode 
Definition  Identifies the Dose Form for the Order Option ie. Tablet Capsule etc.. Links to the CV3 Med Form table. 

BodySiteCode 
Definition  Identifies the Body Site for the Order Option. ie. Left Arm, Right Foot etc.. Links to the CV3BodySite table. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

FillingLabelDataID 
Definition  Identifies the Filling Label records that were generated by the Cart Fill process 

DispensingContainerID 
Definition  A foreign key to the DispensingContainerID column in the SXAMMDispensingContainer table. 

LineTypeID 
Definition  Identifies the Preferred Line Type for this Order 

UseFloorstock 
Definition  Identifies if Floor Stock should be used for Filling the order. 

HangTimeNum 
Definition  Identifies the Default Hang Time. 

HangTimeUOMCode 
Definition  Identifies the Unit of measure associated with the hang time.Links to CV3UnitOfmeasure 

CostAmt 
Definition  Total Cost of all components 

KeepVeinOpen 
Definition  Keep Vein Open 

LabelExpiryPeriodNum 
Definition  Expiry Period to print on labels 

LabelExpiryPeriodType 
Definition  An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days], 

PriceAmt 
Definition  Total Price of all components 

StorageConditionID 
Definition  A foreign key to the StorageConditionID column in the SXAMMStorageCondition table. 

OrderVariableComponentGUID 
Definition  Identifies the Order Variable Component GUID for complex orders 

CalculationDetails 
Definition  This attribute contains a detailed explanation of how the Charge Calculation was determined. It will contain the exact steps that were done to calculate the charge being processed to the patient - will include markup, dispensing fees etc... applied to the base price of the drug.This entity contains the formatted text displayed within the Price Popup window. The data stored in this attribute will most likely be in XLM format 

TotalVolumeNum 
Definition  Identifies the total volume for the Order Option (Route). 

TotalVolumeUOMCode 
Definition  Identifies the Unit of Measure associated with the Total Volume. Links to the CV3 Unit of Measure table via 'Code'. 

IsManualFillQuantitySet 
Definition  Tells if fill Quantity is set by the user on the order. If so use manually set value else calculate based on frequency. 

ManualFillQuantity 
Definition  Manually set fill quantity for the order. 

UseRobot 
Definition  true if the order will be dispatched to the robot 

FlowRateNum 
Definition 
SMM Order Flow Rate Value 

FlowRateUOMCode 
Definition 
SMM Order Flow Rate UOM 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.