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. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

TransactionID 
Definition  Auto generated unique primary key value. 

BatchID 
Definition  A foreign key to the BatchID column in the SXARCMBatch table. 

PostedUTC 
Definition  Store posted date of transaction 

TransactionCodeMasterID 
Definition  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 

Amount 
Definition  Transaction Amount 

VisitID 
Definition  Referred from CV3ClientVisit Table of SCM Database 

IsReadyForPosting 
Definition  Flag to check if Posting is ready 

CopiedFromTransactionID 
Definition  FK Key Reference To SXARCMTransaction Table 

ReverseTransactionID 
Definition  A foreign key to the TransactionID column in the SXARCMTransaction table. 

TransactionCodeDescription 
Definition  Transaction code description. 

IsLateCharge 
Definition  Flag to check if late charge is true or false 

PostingStatus 
Definition  Posting status of Transaction 

ContainerID 
Definition  FK Key Reference to SXARCMContainer Table 

ContainerType 
Definition  Type of Container 

IsEditedAfterPost 
Definition  Flag to check if transaction edited after Posting or not 

IsAutoGenerated 
Definition  Flag to check to transaction generated automatically or not 

TransactionNote 
Definition  Remark for Transaction 

IsTransferred 
Definition  Flag to identify that Transaction is Transferred or not 

TransactionYear 
Definition  Primary key 

VisitLevelDiagnosisCodeID1 
Definition  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 

VisitLevelDiagnosisCodeID2 
Definition  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 

VisitLevelDiagnosisCodeID3 
Definition  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 

VisitLevelDiagnosisCodeID4 
Definition  A foreign key to the VisitLevelDiagnosisCodeID column in the SXARCMVisitLevelDiagnosisCodes table. 

DiagnosisGroupID 
Definition  Diagnosis Group ID for Visit from SXARCMVisitLevelDiagnosisCodes table 

CustomBatchID 
Definition  Custom Batch ID for Batch Charge Entry 

TransactionGeneratedSource 
Definition  Source of the Transaction. 

RoomLocationID 
Definition  store Room Location ID which refer from CV3Location 

AccomodationID 
Definition  store Accomodation ID 

IsMigrated 
Definition  Flag to identify Transation is migrated one 

ReverseTransactionYear 
Definition  A foreign key to the TransactionYear column in the SXARCMTransaction table. 

InterfaceTransactionID 
Definition  To store interfacetransaction ID 

IsBadDebt 
Definition  Bad Debt flag 

ObsChargeIntervalInMin 
Definition  Store Interval in Min. for observation charge applied 

VisitTransferTransactionID 
Definition  A foreign key to the TransactionID column in the SXARCMTransaction table. 

VisitTransferTransactionYear 
Definition  A foreign key to the TransactionYear column in the SXARCMTransaction table. 

ServiceDate 
Definition  Stores transaction service date 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsReversed 
Definition  Specifies whether the original transaction is reveresed or not 

TaxTransactionID 
Definition  A foreign key to the TransactionID column in the SXARCMTransaction table. 

TaxTransactionYear 
Definition  A foreign key to the TransactionYear column in the SXARCMTransaction table. 

ReferenceNumber 
Definition  SXARCMTransaction