| 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 |
| What you are expecting to receive (basket item). |
| Item | The specific item that is expected to be received for a given commodity. Name of the basket for example. |
| Item Specification | |
| Origin |
| Where the item originates. |
| Purchasing Group |
| To establish a profit center (specific to JDE, SAP integrations). |
| Farm No | Setup specific farm that is associated with the sequence. |
| Grade |
| Specific to Tea |
| Vendor Lot ID |
| Related to Garden (lot of a specific garden). |
| Reference |
| Just a text field. |
| Quantity / UOM | Can have different UOM than contract header. Not typical. |
| Net Weight / UOM |
| Net weight of the product. |
| Packing Description | Examples: bulk, bagged, etc. |
| Original Quantity |
| How many units per pallet. |
| Layers/Pallet |
| How many layers of product per pallet. |
| No. of Sequences | |
| No. of Lots | Number of futures contracts needed to hedge this contract. Not typically used in grain. |
| Container Type |
| Type of container in which item is being shipped. |
| No. of Containers |
| How many containers make up the container type. |
| Market Zone | Used for valuation of grain. Determines where the title (ownership) is transfered during shipment. |
| Discount |
| Determines where discounts take place. |
| Discount Table | Some 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 Code |
| For polorization (what is the percent of sugar can be extracted from the product?). |
| Option |
| Not Used. |
| 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. |
| Determines who is able to fix the price. | | 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 | |
| The PO number that was generated by the integrated software (e.g. SAP, JDE, etc.). | | ERP Item No |
|
| The Item number that was generated by the integrated software (e.g. SAP, JDE, etc.). | | 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 | | The Batch number that was generated by the integrated software (e.g. SAP, JDE, etc.). |
|
| 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 | |