Contracts

Overview

Contracts

A contract represents the purchase agreement of a commodity between two parties. It captures and reflects all of the terms of this agreement including pricing, quantity, and delivery timeframes and locations. Bushel utilizes Contract, Pricing Line, and Pricing History objects that together capture the data points and complexities that exist within contracts. Like most objects in Bushel’s system, these objects reflect the current state of the Contract and do not contain historical data such as terms that have been updated and no longer apply to the Contract.

Pricing Lines

Contract Pricing Lines contain the majority of the pricing and delivery information that make up the Contract. For more information, see Pricing Lines & Histories.

Ticket Applications

Tickets that have been applied to the Contract as well as Settlements associated to the Contract can be linked to and shown in the Contract details by a Ticket Application record. For more information, see Ticket Applications.

Sorting and Filtering

The Contracts page shows a list of all Contracts tied to any Accounts linked to the current user. You can filter this list by Commodity, Delivery Date, Contract Status, Contract Type, Account, and Delivery/Contracted Location.

Clicking on a Contract opens its details, including pricing, delivery information, and any related Settlements or Tickets (if available). You can also search for Contracts directly using their ID.

Contracts are sorted first by Status, then by final Delivery Date:

Open Contracts appear at the top, ordered from the nearest to the farthest delivery date.
Closed Contracts are listed below the Open ones, in reverse – starting from the most recent delivery date and going backward.

Data Mapping

# Name Description API Source

#	Name	Description	API Source
1	Contract List	A high level overview of a contract. Can be expanded to show contract details
2	Contract Number	The contract number as it would be known to the producer	`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 Contract’s `commodity_id`.
4	Delivery Location	The name of the Location(s) that will receive the commodity	The name of the Location with an `id` matching each Pricing Lines' `location_id`
5	Delivery Period	The timeframe during which the Commodity can be brought to the Delivery Location to fulfill the Contract	The timezone-adjusted dates of `delivery_period_start` and `delivery_period_end`
6	Contract Type	The delivery and pricing mechanism of the contract, e.g. "Basis", "HTA", "Delayed Price", "Spot"	`type` and/or `subtype` See: Contract Type Display Format
7	Contracted Quantity	The total amount of grain that was expected to be delivered. This should be the sum of `quantity_delivered` and `quantity_canceled`	`quantity_contracted`
8	Contract UOM	The unit of measure of the contracted quantity of the Commodity	`quantity_uom`
9	Pricing Status	A contract may display 4 different values as the pricing status: The Dollar Value If all Pricing Lines are Priced (see below) and have the same cash_price Priced If all Pricing Lines are Priced*, but have different cash prices Partial If the total quantity of all Priced Pricing Lines is less than the `quantity_contracted` Unpriced If one or more Pricing Lines is not Priced OR the sum of `quantity_priced` from all Pricing Lines is less than the Contract’s `quantity_contracted`
10	Contract Status	"Whether or not all of the contracts obligations have been completed. Valid values are either 'Open' or 'Closed'."	"Open" if `is_closed` is `false` "Closed" if `true`
11	Quantity Remaining to be Delivered	A visual representation of how much of the contract has been delivered	Determined from `quantity_contracted`, `quantity_delivered`, `quantity_canceled`
12	Contract Details	A detailed view of the Contract, displayed when the user expands a Contract in the Contract List (1) view
13	Account	The identifier or name of the counterparty’s account.	The Account ID associated with this record is determined by the Contract’s `user_id`. See: Account ID Selector for display options.
14	Contracted Location	The name of the Location where the Contract was signed.	The name of the Location with an `id` matching the Contract’s `location_id`
15	Signature Status	The current state of gathering a signature for the contract from the counterparty. Examples include: "Signed", "Unsigned", "No Signature Required", "Pending"	`signature_status`
16	Crop Year	The full, 4-digit year of the growing season of the contracted Commodity	`crop_year`
17	Quantity Delivered	The amount of the Commodity for this contract that has been delivered to the Delivery Location(s).	`quantity_delivered`
18	Quantity Remaining	The amount of the Commodity for this contract that has yet to be delivered to the Delivery Location(s), less the canceled quantity.	`quantity_contracted – (quantity_canceled + quantity_delivered)`
19	Quantity Canceled	The amount of the originally contracted quantity that has been canceled and will no longer be priced or delivered.	`quantity_canceled`
20		The amount of the contract that has a determined pricing, whether by being priced or canceled.	The sum of `quantity_priced` from all Pricing Lines that have been priced* in addition to the `quantity_canceled` from all Pricing Lines.
21	Quantity Priced	The amount of the contract for which the Cash Price is determined and set.	The sum of the `quantity_priced` from all Pricing Lines that have been priced*.
22	Quantity Unpriced	The amount of the contract that has not been canceled and does not yet have a Cash Price.	`quantity_contracted – (quantity_canceled + Quantity Priced)`
23	Quantity Canceled	The amount of the originally contracted amount that has been canceled and no longer needs to be priced or delivered.	The sum of `quantity_canceled` from all Pricing Lines.
24	Pricing & Delivery Summary	A high-level overview of all of the individual Pricing Lines associated with the Contract
25	Pricing Line Identifier	The pricing line identifier as it would be known to the producer.	`pricing_line.display_id` if not `null` `pricing_line.id`, otherwise
26	Pricing Line Amount	The amount of the contract covered by this Pricing Line.	`pricing_line.quantity_priced`
27	Futures Price	The value of one unit of the commodity in the Futures Market for the Futures Month the Pricing Line is priced against.	`pricing_line.futures_price`
28	Basis Price	The Basis, or difference between the Cash Price and Futures Price (less any additional Adjustments).	`pricing_line.basis_price`
29	Adjustments	The total of all per-unit-of-measure premiums or deductions applied to the contract price that are not reflected in the Basis. This value is calculated from the Pricing Histories records associated with this Pricing Line.	The sum of all Pricing Histories associated with the Pricing Line with a `mode` equal to "`per_unit`" and `type` not equal to "`basis`" or "`futures`"
30	Cash Price	The monetary 'cash' value of one unit of the commodity.	`pricing_line.cash_price`
31	Created At	The date/time the contract was created.
*A Pricing Line is determined to be Priced if both `futures_price` and `basis_price` are non-`null`.

Contract List

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

Contract Number

The contract number as it would be known to the producer

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 Contract’s commodity_id.

Delivery Location

The name of the Location(s) that will receive the commodity

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

Delivery Period

The timeframe during which the Commodity can be brought to the Delivery Location to fulfill the Contract

The timezone-adjusted dates of delivery_period_start and delivery_period_end

Contract Type

The delivery and pricing mechanism of the contract, e.g. "Basis", "HTA", "Delayed Price", "Spot"

type and/or subtype

See: Contract Type Display Format

Contracted Quantity

The total amount of grain that was expected to be delivered. This should be the sum of quantity_delivered and quantity_canceled

quantity_contracted

Contract UOM

The unit of measure of the contracted quantity of the Commodity

quantity_uom

Pricing Status

A contract may display 4 different values as the pricing status:

The Dollar Value: If all Pricing Lines are Priced (see below) and have the same cash_price
Priced: If all Pricing Lines are Priced*, but have different cash prices
Partial: If the total quantity of all Priced Pricing Lines is less than the quantity_contracted
Unpriced: If one or more Pricing Lines is not Priced OR the sum of quantity_priced from all Pricing Lines is less than the Contract’s quantity_contracted

Contract Status

"Whether or not all of the contracts obligations have been completed. Valid values are either 'Open' or 'Closed'."

"Open" if is_closed is false

"Closed" if true

Quantity Remaining to be Delivered

A visual representation of how much of the contract has been delivered

Determined from quantity_contracted, quantity_delivered, quantity_canceled

Contract Details

A detailed view of the Contract, displayed when the user expands a Contract in the Contract List (1) view

Account

The identifier or name of the counterparty’s account.

The Account ID associated with this record is determined by the Contract’s user_id.

See: Account ID Selector for display options.

Contracted Location

The name of the Location where the Contract was signed.

The name of the Location with an id matching the Contract’s location_id

Signature Status

The current state of gathering a signature for the contract from the counterparty.

Examples include: "Signed", "Unsigned", "No Signature Required", "Pending"

signature_status

Crop Year

The full, 4-digit year of the growing season of the contracted Commodity

crop_year

Quantity Delivered

The amount of the Commodity for this contract that has been delivered to the Delivery Location(s).

quantity_delivered

Quantity Remaining

The amount of the Commodity for this contract that has yet to be delivered to the Delivery Location(s), less the canceled quantity.

quantity_contracted – (quantity_canceled + quantity_delivered)

Quantity Canceled

The amount of the originally contracted quantity that has been canceled and will no longer be priced or delivered.

quantity_canceled

The amount of the contract that has a determined pricing, whether by being priced or canceled.

The sum of quantity_priced from all Pricing Lines that have been priced* in addition to the quantity_canceled from all Pricing Lines.

Quantity Priced

The amount of the contract for which the Cash Price is determined and set.

The sum of the quantity_priced from all Pricing Lines that have been priced*.

Quantity Unpriced

The amount of the contract that has not been canceled and does not yet have a Cash Price.

quantity_contracted – (quantity_canceled + Quantity Priced)

Quantity Canceled

The amount of the originally contracted amount that has been canceled and no longer needs to be priced or delivered.

The sum of quantity_canceled from all Pricing Lines.

Pricing & Delivery Summary

A high-level overview of all of the individual Pricing Lines associated with the Contract

Pricing Line Identifier

The pricing line identifier as it would be known to the producer.

pricing_line.display_id if not null

pricing_line.id, otherwise

Pricing Line Amount

The amount of the contract covered by this Pricing Line.

pricing_line.quantity_priced

Futures Price

The value of one unit of the commodity in the Futures Market for the Futures Month the Pricing Line is priced against.

pricing_line.futures_price

Basis Price

The Basis, or difference between the Cash Price and Futures Price (less any additional Adjustments).

pricing_line.basis_price

Adjustments

The total of all per-unit-of-measure premiums or deductions applied to the contract price that are not reflected in the Basis. This value is calculated from the Pricing Histories records associated with this Pricing Line.

The sum of all Pricing Histories associated with the Pricing Line with a mode equal to "per_unit" and type not equal to "basis" or "futures"

Cash Price

The monetary 'cash' value of one unit of the commodity.

pricing_line.cash_price

Created At

The date/time the contract was created.

*A Pricing Line is determined to be Priced if both futures_price and basis_price are non-null.

Configurations

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.

Contract Type Display Format

The display of Contract Type may be customized to display one of the following:

type only (e.g. Purchase)
type – subtype (e.g. Sales – Basis)
subtype only (e.g. Basis)
subtype – type (e.g. Cash – Purchase)

Contract Type Filter

The option to filter Contracts either by type or subtype is also available. If set, a ‘Contract Type’ filter option is available alongside the other Contract filters. This filter is configurable to operate on either the Contracts ‘type’ (e.g. ‘Purchase’ or ‘Sales’) or ‘subtype’ (e.g. ‘Basis’, ‘HTA’).