Sales Schedule Lines (tdsls3107m000)

Use this session to view or maintain sales schedule lines. Sales schedule lines indicate the specific requirements, expressed in quantity and time, of the item that is specified in the sales schedule.

Field Information

Schedule

The number of the sales schedule.

Schedule Revision

sales schedule revision number

Schedule Type

The sales schedule type, which specifies the sales schedule's purpose.

Allowed values

Material Release
Shipping Schedule
Sequence Shipping Schedule
Pick-up Sheet

Line

The number that identifies each requirement for an item to be supplied to a specific business partner on a specific date and time.

Status

The sales schedule line's status indicates the stage of the sales schedule line in the sales schedule process.

Allowed values

Created

The sales schedule line is created in LN. LN can adjust or approve the sales schedule line in the adjustment or approval process that is carried out for the sales schedule (revision).

Canceled

The sales schedule line is canceled.

A sales schedule line can be canceled as follows:

  • The sales schedule (revision) to which the sales schedule line belongs is terminated. For more information, refer to Terminating sales schedules.
  • The sales schedule line is canceled in the sales schedule adjustment process. For more information, refer to Adjusting sales schedules.
  • The sales schedule line is canceled in the Sales Schedule Lines (tdsls3107m000) session.
Canceling in Process

The sales schedule line is canceled, but the outbound process is already started. If the related outbound order line receives the Shipped status, the sales schedule line gets the Canceled status.

Replaced

The sales schedule (revision) to which the sales schedule line belongs is replaced by another approved revision and the sales schedule line is also replaced. For more information, refer to Sales schedule revisions.

Replacing in Process

The sales schedule line is replaced by another approved revision, but the outbound order line can no longer be updated. If the related outbound order line receives the Shipped status, the sales schedule line gets the Replaced status. For more information, refer to Sales schedule revisions.

Adjusted

The sales schedule line is adjusted in the adjustment process that is started for the sales schedule (revision). For more information, refer to Adjusting sales schedules.

Approved

The sales schedule line is approved. You can release the sales schedule to a warehousing order or to a sales order. For more information, refer to Approving sales schedules.

Order Generated

The sales schedule line is released to a warehousing order or to a sales order. The shipment of required items can take place.

Partially Shipped

Not the entire required quantity of the sales schedule line is shipped. You can invoice the shipped quantity. For more information, refer to Sales schedules and Warehousing.

Goods Delivered

The entire required quantity of the sales schedule line is shipped. You can now invoice the sales schedule line. For more information, refer to Sales schedules and Warehousing.

Released to Invoicing

The sales schedule line is released to Invoicing . For more information, refer to Sales schedules and Invoicing.

Invoiced

The entire ordered quantity of the sales schedule line is invoiced. For more information, refer to Sales schedules and Invoicing.

Processed

The sales schedule line is processed. For more information, refer to Processing and deleting sales schedules.

Referenced Schedule

If this check box is selected, the sales schedule is a referenced sales schedule.

Status

The sales schedule's status indicates the stage of the sales schedule in the sales schedule process.

Allowed values

Created

The sales schedule (revision) is just created in LN. You can adjust or approve the sales schedule.

Adjusted

The sales schedule (revision) has a sales schedule line that is adjusted in the adjustment process. You can approve the sales schedule (revision). For more information, refer to Adjusting sales schedules.

Approved

The sales schedule (revision) is approved and can be released to a warehousing order or to a sales order. For more information, refer to Approving sales schedules.

Terminated

The sales schedule (revision) is terminated and all its sales schedule lines are canceled or processed. For more information, refer to Terminating sales schedules.

Termination in Process

LN is terminating the sales schedule (revision) but cannot finish it before all sales schedule lines are canceled or processed. For more information, refer to Terminating sales schedules.

Replaced

The sales schedule (revision) is replaced by another approved revision and all its sales schedule lines are replaced or processed. For more information, refer to Sales schedule revisions.

Replacing in Process

LN is replacing the sales schedule (revision) but cannot finish it before all sales schedule lines are replaced or processed. For more information, refer to Sales schedule revisions.

Schedule Positions Full

All sales schedule line numbers of the sales schedule (revision) are used up. The sales schedule (revision) can only have this status if it is a referenced sales schedule. For more information, refer to Referenced sales schedules.

Processed

The sales schedule (revision) and all its sales schedule lines are processed. For more information, refer to Processing and deleting sales schedules.

Processing in Process

LN is processing the sales schedule (revision) but cannot finish it before all sales schedule lines are invoiced. For more information, refer to Processing and deleting sales schedules.

Cumulative Shipped Quantity

The total cumulated quantity that you shipped to your ship-to business partner for this sales schedule, expressed in the inventory unit.

Item

The item that is required on the sales schedule.

Engineering Item Rev.

The revision of the engineering item.

Prior Required CUM

The required cumulative that you received from your business partner with the last received EDI message for the sales schedule, expressed in the inventory unit.

Received CUM

The total cumulated quantity that your ship-to business partner received for this sales schedule, expressed in the inventory unit.

Sold-to Business Partner

The sold-to business partner from the schedule header.

Invoiced CUM

The total cumulated quantity that you invoiced for this sales schedule, expressed in the inventory unit.

Ship-to Business Partner

The ship-to business partner to which you ship the items specified on the sales schedule.

Open Balance

open balance

Currency

The currency in which the open balance is expressed.

Requirement Type

The sales schedule line requirement type determines the actions LN carries out if you approve the sales schedule line.

Order Date

order date

Planned Receipt Date

planned receipt date

If the sales schedule is:

  • Shipment Based, your business partner must pick up the items at your warehouse. As a result, the Start Date is equal to the Planned Receipt Date.
  • Receipt Based, you must deliver the items at your business partner's warehouse. The Start Date and End Date are calculated based on the Planned Receipt Date.

LN calculates the Start Date and End Date based on the Planned Receipt Date as follows:

  • Retrieves the address of the warehouse as specified in the Warehouse field of the Sales Schedule Lines (tdsls3107m000) session.
  • Retrieves the Ship-to Address from the Sales Schedules (tdsls3111m000) session.
  • Calculates the transportation time between these two addresses.
  • Determines the Start Date by planning backwards from the Planned Receipt Date with the transportation time.
  • Determines the End Date by planning forward from the Start Date with the Time Unit.

Start Date

The start date and time of the sales schedule line. The start date is the first date of the period to which the sales schedule line applies.

The sales schedule line's start date is also the date on which the required items must be ready for shipment. If the sales schedule is:

  • Shipment Based, your business partner must pick up the items at your warehouse. As a result, the Start Date is equal to the Planned Receipt Date.
  • Receipt Based, you must deliver the items at your business partner's warehouse. In this case, LN calculates the default Start Date based on the Planned Receipt Date.

The following restrictions apply for the sales schedule line's start date:

  • The start date cannot be before the sales schedule's Generation Date.
  • The start date cannot be before the end date of the previous sales schedule line of the same sales schedule, except if the sales schedule line concerns an Immediate requirement.
  • If the sales schedule is linked to a sales contract, the sales schedule line's start date cannot be before the sales contract's Effective Date.
  • The sold-to business partner and the ship-to business partner must be active on the start date.

Time Unit

The amount of time the End Date is later than the Start Date.

If the time unit is:

  • Hours, the End Date is one hour later than the Start Date.
  • Days, the End Date is one day later than the Start Date.
  • Weeks, the End Date is one week later than the Start Date.
  • Months, the End Date is one month later than the Start Date.
  • Four Weeks, the End Date is four weeks later than the Start Date.
  • Not Applicable, the End Date is equal to the Start Date.
End Date

The end date and time of the sales schedule line. The end date is the last date of the period to which the sales schedule line applies. If the End Date differs from the Start Date field, the requirement is aggregated.

Default value

LN determines the default End Date based on the Start Date and the Time Unit. If the time unit is:

  • Hours, the End Date is one hour later than the Start Date.
  • Days, the End Date is one day later than the Start Date.
  • Weeks, the End Date is one week later than the Start Date.
  • Months, the End Date is one month later than the Start Date.
  • Four Weeks, the End Date is four weeks later than the Start Date.
  • Not Applicable, the End Date is equal to the Start Date.
Required Quantity

The quantity of the item that is required for the sales schedule line.

If a sales contract is linked to the sales schedule, the quantity is expressed in the unit specified on the sales contract line. If no sales contract is linked to the sales schedule, the sales unit as specified in the Items - Sales (tdisa0501m000) session is used.

Note: 
  • You cannot use negative quantities on a sales schedule.
  • You cannot change quantities during the sales schedule's frozen period.
Ordered Quantity Unit

The unit in which the Required Quantity is expressed.

Ordered Quantity

The quantity of the item that is required for the sales schedule line, expressed in the inventory unit.

Confirmed Quantity

The ordered quantity that is confirmed to the customer.

Note: This field can only be filled if the Use Confirmation (Sales) check box is selected in the Implemented Software Components (tccom0500m000) details session.
Confirmed Quantity Unit

The unit in which the Confirmed Quantity is expressed.

Confirmed Quantity

The ordered quantity that is confirmed to the customer, expressed in the inventory unit.

Note: This field can only be filled if the Use Confirmation (Sales) check box is selected in the Implemented Software Components (tccom0500m000) details session.
Confirmation Date

The date on which the ordered quantity is confirmed to the sold-to business partner

Note: This field can only be filled if the Use Confirmation (Sales) check box is selected in the Implemented Software Components (tccom0500m000) details session.
Customer Requirement Type

The requirement type that you received from the business partner for the sales schedule line.

Note: The customer requirement type can determine the value of the Requirement Type field.

Delivered Quantity

The quantity already delivered for the sales schedule line, expressed in the sales unit.

Sales Unit

sales unit

Payment

Use this field to define the payment between the sales office, which issues the sales schedule line, and the customer.

Note: This field can only be set to Pay on Use or No Payment if the Goods Flow field reads Warehouse Transfer Delivery.

Default value

This field is defaulted from the Order Terms and Conditions (tctrm1130m000) session.

Allowed values

Pay on Receipt
Pay on Use
No Payment
Not Applicable

Frozen

The status that determines when you get a warning message about changing scheduled quantities.

Allowed values

Frozen Period

The frozen period. You receive a warning when you are in the period during which you cannot change the scheduled quantities.

Frozen Period (+)

The frozen zone+. You receive a warning when you are in the period during which you cannot increase the scheduled quantities.

Frozen Period (-)

The frozen zone-. You receive a warning when you are in the period during which you cannot decrease the scheduled quantities.

Free

The schedule line is free for any change.

Originates from Subcontracting

If this check box is selected, the sales schedule line is a subcontracting schedule line.

Warehouse

The warehouse from which the goods must be shipped.

Note: If the Goods Flow field is set to Warehouse Transfer Delivery, this field must be filled.
Lot

The lot ID that applies for the specific requirement.

Contract

The sales contract that is linked to the sales schedule line during the approval process. LN uses the sales contract price and discount for the sales schedule line.

Note: This field can only be filled if the Use Contracts for Schedules check box is cleared in the Sales Schedule Parameters (tdsls0100s500) session.

Line

The sales contract line that is linked to the sales schedule line.

Contract Office

The sales office that is specified on the sales contract line. This sales office is used for reference purposes and must be the same as the sales office that is specified on the sales schedule.

Put on Hold

If this check box is selected, the sales schedule line is put on hold. You cannot continue the sales schedule process for this sales schedule line.

You can put a sales schedule line on hold in the following ways:

  • In the Sales Schedule Lines (tdsls3107m000) overview session, select a sales schedule line and from the appropriate menu, choose Put on Hold.
  • In the Sales Schedule Lines (tdsls3107m000) details session, click Put on Hold.
Note: You can only put sales schedule lines with the Sales Schedule Status set to Created, Adjusted, or Approved status on hold. Approved lines can only be put on hold if there are no planned warehouse orders against them.

You can undo the on hold status in the following ways:

  • In the Sales Schedule Lines (tdsls3107m000) overview session, select a sales schedule line and from the appropriate menu, choose Release Hold.
  • In the Sales Schedule Lines (tdsls3107m000) details session, click Release Hold.
Schedule Line Text

If this check box is selected, a text is present.

Sold-to Business Partner

sold-to business partner

Ship-to Business Partner

ship-to business partner

Ship-to Address

The ship-to business partner 's address.

Note: 
  • For referenced schedules, this is the Address in the Purchase Schedule Lines (tdpur3111m000) session.
  • For non-referenced schedules, this is the Ship-to Address in the Sales Schedules (tdsls3111m000) session.
Ship-to Warehouse

The warehouse to which the items are shipped.

Note: 
  • This field can and must only be filled if the Goods Flow field is set to Warehouse Transfer Delivery.
  • This field is defaulted from the Ship-to Warehouse field in the Items - Sales Business Partner (tdisa0510m000) session
Carrier/LSP

carrier

Intermediate Consignee

intermediate consignee

Intermediate Consignee Address

The address of the intermediate consignee.

Customer Schedule Number

The business partner's schedule number. This field is only used as a reference.

Customer Schedule Position

The business partner's schedule line number. This field is only used as a reference.

Reference

The reference that you received from your business partner.

Note: 
  • The reference is only specified if the sales schedule is referenced.
  • If the sales schedule line is linked to a pick-up sheet, this reference is optional. However, the Shipment Reference is a mandatory reference for pick-up sheets.

Subcontracting Reference

A reference that is sent by the manufacturer to the subcontractor to enable the subcontractor to link the subcontracting purchase order to the supplied materials. The subcontractor stores the subcontracting reference in its specification as allocated to reference.

Note: This field is filled with the subcontracted purchase order/position/sequence number.

Shipment Reference

A reference communicated by the customer to identify the shipment, such as a transport ID or a customer shipment number. If you use pick-up sheets, this number is used to identify the pick-up sheet to which the sales schedule line is linked.

This field is used to combine sales schedule lines from different sales schedules into one shipment.

Note: 

It is mandatory to enter a shipment reference if:

  • The Linked to Pick-up Sheets check box is selected in the Sales Schedules (tdsls3111m000) session.
  • The Use Shipment Reference check box is selected in the Sales Contract Line Logistic Data (tdsls3102m000) session.

Packaging Reference A

packaging reference A

Note: This field can be specified only if the Reference field is also specified in this session.

Packaging Reference B

packaging reference B

Note: This field can be specified only if the Reference field is also specified in this session.

Dock Location

The business partner's line station at which you must deliver the items that are required for the sales schedule line.

Delivery Point

The business partner's delivery point at which you must deliver the items.

Item

The item required on the sales schedule.

Customer Item

The customer's item code in the coding system. LN converts this item code to the item code used in your own company.

You can specify external and internal item codes in the Item Code System - Items (tcibd0104m000) session.

Customer Item Revision

The revision of the customer's item code.

Note: This field can be specified only if the Customer Item is also specified.

Default value

This field is defaulted as follows:

  1. From the sales release
  2. If empty on the sales release, from the Business Partner Item - Revisions (tcibd0114m000) session based on the schedule line's Start Date.
Length

The item's length.

The item's length is only displayed if the specified sales unit has Length, Area, or Volume as the physical quantity.

To update the item dimensions, click Item Dimensions.

Width

The item's width.

The item's width is only displayed if the specified sales unit has Length, Area, or Volume as the physical quantity.

To update the item dimensions, click Item Dimensions.

Height

The item's thickness.

The item's thickness is only displayed if the specified sales unit has Length, Area, or Volume as the physical quantity.

To update the item dimensions, click Item Dimensions.

Specification

If this check box is selected, a specification is linked to the sales schedule line.

Demand Peg
Allocated to Sold-to Business Partner

The supply that fills this demand must have been allocated or hard pegged to the sold-to business partner displayed in this field.

LN uses this characteristic to find a matching supply for this demand.

Allocated to Ship-to Business Partner

The supply that fills this demand must have been allocated or hard pegged to the ship-to business partner displayed in this field.

LN uses this characteristic to find a matching supply for this demand.

Allocated to Business Object

The supply that fills this demand must have been allocated or hard pegged to the type of order displayed in this field.

LN uses this characteristic to find a matching supply for this demand.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Allowed values

Service (Manual)

Maintenance Sales Order

maintenance sales order

Maintenance Sales (Manual)

Maintenance Work Order

maintenance order

Maintenance Work Order (Manual)
Sales Order

sales order

Sales Schedule

sales schedule

Not Applicable

Sales (Manual)

Service Order

service order

Business Object

The supply that fills this demand must have been allocated or hard pegged to the order, or order line, displayed in this field.

LN uses this characteristic to find a matching supply for this demand.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Business Object Reference

The order or order line to which the items were allocated.

LN can use this characteristic to find a matching supply for this demand.

Note: 

The combination of the following fields identifies the order or order line to which the ordered items were allocated:

  • Business Object Type
  • Business Object
  • Business Object Reference

Allocated to Reference

The supply that fills this demand must have been allocated or hard pegged to the reference code displayed in this field.

LN uses this characteristic to find a matching supply for this demand.

LN can use this field in two ways:

  • If the Sold-to Business Partner field is filled, LN uses the Reference field to record a reference code defined by a customer.
  • If the Sold-to Business Partner field is empty, LN uses the Reference field to record an internal reference.

You can use a reference code to keep a collection of parts linked together, even if they follow different routings, for example, if some of the parts are transported to a subcontractor to be returned later.

Use Unallocated Inventory

If this check box is selected, unallocated inventory can be allocated and used to supply the demand order. First, allocated inventory is used, then unallocated inventory.

If this check box is cleared, only allocated inventory can be used.

Inventory Unit

inventory unit

Unallocated

The inventory on hand that is not allocated in the Warehouse, expressed in the sales unit.

Unallocated Quantity

The inventory on hand that is not allocated in the Warehouse, expressed in the inventory unit.

Price

The sales price of the item expressed in the currency that is displayed in the Sales Schedules (tdsls3111m000) session.

The Price is determined as follows:

    • The price is transferred to the Sales Schedule Lines (tdsls3107m000) session through EDI. At this moment, the sales schedule line has the Created status.
    • You inserted the price manually. At this moment, the sales schedule line is in its Created status.
  1. If no price is specified on a sales schedule line with the status Created, LN searches for a sales contract to be linked to the sales schedule line when approving the sales schedule. If an Active normal contract is available for the item, sold-to BP, ship-to BP, and sales office combination, LN links this sales contract to the sales schedule line and uses the sales contract prices and discounts for the sales schedule.
  2. If no sales contract can be linked, LN uses the prices and discounts as specified in Pricing. To retrieve the correct price at the right moment, LN uses the Start Date from the Sales Schedule Lines (tdsls3107m000) session.
  3. If no price is specified in Pricing, LN retrieves the price from the Items - Sales (tdisa0501m000) session.
Note: If the Material Pricing in Sales check box is selected in the Material Price Parameters (tcmpr0100m000) session, this price can include material prices.

As long as the status of the schedule line is Created or Adjusted, you can manually update the Price in the Price and Discounts (tdpcg1600m000) session. To retrieve the latest pricing data for the sales schedule line, select the sales schedule and click Reprice in the Sales Schedules (tdsls3111m000) session.

As a result, LN:

  • Recalculates the price for all linked sales schedule lines with the Approved, or Order Generated status.
  • Determines the price for all linked sales schedule lines with the Created, or Adjusted status.

Currency

The currency in which the sales schedule's prices and amounts are expressed.

LN retrieves the currency from the Sales Schedules (tdsls3111m000) session.

Sales Price Unit

The item unit in which an item's sales price is expressed.

Note: You can manually insert/update the sales price unit as long as the schedule line has the Created, or Adjusted status.
Total Discount Amount

The schedule line's total discount amount.

Total Discount %

The total of all discounts that are applied to the schedule line, expressed as a percentage.

Net Amount

The sales schedule line's total net amount.

The schedule line amount is calculated as follows:

Quantity * price - discounts.
Tax Classification

tax classification

Default value

This field is defaulted from the sales schedule header.

Exempt

If this check box is selected, tax exemption applies.

Note: 

If the Tax Exempt Level parameter in the Tax Parameters (tctax0100m000) session is set to:

  • Limited and you select this check box manually, the Tax Code is defaulted from the Exempt Sales field of the Tax Handling (tctax0138m000) session. If you clear this check box manually, the tax code is not changed.
  • Extended and you select this check box manually, the Tax Code is not changed. If you clear this check box manually, the Exemption Reason and Exemption Certificate fields are cleared and disabled.

Tax Country

The country used for tax purposes.

Own Tax Number

tax ID

Tax Code

The tax code that applies to the sales schedule line.

Note: The tax code that can be entered in this field can only be of the VAT kind.

BP Tax Country

The country in which the business partner has the tax ID.

BP Tax ID

The business partner's tax ID.

Note: The business partner's tax ID is date effective. To determine and display the correct tax ID for the business partner, LN uses the planned delivery date.

Exemption Certificate

The exemption certificate that is assigned to the sold-to business partner by the tax authority.

Note: 
  • This field only applies if the Tax Exempt Level parameter is set to Extended in the Tax Parameters (tctax0100m000) session.
  • This field is defaulted from the method that is used to retrieve tax details, as defined in the Search Sequence Tax Libraries group box of the Tax Parameters (tctax0100m000) session.

Exemption Reason

The reason code that indicates why a business partner can be exempt from tax for a certain transaction and jurisdiction.

Note: 
  • LN prints the exempt reasons on the sales invoices.
  • This field only applies if the Tax Exempt Level parameter is set to Extended in the Tax Parameters (tctax0100m000) session.
  • This field is defaulted from the method that is used to retrieve tax details, as defined in the Search Sequence Tax Libraries group box of the Tax Parameters (tctax0100m000) session.
  • The reason code must be of the Tax Exemption type and must be date effective, as valuated by the Planned Receipt Date.

Self-Billing

If this check box is selected, self-billing is applicable to the sales schedule line. In this case, the invoice is created by the sold-to business partner.

Default value

This field is defaulted from the Sales Schedules (tdsls3111m000) session.

Extra Intrastat Info

Extra Intrastat info

Sales Type

sales type

Note: A control account is defined for every sales type. When sales invoices are posted, LN retrieves the sales type to determine the control account that must be used for posting.

Goods Flow

The type of order to which the sales schedule line is released.

Note: If this field is set to Warehouse Transfer Delivery and the schedule line is released to Warehousing , a transfer order is created from the schedule line Warehouse to the Ship-to Warehouse.

Allowed values

Warehouse Delivery

Indicates that the goods are delivered from the warehouse.

Sales Order Delivery

Indicates that the goods are delivered as per the sales order.

Warehouse Transfer Delivery

Indicates that the goods are delivered as a result of the warehouse transfer.

Direct Delivery

Indicates that the goods are delivered as per the direct delivery process.

Order

The number of the order to which the sales schedule line is released.

Line

The number that identifies the position number of the warehousing order or the sales order that resulted from the schedule line. This field is only filled if a one-to-one relationship exists between the order and the schedule line. For a one-to-many relationship caused by multiple production orders or sequence information, only the Order field is filled. The production and sequence details can be found in the corresponding warehousing order.

Sequence

The number that identifies the sequence in the order line that resulted from the schedule requirement.

Adjustment Quantity

The adjusted quantity for the sales schedule line, expressed in the sales unit.

Adjustment Quantity

The adjusted quantity for the sales schedule line, expressed in the inventory unit.

Delivered Quantity

The quantity already delivered for the sales schedule line, expressed in the inventory unit.

Last Delivery Date

The last date on which you shipped goods for the sales schedule line.

Last Shipment

The number of the last shipment for the sales schedule line.

Invoice Correction

If this check box is selected, a shipment correction record exists for the sales schedule line in the Sales Schedule Actual Delivery Lines (tdsls3140m000) session.

Last Invoice Date

The date on which the last invoice was printed for the sales schedule line.

Last Invoice Company

The financial company that is specified on the last invoice that is sent for the sales schedule line.

Last Transaction Type

The transaction type used to post the last invoiced order line for the sales schedule line to Financials .

Last Invoice

The number of the last invoice that was printed for the sales schedule line.

Additional Field

additional information