Sequence Line Item Columns
Column NameDescription
Sequence

Numeric, System assigned

StatusSystem assigned, possible values:

Open
Unconfirmed
Cancelled
Re-Open
Complete
Short Close

Start DateTime period for delivery (used mostly for planning).
End DateTime period for delivery (used mostly for planning).
Planned AvailabilityMore for manufacturing.
Event Start DateIndicates when a significant event occurs (e.g. product leaves port). Works in conjunction with Updated Availability date.
Updated AvailabilityDate to determine when the product will be available (esp. ocean bound freight).
LocationCustomer's physical location (from or to).
BookA way to group business (contracts). Used in reporting and the Derivatives screen.
Sub-bookThe next granular level to Book.
Contract ItemWhat you are expecting to receive (basket item).
ItemThe specific item that is expected to be received for a given commodity. Name of the basket for example.
Item SpecificationFree form, informational text
OriginWhere the item originates.
Purchasing GroupTo establish a profit center (specific to JDE, SAP integrations).
Farm NoSetup specific farm that is associated with the sequence.
GradeGrades the item.
GardenSpecific to Tea
Vendor Lot IDRelated to Garden (lot of a specific garden).
ReferenceJust a text field.
Quantity / UOM

Can have different UOM than contract header.

This is the unit of measure that should be displayed on the invoice for a sales contract or Voucher for a purchase contract.

Net Weight / UOMNet weight of the product.
Packing DescriptionExamples: bulk, bagged, etc.
Original QuantityNot used.
Unit/LayerHow many units per pallet.
Layers/PalletHow many layers of product per pallet.
No. of SequencesThe Slice (Replicate Contract) window will open if the user enters a positive number and clicks Save.
No. of LotsNumber of futures contracts needed to hedge this contract. Not typically used in grain.
Container TypeType of container in which item is being shipped.
No. of ContainersHow many containers make up the container type.
Market ZoneUsed for valuation of grain. Determines where the title (ownership) is transfered during shipment.
DiscountDetermines where discounts take place.
Discount TableSome grades shrink the volume, some affect the price and some can do both. Can also vary by customer and geographic location. This causes the Ticket to default when created.
Schedule CodeFor polorization (what is the percent of sugar can be extracted from the product?).
OptionNot Used.
SplitAllows the ability to split the sequence between mulitiple producers.
Pricing
Note: the columns in this section will vary based on the contracts price type.
Column
Description
Fixation ByDetermines who is able to fix the price.
Pricing TypeDefaults to the contract pricing type
Currency 
Futures Market 
Mn/YrFutures month
FuturesFuture price
BasisFutures plus basis
Cash PriceComprised of amount and UOM
Total CostQuantity x Cash Price
ERP
Column
Description
ERP PO NoThe PO number that was generated by the integrated software (e.g. SAP, JDE, etc.).
ERP Item NoThe Item number that was generated by the integrated software (e.g. SAP, JDE, etc.).
ERP Batch NoThe Batch number that was generated by the integrated software (e.g. SAP, JDE, etc.).
Miscellaneous Tab
Column
Descriptions
Pickup/Deliver 
Ship Via 
Farm Invoice No 
Producer 
Claims to Producer 
Fronting 
Invoice 
Provisional Invoice 
Quantity Final 
Certifications 
Marks 
History Tab 
Activities Tab 
Events Tab 
  • No labels