This reference guide provides a comprehensive list of all available Products data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Products fields are available when building custom reports, what information each field represents, and how to select the right fields for your reporting needs. This resource helps you make informed decisions when configuring reports and ensures you're pulling the correct data.
Products
| Column Name | What It Means |
| ProductID | Unique identifier for the product |
| Type | Category of product |
| OperatorID | The business/operator providing this product |
| Code | Short code or SKU for the product |
| Name | Product display name |
| Description | Detailed product description |
| Active | Whether the product is currently available for sale |
| NettCost | Wholesale cost (what you paid for it) |
| GrossCost | Retail price (what you sell it for) |
| GST | Tax amount included in sales |
| Category | Product category classification |
| Supplier | Who supplies the product |
| SubCategory | More specific product classification |
| AccountingSystemCode | Reference code for external accounting software |
| PLUCode | Price Look-Up code for barcode scanning |
| GLCode | General Ledger account code |
| CostCentreCode | Department or cost center identifier |
| TotalProductUnits | How many units of this product exist |
| MaxPersonsAllowed | Maximum occupancy for the accommodation |
| DefaultDailyRate | Standard nightly rate (rack rate) |
| ExtraAdultDailyRate | Additional charge per extra adult |
| ExtraChildDailyRate | Additional charge per extra child |
| ChildNotAllowed | Whether children are prohibited |
| InfantNotAllowed | Whether infants are prohibited |
| IncludeInfantInPaxCount | Whether infants count toward occupancy limits |
| MaxDaysBookable | Maximum length of stay allowed |
| Configuration | Room layout/configuration type |
| Sold | Total quantity sold |
| Returned | Total quantity returned/refunded |
| LowStockLevel | Minimum quantity threshold for reordering |
| StockOnHand | Current inventory quantity |
| StockLocationId | ID of the storage location |
| StockLocation | Name of the storage location |
| SaleDate | Date this product was sold (for aggregated data) |
| SaleId | Link to the specific sale transaction |