Delete order data

For received purchase orders, sales orders, and sales schedules, you can define the method used to remove the order or schedule data.

  • Received purchase orders
    To specify how to use the Archive and Delete Purchase Orders (tdpur4224m000) session to remove purchase order data, use the Delete Order Data if Received Completely field in the Purchase Order Parameters (tdpur0100m400) session.
  • Sales orders and schedules
    To specify how to use the Archive and Delete Sales Orders (tdsls4224m000) session or the Archive and Delete Sales Schedules (tdsls3224m000) session to remove sales order or sales schedule data, use the Method of Deleting Order Data field in the Sales Order Parameters (tdsls0100s400) session.

For these fields, you can select the following values:

  • By Order
    The order/schedule data is removed by order or schedule. LN checks whether the entire order or schedule can be deleted. Order header data and order lines are only removed if no back order quantities exist.
  • By Order Line
    The order or schedule data is removed by order/schedule line. For each order/schedule line, LN checks whether it can be deleted. If no back order quantities exist for an order line, the order line is removed. If the last order or schedule line of an order/schedule is removed, the order/schedule header data is also removed.

If you set this field to By Order Line, you can remove order or schedule data at an earlier time. This reduces data growth and saves performance.

Performance aspects
  • Effect on CPU: Yes
  • Effect on database growth: Yes