| Column Name | Data Type | Notes |
| Id | Int | Primary Key |
| CreatedAt | DateTime | |
| UpdatedAt | DateTime | Primary Key |
| ContractNo | Nvarchar | |
| ContractDate | DateTime | |
| ContractType | Nvarchar | E.g. Sale, Purchase |
| PriceBasis | Nvarchar | E.g. DeliveredGrower, ExFarm |
| CounterpartyId | Int | Foreign Key to join into Organisations table |
| Counterparty | Nvarchar | Organisation Name |
| Location | Nvarchar | |
| Commodity | Nvarchar | |
| Grade | Nvarchar | |
| Quantity | Decimal | |
| Price | Decimal | |
| QuantityDelivered | Decimal | |
| DeliveryStart | DateTime | |
| DeliveryEnd | DateTime | |
| CounterPartyReference | Nvarchar | |
| Variety | Nvarchar | |
| TimeOfDelivery | Nvarchar | |
| Season | Nvarchar | |
| PaymentTerms | Nvarchar | |
| PaymentScales | Nvarchar | |
| DeliveryWeights | Nvarchar | |
| DeliveryTolerance | Nvarchar | |
| DeliveryInspection | Nvarchar | |
| Packaging | Nvarchar | |
| Currency | Nvarchar | E.g. AUD |
| CarryStartDate | DateTime | |
| CarryAmount | Decimal | |
| CarryFrequency | Nvarchar | E.g. Monthly |
| BrokerReference | Nvarchar | |
| BrokerageRateType | Nvarchar | E.g. DollarsPerMetricTon, Percentage |
| BrokerageRate | Decimal | |
| BrokerContact | Nvarchar | |
| Broker | Nvarchar | |
| FreightAccrual | Decimal | |
| Comments | Nvarchar | |
| LocationState | Nvarchar | |
| LocationSiteOperator | Nvarchar |