Items
Stock and catalogue items in HaloServiceDesk, representing products and services that can be added to invoices and orders.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| Use | String | ||
| Name | String | ||
| PurchaseDescription | String | ||
| NominalCode | String | ||
| PurchaseNominalCode | String | ||
| GoodsInUnit | String | ||
| GoodsOutUnit | String | ||
| XeroTenantId | String | ||
| IncomeAccountName | String | ||
| ExpenseAccountName | String | ||
| AssetAccountName | String | ||
| QboSku | String | ||
| QboCategoryId | String | ||
| QboCategoryName | String | ||
| QboCompanyId | String | ||
| SnelStartId | String | ||
| SnelStartDepartmentId | String | ||
| SnelStartDepartmentName | String | ||
| ItemGroupNominalCode | String | ||
| ItemGroupNominalCodePurchase | String | ||
| ItemGroupDbcTemplate | String | ||
| DbcCompanyId | String | ||
| DbcTemplate | String | ||
| ThirdPartyId | String | ||
| QuotePdfName | String | ||
| AssetTypeMatchingFieldName | String | ||
| AssetGroupId | Integer | ||
| AssetGroupName | String | ||
| AssetTypeId | Integer | ||
| AssetTypeName | String | ||
| SupplierId | Integer |
Suppliers.Id | |
| SupplierName | String | ||
| ManufacturerId | Integer | ||
| ManufacturerName | String | ||
| LinkedItemId | Integer |
Items.Id | |
| TemplateId | Integer | ||
| PrimaryImageId | Integer | ||
| CreatedById | Integer |
Agents.Id | |
| Status | Integer | ||
| Type | Integer | ||
| AutoGroupNewQuoteLines | Integer | ||
| InOutConversion | Integer | ||
| TaxCode | Integer | ||
| TaxCodeOther | Integer | ||
| CostingMethod | Integer | ||
| MeterType | Integer | ||
| MeterLife | Integer | ||
| KashFlowId | Integer | ||
| KashflowTenantId | Integer | ||
| AutotaskServiceId | Integer | ||
| AutotaskProductId | Integer | ||
| AssetAccountCode | Integer | ||
| DefaultBillingPeriod | Integer | ||
| Sage50UkDepartmentId | Integer | ||
| AutoReorderType | Integer | ||
| TieredPricingMethod | Integer | ||
| ProjectBillType | Integer | ||
| QuantityDecimalPlaces | Integer | ||
| AccessControlLevel | Integer | ||
| BasePrice | Decimal | ||
| CostPrice | Decimal | ||
| SecondPrice | Decimal | ||
| SleevePrice | Decimal | ||
| SecondHandPrice | Decimal | ||
| RecurringPrice | Decimal | ||
| RecurringCost | Decimal | ||
| Margin | Decimal | ||
| MarkupPercentage | Decimal | ||
| MaxItemDiscount | Decimal | ||
| ServiceFee | Decimal | ||
| Recovery | Decimal | ||
| AverageCost | Decimal | ||
| Hours | Decimal | ||
| MinStockQuantity | Decimal | ||
| MinPurchaseQuantity | Decimal | ||
| ReorderQuantity | Decimal | ||
| QuantityInStock | Decimal | ||
| QuantityReserved | Decimal | ||
| QuantityOnOrder | Decimal | ||
| QuantityOnAllSalesOrders | Decimal | ||
| QuantityIssuedThisYear | Decimal | ||
| QboQuantity | Decimal | ||
| DateCreated | Datetime | ||
| LastModified | Datetime | ||
| QboInitialQuantityDate | Datetime | ||
| IsRecurringItem | Boolean | ||
| IsContractItem | Boolean | ||
| IsInvoiceExcluded | Boolean | ||
| IsTaxable | Boolean | ||
| IsSalesTaxIncluded | Boolean | ||
| IsPurchaseTaxIncluded | Boolean | ||
| IsPromptForPrice | Boolean | ||
| IsConsigningNotRequired | Boolean | ||
| IsDiscountApplied | Boolean | ||
| IsShownInMobileScanner | Boolean | ||
| IsRecurringInvoicePriceUpdated | Boolean | ||
| IsRecurringInvoiceCostUpdated | Boolean | ||
| IsStockTrackingDisabled | Boolean | ||
| IsPurchaseOrderReceiptDisabled | Boolean | ||
| IsQuoteLineAutoRenewByDefault | Boolean | ||
| IsPriceCalculatedFromComponents | Boolean | ||
| IsCostCalculatedFromComponents | Boolean | ||
| IsSerialisedToOneOnly | Boolean | ||
| RelatedCategories | String | ||
| ItemSuppliers | String | ||
| CustomFields | String | ||
| CustomButtons | String |