📚 SAP Business One SDK Help

Items Object Members
See Also  Overview 

Public Methods

Public Method AddAdds a new record to the OITM table.

Adds a record to the object table in SAP Business One company database.

Public Method CancelCancels a record from the object table.
Public Method CloseNot supported.
Public Method GetAsXMLReturns the object from XML data, which is stored as string in a buffer.
Public Method GetByKeyRetrieves and sets the values of the object's properties by the object's absolute key from the Company database.
Public Method RemoveDeletes a record from the object table.
Public Method SaveToFileSave the object to a file as XML data.
Public Method SaveXMLSaves the object data to XML formatted data.
Public Method UpdateUpdates the object data in the company database.
Public Method UpdateFromXMLReceives and processes the XML content.

You can remove sub-object lines from the Items object via the XML file.

Public Properties

Public Property ApTaxCodeSets or returns the Tax Code (AP) for purchase documents.

Field name: TaxCodeAP.

This is a foreign key to the SalesTaxCodes Object.

Length: 8 characters.

Public Property ArTaxCodeSets or returns the Tax Code (AR) for sales documents.

Field name: TaxCodeAR.

This is a foreign key to the SalesTaxCodes Object

Length: 8 characters.

Public Property AssessableValueproperty AssessableValue
Public Property AssetClassThe asset class to which the asset belongs.

Field name: AssetClass.

Length: 20 characters.

Public Property AssetGroupThe asset group to which the asset belongs.

Field name: AssetGroup.

Length: 15 characters.

Public Property AssetItemDetermines whether or not this item is a Fixed Assets.

Field name: AssetItem.

Public Property AssetSerialNumberThe serial number of the asset.

Field name: AssetSerNo.

Length: 30 characters.

Public Property AssetStatusThe asset's status.

Field name: AsstStatus.

Public Property AssVal4WTRproperty AssVal4WTR
Public Property AttachmentEntrySets or returns the Attachment Entry.

Field name: AtcEntry.

Public Property AttributeGroupsReturns the ItemsAttributeGroups child object.
Public Property AutoCreateSerialNumbersOnReleaseDetermines whether or not to create automatically a serial number when releasing the item.

Applicable for cluster B only.

Public Property AvgStdPriceSets or returns the Item Cost.

Field name: AvgPrice.

Public Property BarCodeSets or returns the Bar Code (EAN code) for this item.

Field name: CodeBars.

Length: 16 characters.

Public Property BarCodesproperty BarCodes
Public Property BaseUnitNameSets or returns the inventory Unit Name.

Field name: BaseUnit.

Length: 20 characters.

Public Property BeverageCommercialBrandCodeproperty BeverageCommercialBrandCode
Public Property BeverageGroupCodeproperty BeverageGroupCode
Public Property BeverageTableCodeproperty BeverageTableCode
Public Property BrowserReturns the DataBrowser object.
Public Property CapitalGoodsOnHoldLimitproperty CapitalGoodsOnHoldLimit
Public Property CapitalGoodsOnHoldPercentproperty CapitalGoodsOnHoldPercent
Public Property CapitalizationDateThe date on which the asset is capitalized.

Field name: CapDate.

Public Property CessionIndicates whether the asset is owned by your company but financed by a bank mortgage.

Field name: Cession.

Public Property CESTCodeCEST Code.

Field name: CESTCode.

Public Property ChapterIDproperty ChapterID
Public Property CommissionGroupSets or returns the Commission Group code.

Field name: CommisGrp.

Public Property CommissionPercentSets or returns the commission percentage for the specified Business Partner.

Field name: CommisPcnt.

Public Property CommissionSumSets or returns the Total Commission for Item.

Field name: CommisSum.

Public Property CommodityClassificationCommodity classification.

Field name: CommClass.

Public Property ComponentWarehouseproperty ComponentWarehouse
Public Property CostAccountingMethodSets or returns the Valuation Method used to evaluate inventory.

Field name: EvalSystem.

Public Property CountingItemsPerUnitThe number of items per counting unit.

Field name: NumInCnt.

Public Property CreateDateThe date when the item master data created.

Field name: CreateDate.

Public Property CreateQRCodeFromProvide data source that is used to create a QR Code.

Field name: QRCodeSrc.

Public Property CreateTimeThe timestamp of the item master data created is recorded in the hhmmss format.

Field name: CreateTS.

Public Property CtrSealQtySpecify the Control Seal Quantity for Item Master Data.

Field name: CtrSealQty.

Public Property CustomsGroupCodeSets or returns the Customs Group code. Customs groups determine the customs duty for an item purchased abroad.

Field name: CstGrpCode.

Public Property DataExportCodeSets or returns the Data Export Code.

Field name: ExportCode.

Length: 20 characters.

Public Property DeactivateAfterUsefulLifeDeactivate a low value asset when the asset's useful life ends.

Field name: DeacAftUL.

Public Property DefaultCountingUnitThe name of the default inventory counting unit.

Field name: CntUnitMsr.

Length: 100 characters.

Public Property DefaultCountingUoMEntrySpecify a UoM to be used as the default inventory counting UoM.

Field name: INUoMEntry.

Public Property DefaultPurchasingUoMEntry

The internal key of the default purchasing UoM.

Field name: PUoMEntry.

Public Property DefaultSalesUoMEntry

The internal key of the default sales UoM.

Field name: SUoMEntry.

Public Property DefaultWarehouseSets or returns the Default Warehouse.

Field name: DfltWH.

Length: 8 characters.

Public Property DepreciationGroupThe depreciation areas you have specified in the asset class.

Field name: DeprGroup.

Length: 15 characters.

Public Property DepreciationParametersReturns the ItemsDepreciationParameters child object.
Public Property DesiredInventorySets or returns the Preferred Quantity in Purchase Units.

Field name: ReorderQty.

Public Property DistributionRulesReturns the ItemsDistributionRules child object.
Public Property DNFEntryThe DNF code for this item.

Field name: DNFEntry

This is a foreign key to the DNFCodeSetup object.

Public Property ECExpensesAccountSets or returns the EU Expense Account.

Field name: ECExpAcc.

Length: 15 characters.

Public Property ECRevenuesAccountSets or returns the EU revenues account.

Field name: ECInAcct.

Length: 15 characters.

Public Property EmployeeThe employee to whom the asset is physically assigned.

Field name: Technician.

Public Property EnforceAssetSerialNumbersproperty EnforceAssetSerialNumbers
Public Property Excisableproperty Excisable
Public Property ExemptIncomeAccountNot used from DI API version 6.2 and up.
Public Property ExpanseAccountNot used from DI API version 6.2 and up.
Public Property ForceSelectionOfSerialNumberSets or returns a valid value of BoYesNoEnum type that specifies whether or not to force selection of serial numbers for documents.

Field name: BlockOut.

Public Property ForeignExpensesAccountSets or returns the foreign expenses account.

Length: 15 characters.

Public Property ForeignNameSets or returns the item name or a description in foreign language.

Field name: FrgnName.

Length: 200 characters.

Public Property ForeignRevenuesAccountSets or returns the foreign revenues account.

Length: 15 characters.

Public Property FrozenSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is on hold.
Public Property FrozenFromSets or returns the start date for keeping the item on hold.
Public Property FrozenRemarksSets or returns the remarks regarding the on hold period.

Length: 30 characters.

Public Property FrozenToSets or returns the end date for keeping the item on hold.
Public Property FuelIDproperty FuelID
Public Property GLMethodSets or returns a valid value of BoGLMethods type that specifies the default G/L accounts for posting transactions related to the item. source: Warehouses, ItemGroups, or specified in the item level.
Public Property GSTRelevntproperty GSTRelevnt
Public Property GSTTaxCategoryproperty GSTTaxCategory
Public Property GTSItemSpecproperty GTSItemSpec
Public Property GTSItemTaxCategoryproperty GTSItemTaxCategory
Public Property ImportedItemproperty ImportedItem
Public Property IncomeAccountNot used from DI API version 6.2 and up.
Public Property IncomingServiceCodeSets or returns the Item's incoming service code.

Field name: ISvcCode.

This is a foreign key to the Service Code table (OSCD), not exposed through the DI API.

Public Property InCostRollupproperty InCostRollup
Public Property IndirectTaxSets or returns a valid value of BoYesNoEnum type that specifies whether or not to apply indirect tax.
Public Property IntrastatExtensionReturns the ItemIntrastatExtension child object.
Public Property InventoryItemSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is a warehouse item (not a service).
Public Property InventoryNumberThe inventory number of the asset.

Field name: InventoryNo.

Length: 12 characters.

Public Property InventoryUOMSets or returns the Unit of Measurement for the item (for example, box, case, piece.)

Length: 5 characters.

Public Property InventoryUoMEntry

The internal key of an inventory UoM.

Field name: IUoMEntry.

Public Property InventoryWeightproperty InventoryWeight
Public Property InventoryWeight1property InventoryWeight1
Public Property InventoryWeightUnitproperty InventoryWeightUnit
Public Property InventoryWeightUnit1property InventoryWeightUnit1
Public Property IsPhantomSets or returns a valid value of BoYesNoEnum type that specifies whether or not the item is a phantom item.
Public Property IssueMethodSets or returns a valid value that specifies the method for issuing the item from the inventory: Backflash (automatic) or Manual.
Public Property IssuePrimarilyBySpecify whether you want to pick the serial or batch items for issuing according to their bin locations or their serial or batch information.

Field name: IssuePriBy.

Public Property ItemClassSets or returns a valid value of ItemClassEnum that determines wether or not current Item is a Service or Material.

Field name: ItemClass.

Public Property ItemCodeSets or returns the item code in the inventory. The item code must be unique.

Mandatory property.

Length: 20 characters.

Public Property ItemCountryOrgSets or returns the origin country of the item.

Length: 3 characters.

Public Property ItemNameSets or returns the item name/description.

Length: 200 characters.

Public Property ItemsGroupCodeSets or returns the items group code. The user can classify items by groups. Each item can be assigned to one group only. The items group is used for reports and evaluations.
Public Property ItemTypeSets or returns a valid value of this Item Type.

Field name: ItemType.

Public Property LeadTimeSets or returns the lead time in days for ordering the item.
Public Property LegalTextLegal text.

Field name: LegalText.

Length: 250 characters.

Public Property LinkedResourceproperty LinkedResource
Public Property LocalizationInfosReturns the ItemLocalizationInfos child object.
Public Property LocationThe location of the asset.

Field name: Location.

Public Property MainsupplierSets or returns the card code of the main supplier of this item.

Length: 15 characters.

Public Property ManageBatchNumbersSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is managed by batch numbers.
Public Property ManageByQuantityIndicates whether the asset is managed by quantity.

Field name: MgrByQty.

Public Property ManageSerialNumbersSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is managed by serial numbers.
Public Property ManageSerialNumbersOnReleaseOnlySets or returns a valid value of BoYesNoEnum type that determines whether or not to create automatic serial numbers upon reception.

Field name: ManOutOnly.

Public Property ManageStockByWarehouseSets or returns a valid value of BoYesNoEnum type that specifies whether or not the inventory is managed by the warehouse quantity levels.
Public Property ManufacturerSets or returns the manufacturer code of the item (foreign key of the Manufacturers object).

Mandatory property.

Public Property MaterialGroupSets or returns the Item's Material Group.

Field name: MatGrp.

This is a foreign key to the Material Group OMGP object, not exposed through the DI API.

Public Property MaterialTypeSets or returns a valid value of BoMaterialTypes that determines current material state from Raw Material to Finished Goods.

Field name: MatType.

Public Property MaxInventorySets or returns the maximum inventory quantity for this item.
Public Property MinInventorySets or returns the minimum inventory quantity for this item.
Public Property MinOrderQuantitySets or returns this Item Minimum Order Quantity limitation . Field name: MinOrdrQty.
Public Property MovingAveragePriceReturns the average price of an item calculated according to quantities and prices.
Public Property NCMCodeReturns the item classification issued by the Brazilian government and used to determine the IPI tax rate. NCM stands for Nomenclatura Commun do Mercosul.

Field name: NCMCode

This is a foreign key to the NCM Code table (ONCM), which is exposed via the NCMCodesSetupService object.

Public Property NoDiscountsproperty NoDiscounts
Public Property NVECodeEnter the NVE code.

Field name: NVECode.

Length: 6 characters.

Public Property OrderIntervalsSets or returns the inventory cycle such as, every week on Monday, or every first day of the month. The inventory cycles are defined in SAP Business One (OCYC table, which is not exposed through the DI API).
Public Property OrderMultipleSets or returns the multiple quantity in addition to the minimum quantity of items in a single order.
Public Property OutgoingServiceCodeSets or returns the Outgoing Service Code.

Field name: OSvcCode.

This is a foreign key to the Service Code Table (OSCD), not exposed through the DI API.

Public Property PeriodControlsReturns the ItemsPeriodControls child object.
Public Property PictureSets or returns the picture file name to attach to an item.

Field name: PicturName.

Length: 200 characters.

Public Property PlanningSystemSets or returns a valid value of BoPlanningSystem type that specifies the inventory planning system: MRP or None.
Public Property PlasticPackageExemptionReasonForProductionReason for exemption from tax; options are determined by the authorities.
Public Property PlasticPackageExemptionReasonForPurchaseReason for exemption from tax; options are determined by the authorities.
Public Property PlasticPackageTaxCategoryCategories include single-use plastic container, plastic semi-finished products, and plastic packaging.
Public Property PreferredVendorsReturns the Items_PreferredVendors child object.
Public Property PriceListReturns the Items_Prices child object.
Public Property PricingUnitproperty PricingUnit
Public Property ProcurementMethodSets or returns a valid value of BoProcurementMethod type that specifies the procurement method of items: Buy or Make.
Public Property ProdStdCostproperty ProdStdCost
Public Property ProductSourceSets or returns a valid value of BoProductSources that determines the product source.

Field name: ProductSrc.

Public Property ProjectsReturns the ItemsProjects child object.
Public Property PropertiesSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item belongs to one or more query groups.
Public Property PurchaseFactor1Sets or returns the factor #1 by which the base price list is multiplied to calculate the purchase prices.
Public Property PurchaseFactor2Sets or returns the factor #2 by which the base price list is multiplied to calculate the purchase prices.
Public Property PurchaseFactor3Sets or returns the factor #3 by which the base price list is multiplied to calculate the purchase prices.
Public Property PurchaseFactor4Sets or returns the factor #4 by which the base price list is multiplied to calculate the purchase prices.
Public Property PurchaseHeightUnitSets or returns the units for the purchase unit width (cm, inch, etc.).

Length: 6 characters.

Public Property PurchaseHeightUnit1Sets or returns the secondary units for the purchase unit width (cm, inch, etc.).
Public Property PurchaseItemSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is for purchase (for example, an item can be defined as an asset).
Public Property PurchaseItemsPerUnitSets or returns the number of items per purchasing unit.
Public Property PurchaseLengthUnitSets or returns the units for the purchase unit length (cm, inches, etc.).
Public Property PurchaseLengthUnit1Sets or returns the secondary units for the purchase unit length (cm, inches, etc.).
Public Property PurchasePackagingUnitSets or returns the purchase packaging unit.

Length: 8 characters.

Public Property PurchaseQtyPerPackUnitSets or returns the number of items per purchase packaging unit.
Public Property PurchaseUnitSets or returns the purchasing unit. For example, an item, which is sold in bottles, is purchased in crates of 12 bottles. The purchasing unit is, in this case, a crate.

Length: 5 characters.

Public Property PurchaseUnitHeightSets or returns the height of the purchase unit.
Public Property PurchaseUnitHeight1Sets or returns the secondary height of the purchase unit.
Public Property PurchaseUnitLengthSets or returns the length of the purchase unit.
Public Property PurchaseUnitLength1Sets or returns the secondary length of the purchase unit.
Public Property PurchaseUnitVolumeSets or returns the volume of the purchase unit.
Public Property PurchaseUnitWeightSets or returns the weight of the purchase unit.
Public Property PurchaseUnitWeight1Sets or returns the secondary weight of the purchase unit.
Public Property PurchaseUnitWidthSets or returns the width of the purchase unit.
Public Property PurchaseUnitWidth1Sets or returns the secondary width of the purchase unit.
Public Property PurchaseVATGroupSets or returns the VAT group for a purchase item.

Length: 8 characters.

Public Property PurchaseVolumeUnitSets or returns the units for the purchase unit volume (m3, ft3, litter, gallon, etc.).
Public Property PurchaseWeightUnitSets or returns the units for the purchase unit weight (kg, lb, etc.).
Public Property PurchaseWeightUnit1Sets or returns the secondary units for the purchase unit weight (kg, lb, etc.).
Public Property PurchaseWidthUnitSets or returns the units for the purchase unit width (cm, inch, etc.).
Public Property PurchaseWidthUnit1Sets or returns the secondary units for the purchase unit width (cm, inch, etc.).
Public Property QuantityOnStockSets or returns the total quantity of the item in the warehouse.
Public Property QuantityOrderedByCustomersSets or returns the total quantity of the items ordered by customers.
Public Property QuantityOrderedFromVendorsSets or returns the total quantity of the items ordered from vendors.
Public Property SACEntryproperty SACEntry
Public Property SAFTProductTypeStandard Audit File-Tax (SAF-T) product types according to the Portuguese tax authority.

Field name: ProdctType.

Public Property SAFTProductTypeExStandard Audit File-Tax (SAF-T) define-new option for product types according to the Portuguese tax authority.

Field name: ProdTypeEx.

Length: 10 characters.

Public Property SalesFactor1Sets or returns the factor #1 by which the base price list is multiplied to calculate the sale prices.
Public Property SalesFactor2Sets or returns the factor #2 by which the base price list is multiplied to calculate the sale prices.
Public Property SalesFactor3Sets or returns the factor #3 by which the base price list is multiplied to calculate the sale prices.
Public Property SalesFactor4Sets or returns the factor #4 by which the base price list is multiplied to calculate the sale prices.
Public Property SalesHeightUnitSets or returns the units for the sales unit height (cm, inch, etc.).
Public Property SalesHeightUnit1Sets or returns the secondary units for the sales unit height (cm, inch, etc.).
Public Property SalesItemSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is a sales item.
Public Property SalesItemsPerUnitSets or returns the number of items per sales unit.
Public Property SalesLengthUnitSets or returns the units for the sales unit length (cm, inch, etc.).
Public Property SalesLengthUnit1Sets or returns the secondary units for the sales unit length (cm, inch, etc.).
Public Property SalesPackagingUnitSets or returns the sales packaging unit.

Length: 8 characters.

Public Property SalesQtyPerPackUnitSets or returns the number of items per sales packaging unit.
Public Property SalesUnitSets or returns the sales unit.

Length: 5 characters.

Public Property SalesUnitHeightSets or returns the height of the sales unit.
Public Property SalesUnitHeight1Sets or returns the secondary height of the sales unit.
Public Property SalesUnitLengthSets or returns the length of the sales unit.
Public Property SalesUnitLength1Sets or returns the secondary length of the sales unit.
Public Property SalesUnitVolumeSets or returns the volume of the sales unit.
Public Property SalesUnitWeightSets or returns the weight of the sales unit.
Public Property SalesUnitWeight1Sets or returns the secondary weight of the sales unit.
Public Property SalesUnitWidthSets or returns the width of the sales unit.
Public Property SalesUnitWidth1Sets or returns the secondary width of the sales unit.
Public Property SalesVATGroupSets or returns the VAT group for a sales item.

Length: 8 characters.

Public Property SalesVolumeUnitSets or returns the units for the sales unit volume (m3, ft3, litter, gallon, etc.).
Public Property SalesWeightUnitSets or returns the units for the sales unit weight (kg, lb, etc.).
Public Property SalesWeightUnit1Sets or returns the secondary units for the sales unit weight (kg, lb, etc.).

Length: 6 characters.

Public Property SalesWidthUnitSets or returns the units for the sales unit width (cm, inch, etc.).

Length: 6 characters.

Public Property SalesWidthUnit1Sets or returns the secondary units for the sales unit width (cm, inch, etc.).
Public Property ScsCodeproperty ScsCode
Public Property SerialNumSets or returns the serial number of the item.

Length: 17 characters.

Public Property Seriesproperty Series
Public Property ServiceCategoryEntryproperty ServiceCategoryEntry
Public Property ServiceGroupSets or returns the Item's Service Group.

Field name: ServiceGrp.

This is a foreign key to the OSGP object, not exposed through the DI API.

Public Property ShipTypeSets or returns the shipping type of the item (air cargo, courier, etc.).
Public Property SOIExcisableproperty SOIExcisable
Public Property SpProdTypeproperty SpProdType
Public Property SRIAndBatchManageMethodSets or returns a valid value that specifies the method for managing serial numbers and batch numbers.
Public Property StandardItemIdentificationStandard item identification.

Field name: StdItemId.

Public Property StatisticalAssetIndicates whether the asset is only a statistical asset that is not owned by your company.

Field name: StatAsset.

Public Property SupplierCatalogNoSets or returns the item catalog number as provided by the main supplier.

Length: 17 characters.

Public Property SWWSets or returns an additional identifier of the item.

Length: 16 characters.

Public Property TaxTypeSets or returns a valid value of BoTaxTypes type that specifies the sales tax system for the item.
Public Property TechnicianAssign an employee for maintenance of the asset.

Field name: Technician.

Public Property TNVEDproperty TNVED
Public Property ToleranceDaysproperty ToleranceDays
Public Property TraceableItemIndicate whether the item is traceable.

Field name: Traceable.

Public Property TreeTypeReturns a valid value of BoItemTreeTypes type that specifies the product tree type of the item (also known as bill of material type).
Public Property TypeOfAdvancedRulesIndicates whether the advanced rule type assigned to an item is General, Warehouse, or Item Group. You can change the advanced rule type if required.

Field name: GLPickMeth.

Public Property UnitOfMeasurementsReturns the ItemUnitOfMeasurements child object.
Public Property UoMGroupEntry

The internal key of a unit of measurement group. Field name: UgpEntry.

Public Property UpdateDateThe date when the item master data updated.

Field name: UpdateDate.

Public Property UpdateTimeThe timestamp of the item master data updated is recorded in the hhmmss format.

Field name: UpdateTS.

Public Property User_TextSets or returns a free text string for this item.

Length: 10 characters.

Public Property UserFieldsReturns the UserFields object.
Public Property ValidSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is valid.
Public Property ValidFromSets or returns the start date of the item's validity.
Public Property ValidRemarksSets or returns the remarks regarding the validity period.

Length: 30 characters.

Public Property ValidToSets or returns the end date of the item's validity.
Public Property VatLiableSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is subject to VAT.
Public Property VirtualAssetItemproperty VirtualAssetItem
Public Property WarrantyTemplateSets or returns the template for service warranty.

Length: 20 characters.

Public Property WeightOfRecycledPlasticWeight of recycled plastic per kg of item in master data.
Public Property WhsInfoReturns the ItemWarehouseInfo object.
Public Property WTLiableSets or returns a valid value of BoYesNoEnum type that specifies whether or not this item is subject to Withholding tax.

See Also