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, this line includes the aggregated quantities of its Detail lines, that is purchase contract line details, which are always linked to push schedules. Consequently, the quantities 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 values on the Quantities and Aggregated Quantities tabs differ 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.

Related topics

 

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.
Position

The number of the purchase contract line.

Sequence
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
Purchase Office
Item
Quantities
Current Date

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

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

The unit in which you purchase an item, also referred to as the purchase quantity unit.

Agreed Quantity

The contract quantity expressed in the inventory unit.

Inventory Unit

The unit of measure in which the inventory of an item is recorded, such as piece, kilogram, box of 12, or meter.

The inventory unit is also used as the base unit in measure conversions, especially for conversions that concern the order unit and the price unit on a purchase order or a sales order. These conversions always use the inventory unit as the base unit. An inventory unit therefore applies to all item types, also to item types that cannot be kept in stock.

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:

(Total 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:

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

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

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 Purchase Orders (tdpur4223m000)/ Process Purchase Schedules (tdpur3223m000) session.

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 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 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 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 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 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

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

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.

Aggregated Quantities
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 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.

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 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.

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.

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 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
		  
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.

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 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%
              
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

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, the Aggregated Called Quantity is not equal to the total Called Quantity, or the Aggregated Invoiced Quantity is not equal to the total Invoiced Quantity.