| Name | Description | Type | Additional Information |
|---|---|---|---|
| ContractID |
ID of the purchase contract |
string |
Max length: 15 |
| LocationID |
ID of the delivery location for the contract |
string |
Required Max length: 6 |
| CustomerID |
ID of the customer on the contract |
string |
Required Max length: 6 |
| CommodityID |
ID of the commodity on the contract |
string |
Required Max length: 6 |
| DateEstablished |
Date the contract was established |
string |
Required Format must be MM/dd/yyyy |
| ContractType |
Type of contract |
PurchaseContractType |
Required |
| ContractStatus |
Current status of the contract |
PurchaseContractStatus |
Required |
| CashPrice |
Cash price established for the contract |
decimal number |
Max of 5 decimal places |
| ContractQuantity |
Contracted quantity of the commodity |
decimal number |
Required Cannot be negative |
| BasisPrice |
Difference between the futures price and cash price |
decimal number |
Max of 5 decimal places |
| FuturesMonthID |
ID of the futures month used for the futures price |
string |
Max length: 10 |
| ExchangeID |
ID of the exchange used to establish the price |
string |
Max length: 10 |
| StrikePrice |
Price at which a futures contract can be bought or sold |
decimal number |
Max of 5 decimal places |
| ExpireDate |
Expiration date of the contract |
string |
Format must be MM/dd/yyyy |
| FuturesPrice |
Futures price established for the contract |
decimal number |
Max of 5 decimal places |
| ContractSigned |
Indicates whether or not the contract has been signed |
boolean | |
| BidCriteriaID |
ID for the terms of the bid |
string |
Max length: 20 |
| ShippingDestinationID |
ID of the shipping destination to apply to the contract |
string |
Max length: 6 |
| SalespersonID |
ID of the salesperson associated with the contract |
string |
Max length: 15 |
| PricingNotes |
Note related to pricing for the contract |
string |
Max length: 50 |
| PriceByDate |
Date by which the contract should be priced or rolled |
string |
Format must be MM/dd/yyyy |
| FreightOnBoard |
Indicates whether or not the contract includes freight in the established price |
boolean | |
| ExternalContractID |
Reference ID from another source to be stored with the contract |
string |
Max length: 50 |
| ContractFormat |
The format used to create the physical contract to sign. NOTE: This is required when the database column exists and no defaults are set in Agvance. |
string |
Max length: 50 |
| DirectShipped |
Flag that indicates if the purchase contract is to be treated as direct shipped |
boolean | |
| AgvanceUserIdToAssignBuyerSignatureFrom |
The Agvance user id to use to assign the buyer signature |
string | |
| BuyerSignatureDateSignedToPrint |
The date the buyer's signature was applied to the contract (Only used with a valid AgvanceUserIdToAssignBuyerSignatureFrom set) |
date | |
| BuyerSignatureDateTimeSignedUtc |
The date and time the buyer's signature was captured in UTC (Only used with a valid AgvanceUserIdToAssignBuyerSignatureFrom set) |
date | |
| SpotContract |
Setting to determine if the purchase contract is a "Spot" type, Priced contract |
boolean | |
| FarmId |
Farm ID for the contract - free text field |
string |
Max length: 8 |
| MOTGuid |
The Method of Transportation Guid |
globally unique identifier | |
| SellerSignatureDateSignedToPrint |
The date the seller signed the contract. Only valid when ContractSiigned is true. Only the date portion is used. |
date | |
| PurchaseContractComments |
List of comments associated with the contract |
Collection of ClsGrPurConCommAdd | |
| PurchaseContractDeliveryDates |
List of delivery dates for the contract |
Collection of ClsGrPurConDdAdd | |
| PurchaseContractSchedules |
List of Premium Discount schedules attached to the contract |
Collection of ClsGrPurConGfAdd | |
| PurchaseContractMinimumPriceInfo |
List of minimum price roll records |
Collection of ClsGrPurConRollAdd |