Changes related to Backorders

The SP_V_INITIAL_BACKORDERS new view has been added to support backorders.

These views have been updated to support backorders:

  • SP_V_CUSTOMER_ALLOCATIONS
  • SP_V_CUSTOMER_ORDERS

The mapping logic for backorders in the views is as follows:

  • Customer Orders: Sourced from SC_SALES_OPEN_TRX where order's requirement time (as date) >= Current date
  • Initial backorders: Same mapping logic as for Customer Orders, but sourced from SC_SALES_OPEN_TRX where order's requirement time (as date) < Current date
Note: This feature is enabled after appending the apsco integration template (apsco.zip) for this version and no additional role or privilege is required to access this feature.