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. 

BilledTransactionID 
Definition  Auto generated unique primary key value. 

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

ParentBilledTransactionID 
Definition  A foreign key to the BilledTransactionID column in the SXAMMBilledTransaction table. 

BillingProcessType 
Definition  An enumerated type with the following list of possible values: 0 = [Viewing Billing Transactions],1 = [Charge / Credit process],2 = [SCM Administration Module],3 = [Cart Fill],4 = [IVPB],5 = [LVP],6 = [ADM],7 = [Quick Charge],8 = [Dose Send],9 = [Take Home Meds],10 = [Robot Modified],11 = [Modified],12 = [Transfer Dose], 

BillingTransactionType 
Definition  An enumerated type with the following list of possible values: 0 = [Charge],1 = [Credit],2 = [Quick Charge], 

BillDtm 
Definition  Visit TimeZone - Identifies the Date and Time that Billing was triggered.The Billing Interface populates this with the current date and time.This is also used to populate in the Transaction Posting Date field in each Bill Charge Detail record, which will be sent in the FT1 transaction segment of the Financial Transaction. 

CalculationStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [OK],1 = [Error], 

CalculationDetails 
Definition  This entity 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 XML format. 

RouteCode 
Definition  Identifies the Route of Administration for the Drug(s) being billed. Points to CV3Route 

IsMultiIngredient 
Definition  Identifies whether the charges are for multi-ingredient. 

TotalPrice 
Definition  Identifies the Total Price for the Financial Transaction. 

AdjustmentCodedReasonCode 
Definition  Identifies the coded reason selected by the User for the online creation of a Charge or Credit Transactions from View Billing Transactions process, or the Debit Credit Process.
Must be a valid code from CV3CodedReason table.
Required if Bill Process Type is 'View Billing Transactions', or 'Debit Credit Process'. 

AdjustmentReasonText 
Definition  Identifies the optional free text entered by the User, for the online creation of a Charge or Credit Transactions from View Billing Transactions process, or the Credit / Debit Screen.
May be populated if Bill Process Type is 'View Billing Transactions', or 'Credit / Debit screen'.
,The calling process passes this in to the Billing Process. 

UnitLocationGUID 
Definition  Identifies the Unit Location of the Patient. Points to CV3Location 

PharmacyID 
Definition  A foreign key to the PharmacyID column in the SXAMMPharmacy table.  

OrderTaskOccurrenceGUID 
Definition  Identifies the Order Task Occurrence.
,Only populated when billing was called from SXA Mark as Done. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsQuickCharge 
Definition  Flag to indicate that the order is for a quick charge 

OutpatientOrderDispenseID 
Definition  A foreign key to the OutpatientOrderDispenseID column in the SXAMMOutpatientOrderDispense table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.