web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

FieldOne data model

(0) ShareShare
ReportReport
Posted on by

Hello Community,

I am introducing Dynamics CRM at our manufacturing company. Service is a Major function and FieldOne will be a welcome Addition to CRM. To prepare for the introduction of FieldOne I Need to know the FieldOne data model (as part of Dynamics). Since we have an on-premise CRM Installation we do not yet have FieldOne installed, thus no possibility to  Export the table specifications from SDK. Can anyone Point me to resources / documentation?

Regards,

Amin

PS: this is my first post here. Can anyone tell me how to disable the autocorrection function? As you can see it is Messing up my text ...

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    razdynamics Profile Picture
    17,308 User Group Leader on at

    Hi There

    The following lists the Field one ENtities;

    f1_agreement

    f1_agreementincident

    f1_agreementinvoicedate

    f1_agreementinvoiceproduct

    f1_agreementinvoicesetup

    f1_agreementproduct

    f1_agreementscheduledate

    f1_agreementschedulesetup

    f1_agreementservice

    f1_agreementservicetask

    f1_agreementsubstatus

    f1_customerequipment

    f1_fieldonepricelistitem

    f1_fieldonesetting

    f1_fieldonesystemjob

    f1_glaccount

    f1_incidentproduct

    f1_incidentservice

    f1_incidentservicetask

    f1_incidentskill

    f1_incidenttype

    f1_inventoryadjstproduct

    f1_inventoryadjustment

    f1_inventoryjournal

    f1_inventorytransfer

    f1_ivractivity

    f1_payment

    f1_paymentdetails

    f1_paymentmethod

    f1_paymentterm

    f1_pobill

    f1_poolwogeneration

    f1_poreceipt

    f1_poreceiptproduct

    f1_portalrole

    f1_posubstatus

    f1_potype

    f1_priority

    f1_productinventory

    f1_purchaseorder

    f1_purchaseorderproduct

    f1_resourcecategory

    f1_resourcegroupmember

    f1_resourcepaytype

    f1_resourceskill

    f1_resourceterritory

    f1_rma

    f1_rmaproduct

    f1_rmaproductreason

    f1_rmareceipt

    f1_rmareceiptproduct

    f1_rmasubstatus

    f1_rmatype

    f1_routingoptimizationrequest

    f1_rtv

    f1_rtvproduct

    f1_rtvproductreason

    f1_rtvsubstatus

    f1_rtvtype

    f1_scheduleboardsettings

    f1_scheduletimestamp

    f1_schedulingrule

    f1_servicelevel

    f1_servicetasktype

    f1_shipvia

    f1_skilltype

    f1_smsactivity

    f1_systemuserschedulersettings

    f1_taxcode

    f1_taxcodedetail

    f1_timeoffentity

    f1_timeoffreason

    f1_uniquenumber

    f1_warehouse

    f1_workorder

    f1_workorderincident

    f1_workorderproduct

    f1_workorderresource

    f1_workorderschedulechange

    f1_workorderschedulejournal

    f1_workorderschedulestatus

    f1_workorderservice

    f1_workorderservicetask

    f1_workorderskill

    f1_workorderstatus

    f1_workordertype

    f1_zipcode

    Another way you can analyse the schema is my installing the FieldOne solution on a dev/test/trial and you will see all the objects in the solution. You can also export it to an excell spreadsheet using the XRMtoolbox metadata document generator.

    Does this help? Kindly Verify by Ticking 'Yes' :)

    Best Wishes, Raz

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Gravelhopper, as a Microsoft partner you can ask for access to a learning portal and a so-called playbook from FieldOne. Not sure if you already have access?

    If so, you can find an exhaustive data model under: Diagram of Key Entity Relationships under Support, in the playbook.

    Good luck!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans