Column Name

Data Type

Notes

Id

Int

Primary Key

CreatedAt

DateTime

UpdatedAt

DateTime

Primary Key

UpdatedBy

Nvarchar

E.g. User Email

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

IsStockSwap

Bit

StockSwapRate

Decimal