Purchase Contract Line - Analysis (tdpur3513m000)

Use this session to have a results analysis for a purchase contract line based on its cumulated quantities and amounts.

If the purchase contract line is a Total line, the line includes the aggregated quantities of its Detail lines, that is purchase contract line details, which are always linked to push schedules. Consequently, the values on the Quantities and Aggregated Quantities tabs are equal for the purchase contract line.

A purchase contract Total line can also be linked to a purchase order line. If this happens, the values on the Quantities tab include the aggregated values of its purchase contract line details, increased by the contract line values generated for the purchase order line. Consequently, the Quantities and Aggregated Quantities tabs have different field values and the Quantity Mismatch check box is selected.

Note: The availability of various fields depends on the setting of the Log Turnover on Contract check box in the Purchase Contract Parameters (tdpur0100m300) session.

Field Information

Contract

The number of the purchase contract.

Contract Line Status

The status of the purchase contract line.

You can assign a status to each contract line with the following commands:

  • Activate
  • De-activate
  • Terminate
Note: 
  • For purchase contracts with the Free or Active status in the Purchase Contracts (tdpur3100m000) session, you can specify new contract lines.
  • You can maintain the status at contract level in the Purchase Contracts (tdpur3100m000) session. In this case, all contract lines of a contract obtain the same status.

Allowed values

Free

When a contract (line) is created, the contract line status is set to Free. If the status is Free, and change requests are not used for purchase contracts , you can change the contract (line).

Active

You can link orders, schedules, and quotations to a contract (line) with the Active status.

Terminated

When a contract (line) is terminated, the contract (line) can no longer be used.

Line

The number of the purchase contract line.

Sequence

The number of the purchase contract line detail.

Contract Line Type

The type of contract line.

  • Total

    The contract line is split up in several contract line details. The totaled quantities and amounts are visible on this line.

  • Contract Line

    This line is a normal line. The line is created manually or is generated automatically.

  • Detail

    This line is a purchase contract line detail.

Purchase Office

purchase office

Buy-from Business Partner

buy-from business partner

Item

item

Quantities
Current Date

The current date and time, which is filled automatically when you start this session.

Effective Date

effective date

Expiry Date

The expiry date of the contract.

Time Elapsed (%)

The time elapsed is expressed as a percentage of the total contract duration, as specified in the Purchase Contracts (tdpur3100m000) session.

The calculation for the time elapsed:

(Current Date - Effective Date ÷ ((Expiry Date - Effective Date) + 1)) * 100%
Agreed Quantity

The contract quantity expressed in the purchase unit.

Purchase Unit

purchase unit

Agreed Quantity in Inventory Unit

The contract quantity expressed in the inventory unit.

Inventory Unit

inventory unit

Used Quantity

The total number of called and invoiced items for the contract line, expressed in the purchase unit.

Used Quantity

The total number of called and invoiced items for the contract line, expressed in the inventory unit.

Usage (%)

The total number of called and invoiced items, expressed as a percentage of the agreed contract quantity.

Remaining Quantity

The remaining quantity, expressed in the purchase unit.

The calculation for the remaining quantity:

Agreed quantity - Called quantity - Invoiced quantity
Remaining Quantity

The remaining quantity, expressed in the inventory unit.

The calculation for the remaining quantity:

Agreed quantity - Called quantity - Invoiced quantity
Remaining Usage

The total number of remaining items that is not called or invoiced, expressed as a percentage of the agreed contract quantity.

Expected Quantity

The calculated quantity that you expect to have purchased at the end of the contract, expressed in the purchase unit. This calculation is extrapolated from the contract's ordered quantity that is registered during the part of the effective period that has passed.

The calculation for the expected quantity:

(Used Quantity ÷ Elapsed time in %) * 100%
Expected Quantity

The calculated quantity that you expect to have purchased at the end of the contract, expressed in the inventory unit. This calculation is extrapolated from the contract's ordered quantity that is registered during the part of the effective period that has passed.

The calculation for the expected quantity:

(Used Quantity ÷ Elapsed time in %) * 100%
Expected Result (%)

The percentage of the items that you should have purchased, which is calculated using the agreed quantity and effective period.

Advised Quantity

The advised quantity, expressed in the purchase unit.

The advised quantity totalizes the following:

  • The ordered quantities of all the unapproved purchase order lines that are linked to the contract line.
  • The scheduled quantities of all the purchase schedule (lines) with the Created status that are linked to the contract line.
Advised Quantity in Inventory Unit

The advised quantity, expressed in the inventory unit.

The advised quantity totalizes the following:

  • The ordered quantities of all the unapproved purchase order lines that are linked to the contract line.
  • The scheduled quantities of all the purchase schedule (lines) with the Created status that are linked to the contract line.
Called Quantity

The sum of the called quantities of all the purchase order/schedule lines that are linked to the contract line, expressed in the purchase unit.

Note: Based on the called quantity, the effective date, and expiry date, the total contract quantity at the expiry date can be calculated.

The called quantity is increased when an order/schedule line is linked to a contract. The called quantity is decreased again when an order/schedule line is processed in the Process Delivered Purchase Orders (tdpur4223m000)/ Process Purchase Schedules (tdpur3223m000) session.

Called Quantity in Inventory Unit

The sum of the called quantities of all the purchase order/schedule lines that are linked to the contract line, expressed in the inventory unit.

Called Amount

The sum of the called amounts of all purchase order/schedule lines that are linked to the contract line.

Note: Based on the called quantity, the effective date, and expiry date, the total contract quantity at the expiry date can be calculated.

The called amount is increased when an order/schedule line is linked to a contract. The called amount is decreased again when an order/schedule line is processed in the Process Delivered Purchase Orders (tdpur4223m000)/ Process Purchase Schedules (tdpur3223m000) session.

Invoiced Quantity

The sum of the invoiced quantities of all purchase order/schedule lines that are linked to the contract line, expressed in the purchase unit.

Note: Based on the invoiced quantity, the effective date, and expiry date, the total invoiced quantity at the expiry date can be calculated.

The invoiced quantity is increased when linked purchase order/schedule lines are processed in the Process Delivered Purchase Orders (tdpur4223m000)/ Process Purchase Schedules (tdpur3223m000) session.

Invoiced Quantity in Inventory Unit

The sum of the invoiced quantities of all purchase order/schedule lines that are linked to the contract line, expressed in the inventory unit.

Invoiced Amount

The sum of the invoiced amounts of all purchase order/schedule lines that are linked to the contract line.

Note: Based on the invoiced amount, the effective date, and expiry date, the total invoiced amount at the expiry date can be calculated.

The invoiced amount is increased when linked purchase order/schedule lines are processed in the Process Delivered Purchase Orders (tdpur4223m000)/ Process Purchase Schedules (tdpur3223m000) session.

Minimum Quantity

The minimum contract quantity expressed in the purchase unit.

Note: You can calculate the percentage that the real purchased quantity differs from the minimum quantity with the Evaluate Purchase Contracts (tdpur3420m000) session.
Minimum Quantity in Inventory Unit

The minimum contract quantity expressed in the inventory unit.

Maximum Quantity

The maximum contract quantity expressed in the purchase unit.

Note: You can calculate the percentage that the real purchased quantity differs from the maximum quantity with the Evaluate Purchase Contracts (tdpur3420m000) session.

When the maximum quantity is reached, you can define what action is taken in the Action on Exceeding Maximum Quantity field of the Purchase Contract Parameters (tdpur0100m300) session.

Maximum Quantity in Inventory Unit

The maximum contract quantity expressed in the inventory unit.

Quantity Binding

This field indicates whether the agreed contract quantity is binding.

If this check box is selected, the Evaluate Purchase Contracts (tdpur3420m000) session prints all differences between:

  • The called quantity and the maximum contract quantity
  • The called quantity and the minimum contract quantity

If this check box is cleared, if the boundaries specified in the Evaluate Purchase Contracts (tdpur3420m000) session are exceeded, the Evaluate Purchase Contracts (tdpur3420m000) prints the lines that exceed the allowed deviations.

Required CUM

The required cumulative aggregated from all schedules that are directly or indirectly linked to this contract line, expressed in the purchase unit.

Schedules are indirectly linked to this contract line when they are linked to a related purchase contract line detail.

Required CUM

The required cumulative aggregated from all schedules that are directly or indirectly linked to this contract line, expressed in the inventory unit.

Schedules are indirectly linked to this contract line when they are linked to a related purchase contract line detail.

Received CUM

The received cumulative aggregated from all schedules that are directly or indirectly linked to this contract line, expressed in the purchase unit.

Schedules are indirectly linked to this contract line when they are linked to a related purchase contract line detail.

Received CUM

The received cumulative aggregated from all schedules that are directly or indirectly linked to this contract line, expressed in the inventory unit.

Schedules are indirectly linked to this contract line when they are linked to a related purchase contract line detail.

Planned versus Actual (To-Date)

The planned versus the actual quantity for the contract line, displayed in a graph.

  • The planned quantity is the agreed quantity of the contract line, based on its Time Elapsed (%). For example, if the agreed quantity is 80 and the time elapsed is 50%, the planned quantity that is displayed in the graph is 40.
  • The actual quantity is the sum of the called and invoiced quantities of the contract line.
Aggregated Quantities
Agreed Quantity

The sum of the contract quantities of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

Aggregated Agreed Quantity

The sum of the contract quantities of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

Used Quantity

The sum of the called and invoiced items of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

Aggregated Used Quantity

The sum of the called and invoiced items of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

Aggregated Usage (%)

The total number of called and invoiced items of all the purchase contract line details that are linked to the contract line, expressed as a percentage of the aggregated agreed contract quantity.

Remaining Quantity

The sum of the remaining quantities of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

The calculation for the aggregated remaining quantity:

Aggregated Agreed Quantity - Aggregated Called Quantity - Aggregated Invoiced Quantity
Aggregated Remaining Quantity

The sum of the remaining quantities of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

The calculation for the aggregated remaining quantity:

Aggregated Agreed Quantity - Aggregated Called Quantity - Aggregated Invoiced Quantity
Aggregated Remaining Usage (%)

The total number of remaining items (not called or invoiced) of all the purchase contract line details that are linked to the contract line, expressed as a percentage of the aggregated agreed contract quantity.

Expected Quantity

The calculated quantity that you expect to have purchased at the end of the contract of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit. This calculation is extrapolated from the ordered quantity that is registered during the part of the effective period that has passed.

The calculation for the aggregated expected quantity:

(Total Quantity ÷ Elapsed time in %) * 100%
Aggregated Expected Quantity

The calculated quantity that you expect to have purchased at the end of the contract of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit. This calculation is extrapolated from the ordered quantity that is registered during the part of the effective period that has passed.

The calculation for the aggregated expected quantity:

(Total Quantity ÷ Elapsed time in %) * 100%
Aggregated Expected Usage (%)

The percentage of the items that you should have purchased, which is calculated using the aggregated agreed quantity and effective period.

Aggregated Advised Quantity

The sum of the advised quantities of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

The advised quantity for a purchase contract line detail includes the scheduled quantity of the purchase schedule with the Created status that is linked to the contract line detail.

Aggregated Advised Quantity in Inventory Unit

The sum of the advised quantities of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

The advised quantity for a purchase contract line detail includes the scheduled quantity of the purchase schedule with the Created status that is linked to the contract line detail.

Aggregated Called Quantity

The sum of the called quantities of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

Aggregated Called Quantity

The sum of the called quantities of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

Aggregated Called Amount

The sum of the called amounts of all the purchase contract line details that are linked to the contract line.

Aggregated Invoiced Quantity

The sum of the invoiced quantities of all the purchase contract line details that are linked to the contract line, expressed in the purchase unit.

Aggregated Invoiced Quantity

The sum of the invoiced quantities of all the purchase contract line details that are linked to the contract line, expressed in the inventory unit.

Aggregated Invoiced Amount

The sum of the invoiced amounts of all the purchase contract line details that are linked to the contract line.

Quantity Mismatch

If this check box is selected, quantities differ for these fields on the Aggregated Quantities and Quantities tabs:

  • Aggregated Called Quantity and Called Quantity
  • Aggregated Invoiced Quantity and Invoiced Quantity