CEGID Y2 - Field Settings

1. Set Up Fields to Be Displayed

Menu path: Specifics > Data quality connector > Field settings.

This feature is available from version 1.1.18. It allows you to add fields from the TIERS and TIERSCOMPL tables so that they can be transmitted in the URL and receive data entered in the partner form.

The partner must also take these additional fields into account in their form.

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

Free Tables

To manage free tables from YTC_TABLELIBRETIERS1 to YTC_TABLELIBRETIERSA, you must perform a free export to the partner containing the possible values for these tables.

Transmission Through CbrOpenBrowser

From version 1.4.24, any field from the TIERS table 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.

Fields Updated on Web Page Return

In version 1.5.1, the possibility was added to configure a field in the TIERS table so that it can be updated when the web page is returned.

A Boolean field, ZY2_TOUPDATE, has been added to ZRELCHAMPY2. When checked, this field allows updates from the partner return. This parameter can be checked for all fields available in the list of fields to be added.

When this field is checked in the settings form, an alert message is displayed to warn the person configuring the parameter that they are responsible for this setting and its consequences.

When installing this version, the following fields must be checked if they will be updated by the partner return:

• T_EAN
• T_COMMERCIAL
• All YTC fields available in the field settings.

Warning

Overwriting data in the Y2 TIERS table with data returned by the partner is the responsibility of the person configuring this parameter.

You must check functionally that updates coming from the partner page will not cause any issue in Y2.

Examples of sensitive fields include T_ETABLISSEMENT, T_ETABCREATION, and T_NATUREAUXI.

SQL Query Applied at Launch

An SQL query has been added to update the new ZY2_TOUPDATE field when the application is launched. No special handling is required when installing this version.

The SQL query is:

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