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. 

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

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

LocationID 
Definition  Auto generated unique primary key value. 

DataScopeNum 
Definition  FK to SXAINVOrgUnitAppIDXref table 

LocationName 
Definition  Location Name - May be NULL unless the Name is typed in as freetext 

LocationType 
Definition  Enum field for the location origin (CV3Location, Pharmacy, or Inventory) 

ParentID 
Definition  ID of Parent Location 

ParentLocationType 
Definition  Type of Parent Location (CV3, Pharmacy, Surgery, or Inventory) 

IsInventoryLocation 
Definition  Flag to indicate the location is used to store Inventory Items 

FacilityGUID 
Definition  Facility For the selected Location 

LocationGUID 
Definition  FK to CV3Location 

PharmacyID 
Definition  FK to CV3Pharmacy 

PharmacyLocationConfigID 
Definition  FK to SXAMMPharmacyLocationConfig 

FloorstockID 
Definition  FK to SXAMMFloorstock 

FloorstockLocConfigID 
Definition  FK to SXAMMFloorstockLocConfig 

ParentLocationGUID 
Definition  FK to CV3Location 

ParentPharmacyID 
Definition  FK to CV3Pharmacy 

ParentPharmacyLocationConfigID 
Definition  FK to SXAMMPharmacyLocationConfig 

ParentFloorstockID 
Definition  FK to SXAMMFloorstock 

ParentFloorstockLocConfigID 
Definition  FK to SXAMMFloorstockLocConfig 

IsADM 
Definition  Flag indicating if the location (or parent location) is an ADM location. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.