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. 

SXAAMBSBillChargeDetailId 
Definition  Auto generated unique primary key value. 

SXAAMBSBillChargeHeaderId 
Definition  A foreign key to the SXAAMBSBillChargeHeaderId column in the SXAAMBSBillChargeHeader table. 

TransactionType 
Definition  Transaction Type 

DateOfService 
Definition  visit TimeZone - DOS 

TransactionCode 
Definition  Trans code 

LocationCode 
Definition  Location Code 

VisitClass 
Definition  Type of visit according to the billing classification 

DiagnosisCodeList 
Definition  "^" delimited ICD code list .Up to 25 ICD codes 

PerformedByCode 
Definition  Code for the performer 

OrderedByCode 
Definition  Ordered by code 

HCPCSCode 
Definition  Procedure HCPCS code 

CodeModifier 
Definition  Code Modifier 

Quantity 
Definition  int 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

LocationGUID 
Definition  Reference to GUID in CV3Location table. This identifies the location where the SuperBill charge(s) took place. 

OrderedByProviderGUID 
Definition  Reference to GUID in CV3User table. Identifies the user who entered the SuperBill charge(s). 

PerformedByProviderGUID 
Definition  Reference to GUID in CV3CareProvider table. Identifies the Care Provider who performed the SuperBill charge(s). 

ReferredByCode 
Definition  Referring Provider Billing Code 

NDC 
Definition  National Drug Code 

NDCQuantity 
Definition  The billable quantity 

NDCLabel 
Definition  Drug name and strength 

NDCConversionFactor 
Definition  The Conversion Factor translates the value of one NCPDP Standard billing unit for a particular NDC to the corresponding units for a particular HCPCS Code. 

NDCUnitOfMeasure 
Definition  NDC unit of measure 

ReferredByProviderGUID 
Definition  Referring Provider, link to the CV3Careprovider.GUID 

BillingProviderGUID 
Definition  Billing Provider GUID, link to the CV3Careprovider.GUID 

BillingProviderCode 
Definition  Billing Provider Identification Code 

DiagnosisCodeSetList 
Definition  The codeset for DiagnosisCodelist 

HCPCSCodeSet 
Definition  The codeset for HCPCSCode 

CodeSetModifier 
Definition  The codeset for Modifier 

UserNPICode 
Definition  User NPI Code 

AttendingByCode 
Definition  To save attending provider code 

AttendingByProviderGUID 
Definition  To save attending provider GUID 

DiagnosisCodeSetListXML 
Definition  It saves diagnosis code set XML with their mapping codes 

HCPCSDescription 
Definition  It saves superBill procedure description 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.