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. |
Active |
Definition | Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
PriceAlgorithmRangeRuleID |
Definition | Auto generated unique primary key value. |
PriceAlgorithmID |
Definition | A foreign key to the PriceAlgorithmID column in the SXAMMPriceAlgorithm table. |
FromCostAmt |
Definition | Identifies the From Cost range of the Price Algorithm. If the Cost is between the From Cost Amt and the To Cost Amt, and the Is Multi Ingredient indicator matches whether the drugs are multi-ingredient, then this is the range rule (fees, markups) that are applied to the cost to determine the price. |
ToCostAmt |
Definition | Identifies the To Cost range of the Price Algorithm. If the Cost is between the From Cost Amt and the To Cost Amt, and the Is Multi Ingredient indicator matches whether the drugs are multi-ingredient, then this is the range rule (fees, markups) that are applied to the cost to determine the price. |
IsMultiIngredient |
Definition | Identifies whether this Tiered Price Algorithm is for Multi-Ingredient, or for Single-Ingredient. |
MarkupType |
Definition | An enumerated type with the following list of possible values: 0 = [None],1 = [Amount],2 = [Percent], |
MarkupAmt |
Definition | Identifies the Markup (based on the Markup Type). If Markup Type indicates 'Percent', then this is a percentage markup. If Markup Type indicates 'Amount', then this is a Dollar markup. , |
DispensingFeeType |
Definition | An enumerated type with the following list of possible values: 0 = [None],1 = [Amount],2 = [Percent], |
DispensingFeeAmt |
Definition | Identifies the Dispensing Fee (based on the Dispensing Fee Type). If Dispensing Fee Type indicates 'Percent', then this is a percentage Fee. If Dispensing Fee Type indicates 'Amount', then this is a Dollar Fee. |
CompoundingFeeAmt |
Definition | Identifies the Compounding Fee (if there is one) that should be applied. This is the fee applied for creating the order. Commonly used as reimbursement for effort used in dispensing multi-ingredient orders. , |
AdministrationFeeAmt |
Definition | Identifies the Administration Fee (if there is one) that should be applied. , |
RoundUpAmt |
Definition | Identifies the Round Up amount (if there is one). Round up to the nearest unit specified. The main values used are: 0.01 - Round up to the nearest Cent 0.10 - Round up to the nearest Dime 0.50 - Round up to the nearest half dollar 1.00 - Round up to the nearest Dollar Any value can be specified (for example 1.25 would indicate to round up to the nearest Dollar and 25 Cents). Default of Blank will round to the nearest Cent and is equivalent to 0.01. , |
MinimumPriceAmt |
Definition | Identifies a Minimum price for the tiered range. If the Price determined as a result of applying the Price Algorithm is less than this Minimum Price, then this Minimum Price is the Price of the Stock Item Product , |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |