dbo.SXAMMBilledTransaction 
Default Table Name  SXAMMBilledTransaction 
Definition  The Billed Transaction and Billed Transaction Detail tables contain the Audit History for the Billing Interface. This data represents the parameters used to generate the data in the Bill Charge Header and Bill Charge Detail tables below.
Financial Transaction
Billed Audit Trail Financial Transaction consists of one Billed Transaction and 1 or more Billed Transaction Details.
There is one Billed Transaction for each Bill Charge Header
There is one Billed Transaction Detail for each Bill Charge Detail.
If there was an Error returned by Determine Price, the Billing Interface will still create a Billed Transaction and the associated Billed Transaction Detail records, but will not create corresponding Bill Charge Header and Bill Charge Detail rows.
Billed Transaction
Billed Transaction identifies Patient and Order related information used to generate a Financial Transaction.
This information is maintained for audit purposes, and used to derive the data that populates the PID segment in the Financial Transaction sent to the Financial System.
Billed Transaction Detail
Billed Transaction Detail identifies Drug, Cost, and Price information used to generate a Financial Transaction.
This information is maintained for audit purposes, and used to derive the data that populates the FT1 segment in the Financial Transaction sent to the Financial System.
Billed Transaction
Billed Transaction identifies Patient and Order related information used to generate a Financial Transaction.
This information is maintained for audit purposes, and used to derive the data that populates the PID segment in the Financial Transaction sent to the Financial System.
Billed Transaction Detail
Billed Transaction Detail identifies Drug, Cost, and Price information used to generate a Financial Transaction.
This information is maintained for audit purposes, and used to derive the data that populates the FT1 segment in the Financial Transaction sent to the Financial System. 

dbo.SXAMMBilledTransaction Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  NO  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    datetime  NO  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  NO  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    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
BilledTransactionID(PK)    bigint  NO  Auto generated unique primary key value. 
OrderID(FK)    bigint  NO  A foreign key to the OrderID column in the SXAMMOrder table. 
ParentBilledTransactionID(FK)    bigint  YES  A foreign key to the BilledTransactionID column in the SXAMMBilledTransaction table. 
BillingProcessType    int  NO  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    int  NO  An enumerated type with the following list of possible values: 0 = [Charge],1 = [Credit],2 = [Quick Charge], 
BillDtm    datetime  NO  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    int  NO  An enumerated type with the following list of possible values: 0 = [OK],1 = [Error], 
CalculationDetails    varchar(max)  YES  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    varchar(30)  NO  Identifies the Route of Administration for the Drug(s) being billed. Points to CV3Route 
IsMultiIngredient    bit  NO  Identifies whether the charges are for multi-ingredient. 
TotalPrice    numeric(11, 3)  YES  Identifies the Total Price for the Financial Transaction. 
AdjustmentCodedReasonCode    varchar(30)  YES  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    varchar(520)  YES  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    HVCIDdt  NO  Identifies the Unit Location of the Patient. Points to CV3Location 
PharmacyID    int  YES  A foreign key to the PharmacyID column in the SXAMMPharmacy table.  
OrderTaskOccurrenceGUID    HVCIDdt  YES  Identifies the Order Task Occurrence.
,Only populated when billing was called from SXA Mark as Done. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
IsQuickCharge    bit  YES  Flag to indicate that the order is for a quick charge 
OutpatientOrderDispenseID(FK)    int  YES  A foreign key to the OutpatientOrderDispenseID column in the SXAMMOutpatientOrderDispense table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMBilledTransaction Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMBilledTransactionPK  PrimaryKey  BilledTransactionID