dbo.SXARCMTransaction 
Default Table Name  SXARCMTransaction 
Definition  Holds details of Transaction 

dbo.SXARCMTransaction Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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. 
TouchedWhenUTC    datetimeoffset(3)  NO  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    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. 
CreatedWhenUTC    datetimeoffset(3)  NO  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. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
TransactionID(PK)    bigint  NO  Auto generated unique primary key value. 
BatchID    bigint  YES  A foreign key to the BatchID column in the SXARCMBatch table. 
PostedUTC    datetimeoffset(3)  YES  Store posted date of transaction 
TransactionCodeMasterID(FK)    int  NO  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 
Amount    SXACurrencyDt  NO  Transaction Amount 
VisitID    bigint  YES  Referred from CV3ClientVisit Table of SCM Database 
IsReadyForPosting    bit  YES  Flag to check if Posting is ready 
CopiedFromTransactionID    int  YES  FK Key Reference To SXARCMTransaction Table 
ReverseTransactionID(FK)    bigint  YES  A foreign key to the TransactionID column in the SXARCMTransaction table. 
TransactionCodeDescription    nvarchar(100)  YES  Transaction code description. 
IsLateCharge    bit  NO  Flag to check if late charge is true or false 
PostingStatus    int  YES  Posting status of Transaction 
ContainerID    bigint  YES  FK Key Reference to SXARCMContainer Table 
ContainerType    int  NO  Type of Container 
IsEditedAfterPost    bit  NO  Flag to check if transaction edited after Posting or not 
IsAutoGenerated    bit  NO  Flag to check to transaction generated automatically or not 
TransactionNote    varchar(250)  YES  Remark for Transaction 
IsTransferred    bit  NO  Flag to identify that Transaction is Transferred or not 
TransactionYear(PK)    int  NO  Primary key 
VisitLevelDiagnosisCodeID1    bigint  YES  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 
VisitLevelDiagnosisCodeID2    bigint  YES  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 
VisitLevelDiagnosisCodeID3    bigint  YES  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 
VisitLevelDiagnosisCodeID4    bigint  YES  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 
DiagnosisGroupID    bigint  YES  Diagnosis Group ID for Visit from SXARCMVisitLevelDiagnosisCodes table 
CustomBatchID    nvarchar(30)  YES  Custom Batch ID for Batch Charge Entry 
TransactionGeneratedSource    int  YES  Source of the Transaction. 
RoomLocationID    HVCIDdt  YES  store Room Location ID which refer from CV3Location 
AccomodationID    int  YES  store Accomodation ID 
IsMigrated    bit  NO  Flag to identify Transation is migrated one 
ReverseTransactionYear(FK)    int  YES  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
InterfaceTransactionID    bigint  YES  To store interfacetransaction ID 
IsBadDebt    bit  NO  Bad Debt flag 
ObsChargeIntervalInMin    int  YES  Store Interval in Min. for observation charge applied 
VisitTransferTransactionID(FK)    bigint  YES  A foreign key to the TransactionID column in the SXARCMTransaction table. 
VisitTransferTransactionYear(FK)    int  YES  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
ServiceDate    date  NO  Stores transaction service date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsReversed    bit  NO  Specifies whether the original transaction is reveresed or not 
TaxTransactionID(FK)    bigint  YES  A foreign key to the TransactionID column in the SXARCMTransaction table. 
TaxTransactionYear(FK)    int  YES  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
ReferenceNumber    varchar(250)  YES  SXARCMTransaction 

dbo.SXARCMTransaction Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMTransactionPK  PrimaryKey  TransactionID, TransactionYear