This entity represents all billable items including services, inventory, diagnostics, and laboratory codes. The attached contains the required format for the ICodeBillables.CSV with a sample record.
The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.
Fields
Field Name | Required | Type | Description |
SiteID |
| String/Varchar(Max) | Id of site if more than one site location is being converted |
Code | Y | String/Varchar(Max) | Unique code identified |
Description | Y | String | Item description |
CategoryID | Y | String | This will match the KEY field in ICodeCategory. It is the Concatenation of Code, Pipe Symbol ( | ) and Type Description from ICodeCategory. Example: 100|Inventory Not used for Diagnostic Type |
Type | Y | String | Type will be Group, Diagnostic, Inventory, Service or Laboratory |
FollowupInterval |
|
|
|
ReminderInterval |
|
|
|
PrescriptionLabelText |
|
|
|
InstructionExternal |
| String | Client Notes |
Cost |
|
|
|
BasePrice |
| Decimal | Limit of 2 places |
DispensingFee |
| Decimal |
|
MinimumPrice |
|
|
|
MaximumPrice |
|
|
|
MarkupPercentage |
|
|
|
MarkupAmount |
|
|
|
DispenseUnitOfMeasure |
| Integer | Bottle, case, etc. |
Manufacturer |
|
|
|
ReorderLevel |
| String |
|
ReorderQuantity |
|
|
|
QuantityOnHand |
| Decimal |
|
QuantityOnOrder |
|
|
|
BreakQuantity1 |
| Decimal | quantity dispensed or administered to for Price1 to be applied |
BreakQuantity2 |
| Decimal | quantity dispensed or administered to for Price2 to be applied |
BreakQuantity3 |
| Decimal | quantity dispensed or administered to for Price3 to be applied |
BreakQuantity4 |
| Decimal | quantity dispensed or administered to for Price4 to be applied |
BreakQuantity5 |
| Decimal | quantity dispensed or administered to for Price5 to be applied |
BreakPrice1 |
| Decimal | selling price of a single unit at PriceBreak1 |
BreakPrice2 |
| Decimal | selling price of a single unit at PriceBreak2 |
BreakPrice3 |
| Decimal | selling price of a single unit at PriceBreak3 |
BreakPrice4 |
| Decimal | selling price of a single unit at PriceBreak4 |
BreakPrice5 |
| Decimal | selling price of a single unit at PriceBreak5 |
BarCode |
| String | Item barcode |
Inactive |
| Boolean/bit |
|
IsDeleted |
| Boolean/bit |
|
IsMedical |
| Boolean/bit |
|
IsDrug |
| Boolean/bit | True = FDA prescription medication |
IsInjection |
| Boolean/bit |
|
IsVaccine |
| Boolean/bit | True = Code is vaccine |
IsControlledSubstance |
| Boolean/bit | True = Code is FDA controlled substance |
IsDiscountPreventing |
| Boolean/bit | True = Code not subject to any discounting |
IsLaboratory |
| Boolean/bit |
|
IsDiagnostic |
| Boolean/bit |
|
IsReminder |
| Boolean/bit |
|
IsTaxable |
| Boolean/bit | Item code is subject to tax |
Key |
| String/Varchar(4000) | Concatenation of Code, |, Item (If using SiteID concatenate to the end) |
PmsID |
| String/Varchar(Max) | Concatenation of Code, |, Item (If using SiteID concatenate to the end) |