NameDescriptionTypeAdditional Information
CommodityId

Commodity ID of the record - must exist in Agvance

string

Required

Max length: 6

LocationId

Location ID of the record - when populated must exist in Agvance

string

Max length: 6

ExchangeId

Exchange ID of the record - when populated must exist in Agvance

string

Max length: 10

BidCriteriaId

Bid Criteria ID of the record - when populated must exist in Agvance

string

Max length: 20

FutMonth

Futures Month ID of the record

string

Required

Max length: 10

StartingDeliveryPeriod

The starting delivery period for the record (only the date portion is used)

date
EndingDeliveryPeriod

The ending delivery period for the record (only the date portion is used)

date
FutMoEndDate

Required for the Adds ONLY - the date that this futures price becomes no longer valid (only the date portion is used)

date
FuturesPrice

The Futures Price of the record

decimal number

Max of 4 decimal places

FuturesPriceDateTimeLocal

The date and time the Futures Price was captured in Local Time (if null and Futures Price is set, will be the current locations date and time)

date
BasisPrice

The Basis Price of the record

decimal number

Max of 4 decimal places

BasisDateTimeLocal

The date and time the Basis Price was captured in Local Time (if null and Basis Price is set, will be the current locations date and time)

date
CommoditySymbol

The market symbol that represents this commodity and futures month on the trading platform

string

Max length: 10

FutureMonthAliasId

An alternate identifying record for the futures month - when populated must exist in Agvance

string

Max length: 20

IndustryCode

The Industry Code of the record

string

Max length: 20