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

Position
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.
Shipped CUM
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 Revision

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 BP
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 BP
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
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 entered into the system 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 Item - 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 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 Contract Parameters (tdsls0100s300) session.

Position
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 further carry out 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.
Text
If this check box is selected, a text is present.
Sold-to BP
Usually a customer's purchase department, the business partner who orders goods or services from your organization, that owns the configurations you maintain, or for whom you perform a project.

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

  • Default price and discount agreements
  • Sales order defaults
  • Delivery terms
  • The related ship-to and invoice-to business partner
Ship-to BP
The business partner to which 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
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.
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 Update Item Dims..

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 Update Item Dims..

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 Update Item Dims..

Specification
If this check box is selected, a specification is linked to the sales schedule line.
Demand Peg
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.

Business Object Type
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
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 Business Partner field is filled, LN uses the Reference field to record a reference code defined by a customer.
  • If the 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 Quantity
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 is in its Created status.
    • You inserted the price manually. At this moment, the sales schedule line is in its Created status.
  1. If no price is entered on a sales schedule line with the status Created, either manually, or by EDI, LN searches for a sales contract to be linked to the sales schedule line when you try to approve 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. For more information on approving sales schedules, refer to Approving sales schedules.
  2. If no sales contract can be linked, LN uses the prices and discounts as specified in the Pricing module. 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 Item - Sales (tdisa0501m000) session.
Note

As long as the schedule line has the Created, or Adjusted, you can manually insert/update the Price in the Price and Discounts (tdpcg1600m000) session. If you want LN to retrieve the latest pricing data for the sales schedule line, you must 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 that 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.
Position
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 ID
The number of the last shipment for the sales schedule line.
Shipment Correction
If this check box is selected, a shipment correction record exists for the sales schedule line in the Schedule Shipment Details/Corrections (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 Information
User-defined fields that can be linked to LN tables.

The contents of additional fields can be transferred between LN tables. Additional information fields are meaningless to LN as no functional logic is linked to the contents of these fields.

 

Sales Schedule Actual Delivery Lines
Starts the Sales Schedule Actual Delivery Lines (tdsls3140m000) session. You can only use this command if items are delivered for the selected sales schedule line.
Sequence Shipping Information
Starts the Sequence Shipping Information (tdsls3517m000) session, in which you can view the sequence shipping information for the relevant schedule. You can only use this command if the sales schedule type is Sequence Shipping Schedule.
Planned Warehouse Orders
Warehouse Order
Starts the Warehousing Orders (whinh2100m000) session. You can only use this command if the selected sales schedule line is released to a warehouse order.
Pegging
Specification
Starts the Specification (tcibd4120m000) session. You can only use this command if the Specification check box is selected for the sales schedule line.
Allocation and Hard Pegging Relationships
Starts the Demand Pegging Relationships (tcibd4520m000) session. You can only use this command if the Specification check box is selected for the sales schedule line.
Approve
Sets the sales schedule line status to Approved.
Release to Order...
Release to Invoicing...
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 further carry out 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.
Sales Schedule
Process Delivered Sales Schedules
Price and Discounts
Starts the Price and Discounts (tdpcg1600m000) session in which you can view and maintain the prices and discounts for the schedule line.
Price Inquiry
Starts the Price Inquiry (tdpcg0250m000) session in which you can view how the net amount is calculated.
Update Item Dims.
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 Item - General (tcibd0101s000) session are selected for the item, you can search for the item's revision.