| Column Name | Data Type | Notes |
| Id | Int | Primary Key |
| CreatedAt | DateTime | |
| UpdatedAt | DateTime | Primary Key |
| OrderNo | Nvarchar | |
| OrderDate | DateTime | |
| OriginType | Nvarchar | |
| Status | Nvarchar | E.g. AwaitingDeliveries, InProgress, Complete, Cancelled, Unfulfilled |
| OriginContractId | Int | Foreign Key to join into Contracts table |
| OriginContractNo | Nvarchar | |
| DestinationType | Nvarchar | |
| DestinationContractId | Int | Foreign Key to join into Contracts table |
| DestinationContractNo | Nvarchar | |
| OriginReference | Nvarchar | |
| DestinationReference | Nvarchar | |
| Commodity | Nvarchar | |
| OriginLocation | Nvarchar | |
| OriginGrade | Nvarchar | |
| DestinationLocation | Nvarchar | |
| DestinationGrade | Nvarchar | |
| Quantity | Decimal | |
| QuantityDelivered | Decimal | |
| StartDate | DateTime | |
| EndDate | DateTime | |
| CreatedByOrg | Nvarchar | Organisation Name |
| OriginComments | Nvarchar | |
| DestinationComments | Nvarchar | |
| Tolerance | Nvarchar | |
| FreightCarrier | Nvarchar | |
| FreightRate | Decimal | |
| FreightComments | Nvarchar |