Model / INT / ACDOCI

INT — Universal Interaction Journal

ACDOCI

64 fields · 4 key · 6 foreign keys · sourced from EVEglyphDesign canonical structure. Not a vendor table. Mirrors Salesforce and ServiceNow systems of record; extensible to telephony and satellite via IJTEL and IJSAT.

Universal Interaction Journal. The same idea as ACDOCA, applied to human interaction: one line per interaction, carrying every dimension that interaction belongs to, whatever system of record it originated in. A case in Salesforce, an incident in ServiceNow, a phone call, a satellite session and a visit in a parish hall all land as the same shape of row. The source record is never altered and never replaced — SRCSYS, SRCTYP and SRCID always point back to it. Carries the ACDOCA cost-object spine so an interaction can be tied to the money it caused and to the societal effect it produced.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
EPH_ANN keyephemeris commercii annusInteraction journal yearGJAHRNUMC 4
EPH_NDO keyephemeris commercii numerus documentiInteraction journal document numberEGD_IJNOCHAR 20
EPH_POS keyephemeris commercii positioInteraction journal itemEGD_IJLNNUMC 6
FNS_SYS_ITRfons systema tabularum commerciumSource system of record the interaction was mirrored fromEGD_SRCSYSCHAR 10SYSRC
FNS_OBI_TBLfons obiectum tabulaSource object or table name in the system of recordEGD_SRCTYPCHAR 40
TORtabula originisSource record identifier, unalteredEGD_SRCIDCHAR 60
FNS_TPR_ITRfons tabula parentis commerciumSource parent record identifier, where the interaction hangs off a case or requestEGD_SRCIDCHAR 60
ULT_TMS_SORultimus tempus signatum systema originisLast modified timestamp in the source systemTIMESTAMPDEC 15
SPC_TMS_FNSspeculum tempus signatum fonsMirror timestamp — when this line was read from the sourceTIMESTAMPDEC 15
HSH_FNS_ONSsumma digesta fons onusSHA-256 hash of the mirrored source payload, so drift is detectableEGD_EVDHSHCHAR 64
ITR_GEN_VOCcommercium genus vocatioInteraction type: case, incident, call, meeting, message, task, service request or visitEGD_INTTYPCHAR 10ITYP
CNL_ITRcanalis commerciumChannel the interaction travelled overEGD_CHANNLCHAR 10CHNL
DRCdirectioDirection: inbound, outbound or internalEGD_DIRECTCHAR 1
PIN_PSN_CLVpersona incipiens persona clavisInitiating party — pseudonymous party key of whoever began the interactionEGD_PARTYCHAR 32PARTY
PRC_PSN_CLVpersona recipiens persona clavisReceiving party — pseudonymous party key of whoever answeredEGD_PARTYCHAR 32PARTY
PSN_ITRpersona commerciumOwning party — the person or team accountable for the interactionEGD_PARTYCHAR 32PARTY
ORM_ITRorganizatio membri commerciumMember organisation the interaction belongs toEGD_MEMBERCHAR 18MEMBR
SOC_ITRcodex societatis commerciumCompany Code the interaction is attributed toBUKRSCHAR 4T001
CSM_SMP_ITRcentrum sumptus sumptus commerciumCost Center carrying the cost of the interactionKOSTLCHAR 10CSKS
CLU_ITRcentrum lucri commerciumProfit Center carrying the interactionPRCTRCHAR 10CEPC
OPS_ELM_ITRopus elementum commerciumWork Breakdown Structure Element the interaction belongs toPS_PSP_PNRNUMC 8PRPS
MND_NUM_ITRmandatum numerus commerciumOrder Number the interaction belongs toAUFNRCHAR 12AUFK
EMP_NUM_TBLemptor numerus tabulaCustomer Number, where the counterparty is a customer of recordKUNNRCHAR 10KNA1
VEN_RAT_NUMvenditor ratio numerusVendor Account Number, where the counterparty is a supplierLIFNRCHAR 10LFA1
INM_NUM_ITRinstrumentum numerus commerciumEquipment Number the interaction concerns, for field service and maintenanceEQUNRCHAR 18EQUI
ITR_INI_DIEcommercium initium diesInteraction start dateDATUMDATS 8
ITR_INI_TMPcommercium initium tempusInteraction start timeUZEITTIMS 6
ITR_FIN_DIEcommercium finis diesInteraction end dateDATUMDATS 8
ITR_FIN_TMPcommercium finis tempusInteraction end timeUZEITTIMS 6
ITR_MRAcommercium moraInteraction duration in secondsEGD_DURSECDEC 13
ZTM_ITRzona temporis commerciumTime zone the interaction occurred inTZNZONECHAR 6TTZZ
ORD_OPS_CTSordo expectantium opus coetusQueue or work group the interaction was handled inEGD_QUEUECHAR 30
PRI_SORprioritas systema originisPriority assigned in the source systemEGD_PRIORTCHAR 2
GRV_SORgravitas systema originisSeverity assigned in the source systemEGD_SEVERTCHAR 2
STA_SORstatus systema originisCanonical status, crosswalked from the source system statusEGD_STATUSCHAR 10STSMAP
STA_VAL_SORstatus valor systema originisStatus value exactly as held in the source system, never normalised awayEGD_SRCSTACHAR 40
RSL_CODresolutio codexResolution code, crosswalkedEGD_RESCODCHAR 10
RSP_TMPresponsum primum tempusFirst response time in secondsEGD_DURSECDEC 13
TMP_RSLtempus resolutioTime to resolution in secondsEGD_DURSECDEC 13
NUM_ITRnumerus commerciumNumber of times the interaction was reopenedEGD_COUNTNUMC 3
ESC_GRDescalatio gradusEscalation level reachedEGD_COUNTNUMC 3
PSF_ITRpunctum satisfactionis commerciumSatisfaction score recorded for the interactionEGD_CSATSCDEC 5,2
AFF_ITR_CNSaffectus commercium consensusSentiment score derived from the interaction, where consent permits derivationEGD_SENTIMDEC 5,2
ARG_ITRargumentum commerciumTopic classification of the interactionEGD_TOPICCHAR 40
RFR_SORreferentia systema originisSubject reference — pointer to the subject line held in the source systemEGD_SRCIDCHAR 60
RFR_ITR_SORreferentia commercium systema originisContent reference — pointer to the interaction body in the source system. The body is not copied hereEGD_SRCIDCHAR 60
HSH_TBLsumma digesta tabulaSHA-256 hash of the referenced content, so a record cannot be silently rewrittenEGD_EVDHSHCHAR 64
IDX_CNSindex consensusPersonal data indicator: the line references personal data and is consent-scopedXFELDCHAR 1
CNS_STA_ITRconsensus status commerciumConsent status governing use of this interaction recordEGD_CNSSTACHAR 1
CNS_RFRconsensus referentiaConsent reference — the recorded consent this use relies onEGD_SRCIDCHAR 60
RTN_CLVretentio clavisRetention policy key governing how long this line may be heldEGD_RETPOLCHAR 10
IDXindexLegal hold indicator suspending deletionXFELDCHAR 1
LNG_ITRlingua commerciumLanguage the interaction was conducted inSPRASLANG 1T002
PTR_CLV_ITRpatria clavis commerciumCountry Key the interaction occurred inLAND1CHAR 3T005
REG_ITRregio commerciumRegion the interaction occurred inREGIOCHAR 3T005S
GIN_PINgenus instrumenti persona incipiensDevice type used by the initiating partyEGD_DEVTYPCHAR 10
SMS_ITRsumptus serviendi commerciumCost to serve the interactionEGD_EFFAMTCURR 23,2
CVM_SMSclavis monetae sumptus serviendiCurrency key of the cost to serveWAERSCUKY 5TCURC
NDO_ITR_INSnumerus documenti commercium inscriptioAccounting Document Number this interaction caused, where it caused a postingBELNR_DCHAR 10
ANF_DOCannus fiscalis documentumFiscal Year of the accounting documentGJAHRNUMC 4
INS_POS_DOCinscriptio positio documentumPosting item of the accounting documentDOCLN6CHAR 6
EFC_POS_NMReffectus positio numeratorEffect item counter, where the interaction produced a recorded societal effectEGD_EFFLNNUMC 3
RVS_RFR_ITRreversio referentia commerciumReversal reference to the interaction line this line supersedesEGD_IJLNNUMC 6

Foreign keys

FieldCheck tableCheck field
SRCSYSSYSRCSRCSYS
INTTYPITYPINTTYP
CHANNLCHNLCHANNL
MEMBERMEMBRMEMBER
RBUKRST001BUKRS
KOSTLCSKSKOSTL

View ACDOCI.yaml in the repository