Scale Tickets

Overview

The full representation of a Scale Ticket in our model is comprised of a number of individual objects.

Tickets: A Scale Ticket is the record or receipt of a Commodity in your system for when a Producer delivers their Commodity to a receiving facility. It contains weights and grades of said Commodity as well as general load information such as when the load was received.
Splits: A Split represents the assignment of ownership for a portion of the Ticket.
Ticket Applications: A Tickets relationships to other objects such as Contracts and Settlements can be represented via Ticket Applications. For for information on Ticket Applications, see: Ticket Applications

Addendums

In addition to the information about a Ticket displayed by default, Bushel’s Ticket Addendums offer a powerful way to augment the information stored in a Ticket. Addendums allow additional, arbitrary data points to be included with Tickets, effectively enabling the augmentation of the Ticket data model to support your specific needs. See our overview of Ticket Addendums for more information on the functionality and cababilities of this feature.

Displayed Tickets and Ticket Ownership

A User can view all Tickets that are associated with one of the User’s Accounts. A Ticket becomes associated to an Account in two ways.

Directly: The user_id of a Ticket indicates the Account associated with the Ticket.
Via Splits: The Splits on a Ticket provide additional associated Accounts. Each Split associated with a Ticket will associate the Ticket to the Account referenced in the Splits' user_id field.

Each user having at least one Account associated to a Ticket (either directly or through a Split) can view the full Ticket details, including Grade Factors and split accounts and percentages.

Sorting and Filtering

Sorting

Bushel sorts Tickets by delivery time, beginning with the most recently delivered Ticket. More information on how the sort order is determined is available at the Ticket Sort Method configuration.

Filtering

Bushel provides a number of convenient ways to filter the Ticket List, allowing users to quickly identify and isolate the Tickets they are interested in.

Filters for Commodity, time range, Account, and delivery Location are available by default. The list of available filter options within each Filter is determined from the Tickets viewable by the user. For example, only the Locations the user has delivered to will be availble in the Location filter rather than all of the Agribusiness' Locations. Any filter having less than two distinct values will not be presented to the user.

Figure 1. Available Ticket filters with time range and Account filters active

Additional filters from data in Ticket Addendums can also be specified. See our overview of Ticket Addendums for more information.

Sorting and Filtering

The Tickets page shows a list of all tickets associated with your linked accounts. A ticket is considered part of an account if that account is listed in the ticket’s user_id field or in any of its associated splits. Tickets are sorted started with the most recent Weigh-in or updated_at timestamp.

Clicking on a Ticket opens its details, including grade factors, delivery information, and any related Contracts or Settlements (if available).

You can filter the ticket list by several standard fields:

Commodity
Delivery Date
Account
Delivery Location

For more advanced filtering, you can create custom filters using any data sent in the ticket’s addendum object. If you know the specific ticket you’re looking for, you can also search directly by its ID.

Data Mapping

All fields are assumed to be from a ticket object unless otherwise noted.

# Name Description API Source

#	Name	Description	API Source
1	Ticket List	A high level overview of a ticket. Can be expanded to show ticket details
2	Ticket Number	The ticket number as it would be known to the producer or printed on a physical Scale Ticket	`display_id` if not `null`, `id` otherwise
3	Commodity Name	This is name of the commodity or crop that was delivered	The `display_name` of the Commodity with an `id` matching the Ticket’s `commodity_id`.
4	Date/Time	The timestamp of when the ticket was created, presented in the timezone of the viewers device.	If provided, `weigh_in_at` `created_at` otherwise If neither timestamp is accurate, the time component may be hidden with only the date displayed.
5	Delivery Location	The name of the location where the Commodity was delivered	The name of the Location with an `id` matching each Pricing Lines' `location_id`
6	Account	An identifier for the account responsible for the Ticket.	This value is highly configurable and can take many forms. Split If the Show Generic Split Name on Ticket List Configuration is enabled and Splits from multiple Accounts are associated with the Ticket, "Split" will be displayed. Ticket Account ID The `user_id` property of the Ticket can optionally be used, see: Display User from Ticket Configuration. Either the Account ID or the Account’s name will be displayed, depending on the Account ID Display Configuration. Largest Split Account ID `(default)` Of the Splits associated with the Ticket, the `user_id` property of the Split with the largest share is used to determine the Account. If multiple Splits have equal share, one will be selected at random. If no Account record is found for the Split, the Split’s `user_name` or `user_id` (depending on the Account ID Display Configuration) will be displayed. Custom Identifier An alternate property of a Ticket may be used to provide the value of Account ID. This is most frequently used in conjunction with Ticket Addendums. Hidden The Account ID field may also be hidden entirely from both the Ticket List and Detail views.
7	Net Units	The total amount of the Commodity delivered	`primary_net_weight`
8	Primary unit of measure	The unit of measure of the total amount of the Commodity delivered	`primary_weight_uom`
9	Highlighted Grade Factor value	The value of the highlighted Grade Factor for the Ticket.	`remarks.[n].grade_factor_value`, where `[n]` indicates the Grade Factor object with the `grade_factor` to highlight. The selected `grade_factor` is configurable by Commodity but will default to `Moisture`.
10	Highlighted Grade Factor label	The label of the highlighted Grade Factor for the Ticket.	`remarks.[n].grade_factor`, where `[n]` indicates the Grade Factor object with the `grade_factor` to highlight. The selected `grade_factor` is configurable by Commodity but will default to `Moisture`.
11	Driver	The name of the Truck Driver that delivered the Commodity, if available.	`truck_driver`
12	Truck	A description or identifier of the Truck that delivered the Commodity, if available.	`truck_name`
13	License	The license plate number of the Truck that delivered the Commodity.	`truck_license`
14	Weigh-in	The time the delivering truck was first weighed, prior to the Commodity being offloaded. This corresponds the time the Gross Weight measurement was taken.	`weigh_in_at`, localized to the timezone of the device displaying the data.
15	Weight-out	The time the delivering truck was weighed after the Commodity had been offloaded. This corresponds the time the Tare Weight measurement was taken.	`weigh_out_at`, localized to the timezone of the device displaying the data.
16	Gross Weight	The full, combined weight of the delivered Commodity in addition to the weight of the delivering truck.	`secondary_gross_weight`
17	Secondary weight unit of measure	The unit of measure corresponding to the 'secondary' weights. This is typically the same Unit of Measure as the scale at the receiving facility.	`secondary_weight_uom`
18	Tare Weight	The weight of the delivering truck, after the Commodity has been offloaded.	`secondary_tare_weight`
19	Net Weight	The weight of the delivered Commodity. This value should be equal to the Gross Weight less the Tare Weight.	`secondary_net_weight`
20	Gross Units	The full, combined amount of the delivered Commodity combined with the delivering Truck.	`primary_gross_weight`
21	Shrink Units	The number of units deducted from the received quantity due to excess moisture.	`primary_shrink_weight`
22	Split Owner	The name of the Account owning a portion of the Commodity delivered in this Ticket.	`split.user_name`
23	Split Percentage	The percentage of the delivered Commodity owned by the Account. All Splits with the same `remote_user_id` for the Ticket will be grouped together, summing the amounts.	When `split.amount_type` is `percentage`: `split.amount` When `split.amount_type` is `amount`: `100 * split.amount / primary_net_weight` If `split.amount_uom` differs from `primary_weight_uom`, Bushel will attempt to convert the amount into the same unit of measure.
24	Grade Factor name	The name of the Grade Factor.	`remark.[].grade_factor`
25	Grade Factor value	The value of the Grade Factor	`remark.[].grade_factor_value`
26	User-defined Field Name
27	Comments	Additional, free-form text with additional information relevant to the Ticket.	`comments`

Ticket List

A high level overview of a ticket. Can be expanded to show ticket details

Ticket Number

The ticket number as it would be known to the producer or printed on a physical Scale Ticket

display_id if not null, id otherwise

Commodity Name

This is name of the commodity or crop that was delivered

The display_name of the Commodity with an id matching the Ticket’s commodity_id.

Date/Time

The timestamp of when the ticket was created, presented in the timezone of the viewers device.

If provided, weigh_in_at created_at otherwise

If neither timestamp is accurate, the time component may be hidden with only the date displayed.

Delivery Location

The name of the location where the Commodity was delivered

The name of the Location with an id matching each Pricing Lines' location_id

Account

An identifier for the account responsible for the Ticket.

This value is highly configurable and can take many forms.

Split: If the Show Generic Split Name on Ticket List Configuration is enabled and Splits from multiple Accounts are associated with the Ticket, "Split" will be displayed.
Ticket Account ID: The user_id property of the Ticket can optionally be used, see: Display User from Ticket Configuration. Either the Account ID or the Account’s name will be displayed, depending on the Account ID Display Configuration.
Largest Split Account ID: (default) Of the Splits associated with the Ticket, the user_id property of the Split with the largest share is used to determine the Account. If multiple Splits have equal share, one will be selected at random. If no Account record is found for the Split, the Split’s user_name or user_id (depending on the Account ID Display Configuration) will be displayed.
Custom Identifier: An alternate property of a Ticket may be used to provide the value of Account ID. This is most frequently used in conjunction with Ticket Addendums.
Hidden: The Account ID field may also be hidden entirely from both the Ticket List and Detail views.

Net Units

The total amount of the Commodity delivered

primary_net_weight

Primary unit of measure

The unit of measure of the total amount of the Commodity delivered

primary_weight_uom

Highlighted Grade Factor value

The value of the highlighted Grade Factor for the Ticket.

remarks.[n].grade_factor_value, where [n] indicates the Grade Factor object with the grade_factor to highlight. The selected grade_factor is configurable by Commodity but will default to Moisture.

Highlighted Grade Factor label

The label of the highlighted Grade Factor for the Ticket.

remarks.[n].grade_factor, where [n] indicates the Grade Factor object with the grade_factor to highlight. The selected grade_factor is configurable by Commodity but will default to Moisture.

Driver

The name of the Truck Driver that delivered the Commodity, if available.

truck_driver

Truck

A description or identifier of the Truck that delivered the Commodity, if available.

truck_name

License

The license plate number of the Truck that delivered the Commodity.

truck_license

Weigh-in

The time the delivering truck was first weighed, prior to the Commodity being offloaded. This corresponds the time the Gross Weight measurement was taken.

weigh_in_at, localized to the timezone of the device displaying the data.

Weight-out

The time the delivering truck was weighed after the Commodity had been offloaded. This corresponds the time the Tare Weight measurement was taken.

weigh_out_at, localized to the timezone of the device displaying the data.

Gross Weight

The full, combined weight of the delivered Commodity in addition to the weight of the delivering truck.

secondary_gross_weight

Secondary weight unit of measure

The unit of measure corresponding to the 'secondary' weights. This is typically the same Unit of Measure as the scale at the receiving facility.

secondary_weight_uom

Tare Weight

The weight of the delivering truck, after the Commodity has been offloaded.

secondary_tare_weight

Net Weight

The weight of the delivered Commodity. This value should be equal to the Gross Weight less the Tare Weight.

secondary_net_weight

Gross Units

The full, combined amount of the delivered Commodity combined with the delivering Truck.

primary_gross_weight

Shrink Units

The number of units deducted from the received quantity due to excess moisture.

primary_shrink_weight

Split Owner

The name of the Account owning a portion of the Commodity delivered in this Ticket.

split.user_name

Split Percentage

The percentage of the delivered Commodity owned by the Account. All Splits with the same remote_user_id for the Ticket will be grouped together, summing the amounts.

When split.amount_type is percentage:
split.amount

When split.amount_type is amount:
100 * split.amount / primary_net_weight
If split.amount_uom differs from primary_weight_uom, Bushel will attempt to convert the amount into the same unit of measure.

Grade Factor name

The name of the Grade Factor.

remark.[].grade_factor

Grade Factor value

The value of the Grade Factor

remark.[].grade_factor_value

User-defined Field Name

Comments

Additional, free-form text with additional information relevant to the Ticket.

comments

Configurations

Alternative Feature Name

The display name of this feature can be customized. A modified name will be used in place of the default name wherever the feature name is displayed including navigation menus and headings.

Decimal Place Formats

The number of digits following the decimal point for various categories of numbers is customizable. This is a global config and will affect all features that display the relevant number.

Price

Default: 2

This is used wherever prices are displayed.

Amount

Default: 2

This is used to format quantities that have a volumetric or spatial Unit of Measure, such as Bushels and Acres.

Weight

Default: 2

This is used to format quantities that have a Unit of Measure of mass or weight, such as hundredweight and metric tons.

Cash Bid

Default: 2

This is used to format cash bid prices.

Offer

Default: 2

Account ID Display

The Account associated with this object can be displayed in two ways:

Full Name: (default) The concatenation of first_name and last_name from the Account associated with the object.
Account ID: The id from the Account associated with the object.

Get Account ID from Ticket instead of Splits

If enabled, the Account identifier for the Ticket will be determined from the user_id field of the Ticket.

The Account will be displayed according to the Account ID Configuration

Often used in conjunction with the Enable Filtering by Delivery Account ID configuration.

Enable Filtering by Delivery Account ID

Default: false

When enabled, Delivery Accounts are included in the options for the Account filter in addition to the accounts listed in Splits. Often used in conjunction with Get Account ID from Ticket instead of Splits.

Show 'Split' for Account ID on Ticket List

If enabled and the Ticket has Splits associated with more than one Account, the word "Split" will be displayed instead of an Account identifier.

Otherwise, the Account identifier as determiend by the Account ID Configuration will be displayed.

Hide Account ID from Ticket List and Detail

The Account ID field may be removed from both the Ticket List and Ticket Detail views.

Alternate Account ID Mapping

An alternate property of a Ticket may be used to provide the value of Account ID. Defining an alternate property to use as the Account ID of the Ticket is useful when the user_id on the Ticket represents (for example) the trucking company rather than the producing farm. This configuration is most frequently used in conjunction with Ticket Addendums, where the Alternate Account ID is sent as an Addendum property.

Ticket List Grade Factor

Default: Moisture

The selected Grade Factor displayed alongside each Ticket is configurable by Commodity.

Grade Factors Allowlist

A list of Grade Factors to show to the end user may be provided if it is not desirable to display the full list.

If configured, only the Grade Factors included in the Allowlist will be displayed to the end user. CSV exports will have a separate column for each Grade Factor in the Allowlist.

By default, this configuration is not set and every Grade Factor on a Ticket is shown. CSV exports will contain a single column with all Grade Factor names and values, separated by a comma.

Show Comments on Tickets

Default: true

Comments are free-form text that is displayed with a Ticket. Comments attached to a Ticket are displayed to users by default. If desired, this configuration can prevent comments from being displayed.

Ticket Sort Method

By default, Bushel sorts Tickets by their arrival time at the receiving facility with the most recently delivered Tickets presented at the top of the list. A Tickets arrival time is determined from from the weigh_in_at property, falling back to the created_at timestamp when weigh_in_at is not set or available.

If neither of these timestamps is available or reliable in your integration, Tickets may also be sorted by their display_id. See Ticket Sort Method for more information.

Ignore Splits with an Amount of 0

Default: false

If enabled, any Split with an amount of 0 will be ignored by Bushel’s system. These Splits will not be displayed to Users and will not be considered when determining which Accounts a Ticket is associated with.

Hide Created Time

If enabled, only the Date portion of the Ticket’s created at time will be displayed in both Ticket Details and the List view. The label will change from "Date/Time" to "Date". This configuration is useful when both the weigh_in_at and created_at timestamps on the Ticket are not representative of when the Ticket was delivered, such as systems that create database records for Tickets daily rather than continuously.