CEGID Y2 - Appendix

CBS objects

Dictionary Z Tables

ZCAPCONFIG

DQE connector settings

ZRELCHAMPY2

Field mapping between Y2 and DQE

ZTIERSQUALCAP

DQE returned quality code management

Quality codes

Address

VAL = Verified / NOK = Not Verified / MAN = Forcé / NOS = Non soumise

Email1 and Email2

VAL = Verified / OK = Not Verified

Phone

Optins (consent information)

The consent information (Optins) is in the TIERSCOMPL table.

The fields concerned by the Optins, or consents are :

• TIERSCOMPL.YTC_INFOEMAIL1 → Optins for email 1
• TIERSCOMPL.YTC_INFOEMAIL2 → Optins for email 2
• TIERSCOMPL.YTC_INFOTEL1 → Optins from TIERS.T_TELEPHONE (Home phone number)
• TIERSCOMPL.YTC_INFOTEL2 → Optins of TIERS.T_FAX (Tel office)
• TIERSCOMPL.YTC_INFOTEL3 → Optins of TIERST_TELEX (Mobile number)
• TIERSCOMPL.YTC_INFOADRESSE→ Postal address options

The possible values for these fields are : DEM, ENS, PAR, REF

• DEM : to be requested from the customer
• ENS : can be used by the retailer
• PAR : usable by the retailer and partners
• REF : not usable (refused)