1. Setup fields to be displayed

Specifics -> Data quality connector -> Field settings

This feature is available from version 1.1.18. It allows you to add a certain number of fields from the TIERS and TIERSCOMPL tables allowing them to be transmitted in the URL and to receive data entered in the partner's form. It is necessary that the partner is also considered this addition of field in his form.

By default, the fields initially provided for in exchanges with partner forms cannot be modified.

To be able to manage the free tables (YTC_TABLELIBRETIERS1 to YTC_TABLELIBRETIERSA) it will be necessary to make a free export to the partner of the possible values in these tables.

From now on, in Version 1.4.24, any field of the table TIERS can be transmitted via "CbrOpenBrowser". Among the "TIERS" fields configured as "manual control", only the T_COMMENTAIRE and T_EAN fields are processed when the Web page is returned.

In Version 1.5.1, we have added the possibility of setting up a field in the table TIERS table to be updated when the web page is returned.

We have added a Boolean field ZY2_TOUPDATE in ZRELCHAMPY2 which, if checked, will allow updating by the partner's return. This possibility of checking this parameter is present on all the fields present in the choice of the fields to be added.

When this field is checked in the setting form, an alert message will appear to warn the person who sets the parameters that he is responsible for this setting and its consequences.

When installing this new version, it is now necessary to check the fields that will be updated by
the partner's return

• T_EAN
• T_COMMERCIAL
• All the YTC present in the field settings

Warning:

The overwriting of the data in the TIERS table of Y2 by the data coming from the partner is therefore the responsibility of the person who will carry out this parameterisation.

Indeed, it is absolutely necessary to check functionally that the update from the partner's page will not cause any problem in Y2.

For example, on fields such as T_ETABLISSEMENT, T_ETABCREATION or T_NATUREAUXI.

Note: In addition, we have added the execution of an SQL query to update the new "ZY2_TOUPDATE" field when the application is launched. So there is no need for any special handling when installing this version. Here is the SQL query:

UPDATE ZRELCHAMPY2 SET ZY2_TOUPDATE = CASE WHEN ZY2_DOMY2 <> "T" OR
ISNULL(ZY2_MANUALFIELD, "-") <> "X" OR ZY2_FLDY2 in ("T_COMMENTARY", "T_EAN") THEN
"X" ELSE "-" END WHERE ZY2_TOUPDATE IS NULL