Column Name

Data Type

Notes

Id

Int

Primary Key

CreatedAt

DateTime

UpdatedAt

DateTime

Primary Key

UpdatedBy

Nvarchar

E.g. User Email

DeliveryNo

Nvarchar

DeliveryDate

DateTime

DeliveryType

Nvarchar

E.g. Warehouse, Cash GrowerContract

Status

Nvarchar

CompletedAt

DateTime

SupplierId

Int

Foreign Key to join into Organisations table

Supplier

Nvarchar

Organisation Name

BuyerId

Int

Foreign Key to join into Organisations table

Buyer

Nvarchar

Organisation Name

Location

Nvarchar

Commodity

Nvarchar

Grade

Nvarchar

Gross

Decimal

Tare

Decimal

NetQuantity

Decimal

OrderId

Int

Foreign Key to join into Orders table

OrderNo

Nvarchar

ContractId

Int

Foreign Key to join into Contracts table

ContractNo

Nvarchar

FreightCarrier

Nvarchar

Season

Nvarchar

TransferDate

DateTime

TransferNo

Nvarchar

Variety

Nvarchar

VehicleAllowableGross

Decimal

VehicleDriver

Nvarchar

VehicleRegistration

Nvarchar

VehicleRegistrationState

Nvarchar

VehicleType

Nvarchar

Defective

Decimal

FallingNumbers

Decimal

FreeFattyAcid

Decimal

Impurities

Decimal

Moisture

Decimal

Oil

Decimal

Protein

Decimal

Purity

Decimal

Retention

Decimal

Screenings

Decimal

TestWeight

Decimal

Vitreous

Decimal

InvoiceId

Int

Foreign Key to join into Invoices table

InvoiceNo

Nvarchar

AdjustedPriceExTax

Decimal

Comments

Nvarchar

ContainerNo

Nvarchar

ContainerSeal1

Nvarchar

ContainerSeal2

Nvarchar

SupplierReference

Nvarchar