msdyn_fact EntityType

Aggregated fact entity for actual transactions.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_facts
Base Type
crmbaseentity
Display Name
Fact
Primary Key
msdyn_factid
Primary Key Attribute
msdyn_name
Operations Supported
POST GET PATCH DELETE

Properties

Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
exchangerate Edm.Decimal

Exchange rate for the currency associated with the entity with respect to the base currency.

Display Name: Exchange Rate

Read Only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
msdyn_actchargeablebilledsalesamount Edm.Decimal

Display Name: Actual Chargeable Billed Sales Amount

msdyn_actchargeablebilledsalesamount_base Edm.Decimal

Value of the Actual Chargeable Billed Sales Amount in base currency.

Display Name: Actual Chargeable Billed Sales Amount (Base)

Read Only
msdyn_actchargeablebilledsalesquantity Edm.Decimal

Display Name: Actual Chargeable Billed Sales Quantity

msdyn_actchargeablecostamount Edm.Decimal

Display Name: Actual Chargeable Cost Amount

msdyn_actchargeablecostamount_base Edm.Decimal

Value of the Actual Chargeable Cost Amount in base currency.

Display Name: Actual Chargeable Cost Amount (Base)

Read Only
msdyn_actchargeablecostquantity Edm.Decimal

Display Name: Actual Chargeable Cost Quantity

msdyn_actchargeableunbilledsalesamount Edm.Decimal

Display Name: Actual Chargeable Unbilled Sales Amount

msdyn_actchargeableunbilledsalesamount_base Edm.Decimal

Value of the Actual Chargeable Unbilled Sales Amount in base currency.

Display Name: Actual Chargeable Unbilled Sales Amount (Base)

Read Only
msdyn_actchargeableunbilledsalesquantity Edm.Decimal

Display Name: Actual Chargeable Unbilled Sales Quantity

msdyn_actnochargebilledsalesamount Edm.Decimal

Display Name: Actual No Charge Billed Sales Amount

msdyn_actnochargebilledsalesamount_base Edm.Decimal

Value of the Actual No Charge Billed Sales Amount in base currency.

Display Name: Actual No Charge Billed Sales Amount (Base)

Read Only
msdyn_actnochargebilledsalesquantity Edm.Decimal

Display Name: Actual No Charge Billed Sales Quantity

msdyn_actnochargecostamount Edm.Decimal

Display Name: Actual No Charge Cost Amount

msdyn_actnochargecostamount_base Edm.Decimal

Value of the Actual No Charge Cost Amount in base currency.

Display Name: Actual No Charge Cost Amount (Base)

Read Only
msdyn_actnochargecostquantity Edm.Decimal

Display Name: Actual No Charge Cost Quantity

msdyn_actnochargeunbilledsalesamount Edm.Decimal

Display Name: Actual No Charge Unbilled Sales Amount

msdyn_actnochargeunbilledsalesamount_base Edm.Decimal

Value of the Actual No Charge Unbilled Sales Amount in base currency.

Display Name: Actual No Charge Unbilled Sales Amount (Base)

Read Only
msdyn_actnochargeunbilledsalesquantity Edm.Decimal

Display Name: Actual No Charge Unbilled Sales Quantity

msdyn_actnonchargeablecostamount Edm.Decimal

Display Name: Actual Non Chargeable Cost Amount

msdyn_actnonchargeablecostamount_base Edm.Decimal

Value of the Actual Non Chargeable Cost Amount in base currency.

Display Name: Actual Non Chargeable Cost Amount (Base)

Read Only
msdyn_actnonchargeablecostquantity Edm.Decimal

Display Name: Actual Non Chargeable Cost Quantity

msdyn_actnonchargeableunbilledsalesamount Edm.Decimal

Display Name: Actual Non Chargeable Unbilled Sales Amount

msdyn_actnonchargeableunbilledsalesamount_base Edm.Decimal

Value of the Actual Non Chargeable Unbilled Sales Amount in base currency.

Display Name: Actual Non Chargeable Unbilled Sales Amount (Base)

Read Only
msdyn_actnonchargeableunbilledsalesquantity Edm.Decimal

Display Name: Actual Non Chargeable Unbilled Sales Quantity

msdyn_customertype Edm.Int32

Display Name: Customer Type

Default Options
Value Label
192350001 Account
192350002 Contact
msdyn_documentdate Edm.DateTimeOffset

Enter the transaction date of the business event.

Display Name: Document Date

msdyn_earnedrevenue Edm.Decimal

Display Name: Earned Revenue

Read Only
Is Computed
msdyn_earnedrevenue_base Edm.Decimal

Value of the Earned Revenue in base currency.

Display Name: Earned Revenue (Base)

Read Only
Is Computed
msdyn_enddate Edm.DateTimeOffset

Enter the end date for this transaction.

Display Name: End Date

msdyn_estchargeablebilledsalesamount Edm.Decimal

Display Name: Estimated Chargeable Billed Sales Amount

msdyn_estchargeablebilledsalesamount_base Edm.Decimal

Value of the Estimated Chargeable Billed Sales Amount in base currency.

Display Name: Estimated Chargeable Billed Sales Amount (Base)

Read Only
msdyn_estchargeablebilledsalesquantity Edm.Decimal

Display Name: Estimated Chargeable Billed Sales Quantity

msdyn_estchargeablecostamount Edm.Decimal

Display Name: Estimated Chargeable Cost Amount

msdyn_estchargeablecostamount_base Edm.Decimal

Value of the Estimated Chargeable Cost Amount in base currency.

Display Name: Estimated Chargeable Cost Amount (Base)

Read Only
msdyn_estchargeablecostquantity Edm.Decimal

Display Name: Estimated Chargeable Cost Quantity

msdyn_estchargeableunbilledsalesamount Edm.Decimal

Display Name: Estimated Chargeable Unbilled Sales Amount

msdyn_estchargeableunbilledsalesamount_base Edm.Decimal

Value of the Estimated Chargeable Unbilled Sales Amount in base currency.

Display Name: Estimated Chargeable Unbilled Sales Amount (Base)

Read Only
msdyn_estchargeableunbilledsalesquantity Edm.Decimal

Display Name: Estimated Chargeable Unbilled Sales Quantity

msdyn_estnochargebilledsalesamount Edm.Decimal

Display Name: Estimated No Charge Billed Sales Amount

msdyn_estnochargebilledsalesamount_base Edm.Decimal

Value of the Estimated No Charge Billed Sales Amount in base currency.

Display Name: Estimated No Charge Billed Sales Amount (Base)

Read Only
msdyn_estnochargebilledsalesquantity Edm.Decimal

Display Name: Estimated No Charge Billed Sales Quantity

msdyn_estnochargecostamount Edm.Decimal

Display Name: Estimated No Charge Cost Amount

msdyn_estnochargecostamount_base Edm.Decimal

Value of the Estimated No Charge Cost Amount in base currency.

Display Name: Estimated No Charge Cost Amount (Base)

Read Only
msdyn_estnochargecostquantity Edm.Decimal

Display Name: Estimated No Charge Cost Quantity

msdyn_estnochargeunbilledsalesamount Edm.Decimal

Display Name: Estimated No Charge Unbilled Sales Amount

msdyn_estnochargeunbilledsalesamount_base Edm.Decimal

Value of the Estimated No Charge Unbilled Sales Amount in base currency.

Display Name: Estimated No Charge Unbilled Sales Amount (Base)

Read Only
msdyn_estnochargeunbilledsalesquantity Edm.Decimal

Display Name: Estimated No Charge Unbilled Sales Quantity

msdyn_estnonchargeablecostamount Edm.Decimal

Display Name: Estimated Non Chargeable Cost Amount

msdyn_estnonchargeablecostamount_base Edm.Decimal

Value of the Estimated Non Chargeable Cost Amount in base currency.

Display Name: Estimated Non Chargeable Cost Amount (Base)

Read Only
msdyn_estnonchargeablecostquantity Edm.Decimal

Display Name: Estimated Non Chargeable Cost Quantity

msdyn_estnonchargeableunbilledsalesamount Edm.Decimal

Display Name: Estimated Non Chargeable Unbilled Sales Amount

msdyn_estnonchargeableunbilledsalesamount_base Edm.Decimal

Value of the Estimated Non Chargeable Unbilled Sales Amount in base currency.

Display Name: Estimated Non Chargeable Unbilled Sales Amount (Base)

Read Only
msdyn_estnonchargeableunbilledsalesquantity Edm.Decimal

Display Name: Estimated Non Chargeable Unbilled Sales Quantity

msdyn_factid Edm.Guid

Unique identifier for entity instances

Display Name: Fact

msdyn_facttype Edm.Int32

Display Name: Fact Type

Default Options
Value Label
192350000 Actual
192350001 Estimate
msdyn_grossmargin Edm.Decimal

Display Name: Gross Margin

Read Only
Is Computed
msdyn_grossmargin_base Edm.Decimal

Value of the Gross Margin in base currency.

Display Name: Gross Margin (Base)

Read Only
Is Computed
msdyn_name Edm.String

The name of the custom entity.

Display Name: Name

msdyn_salescontractline Edm.String

Display Name: Project Contract Line

msdyn_startdate Edm.DateTimeOffset

Enter the start date.

Display Name: Start Date

msdyn_totalcost Edm.Decimal

Display Name: Total Cost

Read Only
Is Computed
msdyn_totalcost_base Edm.Decimal

Value of the Total Cost in base currency.

Display Name: Total Cost (Base)

Read Only
Is Computed
msdyn_totalhours Edm.Decimal

Display Name: Total Hours

Read Only
Is Computed
msdyn_transactionclassification Edm.Int32

Display Name: Transaction Classification

Default Options
Value Label
690970000 Commission
690970001 Additional
690970002 Tax
192350000 Time
192350001 Expense
192350002 Material
192350003 Milestone
192350004 Fee
msdyn_vendortype Edm.Int32

Display Name: Vendor Type

Default Options
Value Label
192350001 Account
192350002 Contact
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Fact

Display Name: Status

Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Reason for the status of the Fact

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the record.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who modified the record.

_msdyn_accountcustomer_value msdyn_AccountCustomer
_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_bookableresource_value msdyn_bookableresource
_msdyn_contactcustomer_value msdyn_ContactCustomer
_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_estimate_value msdyn_Estimate
_msdyn_estimatelineid_value msdyn_estimatelineid
_msdyn_product_value msdyn_Product
_msdyn_project_value msdyn_Project
_msdyn_resourcecategory_value msdyn_ResourceCategory
_msdyn_salescontract_value msdyn_SalesContract
_msdyn_task_value msdyn_Task
_msdyn_transactioncategory_value msdyn_TransactionCategory
_ownerid_value ownerid

Owner Id

_owningbusinessunit_value owningbusinessunit

Unique identifier for the business unit that owns the record

_owningteam_value owningteam

Unique identifier for the team that owns the record.

_owninguser_value owninguser

Unique identifier for the user that owns the record.

_transactioncurrencyid_value transactioncurrencyid

Shows the currency associated with the entity.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_msdyn_fact_createdby
createdonbehalfby systemuser lk_msdyn_fact_createdonbehalfby
modifiedby systemuser lk_msdyn_fact_modifiedby
modifiedonbehalfby systemuser lk_msdyn_fact_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_fact_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_fact_AccountVendor
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_fact_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_fact_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_fact_ContactVendor
msdyn_Estimate msdyn_estimate msdyn_msdyn_estimate_msdyn_fact_Estimate
msdyn_estimatelineid msdyn_estimateline msdyn_msdyn_estimateline_msdyn_fact_estimatelineid
msdyn_Product product msdyn_product_msdyn_fact_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_fact_Project
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_fact_ResourceCategory
msdyn_SalesContract salesorder msdyn_salesorder_msdyn_fact_SalesContract
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_fact_Task
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_fact_TransactionCategory
ownerid principal owner_msdyn_fact
owningbusinessunit businessunit business_unit_msdyn_fact
owningteam team team_msdyn_fact
owninguser systemuser user_msdyn_fact
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_fact

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
msdyn_fact_Annotations annotation objectid_msdyn_fact
msdyn_fact_AsyncOperations asyncoperation regardingobjectid_msdyn_fact
msdyn_fact_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_fact
msdyn_fact_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_fact
msdyn_fact_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_fact
msdyn_fact_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_fact
msdyn_fact_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_fact
msdyn_fact_ProcessSession processsession regardingobjectid_msdyn_fact
msdyn_fact_SyncErrors syncerror regardingobjectid_msdyn_fact

Operations

The following operations can be used with the msdyn_fact entity type.

Name Binding
GrantAccess Not Bound
IsValidStateTransition Not Bound
ModifyAccess Not Bound
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound

Solutions

The following solutions include the msdyn_fact entity type.

Name Description
Project Service Automation Microsoft Dynamics 365 for Project Service Automation is an end-to-end solution that helps sales and delivery teams engage customers and deliver billable projects on time and within budget. Project Service gives you the tools you need to: Estimate, quote, and contract work; Plan and assign resources; Enable team collaboration; Capture time, expense, and progress data for real-time insights and accurate invoicing.

See also