Product — data reference

All 97 fields BSuit stores for Product (Product Management), with the record types they refer to.

On this page

#About Product

Product is a record type in the Product Management area of BSuit. This page lists everything BSuit stores for each product — 97 fields. It is maintained on the “Products” page.

Related screen
ScreenModule
ProductsInsurance

#Fields

Every field stored for a product. “Stored as” is the technical field name, useful when talking to support or building reports. 6 fields are references to other record types.

Fields stored for Product
FieldStored asTypeRequiredMax lengthRefers to
CodeCodeTextNo——
NameNameTextNo——
DescriptionDescriptionTextNo——
Category IdCategoryIdTextNo—Category
Product Type IdProductTypeIdTextNo—ProductType
Brand IdBrandIdTextNo—Brand
Product Group IdProductGroupIdTextNo—ProductGroup
Base Uom IdBaseUomIdTextNo——
Hsn CodeHsnCodeTextNo——
SkuSkuTextNo——
BarcodeBarcodeTextNo——
WeightWeightNumber (decimal)No——
LengthLengthNumber (decimal)No——
WidthWidthNumber (decimal)No——
HeightHeightNumber (decimal)No——
Min StockMinStockNumber (decimal)No——
Max StockMaxStockNumber (decimal)No——
Reorder PointReorderPointNumber (decimal)No——
Reorder QtyReorderQtyNumber (decimal)No——
Cost PriceCostPriceNumber (decimal)No——
Selling PriceSellingPriceNumber (decimal)No——
MrpMrpNumber (decimal)No——
Is StockableIsStockableYes / NoNo——
Is PurchasableIsPurchasableYes / NoNo——
Is SellableIsSellableYes / NoNo——
Model NumberModelNumberTextNo——
Specifications_ JsonSpecifications_JsonTextNo——
Image UrlImageUrlTextNo——
Kitchen StationKitchenStationTextNo——
Shelf Life DaysShelfLifeDaysWhole numberNo——
Valuation MethodValuationMethodTextNo——
Opening StockOpeningStockNumber (decimal)No——
Weight UnitWeightUnitTextNo——
Dimension UnitDimensionUnitTextNo——
Is Batch ControlledIsBatchControlledYes / NoNo——
Is Serial ControlledIsSerialControlledYes / NoNo——
Barcode FormatBarcodeFormatTextNo——
Pricing ModePricingModeTextNo——
Commodity IdCommodityIdTextNo—Commodity
Making Charge TypeMakingChargeTypeTextNo——
Making Charge AmountMakingChargeAmountNumber (decimal)No——
Currency IdCurrencyIdTextNo—Currency
Tax ClassTaxClassTextNo——
Sort OrderSortOrderWhole numberNo——
SlugSlugTextNo——
Meta TitleMetaTitleTextNo——
Meta DescriptionMetaDescriptionTextNo——
Meta KeywordsMetaKeywordsTextNo——
Short DescriptionShortDescriptionTextNo——
Long DescriptionLongDescriptionTextNo——
Is PublishedIsPublishedYes / NoNo——
Published AtPublishedAtDate and timeNo——
Sales ChannelsSalesChannelsTextNo——
Show Stock On WebShowStockOnWebYes / NoNo——
Allow BackorderAllowBackorderYes / NoNo——
Allow PreorderAllowPreorderYes / NoNo——
Shipping ClassShippingClassTextNo——
Is DigitalIsDigitalYes / NoNo——
Digital File UrlDigitalFileUrlTextNo——
Has VariantsHasVariantsYes / NoNo——
Lifecycle StatusLifecycleStatusTextNo——
Warranty MonthsWarrantyMonthsWhole numberNo——
Return PolicyReturnPolicyTextNo——
Is ActiveIsActiveYes / NoNo——
Sales Income Ledger IdSalesIncomeLedgerIdTextNo——
Is PharmaceuticalIsPharmaceuticalYes / NoNo——
Generic NameGenericNameTextNo——
Dosage FormDosageFormTextNo——
Dosage StrengthDosageStrengthTextNo——
Drug CategoryDrugCategoryTextNo——
Route Of AdministrationRouteOfAdministrationTextNo——
Therapeutic ClassTherapeuticClassTextNo——
Is Controlled SubstanceIsControlledSubstanceYes / NoNo——
Requires PrescriptionRequiresPrescriptionYes / NoNo——
ContraindicationsContraindicationsTextNo——
Side EffectsSideEffectsTextNo——
Requires FastingRequiresFastingYes / NoNo——
CategoryCategoryTextNo——
Product TypeProductTypeTextNo——
BrandBrandTextNo——
Product GroupProductGroupTextNo——
VariantsVariantsTextNo——
MediaMediaTextNo——
TagsTagsTextNo——
SpecificationsSpecificationsTextNo——
Category MappingsCategoryMappingsTextNo——
RelationsRelationsTextNo——
BarcodesBarcodesTextNo——
PricesPricesTextNo——
Vendor ProductsVendorProductsTextNo——
Customer ProductsCustomerProductsTextNo——
U O M ConversionsUOMConversionsTextNo——
Lifecycle EventsLifecycleEventsTextNo——
IdIdTextNo——
Created AtCreatedAtDate and timeNo——
Updated AtUpdatedAtDate and timeNo——
Is DeletedIsDeletedYes / NoNo——

#Where Product is referenced

Other record types point to this one, so changing or removing a record here can affect them:

Record types that refer to Product
Record typeField
ProductTaxProduct Id
ContractScopeLineProduct Id
CrmOpportunityProductProduct Id
TransactionProductProduct Id
DrugDispensationProduct Id
PharmacyReturnProduct Id
PrescriptionItemProduct Id
PolicyProduct Id
RatingFactorProduct Id
BatchProduct Id
BatchExpiryAlertProduct Id
CrossDockTaskProduct Id
CycleCountLineProduct Id
GoodsReceiptNoteItemProduct Id
PackingBoxProduct Id
PickTaskProduct Id
PutawayRuleProduct Id
SerialNumberProduct Id
StockAdjustmentItemProduct Id
StockCostLayerProduct Id
StockMovementProduct Id
StockReservationProduct Id
StockTransferItemProduct Id
WarehouseProductProduct Id
BOMProduct Id
BOMCoproductProduct Id
DemandForecastProduct Id
DesignBomProduct Id
EngineeringChangeOrderProduct Id
MpsEntryProduct Id
MRPRunResultProduct Id
NonConformanceReportProduct Id
PlanningParameterProduct Id
ProductionOrderProduct Id
QualityInspectionProduct Id
RoutingProduct Id
StandardCostProduct Id
ChecklistTemplatePartProduct Id
HireAgreementLineProduct Id
PMWorkOrderPartProduct Id
PMWorkOrderPartIssueProduct Id
AdvanceShipmentNoticeLineProduct Id
BlanketAgreementLineProduct Id
CatalogCartItemProduct Id
CatalogItemProduct Id
ProductGlMappingProduct Id
PurchaseOrderLineProduct Id
PurchaseRequisitionItemProduct Id
RfqLineProduct Id
VendorInvoiceSubmissionLineProduct Id
CustomerProductProduct Id
ProductBarcodeProduct Id
ProductCategoryMappingProduct Id
ProductLifecycleEventProduct Id
ProductMediaProduct Id
ProductPackagingProduct Id
ProductPriceProduct Id
ProductRelationProduct Id
ProductSpecificationProduct Id
ProductTagMappingProduct Id
ProductVariantProduct Id
UOMConversionProduct Id
VendorProductProduct Id
AdCampaignProductProduct Id
AdEventProduct Id
CartLineProduct Id
DeliveryNoteLineProduct Id
LoyaltyRewardProduct Id
OfferProduct Id
PriceListLineProduct Id
ProductConfigProduct Id
ProductModifierGroupProduct Id
ProductQuestionProduct Id
ProductReviewProduct Id
RestaurantOrderItemProduct Id
SalesCommissionProductRateProduct Id
SalesOrderLineProduct Id
SalesPromotionConditionProduct Id
SalesReturnLineProduct Id
SavedCartItemProduct Id

#About this guide

Generated from BSuit’s data model on the date shown under “Seen on a running system”. Field names, types and lengths come from the model itself. References are inferred from field names (a field called “Ledger Id” is treated as pointing to Ledger); the model does not declare relationships, so an inferred link can occasionally be wrong or missing.

About this guide

Status
Partially reviewed
Application
BSuit ERP
Audience
Administrators, analysts and support staff
Owner
BSuit documentation team
Reviewer
Not yet reviewed
Last verified
Never
Checked against
Generated from source revision a36c7a086 on 2026-10-02
Seen on a running system
Not yet
Help version
2026.0.0-preview
Guide ID
erp:data/product_management.product
Need more help?If feedback above cannot be sent, email support and quote guide ID erp:data/product_management.product.
Email support