Column Name | Data Type | Notes |
Id | Int | Primary Key |
CreatedAt | DateTime | |
UpdatedAt | DateTime | Primary Key |
UpdatedBy | Nvarchar | E.g. User Email |
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 |