This entity represents associations between group codes and their component items. The attached contains the required format for the ICodeAssociation_GroupItem.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 |
|
| Id of site if more than one site location is being converted |
ParentCodeID | Y | String/Varchar(Max) | Key from ICodeBillables_GroupCode |
AssociatedCodeId | Y | String/Varchar(Max) | Key from ICodeBillables |
Quantity | Y | Integer | Quantity of item for that Group |
Price | Y | Decimal | Limit of 2 places |
Type |
| String | Default to GroupItem |
Key |
| String/Varchar(4000) | Concatenation of Code, |, RemCode (If using SiteID concatenate to the end) |
PmsID |
| String/Varchar(Max) | Concatenation of Code, |, RemCode (If using SiteID concatenate to the end) |
ReminderDays |
| Integer | Defaults to 0 |
Sample File