| Sequence Line Item Columns |
|---|
| Column Name | Description |
|---|
| Sequence | System assigned |
| Status | System assigned |
| Start Date | Time period for delivery (used mostly for planning). |
| End Date | Time period for delivery (used mostly for planning). |
| Planned Availability | More for manufacturing. |
| Event Start Date | |
| Updated Availability | |
| Location | Customer's physical location (from or to). |
| Book | A way to group business (contracts). Used in reporting and the Derivatives screen. |
| Sub-book | The next granular level to Book. |
| Contract Item | |
| Item | The specific item that is expected to be received for a given commodity. |
| Item Specification | |
| Origin | |
| Purchasing Group | |
| Farm No | Setup specific farm that is associated with the sequence. |
| Grade | |
| Garden | |
| Vendor Lot ID | |
| Reference | |
| Quantity / UOM | Can have different UOM than contract header. Not typical. |
| Net Weight / UOM | |
| Packing Description | Examples: bulk, bagged, etc. |
| Original Quantity | |
| Unit/Layer | |
| Layers/Pallet | |
| No. of Sequences | |
| No. of Lots | Number of futures contracts needed to hedge this contract. Not typically used in grain. |
| Container Type | |
| No. of Containers | |
| Market Zone | Used for valuation of grain. Determines where the title (ownership) is transfered during shipment. |
| Discount | |
| Discount Table | Some grades shrink the volume, some affect the price and some can do both. Can also vary by customer and geographic location. |
| Schedule Code | |
| Option | |
| Split | Allows the ability to split the sequence between mulitiple producers. |
| Pricing | Note: the columns in this section will vary based on the contracts price type. | |
|---|
| Fixation By | | | Pricing Type | Defaults to the contract pricing type | | Currency | | | Futures Market | | | Mn/Yr | Futures month | | Futures | Future price | | Basis | Futures plus basis | | Cash Price | Comprised of amount and UOM | | Total Cost | Quantity x Cash Price |
|
| ERP | | |
|---|
| ERP PO No | | | ERP Item No | | | ERP Batch No | |
|
| FX Tab | | |
|---|
| Invoice Currency | Currency that should be used for invoicing | | Fx Valid From / To | | | Currency Pair | | | Exchange Rate | | | FX Price | | | Rate Type | | | FX Price UOM | | | FX Remarks | | | Assumed FX for Marginal Risk Report | |
|
| Miscellaneous Tab | | |
|---|
| 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 | |