Sequence Line Item Columns |
---|
Column Name | Description |
---|
Sequence | Numeric, System assigned |
Status | System assigned, possible values: Open Unconfirmed Cancelled Re-Open Complete Short Close |
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 |
Indicates when a significant event occurs (e.g. product leaves port). Works in conjunction with Updated Availability date. |
Updated Availability |
Date to determine when the product will be available (esp. ocean bound freight). |
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 |
Free form, informational text |
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 typicalThis is the unit of measure that should be displayed on the invoice for a sales contract or Voucher for a purchase contract. |
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 |
The Slice (Replicate Contract) window will open if the user enters a positive number and clicks Save. |
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 | |