| Name | Description | Type | Additional Information |
|---|---|---|---|
| MigratedQuantity |
Migrated contract quantity of the commodity (Rounded to commodity decimal accuracy) |
decimal number |
Required Cannot be negative Max of 4 decimal places |
| ContractType |
Type of the migrated contract |
PurchaseContractType |
Required |
| CashPrice |
Cash price established for the contract |
decimal number |
Max of 5 decimal places |
| FuturesPrice |
Futures price established for the contract |
decimal number |
Max of 5 decimal places |
| 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 |
| 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 |
| ContractID |
ID of the purchase contract (Required when autonumber is disabled) |
string |
Max length: 15 |
| DateEstablished |
Date the contract was established |
string |
Required Format must be MM/dd/yyyy |
| ExpireDate |
Expiration date of the contract |
string |
Format must be MM/dd/yyyy |
| PriceByDate |
Date by which the contract should be priced or rolled |
string |
Format must be MM/dd/yyyy |
| MigratedContractIsNewCropStatus |
Set to True if the new migrated contract should have a "New Crop" status - if not, new contract will be "Open" |
boolean | |
| ContractSigned |
Indicates whether or not the contract has been signed |
boolean | |
| SellerSignatureDateSignedToPrint |
The date the seller signed the contract. Only valid when ContractSiigned is true. |
string |
Format must be MM/dd/yyyy |
| FarmID |
Farm ID for the contract - free text field |
string |
Max length: 8 |
| SalespersonID |
ID of the salesperson associated with the contract |
string |
Max length: 15 |
| 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 |
| FreightOnBoard |
Indicates whether or not the contract includes freight in the established price |
boolean | |
| DirectShipped |
Flag that indicates if the purchase contract is to be treated as direct shipped |
boolean | |
| PricingNote |
Note related to pricing for the contract |
string |
Max length: 50 |
| MOTGuid |
The Method of Transportation Guid |
globally unique identifier | |
| AgvanceUserIDToAssignBuyerSignatureFrom |
The Agvance user id to use to assign the buyer signature |
string |
Max length: 3 |
| BuyerSignatureDateSignedToPrint |
The date the buyer's signature was applied to the contract (Only used with a valid AgvanceUserIDToAssignBuyerSignatureFrom set) |
string |
Format must be MM/dd/yyyy |
| BuyerSignatureDateTimeSignedUTC |
The date and time the buyer's signature was captured in UTC (Only used with a valid AgvanceUserIDToAssignBuyerSignatureFrom set) |
date | |
| DeliveryDates |
List of delivery dates for the contract |
Collection of ClsNewMigrateContractDeliveryDate |
Maximum of 200 allowed |
| Schedules |
List of Premium Discount schedules attached to the contract |
Collection of ClsNewMigrateContractSchedule | |
| Comments |
List of comments associated with the contract |
Collection of ClsNewMigrateContractComment |