3402 - Pending Orders - Products list

MSS 5.1 - Extensibility - Functions MSS to Kalipso - Dashboards - 3402 - Pending Orders - Products list

3402 - Pending Orders - Products list

Event	Extension action set	Description
Before	EXT_3402_1_Before	Will run before refresh the pending documents products list and must save the information in the table ENC_PendentesLinhas
Replace	n/a
After	n/a

Before

Input Parameters

• inDocumentExercise - Exercise of the document

• inDocumentType - Type of the document

• inDocumentSerie - Serie of the document

• inDocumentNumber - Number of the document

Output Parameters

• n/a

The functions "3401 - Pending Orders - Documents list" and "3402 - Pending Orders - Products list" are available to enable extensibility in retrieving the data to be displayed on the pending orders dashboards.

In Expedition Planner mode, extensibility is not available.

These events are executed only in the "Before" option, meaning they run before the list update code and instead of the default behavior, which is connecting to the MSS API to retrieve data from the database.

The retrieved data must be stored in the local tables ENC_Pendentes and ENC_PendentesLinhas, with the following structure:

ENC_Pendentes

• DCCEXR – Fiscal year

• DCCTPD – Document type

• DCCSER – Series

• DCCNDC – Number

• DCCDTA – Date

• DCCDTE – Expected delivery date

• DCCCLI – Customer code

• DCCLCE – Delivery location code

• DCCNOM – Customer name

• DCCENO – Delivery location description

• EXPDSC – Expedition description (applicable only to planner or ERP + POD)

• EXPDTA – Expedition date (applicable only to planner or ERP + POD)

• EXPSTS – Expedition status (applicable only to planner or ERP + POD)

• EXPLOG – In logistics processing (applicable only to planner)

• DCESTS – Document status (applicable only to planner or ERP + POD)

• EXPSTP – Expedition stamp (applicable only to planner or ERP + POD)

Note: The following fields should have the corresponding values in ERP + POD mode or ERP only:

• EXPDSC – Expedition description corresponding to VENDSC

• EXPDTA – Expedition date corresponding to VENDTA

• EXPSTS –

  • E – For delivery

  • P – Partially delivered

  • T – Fully delivered

  • N – Not delivered

• DCESTS – In ERP+POD mode, if empty, it means it has not yet been dispatched; if filled, it means it has already been dispatched (any value can be used as the validation only checks if the field is filled)

• EXPSTP – Expedition stamp corresponding to VENSTP or VEIVEN if already dispatched

ENC_PendentesLinhas

• DCCEXR – Fiscal year

• DCCTPD – Document type

• DCCSER – Series

• DCCNDC – Number

• DCLLIN – Line

• DCLART – Item code

• DCLDSA – Item description

• DCLQTO – Ordered quantity

• DCLQTP – Planned quantity (applicable only to planner)

• DCLQTL – Loaded quantity (applicable only to planner)

• DCLQEP – Delivered quantity

• EXPSTP – Expedition stamp (applicable only to planner or ERP + POD)