Usage > Trade connectors > APS Forecast > APS Forecast > APS Forecast interface launch 

This interface is used to manage the flows coming from and designed to the product dedicated to the Supply Chain Management:  AZAP.

This processing uses the setups specified in the SCM AZAP setup function.

SEEREFERTTO The principles of the interface functioning are given in the documentation about the SCM AZAP setup

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

Enter the reference identifying the SCM AZAP interface setup to use.

No flow is selected by default. It is only necessary to select those that have to be processed.
It is also possible to:

- specify selection formulas different from those specified by default, on the setup,
- specify a period in order to limit the history of exported sales,
- modify the aggregation level,
- modify the selection, indicated in the setup, to delete or not the sales forecasts before import processing.

A log file is displayed by default at the end of the processing when it has been started in interactive mode. It indicates:
- the directories used,
- the setup used: the pivots, the selections...,
- the result of the processing for each imported file.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Identifier (field ID)

Identification code of the interface setup.

  • field INTIT

 

Block number 2

  • field FIL0201

 

  • Destination type (field TYPEXP)

Select the type of sender: customer or server.

  • Log (field TRACE)

A log file is systematically created at the end of the processing. It indicates:

  • the folders,
  • the setup used: pivots, selections, etc.
  • For each imported file:
      • the number of lines read/processed/rejected
      • the name of the reject file,
      • the list of the rejected lines with the explanation.

If this check box is selected, the file is opened at the end of the processing launched in interactive mode. Otherwise, it is created but opened only if errors occur.

  • field FIL0202

 

  • Work directory (field VOLFILWRK)

 

  • Storage directory (field VOLFILSTO)

 

Exports

This field, which cannot be modified, contains the pivot code describing the lines of the Productsfile to export:  produits.csv. This pivot code is entered in the setup of the interface.

  • field FLGITMPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

This field is used to specify a products selection reference, which will be suggested, by default, when launching the interface processing.

This field is used to specify a products selection reference.
This reference can be entered, by default, at the level of the interface setup function.

This field, which cannot be modified, contains the pivot code describing the lines of the Sites/Conversionsfile to export:  conversion.csv. This pivot code is entered in the setup of the interface.

  • field FLGITMTCOP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

  • field FIL0400

 

  • Packing units (field FIL04)

 

  • 1 (field PCU0FLG)

These checkboxes cannot be modified. They are coming from the setup of the interface.
Remember: the first line of the Products/Conversions file systematically contains, for each product, the conversion information between the sales and stock units.
From 1 to 4 optional lines are added, if the corresponding checkboxes are activated, in order to export the conversion information on the conversions between the 4 packing units and the stock unit.

  • 2 (field PCU1FLG)

 

  • 3 (field PCU2FLG)

 

  • 4 (field PCU3FLG)

 

This field, which cannot be modified, contains the pivot code describing the lines of the Sites/Criteriafile to export:  critstr.csv. This pivot code is entered in the setup of the interface.

  • field FLGITMCRIP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

  • Code type (field ITMCRITYP)

These radio buttons cannot be modified. They are coming from the setup of the interface.
Remember, for each criterion, it is possible to include either the code, or the title, or both at the same time in the file.

  • field FIL0700

 

  • Product statistical groups (field FIL07)

 

  • 1 (field TSICOD0FLG)

  • 2 (field TSICOD1FLG)

 

  • 3 (field TSICOD2FLG)

 

  • 4 (field TSICOD3FLG)

 

  • 5 (field TSICOD4FLG)

 

  • field FIL0800

 

  • Category (field TCLCODFLG)

 

  • Product line (field CFGLINFLG)

 

  • User (field PLANNERFLG)

 

Ce champ, non modifiable, contient le code du pivot décrivant les lignes du fichier Sitesà exporter : sites.csv.
Ce code pivot est renseigné au niveau du paramétrage de l'interface.
SEEINFO Dans AZAP, les sites sont des clients ou des dépôts, le fichier des sites contiendra donc des informations sur les sites de stockage et sur les clients.

  • field FLGFCYPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Ce champ, non modifiable, contient le code du pivot décrivant les lignes du fichier Sites/Critèresà exporter : critstrsite.csv. 
Ce code pivot est renseigné au niveau du paramétrage de l'interface.
SEEINFO Dans AZAP, les sites sont des clients ou des dépôts, le fichier des sites contiendra donc des informations sur les sites de stockage et sur les clients.

  • field FLGFCYCRIP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

  • Code type (field FCYCRITYP)

These radio buttons cannot be modified. They are coming from the setup of the interface.
Remember, for each criterion, it is possible to include either the code, or the title, or both at the same time in the file.

  • field FIL1200

 

  • Country (field CRYFLG)

This checkbox cannot be modified, it comes from the interface setup.
This criterion is exported only if the corresponding checkbox is activated.
When a criterion is not exported, the corresponding column is not present in the file.

  • Category (field BCGCODFLG)

 

  • Bill-to customer (field BPCINVFLG)

 

  • Group customer (field BPCGRUFLG)

 

  • field FIL1300

 

  • Customer statistical groups (field FIL13)

 

  • 1 (field TSCCOD0FLG)

  • 2 (field TSCCOD1FLG)

 

  • 3 (field TSCCOD2FLG)

 

  • 4 (field TSCCOD3FLG)

 

  • 5 (field TSCCOD4FLG)

 

Sales exports

  • Aggregation level (field SOHGRU)

Radio button used to specify the level of aggregation. The level of aggregation defines the data grouping on the sales history and the sales orders in progress.
When Week or Month is selected, the date of the start date of the week or month is exported.

This field is used to indicate the reference of an order selection that will be applied on the sales orders in progress and the sales history if this history is issued from closed orders.
This reference can be entered, by default, at the level of the interface setup function.

This field, that cannot be modified, contains the code of the pivot describing the lines of the Sales history file to export:  ventes.csv.  
This pivot code is entered in the setup of the interface.
The sales history can either rely on:
- the paid orders for which a quantity has been delivered or invoiced, that is possible to filter entering a selection reference in the Orders selection field,
- or the deliveries and invoices that can be filtered, by entering a selection reference in the Deliv/Invoice selection field.

  • field FLGHISSOHP

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

  • Deliveries/invoices (field HISSDHFLG)

This checkbox cannot be entered. Its value comes from the interface setup.
It is checked to indicate that the sales history comes from deliveries and invoices, that can be selected by entering a selection code in the following field.
This history relies on:
+ the validated deliveries
+ the direct invoices with stock movement
+ the validated "order" invoices with stock movement
+ the validated "delivery" invoice lines with stock movement without delivery number
- the delivery returns
- the validated direct credit memos with stock movement
- the validated credit memos on invoice with stock movement

This field can only be accessed if the sales history comes from the deliveries and invoices.
It is used to indicate the reference of a deliveries and invoices selection which can be entered, by default, in the interface setup function.

  • field FIL0405

 

  • field FIL040502

 

  • Closed orders (field HISSOHFLG)

This checkbox cannot be entered. Its value comes from the interface setup.
It is checked to indicate that the sales history comes from the paid orders for which a quantity has been delivered or invoiced.
When a selection reference is entered in the Order selectionfield, this selection is also applied to the sales history.

  • End date (field HSOHENDDAT)

A date range can be entered to limit the history exported.

This range is limited by:
- an end date
- a start date

End date: It is either possible to enter a fixed end date, or to indicate that the end date taken into account must correspond to the current date.
Start date: It is either possible to enter a fixed start date or to indicate the number of days to take into account before the end date.

  • Current date (field HSOHEDTFLG)

This checkbox can only be accessed if any end date has been entered. It is then automatically activated.
The end date taken into account to determine the period concerned by the sales history export, will systematically be the same as the current date.

  • field FIL0406

 

  • field FIL040602

 

  • Start date (field HSOHSTRDAT)

A date range can be entered to limit the history exported.

This range is limited by:
- an end date
- a start date

End date: It is either possible to enter a fixed end date, or to indicate that the end date taken into account must correspond to the current date.
Start date: It is either possible to enter a fixed start date or to indicate the number of days to take into account before the end date.

  • End - no. days (field HSOHNDSTR)

This field can only be accessed if any start date has been entered. It is used to enter the number of days taken into account before the end date to determine the period concerned by the sales history export.

This field, that cannot be modified, contains the code of the pivot describing the lines of the Sales orders in progress file to export: carnet.csv.  
This pivot code is entered in the setup of the interface.
It is possible to filter the open orders to export by entering a selection reference in the field Orders selection.
SEEINFOIn case the sales history comes from deliveries and invoices, an open order can have a quantity already delivered which will be taken into account in the history. The quantity taken into account in the WIP corresponds to the quantity remaining to be delivered.

  • field FLGSOHPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

Imports

This field, that cannot be modified, contains the pivot code describing the file lines of the Sales forecasts to import: previsions.csv.
This pivot code is entered at the level of the interface setup.

  • field FLGSOSPIT

Cette case à cocher, activée par défaut, permet de prendre en compte ce flux dans le traitement d'interface.

  • field FIL0501

 

  • Deletion of forecasts by product (field SOSDLTFLG)

This checkbox is used to indicate that the former forecasts of each product of the imported file will be deleted before importing the new ones.
It can be checked at the same time as the RTZ of forecasts box.

  • Forecast rtz (field SOSRAZFLG)

This checkbox is used to specify that all the forecasts will be deleted before processing the file.
It can be checked at the same time as the Deletion of forecasts by product box.

Close

 

Batch task

This function can be run in batch mode. The standard task SCMAINT is provided for that purpose.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation