Sales Waste Report¶
The Sales Waste Report , derived from data stored in the waste section of the sales transactions within Dsposal's Paperwork, offers a comprehensive insight into the waste lines associated with sales activities. This report serves as a fundamental tool for accessing detailed information regarding the waste associated through the sales transactions. The Sales Waste Report facilitates quick and efficient access to critical insights into waste management practices, ensuring users can effectively monitor and analyse waste-related aspects of sales operations.
Before you start¶
Before getting started, there are a couple of helpful things to know:
- The date from and to fields relate to the dates when the sale was created (not not the waste within the sale).
- Deleted sales are NOT included in the report, and deleted waste lines are NOT included in the report.
- Each sales transaction in the Sales Waste Report is uniquely identified by a salesId.
- The salesNumber serves as a reference code for each sales transaction and may appear multiple times if there are multiple waste lines associated with the same sales transaction.
- This duplication of salesNumbers allows for a comprehensive view of all waste lines associated with a particular sales transaction, ensuring accurate tracking and management of waste generated or managed through sales activities.
Fields in the report¶
| Field Name | Format Type | Description |
|---|---|---|
| salesId | Number | The unique identifier for the sales record. |
| salesNumber | Text | Paperwork-generated unique identifier for this sales transaction. |
| wasteId | Number | The unique identifier for the waste record. |
| containerId | Number | The unique identifier for the container associated with the waste. |
| wasteType | Text | The waste type assigned to this waste, providing insight into waste allocation. |
| wasteDescription | Text | A description of the waste. |
| containerQuantity | Number | The quantity of containers associated with the waste. |
| containerName | Text | The type of the container used. |
| estimatedWeightVolume | Number | The estimated weight or volume of the waste. |
| weightVolumeUnit | Text | The unit of measurement for the estimated weight or volume (e.g., tonne, litre). |
| estimatedSpecificGravity | Number | The estimated specific gravity of the waste. |
| physicalForm | Text | The physical form of the waste (e.g., Liquid, Solid). |
| ewcCodes | Text | The list of European Waste Catalogue (EWC) code(s) associated with the waste. |
| wasteContainsHazardousWaste | Text | Indicates whether the waste is hazardous or not. |
| actions | Text | Actions related to the waste. |
| extraIds | Text | The list of the ids for the extras associated to the actions. |
| extras | Text | The list of the names of the extras associated to the actions. |
| chargingBasis | Text | The basis used for charging (e.g., Fixed, Container, Weight / Volume). |
| price£ | Number | The unit price in GBP (£) associated with the waste. |
| minimumNumberOfContainersToBeCharged | Number | The minimum number of containers to be charged. |
| minimumThresholdPerContainer | Number | The minimum threshold per container. |
| weightVolumeAllowanceIncludedWithTheContainerCharge | Number | The weight or volume allowance included with the container charge. |
| containerCharge | Number | The charge associated with the container. |
| totalPrice | Number | The total price associated with the waste. |
| caveat | Text | Any caveat or special consideration related to the waste. |
| privateNotes | Text | Private notes or comments related to the waste. |
| createdDate | Date/Time | The date and time when the waste record was created. |
| createdBy | Text | The user who created the waste record. |
| updatedDate | Date/Time | The date and time when the waste record was last updated. |
| updatedBy | Text | The user who last updated the waste record. |
Frequently asked questions¶
Why does my data have duplicate sales numbers in it?
Duplicate sales numbers may appear in your data due to the presence of multiple waste lines associated with a single sales transaction. Each waste line represents a distinct item or quantity of waste managed or generated through the same sales transaction, hence necessitating the duplication of sales numbers to accurately reflect this relationship in the dataset. This ensures comprehensive tracking and management of waste-related activities within the sales transactions.
What is a field?
A field refers to a single piece of data within a dataset, also known as a column or attribute. It represents a specific characteristic or attribute of the data being collected or analysed. For example, in a dataset of opportunity information, fields may include "department," "salesType," "customerSite," and "lostReason".
Why do your field names look funny?
We use a computer programming convention called camel case (more accurately lower camel case) where multiple words are combined into a single word, with each word (except the first one) capitalised and no spaces between the words. The name "camel case" comes from the capitalisation's resemblance to the humps of a camel.