Model / INT / CHNL

INT — Universal Interaction Journal

CHNL

10 fields · 2 key · 1 foreign keys · sourced from EVEglyphDesign canonical structure.

Channel master. The medium an interaction travelled over — voice, chat, email, portal, field visit, in person, satellite link, letter. Held as master data so that a channel nobody has thought of yet is an insert, not a schema change.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
CNL_CLV keycanalis clavisChannel keyEGD_CHANNLCHAR 10
CNL_DSCcanalis descriptioChannel descriptionTEXT60CHAR 60
CNL_CTS_PSNcanalis coetus personaChannel group: synchronous, asynchronous or in personEGD_CHNGRPCHAR 4
CNLcanalisChannel is synchronous — both parties present at onceXFELDCHAR 1
CNL_TLPcanalis telephoniaChannel requires the telephony extensionXFELDCHAR 1
CNL_STLcanalis satellesChannel requires the satellite extensionXFELDCHAR 1
NRM_SMP_UNInorma sumptus unitasStandard cost per unit of use of this channelEGD_EFFAMTCURR 23,2
CVM_NRM_SMPclavis monetae norma sumptusCurrency key of the standard costWAERSCUKY 5TCURC
CLSclassisAccessibility class — channels that reach people other channels do notEGD_ACCESSCHAR 4

Foreign keys

FieldCheck tableCheck field
CHANNLCHNLCHANNL

View CHNL.yaml in the repository