Connector Improvement: D365 Associated Entity Fields for Foreign Key Fields
When Microsoft Dynamics is replicated through other services (Microsoft Data Export Service / TIBCO), there are additional fields generated for foreign key fields.
These fields are particularly helpful in instances a field can link to different tables, depending on the record. The entitytype field tells you which table that record links to.
The other fields are convenience fields that pull in high level data from the joined record. These can be helpful if you don't want to join to the other table, but you do need that high level information.
For example:
ENTITY: contact
FIELD: parentcustomerid
EXTRA GENERATED FIELDS:
- parentcustomerid_entitytype (tells whether this links to a contact or account)
- parentcustomeridtype
- parentcustomeridname
- parentcustomeridyominame
In the above example, without explicitly checking whether the parentcustomerid exists in the Account or Contact entity, we don't know what table that parentcustomerid joins to. The entitytype fields are useful and important in many instances.
Thus, my question is why doesn't Fivetran generate these fields? Can you enhance your connector to include these fields, mimicking the way Microsoft's own replication service works? Or can the connector already include these fields and I'm just not seeing where I can enable the option to include them?
Let me know if you need more details or have any questions.
-
Please provide a reply for this request @...
-
Below is our Contact entity showing a more explicit comparison of the fields.
In addition to the missing fields, you will see that every column name that has a number in it is renamed to have an _ precede the number. My assumption is that this is a poor implementation of a safeguard to Snowflake's requirement that object names cannot start with a number. Blindly putting an _ before any number in any field name, regardless of whether it is at the start of the field name, makes it a nuisance when transferring queries from dynamics.
Additionally, the change to any foreign key field to name it with a preceding _ and _VALUE after it also is a nuisance.
While I wanted to call out these design decisions making extra work when moving queries, the missing fields is an enhancement that would be extremely helpful:
Fivetran Snowflake Table MicrosoftReplicationService equivalent name _ACCOUNTID_VALUE accountid FALSE accountid_entitytype FALSE accountidname FALSE accountidyominame FALSE ACCOUNTROLECODE accountrolecode TRUE ADDRESS_1_ADDRESSID address1_addressid FALSE ADDRESS_1_ADDRESSTYPECODE address1_addresstypecode FALSE ADDRESS_1_CITY address1_city FALSE ADDRESS_1_COMPOSITE address1_composite FALSE ADDRESS_1_COUNTRY address1_country FALSE ADDRESS_1_COUNTY address1_county FALSE ADDRESS_1_FAX address1_fax FALSE ADDRESS_1_FREIGHTTERMSCODE address1_freighttermscode FALSE ADDRESS_1_LATITUDE address1_latitude FALSE ADDRESS_1_LINE_1 address1_line1 FALSE ADDRESS_1_LINE_2 address1_line2 FALSE ADDRESS_1_LINE_3 address1_line3 FALSE ADDRESS_1_LONGITUDE address1_longitude FALSE ADDRESS_1_NAME address1_name FALSE ADDRESS_1_POSTALCODE address1_postalcode FALSE ADDRESS_1_POSTOFFICEBOX address1_postofficebox FALSE ADDRESS_1_PRIMARYCONTACTNAME address1_primarycontactname FALSE ADDRESS_1_SHIPPINGMETHODCODE address1_shippingmethodcode FALSE ADDRESS_1_STATEORPROVINCE address1_stateorprovince FALSE ADDRESS_1_TELEPHONE_1 address1_telephone1 FALSE ADDRESS_1_TELEPHONE_2 address1_telephone2 FALSE ADDRESS_1_TELEPHONE_3 address1_telephone3 FALSE ADDRESS_1_UPSZONE address1_upszone FALSE ADDRESS_1_UTCOFFSET address1_utcoffset FALSE ADDRESS_2_ADDRESSID address2_addressid FALSE ADDRESS_2_ADDRESSTYPECODE address2_addresstypecode FALSE ADDRESS_2_CITY address2_city FALSE ADDRESS_2_COMPOSITE address2_composite FALSE ADDRESS_2_COUNTRY address2_country FALSE ADDRESS_2_COUNTY address2_county FALSE ADDRESS_2_FAX address2_fax FALSE ADDRESS_2_FREIGHTTERMSCODE address2_freighttermscode FALSE ADDRESS_2_LATITUDE address2_latitude FALSE ADDRESS_2_LINE_1 address2_line1 FALSE ADDRESS_2_LINE_2 address2_line2 FALSE ADDRESS_2_LINE_3 address2_line3 FALSE ADDRESS_2_LONGITUDE address2_longitude FALSE ADDRESS_2_NAME address2_name FALSE ADDRESS_2_POSTALCODE address2_postalcode FALSE ADDRESS_2_POSTOFFICEBOX address2_postofficebox FALSE ADDRESS_2_PRIMARYCONTACTNAME address2_primarycontactname FALSE ADDRESS_2_SHIPPINGMETHODCODE address2_shippingmethodcode FALSE ADDRESS_2_STATEORPROVINCE address2_stateorprovince FALSE ADDRESS_2_TELEPHONE_1 address2_telephone1 FALSE ADDRESS_2_TELEPHONE_2 address2_telephone2 FALSE ADDRESS_2_TELEPHONE_3 address2_telephone3 FALSE ADDRESS_2_UPSZONE address2_upszone FALSE ADDRESS_2_UTCOFFSET address2_utcoffset FALSE ADDRESS_3_ADDRESSID address3_addressid FALSE ADDRESS_3_ADDRESSTYPECODE address3_addresstypecode FALSE ADDRESS_3_CITY address3_city FALSE ADDRESS_3_COMPOSITE address3_composite FALSE ADDRESS_3_COUNTRY address3_country FALSE ADDRESS_3_COUNTY address3_county FALSE ADDRESS_3_FAX address3_fax FALSE ADDRESS_3_FREIGHTTERMSCODE address3_freighttermscode FALSE ADDRESS_3_LATITUDE address3_latitude FALSE ADDRESS_3_LINE_1 address3_line1 FALSE ADDRESS_3_LINE_2 address3_line2 FALSE ADDRESS_3_LINE_3 address3_line3 FALSE ADDRESS_3_LONGITUDE address3_longitude FALSE ADDRESS_3_NAME address3_name FALSE ADDRESS_3_POSTALCODE address3_postalcode FALSE ADDRESS_3_POSTOFFICEBOX address3_postofficebox FALSE ADDRESS_3_PRIMARYCONTACTNAME address3_primarycontactname FALSE ADDRESS_3_SHIPPINGMETHODCODE address3_shippingmethodcode FALSE ADDRESS_3_STATEORPROVINCE address3_stateorprovince FALSE ADDRESS_3_TELEPHONE_1 address3_telephone1 FALSE ADDRESS_3_TELEPHONE_2 address3_telephone2 FALSE ADDRESS_3_TELEPHONE_3 address3_telephone3 FALSE ADDRESS_3_UPSZONE address3_upszone FALSE ADDRESS_3_UTCOFFSET address3_utcoffset FALSE AGING_30 aging30 FALSE AGING_30_BASE aging30_base FALSE AGING_60 aging60 FALSE AGING_60_BASE aging60_base FALSE AGING_90 aging90 FALSE AGING_90_BASE aging90_base FALSE ANNIVERSARY anniversary TRUE ANNUALINCOME annualincome TRUE ANNUALINCOME_BASE annualincome_base TRUE ASSISTANTNAME assistantname TRUE ASSISTANTPHONE assistantphone TRUE BIRTHDATE birthdate TRUE BUSINESS_2 business2 FALSE BUSINESSCARD businesscard TRUE BUSINESSCARDATTRIBUTES businesscardattributes TRUE CALLBACK callback TRUE CHILDRENSNAMES childrensnames TRUE CNCY_ACCOUNTMANAGERACCEPTED cncy_accountmanageraccepted TRUE CNCY_ACCOUNTNUMBER cncy_accountnumber TRUE CNCY_ADDRESS_1_ADDRESSTYPE cncy_address1_ismailing FALSE CNCY_ADDRESS_1_COUNTRY cncy_address1_isprimary FALSE CNCY_ADDRESS_1_ISMAILING cncy_address1addresstype FALSE CNCY_ADDRESS_1_ISPRIMARY cncy_address1country FALSE CNCY_ADDRESS_1_STATE cncy_address1state FALSE CNCY_ADDRESS_2_ADDRESSTYPE cncy_address2addresstype FALSE CNCY_ADDRESS_2_COUNTRY cncy_address2country FALSE CNCY_ADDRESS_2_STATE cncy_address2state FALSE CNCY_ADDRESSLINE_4 cncy_addressline4 FALSE CNCY_ADDRESSTYPE cncy_addresstype TRUE CNCY_ALLOWEXTENSION cncy_allowextension TRUE CNCY_AMADATE cncy_amadate TRUE CNCY_APTCERT cncy_aptcert TRUE CNCY_ASC cncy_asc TRUE CNCY_ASDCERT cncy_asdcert TRUE CNCY_ATTENTION cncy_attention TRUE CNCY_BDS cncy_bds TRUE CNCY_BEHAVIORSCORE cncy_behaviorscore TRUE CNCY_BILLINDIVIDUALLY cncy_billindividually TRUE CNCY_CAMPAIGNCODE cncy_campaigncode TRUE CNCY_CH_3 cncy_ch3 FALSE CNCY_CH_3_CERT cncy_ch3cert FALSE CNCY_CHAPTERREGION cncy_chapterregion TRUE CNCY_CILEVEL cncy_cilevel TRUE CNCY_CISTATUS cncy_cistatus TRUE CNCY_CLASSESTAUGHT cncy_classestaught TRUE CNCY_CLASSESTAUGHT_DATE cncy_classestaught_date TRUE CNCY_CLASSESTAUGHT_STATE cncy_classestaught_state TRUE CNCY_CMSSYNCRETRIES cncy_cmssyncretries TRUE CNCY_CMSSYNCSTUCK cncy_cmssyncstuck TRUE CNCY_CMSSYNCTOGGLE cncy_cmssynctoggle TRUE CNCY_CONTACTROLE cncy_contactrole TRUE CNCY_CPI cncy_cpi TRUE CNCY_CUSTCODE cncy_custcode TRUE CNCY_CUSTOMERCLASS cncy_customerclass TRUE CNCY_CUSTOMERNUMBER cncy_customernumber TRUE CNCY_DCCB cncy_dccb TRUE CNCY_DCCBCERT cncy_dccbcert TRUE CNCY_DCSCERT cncy_dcscert TRUE CNCY_DECEASED cncy_deceased TRUE CNCY_DEMOGRAPHICSCORE cncy_demographicscore TRUE CNCY_DEPARTMENT cncy_department TRUE CNCY_DISCIPLINE cncy_discipline TRUE CNCY_DOCEBOID cncy_doceboid TRUE CNCY_DRCCERT cncy_drccert TRUE CNCY_EMAILALLOWANCECHANGED cncy_emailallowancechanged TRUE CNCY_EMAILUNKNOWN cncy_emailunknown TRUE CNCY_ENROLLSHIPADDRESS cncy_enrollshipaddress TRUE CNCY_EVENTCITY cncy_eventcity TRUE CNCY_EVENTDATES cncy_eventdates TRUE CNCY_EVENTNUMBER cncy_eventnumber TRUE CNCY_EVSCERT cncy_evscert TRUE CNCY_EXCLUDEFROMDOCUMENTATION cncy_excludefromdocumentation TRUE CNCY_EXCLUDEFROMDOCUMENTATIONDATE cncy_excludefromdocumentationdate TRUE CNCY_FRANCEGENERALMARKETTYPE cncy_francegeneralmarkettype TRUE CNCY_FRANCESECTOR cncy_francesector TRUE CNCY_FRANCESPECIFICMARKETTYPE cncy_francespecificmarkettype TRUE CNCY_GDPRCONSENT cncy_gdprconsent TRUE CNCY_GP cncy_gp TRUE CNCY_GPSYNCRETRIES cncy_gpsyncretries TRUE CNCY_GPSYNCSTUCK cncy_gpsyncstuck TRUE CNCY_GPSYNCTOGGLE cncy_gpsynctoggle TRUE CNCY_HYBRIDCERT cncy_hybridcert TRUE CNCY_ICP cncy_icp TRUE CNCY_INITIALDATASOURCE cncy_initialdatasource TRUE CNCY_INITIALDATASOURCEID cncy_initialdatasourceid TRUE CNCY_ISBA cncy_isba TRUE CNCY_ISLEARNER cncy_islearner TRUE CNCY_ISLMSINSTRUCTOR cncy_islmsinstructor TRUE CNCY_KENTICOID cncy_kenticoid TRUE CNCY_LEADSOURCE cncy_leadsource TRUE CNCY_LINKEDGP cncy_linkedgp TRUE CNCY_LOCATIONCODE cncy_locationcode TRUE CNCY_MAPACERT cncy_mapacert TRUE CNCY_MAPS cncy_maps TRUE _CNCY_MARKETINGLIST_VALUE cncy_marketinglist FALSE cncy_marketinglist_entitytype FALSE cncy_marketinglistname FALSE CNCY_MARKETOID cncy_marketoid TRUE CNCY_MARKETTYPE cncy_markettype TRUE CNCY_MEAS cncy_meas TRUE CNCY_MIGRATEDFROMEXTERNALSYSTEM cncy_migratedfromexternalsystem TRUE CNCY_MIGRATIONDETAILS cncy_migrationdetails TRUE CNCY_NCIAPSQUALIFICATION cncy_nciapsqualification TRUE CNCY_NCICERT cncy_ncicert TRUE CNCY_NCICYCLEENDDATE cncy_ncicycleenddate TRUE CNCY_NCICYCLESTARTDATE cncy_ncicyclestartdate TRUE CNCY_NCIE cncy_ncie TRUE CNCY_NCIEFFECTIVEDATE cncy_ncieffectivedate TRUE CNCY_NOPHYSICALS cncy_nophysicals TRUE CNCY_OLDCUSTOMERID cncy_oldcustomerid TRUE CNCY_OPENCRMID cncy_opencrmid TRUE CNCY_OPTIN cncy_optin TRUE CNCY_OPTINDATE cncy_optindate TRUE CNCY_OPTOUT cncy_optout TRUE CNCY_PINGUSERID cncy_pinguserid TRUE CNCY_PIVOTALID cncy_pivotalid TRUE CNCY_PREFIX cncy_prefix TRUE CNCY_PRIMARYCONTACT cncy_primarycontact TRUE CNCY_PRIMARYLANGUAGE cncy_primarylanguage TRUE CNCY_PRIORITYCODE cncy_prioritycode TRUE CNCY_PRIORITYCODE_1 cncy_prioritycode1 FALSE CNCY_PROFESSIONALSTANDARD cncy_professionalstandard TRUE CNCY_PROFSTDDATE cncy_profstddate TRUE CNCY_PTPCERT cncy_ptpcert TRUE CNCY_QCF cncy_qcf TRUE CNCY_RANK cncy_rank TRUE CNCY_RENEWAL cncy_renewal TRUE CNCY_RENEWALYEAR cncy_renewalyear TRUE CNCY_RESTRICTED cncy_restricted TRUE CNCY_RETIRED cncy_retired TRUE CNCY_ROLE cncy_role TRUE CNCY_SALESMARKETTYPE cncy_salesmarkettype TRUE CNCY_SALESPRIORITYCODE cncy_salesprioritycode TRUE _CNCY_SALESPRIORITYCODEID_VALUE cncy_salesprioritycodeid FALSE cncy_salesprioritycodeid_entitytype FALSE cncy_salesprioritycodeidname FALSE CNCY_SECONDOWNER cncy_secondowner TRUE CNCY_SHIPPINGMETHOD cncy_shippingmethod TRUE CNCY_SLXACCOUNTID cncy_slxaccountid TRUE CNCY_SLXCONTACTID cncy_slxcontactid TRUE _CNCY_SLXCREATEBY_VALUE cncy_slxcreateby FALSE cncy_slxcreateby_entitytype FALSE cncy_slxcreatebyname FALSE cncy_slxcreatebyyominame FALSE CNCY_SLXCREATEDATE cncy_slxcreatedate TRUE CNCY_STATUS cncy_status TRUE CNCY_STRATEGICACCOUNTS cncy_strategicaccounts TRUE CNCY_SURVEYMONKEYID cncy_surveymonkeyid TRUE CNCY_TAXEXEMPT cncy_taxexempt TRUE CNCY_TAXSCHEDULE cncy_taxschedule TRUE CNCY_TERRITORYCODE cncy_territorycode TRUE CNCY_TICCERT cncy_ticcert TRUE CNCY_TITLECODE cncy_titlecode TRUE CNCY_TOTALCLASSES cncy_totalclasses TRUE CNCY_TOTALHOURS cncy_totalhours TRUE CNCY_TOTALPARTICIPANTS cncy_totalparticipants TRUE _CNCY_TRAININGPARTNER_VALUE cncy_trainingpartner FALSE cncy_trainingpartner_entitytype FALSE cncy_trainingpartnername FALSE CNCY_TYPE cncy_type TRUE CNCY_UHS cncy_uhs TRUE CNCY_VIROLE cncy_virole TRUE CNCY_WORKPHONEEXTENSION cncy_workphoneextension TRUE COMPANY company TRUE CONTACTID contactid TRUE CPI_ASSETS cpi_assets TRUE _CREATEDBY_VALUE createdby FALSE createdby_entitytype FALSE createdbyname FALSE createdbyyominame FALSE _CREATEDBYEXTERNALPARTY_VALUE createdbyexternalparty FALSE createdbyexternalparty_entitytype FALSE createdbyexternalpartyname FALSE createdbyexternalpartyyominame FALSE CREATEDON createdon TRUE _CREATEDONBEHALFBY_VALUE createdonbehalfby FALSE createdonbehalfby_entitytype FALSE createdonbehalfbyname FALSE createdonbehalfbyyominame FALSE CREDITLIMIT creditlimit TRUE CREDITLIMIT_BASE creditlimit_base TRUE CREDITONHOLD creditonhold TRUE CUSTOMERSIZECODE customersizecode TRUE CUSTOMERTYPECODE customertypecode TRUE _DEFAULTPRICELEVELID_VALUE defaultpricelevelid FALSE defaultpricelevelid_entitytype FALSE defaultpricelevelidname FALSE DEPARTMENT department TRUE DESCRIPTION description TRUE DONOTBULKEMAIL donotbulkemail TRUE DONOTBULKPOSTALMAIL donotbulkpostalmail TRUE DONOTEMAIL donotemail TRUE DONOTFAX donotfax TRUE DONOTPHONE donotphone TRUE DONOTPOSTALMAIL donotpostalmail TRUE DONOTSENDMM donotsendmm TRUE EDUCATIONCODE educationcode TRUE EMAILADDRESS_1 emailaddress1 FALSE EMAILADDRESS_2 emailaddress2 FALSE EMAILADDRESS_3 emailaddress3 FALSE EMPLOYEEID employeeid TRUE ENTITYIMAGE FALSE ENTITYIMAGE_TIMESTAMP entityimage_timestamp TRUE ENTITYIMAGE_URL entityimage_url TRUE ENTITYIMAGEID entityimageid TRUE EXCHANGERATE exchangerate TRUE EXTERNALUSERIDENTIFIER externaluseridentifier TRUE FAMILYSTATUSCODE familystatuscode TRUE FAX fax TRUE FIRSTNAME firstname TRUE FOLLOWEMAIL followemail TRUE FTPSITEURL ftpsiteurl TRUE FULLNAME fullname TRUE GENDERCODE gendercode TRUE GOVERNMENTID governmentid TRUE HASCHILDRENCODE haschildrencode TRUE HOME_2 home2 FALSE Id FALSE IMPORTSEQUENCENUMBER importsequencenumber TRUE isautocreate FALSE ISBACKOFFICECUSTOMER isbackofficecustomer TRUE isprivate FALSE JOBTITLE jobtitle TRUE LASTNAME lastname TRUE LASTONHOLDTIME lastonholdtime TRUE LASTUSEDINCAMPAIGN lastusedincampaign TRUE LEADSOURCECODE leadsourcecode TRUE MANAGERNAME managername TRUE MANAGERPHONE managerphone TRUE MARKETINGONLY marketingonly TRUE _MASTERID_VALUE masterid FALSE masterid_entitytype FALSE mastercontactidname FALSE mastercontactidyominame FALSE MERGED merged TRUE MIDDLENAME middlename TRUE MKT_BIRTHMARK mkt_birthmark TRUE MKT_LEADSCORE mkt_leadscore TRUE MKT_WATERMARK mkt_watermark TRUE MOBILEPHONE mobilephone TRUE _MODIFIEDBY_VALUE modifiedby FALSE modifiedby_entitytype FALSE modifiedbyname FALSE modifiedbyyominame FALSE _MODIFIEDBYEXTERNALPARTY_VALUE modifiedbyexternalparty FALSE modifiedbyexternalparty_entitytype FALSE modifiedbyexternalpartyname FALSE modifiedbyexternalpartyyominame FALSE MODIFIEDON modifiedon TRUE _MODIFIEDONBEHALFBY_VALUE modifiedonbehalfby FALSE modifiedonbehalfby_entitytype FALSE modifiedonbehalfbyname FALSE modifiedonbehalfbyyominame FALSE MSDYN_GDPROPTOUT msdyn_gdproptout TRUE MSDYN_ORGCHANGESTATUS msdyn_orgchangestatus TRUE _MSDYN_SEGMENTID_VALUE msdyn_segmentid FALSE msdyn_segmentid_entitytype FALSE msdyn_segmentidname FALSE NEW_SYNCTOMKTO new_synctomkto TRUE NICKNAME nickname TRUE NUMBEROFCHILDREN numberofchildren TRUE ONHOLDTIME onholdtime TRUE _ORIGINATINGLEADID_VALUE originatingleadid FALSE originatingleadid_entitytype FALSE originatingleadidname FALSE originatingleadidyominame FALSE OVERRIDDENCREATEDON overriddencreatedon TRUE _OWNERID_VALUE ownerid FALSE ownerid_entitytype FALSE owneridname FALSE owneridtype FALSE owneridyominame FALSE _OWNINGBUSINESSUNIT_VALUE owningbusinessunit FALSE owningbusinessunit_entitytype FALSE owningbusinessunitname FALSE _OWNINGTEAM_VALUE owningteam FALSE owningteam_entitytype FALSE _OWNINGUSER_VALUE owninguser FALSE owninguser_entitytype FALSE PAGER pager TRUE _PARENT_CONTACTID_VALUE parent_contactid FALSE parent_contactid_entitytype FALSE parent_contactidname FALSE parent_contactidyominame FALSE _PARENTCONTACTID_VALUE parentcontactid FALSE parentcontactid_entitytype FALSE parentcontactidname FALSE parentcontactidyominame FALSE _PARENTCUSTOMERID_VALUE parentcustomerid FALSE parentcustomerid_entitytype FALSE parentcustomeridname FALSE parentcustomeridtype FALSE parentcustomeridyominame FALSE PARTICIPATESINWORKFLOW participatesinworkflow TRUE PAYMENTTERMSCODE paymenttermscode TRUE PREFERREDAPPOINTMENTDAYCODE preferredappointmentdaycode TRUE PREFERREDAPPOINTMENTTIMECODE preferredappointmenttimecode TRUE PREFERREDCONTACTMETHODCODE preferredcontactmethodcode TRUE _PREFERREDEQUIPMENTID_VALUE preferredequipmentid FALSE preferredequipmentid_entitytype FALSE preferredequipmentidname FALSE _PREFERREDSERVICEID_VALUE preferredserviceid FALSE preferredserviceid_entitytype FALSE preferredserviceidname FALSE _PREFERREDSYSTEMUSERID_VALUE preferredsystemuserid FALSE preferredsystemuserid_entitytype FALSE preferredsystemuseridname FALSE preferredsystemuseridyominame FALSE PROCESSID processid TRUE SALUTATION salutation TRUE SHIPPINGMETHODCODE shippingmethodcode TRUE SinkCreatedOn FALSE SinkModifiedOn FALSE SL_MOST_RECENT_CADENCE_CADENCE_NAME sl_most_recent_cadence_cadence_name TRUE SL_MOST_RECENT_CADENCE_LAST_COMPLETED_STEP sl_most_recent_cadence_last_completed_step TRUE SL_MOST_RECENT_CADENCE_NEXT_DUE_DATE sl_most_recent_cadence_next_due_date TRUE _SLAID_VALUE slaid FALSE slaid_entitytype FALSE slaname FALSE _SLAINVOKEDID_VALUE slainvokedid FALSE slainvokedid_entitytype FALSE slainvokedidname FALSE SPOUSESNAME spousesname TRUE STAGEID stageid TRUE STATECODE statecode TRUE STATUSCODE statuscode TRUE SUBSCRIPTIONID subscriptionid TRUE SUFFIX suffix TRUE TEAMSFOLLOWED teamsfollowed TRUE TELEPHONE_1 telephone1 FALSE TELEPHONE_2 telephone2 FALSE TELEPHONE_3 telephone3 FALSE TERRITORYCODE territorycode TRUE TIMESPENTBYMEONEMAILANDMEETINGS timespentbymeonemailandmeetings TRUE TIMEZONERULEVERSIONNUMBER timezoneruleversionnumber TRUE _TRANSACTIONCURRENCYID_VALUE transactioncurrencyid FALSE transactioncurrencyid_entitytype FALSE transactioncurrencyidname FALSE TRAVERSEDPATH traversedpath TRUE UTCCONVERSIONTIMEZONECODE utcconversiontimezonecode TRUE VERSIONNUMBER versionnumber TRUE WEBSITEURL websiteurl TRUE WIPFLI_SENDTOGP wipfli_sendtogp TRUE YOMIFIRSTNAME yomifirstname TRUE YOMIFULLNAME yomifullname TRUE YOMILASTNAME yomilastname TRUE YOMIMIDDLENAME yomimiddlename TRUE
Please sign in to leave a comment.
Comments
2 comments