This entity represents group code billable items used for bundling services and products. The attached contains the required format for the ICodeBillables_GroupCode.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) | Billable item code |
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 | GroupCode |
EntryDate |
|
|
|
FollowupInterval |
|
|
|
ReminderInterval | Y |
| Number of days for reminder |
PrescriptionLabelText |
|
|
|
AlteredGender |
|
|
|
InstructionInternal |
| String |
|
InstructionExternal |
| String | Client Notes |
ExpenseAccount |
|
|
|
IncomeAccount |
|
|
|
CostOfGoodsAccount |
|
|
|
Cost |
|
|
|
BasePrice |
| Decimal | Limit of 2 places |
DispensingFee |
| Decimal |
|
DispensingFeeType |
|
|
|
AdministeringFee |
|
|
|
AdministeringFeeType |
|
|
|
MinimumPrice |
|
|
|
MaximumPrice |
|
|
|
MarkupPercentage |
|
|
|
MarkupAmount |
|
|
|
PackQuantity |
|
|
|
PurchaseUnitOfMeasureID |
|
|
|
SalesUnitOfMeasureID |
|
|
|
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 |
BreakType1 |
|
|
|
BreakType2 |
|
|
|
BreakType3 |
|
|
|
BreakType4 |
|
|
|
BreakType5 |
|
|
|
PreferredVendor1ID |
|
|
|
PreferredVendor2ID |
|
|
|
PreferredVendor3ID |
|
|
|
BarCode |
| String | Item barcode |
Inactive |
| Boolean/bit |
|
IsDeleted |
| Boolean/bit |
|
IsMedical | Y | Boolean/bit | Default to True |
IsDrug |
| Boolean/bit | True = FDA prescription medication |
IsInjection |
| Boolean/bit |
|
IsVaccine |
| Boolean/bit | True = Code is vaccine |
IsSurgery |
| Boolean/bit |
|
IsXray |
| Boolean/bit |
|
IsControlledSubstance |
| Boolean/bit | True = Code is FDA controlled substance |
IsDietary |
| Boolean/bit |
|
IsEuthanasia |
| Boolean/bit |
|
IsGenderAlteration |
| Boolean/bit |
|
IsDiscountPreventing |
| Boolean/bit | True = Code not subject to any discounting |
IsOtcEligible |
| Boolean/bit |
|
IsFixedPrice |
| Boolean/bit |
|
IsNonPrinting |
| Boolean/bit |
|
IsCritical |
| Boolean/bit |
|
IsCertificate |
| Boolean/bit |
|
IsLaboratory |
| Boolean/bit |
|
IsDiagnostic |
| Boolean/bit |
|
IsReminder | Y | Boolean/bit |
|
IsProblem |
| Boolean/bit |
|
IsTaxable |
| Boolean/bit | Item code is subject to tax |
Key |
| String/Varchar(4000) | Concatenation of Code, |, GroupCode (If using SiteID concatenate to the end) |
PmsID |
| String/Varchar(Max) | Concatenation of Code, |, GroupCode (If using SiteID concatenate to the end) |