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.

 

Schedule

The number of the sales schedule.

Revision

A number that uniquely identifies the revision of the sales schedule. The sales schedule revision number indicates the sales schedule updates that are sent by your business partner.

Schedule Type

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

Allowed values

Release Type

Related topics

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

Sales Schedule Status

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.

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.

Related topics

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

The balance of all unpaid invoices relating to one particular business partner.

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

The date on which the order is manually specified or is automatically generated.

Planned Receipt Date

The date on which the goods are expected to arrive in the destination warehouse.

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

The unit in which an item is sold.

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 Type of Order field reads Warehouse Transfer.

Default value

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

Allowed values

Payment

Frozen

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

Allowed values

Frozen Period

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 Type of Order field is set to Warehouse Transfer, 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 on hold sales schedule lines with the Created, Adjusted, or Approved status.

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

The business partner who orders goods or services from your organization, who owns the configurations you maintain, or for whom you perform a project. Usually a customer's purchase department.

The agreement with the sold-to business partner can include:

  • Default price and discount agreements
  • Sales order defaults
  • Delivery terms
  • The related ship-to and invoice-to business partner
Ship-to Business Partner

The business partner to whom you ship the ordered goods. This usually represents a customer's distribution center or warehouse. The definition includes the default warehouse from which you send the goods, the carrier who carries out the transport, and the related sold-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 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 Type of Order field is set to Warehouse Transfer.
  • This field is defaulted from the Ship-to Warehouse field in the Items - Sales Business Partner (tdisa0510m000) session
Carrier/LSP

The company responsible for the transportation of goods to the ship-to business partner.

Intermediate Consignee

A distribution center where goods sent from the supplier are consolidated and often repacked before being shipped to the final destination at the customer's. An intermediate consignee is owned by the customer or a carrier acting on behalf of the customer.

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.

Related topics

Packaging Reference A

A package building criterion, which refers to the distribution zone or routing code.

Note

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

Related topics

Packaging Reference B

A package building criterion, which refers to the consumption point or point of destination.

Note

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

Related topics

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

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.

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

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

An attribute of order headers and order lines that you can use to define tax exceptions for the transaction. LN retrieves the default tax classification from the invoice-from and invoice-to business partners.

For example, you can use the tax classification to indicate:

  • That payments to an invoice-from business partner are subject to withholding tax and social contributions
  • To group business partners who have the same tax aspects for your company, for example, subcontractors, or agents
  • That the tax must be paid in a country other than the sales office or service office's home country

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 Exempt Reason and Exempt Certificate fields are cleared and disabled.
Tax Country

The country used for tax purposes.

Own Tax Number

A number used to identify legal persons or businesses. The tax authorities assign the tax numbers to the registered businesses. Your business partners must provide you with their tax number. Business partners without a tax number are considered to be private persons.

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.

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

Statistical import/export data that is not available as standard information in LN, but which is required on the sales listing or the Intrastat declaration by some of the EU member states.

You can add up to 15 data fields to the Intrastat statistical data by defining them as extra Intrastat information set. You can assign the extra Intrastat information sets to warehouse order lines.

Related topics

Sales Type

A sales order property that allows you to identify the kind of sale made and the kind of receivable. This property is used to post the sales to the correct Accounts Receivable account when the invoice is created. To post a sales invoice, LN retrieves the control account from the sales type linked to the sales order line, project contract, and so on.

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.

Type of Order

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

Note

If this field is set to Warehouse Transfer 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

Kind of Order

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

User-defined fields of various field formats that can be added to various sessions, in which users can edit these fields. No functional logic is linked to the contents of these fields.

Additional information fields can be linked to database tables. When linked to a table, the fields are displayed in the sessions corresponding to the database tables. For example, a field defined for the whinh200 table is displayed as an extra field in the Warehousing Orders (whinh2100m000) session.

The contents of additional fields can be transferred between database tables. For example, the information specified by a user in additional information field A of the Warehousing Orders (whinh2100m000) session is transferred to additional information field A in the Shipments (whinh4130m000) session. For this purpose, additional information fields with identical field formats and field name A must be present for the whinh200 and the whinh430 tables (whinh430 corresponds to the Shipments (whinh4130m000) session).

 

Approve

Sets the sales schedule line status to Approved.

Cancel

Cancels the selected sales schedule line. You can only cancel a sales schedule line with the Created, Adjusted, Approved, Order Generated, or Partially Shipped status. As a result, LN reduces the business partner balance and the linked contract's called amount.

Put on Hold

Puts the selected sales schedule line on hold. You cannot continue the sales schedule process for this sales schedule line. You can only put on hold sales schedule lines with the Created, Adjusted, or Approved status. If a sales schedule line is put on hold, the Put on Hold check box is selected.

Release Hold

Cancels the on hold status of the selected sales schedule line. The Put on Hold check box is cleared.

Sales Order

Starts the Sales Orders (tdsls4100m000) session. You can only use this command if the sales schedule concerns a delivery contract and the selected sales schedule line is released to a sales order.

Item Dimensions

Starts the Item Dimensions (tdsls4811s000) session. You can only update item dimensions in the Item Dimensions (tdsls4811s000) session if the specified sales unit has a physical quantity of Length, Area, or Volume.

Search Revision

If the Engineering Revisions Active in Sales check box in the Sales Parameters (tdsls0100s000) session and the Revision Controlled check box in the Items (tcibd0501m000) session are selected for the item, you can search for the item's revision.