Примечание
Для доступа к этой странице требуется авторизация. Вы можете попробовать войти или изменить каталоги.
Для доступа к этой странице требуется авторизация. Вы можете попробовать изменить каталоги.
Record Purchase Orders pertaining to Work Orders or otherwise
Messages
The following table lists the messages for the Purchase Order (msdyn_purchaseorder) table. Messages represent operations that can be performed on the table. They may also be events.
Name Is Event? |
Web API Operation | SDK for .NET |
---|---|---|
Assign Event: True |
PATCH /msdyn_purchaseorders(msdyn_purchaseorderid)Update the ownerid property. |
AssignRequest |
Associate Event: True |
Associate records | Associate records |
BulkRetain Event: True |
BulkRetain | Learn to use messages with the SDK for .NET |
Create Event: True |
POST /msdyn_purchaseordersSee Create |
Create records |
CreateMultiple Event: True |
CreateMultiple | CreateMultipleRequest |
Delete Event: True |
DELETE /msdyn_purchaseorders(msdyn_purchaseorderid)See Delete |
Delete records |
Disassociate Event: True |
Disassociate records | Disassociate records |
GrantAccess Event: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransition Event: False |
IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccess Event: True |
ModifyAccess | ModifyAccessRequest |
PurgeRetainedContent Event: True |
PurgeRetainedContent | Learn to use messages with the SDK for .NET |
Restore Event: True |
Restore | Learn to use messages with the SDK for .NET |
Retain Event: True |
Retain | Learn to use messages with the SDK for .NET |
Retrieve Event: True |
GET /msdyn_purchaseorders(msdyn_purchaseorderid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /msdyn_purchaseordersSee Query data |
Query data |
RetrievePrincipalAccess Event: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess Event: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess Event: True |
RevokeAccess | RevokeAccessRequest |
RollbackRetain Event: True |
RollbackRetain | Learn to use messages with the SDK for .NET |
SetState Event: True |
PATCH /msdyn_purchaseorders(msdyn_purchaseorderid)Update the statecode and statuscode properties. |
SetStateRequest |
Update Event: True |
PATCH /msdyn_purchaseorders(msdyn_purchaseorderid)See Update |
Update records |
UpdateMultiple Event: True |
UpdateMultiple | UpdateMultipleRequest |
Upsert Event: False |
PATCH /msdyn_purchaseorders(msdyn_purchaseorderid)See Upsert a table row |
UpsertRequest |
UpsertMultiple Event: False |
UpsertMultiple | UpsertMultipleRequest |
ValidateRetentionConfig Event: True |
ValidateRetentionConfig | Learn to use messages with the SDK for .NET |
Properties
The following table lists selected properties for the Purchase Order (msdyn_purchaseorder) table.
Property | Value |
---|---|
DisplayName | Purchase Order |
DisplayCollectionName | Purchase Orders |
SchemaName | msdyn_purchaseorder |
CollectionSchemaName | msdyn_purchaseorders |
EntitySetName | msdyn_purchaseorders |
LogicalName | msdyn_purchaseorder |
LogicalCollectionName | msdyn_purchaseorders |
PrimaryIdAttribute | msdyn_purchaseorderid |
PrimaryNameAttribute | msdyn_name |
TableType | Standard |
OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- msdyn_Address1
- msdyn_Address2
- msdyn_Address3
- msdyn_AddressName
- msdyn_AmountBilled
- msdyn_ApprovalStatus
- msdyn_ApprovedRejectedBy
- msdyn_AutoNumbering
- msdyn_Booking
- msdyn_City
- msdyn_Country
- msdyn_DateExpected
- msdyn_InternalFlags
- msdyn_Latitude
- msdyn_Longitude
- msdyn_name
- msdyn_OrderedBy
- msdyn_PaymentTerm
- msdyn_PODate
- msdyn_PostalCode
- msdyn_purchaseorderId
- msdyn_ReceivetoWarehouse
- msdyn_RequestedByResource
- msdyn_ShipTo
- msdyn_ShipVia
- msdyn_StateOrProvince
- msdyn_SubStatus
- msdyn_SystemStatus
- msdyn_TotalAmount
- msdyn_Vendor
- msdyn_VendorNote
- msdyn_WorkOrder
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- processid
- stageid
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- traversedpath
- UTCConversionTimeZoneCode
ImportSequenceNumber
Property | Value |
---|---|
Description | Shows the sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | importsequencenumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
msdyn_Address1
Property | Value |
---|---|
Description | |
DisplayName | Street 1 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_address1 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 250 |
msdyn_Address2
Property | Value |
---|---|
Description | |
DisplayName | Street 2 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_address2 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 250 |
msdyn_Address3
Property | Value |
---|---|
Description | |
DisplayName | Street 3 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_address3 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 250 |
msdyn_AddressName
Property | Value |
---|---|
Description | Enter the location to ship the products of this PO to. |
DisplayName | Address Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_addressname |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 250 |
msdyn_AmountBilled
Property | Value |
---|---|
Description | |
DisplayName | Amount Billed |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_amountbilled |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 900000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_ApprovalStatus
Property | Value |
---|---|
Description | Enter the current status of the approval. |
DisplayName | Approval Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_approvalstatus |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | msdyn_poapprovalstatus |
msdyn_ApprovalStatus Choices/Options
Value | Label |
---|---|
690970000 | Approved |
690970001 | Rejected |
msdyn_ApprovedRejectedBy
Property | Value |
---|---|
Description | The user who approved or rejected this PO |
DisplayName | Approved/Rejected By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_approvedrejectedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
msdyn_AutoNumbering
Property | Value |
---|---|
Description | Internal field used to generate the next name upon entity creation. It is optionally copied to the msdyn_name field. |
DisplayName | Auto-Numbering |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_autonumbering |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
msdyn_Booking
Property | Value |
---|---|
Description | If purchase order is being ordered directly to a booking specify here. Note, when specified, by default all products will receive directly to booking. |
DisplayName | Booking |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_booking |
RequiredLevel | None |
Type | Lookup |
Targets | bookableresourcebooking |
msdyn_City
Property | Value |
---|---|
Description | |
DisplayName | City |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_city |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 80 |
msdyn_Country
Property | Value |
---|---|
Description | |
DisplayName | Country/Region |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_country |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 80 |
msdyn_DateExpected
Property | Value |
---|---|
Description | Enter the date you expect to receive your order. Note that products added once the date is specified here will automatically be set to this date. |
DisplayName | Date Expected |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_dateexpected |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | True |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Auto |
SourceTypeMask | 0 |
msdyn_InternalFlags
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Internal Flags |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_internalflags |
RequiredLevel | None |
Type | Memo |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1048576 |
msdyn_Latitude
Property | Value |
---|---|
Description | |
DisplayName | Latitude |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_latitude |
RequiredLevel | None |
Type | Double |
ImeMode | Auto |
MaxValue | 90 |
MinValue | -90 |
Precision | 5 |
msdyn_Longitude
Property | Value |
---|---|
Description | |
DisplayName | Longitude |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_longitude |
RequiredLevel | None |
Type | Double |
ImeMode | Auto |
MaxValue | 180 |
MinValue | -180 |
Precision | 5 |
msdyn_name
Property | Value |
---|---|
Description | Enter the name of the custom entity. |
DisplayName | Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_name |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
msdyn_OrderedBy
Property | Value |
---|---|
Description | Unique identifier for User associated with Purchase Order. |
DisplayName | Ordered By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_orderedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
msdyn_PaymentTerm
Property | Value |
---|---|
Description | The payment terms for this PO |
DisplayName | Payment Term |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_paymentterm |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_paymentterm |
msdyn_PODate
Property | Value |
---|---|
Description | Shows the date you submitted your order to the vendor. Note this field is for information only. |
DisplayName | Purchase Order Date |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_purchaseorderdate |
RequiredLevel | ApplicationRequired |
Type | DateTime |
CanChangeDateTimeBehavior | True |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Auto |
SourceTypeMask | 0 |
msdyn_PostalCode
Property | Value |
---|---|
Description | |
DisplayName | Postal Code |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_postalcode |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 20 |
msdyn_purchaseorderId
Property | Value |
---|---|
Description | Shows the entity instances. |
DisplayName | Purchase Order |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_purchaseorderid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
msdyn_ReceivetoWarehouse
Property | Value |
---|---|
Description | Warehouse where products of this PO will be received to |
DisplayName | Receive to Warehouse |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_receivetowarehouse |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_warehouse |
msdyn_RequestedByResource
Property | Value |
---|---|
Description | Resource that requested the purchase |
DisplayName | Requested By Resource |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_requestedbyresource |
RequiredLevel | None |
Type | Lookup |
Targets | bookableresource |
msdyn_ShipTo
Property | Value |
---|---|
Description | Enter the location to ship to. If the PO has been associated to a work order or a schedule, you can ship directly to the service account address. |
DisplayName | Ship To |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_shipto |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | msdyn_poshiptotype |
msdyn_ShipTo Choices/Options
Value | Label |
---|---|
690970000 | Site |
690970001 | Business Unit |
690970002 | Service Account |
690970003 | Other |
msdyn_ShipVia
Property | Value |
---|---|
Description | Method of shipment by vendor |
DisplayName | Ship Via |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_shipvia |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_shipvia |
msdyn_StateOrProvince
Property | Value |
---|---|
Description | |
DisplayName | State Or Province |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_stateorprovince |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 50 |
msdyn_SubStatus
Property | Value |
---|---|
Description | Purchase Order Substatus |
DisplayName | Substatus |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_substatus |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_purchaseordersubstatus |
msdyn_SystemStatus
Property | Value |
---|---|
Description | Enter the current status of the purchase order. |
DisplayName | System Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_systemstatus |
RequiredLevel | ApplicationRequired |
Type | Picklist |
DefaultFormValue | 690970000 |
GlobalChoiceName | msdyn_posystemstatus |
msdyn_SystemStatus Choices/Options
Value | Label |
---|---|
690970000 | Draft |
690970001 | Submitted |
690970002 | Canceled |
690970003 | Products Received |
690970004 | Billed |
msdyn_TotalAmount
Property | Value |
---|---|
Description | Total Amount (used by Field Service only) |
DisplayName | Total Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalamount |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 922337203685477 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_Vendor
Property | Value |
---|---|
Description | Vendor you wish to purchase from |
DisplayName | Vendor |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_vendor |
RequiredLevel | ApplicationRequired |
Type | Lookup |
Targets | account |
msdyn_VendorNote
Property | Value |
---|---|
Description | If you wish to display a note for the vendor on this PO specify it here |
DisplayName | Vendor Note |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_vendornote |
RequiredLevel | None |
Type | Memo |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 2000 |
msdyn_WorkOrder
Property | Value |
---|---|
Description | If purchase order is being ordered directly to a work order specify here. Note, when specified, by default all products will receive directly to work order. |
DisplayName | Work Order |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_workorder |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_workorder |
OverriddenCreatedOn
Property | Value |
---|---|
Description | Shows the date and time that the record was migrated. |
DisplayName | Record Created On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
OwnerId
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Type | Owner |
Targets | systemuser, team |
OwnerIdType
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
processid
Property | Value |
---|---|
Description | Contains the ID of the process associated with the entity. |
DisplayName | Process Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | processid |
RequiredLevel | None |
Type | Uniqueidentifier |
stageid
Property | Value |
---|---|
Description | Contains the ID of the stage where the entity is located. |
DisplayName | Stage Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
statecode
Property | Value |
---|---|
Description | Status of the Purchase Order |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | |
GlobalChoiceName | msdyn_purchaseorder_statecode |
statecode Choices/Options
Value | Details |
---|---|
0 | Label: Active DefaultStatus: 1 InvariantName: Active |
1 | Label: Inactive DefaultStatus: 2 InvariantName: Inactive |
statuscode
Property | Value |
---|---|
Description | Reason for the status of the Purchase Order |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | |
GlobalChoiceName | msdyn_purchaseorder_statuscode |
statuscode Choices/Options
Value | Details |
---|---|
1 | Label: Active State:0 TransitionData: None |
2 | Label: Inactive State:1 TransitionData: None |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
TransactionCurrencyId
Property | Value |
---|---|
Description | Unique identifier of the currency associated with the entity. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | transactioncurrencyid |
RequiredLevel | ApplicationRequired |
Type | Lookup |
Targets | transactioncurrency |
traversedpath
Property | Value |
---|---|
Description | Shows a comma-separated list of string values that represent the unique identifiers of stages in a business process flow instance in the order that they occur. |
DisplayName | Traversed Path |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | traversedpath |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1250 |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Shows the time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- ExchangeRate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- msdyn_amountbilled_Base
- msdyn_totalamount_Base
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
CreatedOn
Property | Value |
---|---|
Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Created On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ExchangeRate
Property | Value |
---|---|
Description | Shows the exchange rate for the currency associated with the entity with respect to the base currency. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
RequiredLevel | None |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-10 |
Precision | 10 |
SourceTypeMask | 0 |
ModifiedBy
Property | Value |
---|---|
Description | Unique identifier of the user who modified the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
ModifiedOn
Property | Value |
---|---|
Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Shows who last updated the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
msdyn_amountbilled_Base
Property | Value |
---|---|
Description | Shows the value of the amount billed in the base currency. |
DisplayName | Amount Billed (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_amountbilled_base |
RequiredLevel | None |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | True |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_totalamount_Base
Property | Value |
---|---|
Description | Shows the value of the total amount in the base currency. |
DisplayName | Total Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalamount_base |
RequiredLevel | None |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | True |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
RequiredLevel | SystemRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
OwningBusinessUnit
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Type | Lookup |
Targets | businessunit |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Type | Lookup |
Targets | team |
OwningUser
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- msdyn_account_msdyn_purchaseorder_Vendor
- msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource
- msdyn_bookableresourcebooking_msdyn_purchaseorder_Booking
- msdyn_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus
- msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia
- msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse
- msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder
msdyn_account_msdyn_purchaseorder_Vendor
One-To-Many Relationship: account msdyn_account_msdyn_purchaseorder_Vendor
Property | Value |
---|---|
ReferencedEntity | account |
ReferencedAttribute | accountid |
ReferencingAttribute | msdyn_vendor |
ReferencingEntityNavigationPropertyName | msdyn_vendor |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource
One-To-Many Relationship: bookableresource msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource
Property | Value |
---|---|
ReferencedEntity | bookableresource |
ReferencedAttribute | bookableresourceid |
ReferencingAttribute | msdyn_requestedbyresource |
ReferencingEntityNavigationPropertyName | msdyn_requestedbyresource |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_bookableresourcebooking_msdyn_purchaseorder_Booking
One-To-Many Relationship: bookableresourcebooking msdyn_bookableresourcebooking_msdyn_purchaseorder_Booking
Property | Value |
---|---|
ReferencedEntity | bookableresourcebooking |
ReferencedAttribute | bookableresourcebookingid |
ReferencingAttribute | msdyn_booking |
ReferencingEntityNavigationPropertyName | msdyn_booking |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus
One-To-Many Relationship: msdyn_purchaseordersubstatus msdyn_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus
Property | Value |
---|---|
ReferencedEntity | msdyn_purchaseordersubstatus |
ReferencedAttribute | msdyn_purchaseordersubstatusid |
ReferencingAttribute | msdyn_substatus |
ReferencingEntityNavigationPropertyName | msdyn_substatus |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia
One-To-Many Relationship: msdyn_shipvia msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia
Property | Value |
---|---|
ReferencedEntity | msdyn_shipvia |
ReferencedAttribute | msdyn_shipviaid |
ReferencingAttribute | msdyn_shipvia |
ReferencingEntityNavigationPropertyName | msdyn_shipvia |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse
One-To-Many Relationship: msdyn_warehouse msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse
Property | Value |
---|---|
ReferencedEntity | msdyn_warehouse |
ReferencedAttribute | msdyn_warehouseid |
ReferencingAttribute | msdyn_receivetowarehouse |
ReferencingEntityNavigationPropertyName | msdyn_receivetowarehouse |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder
One-To-Many Relationship: msdyn_workorder msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder
Property | Value |
---|---|
ReferencedEntity | msdyn_workorder |
ReferencedAttribute | msdyn_workorderid |
ReferencingAttribute | msdyn_workorder |
ReferencingEntityNavigationPropertyName | msdyn_workorder |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
- msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder
- msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder
- msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder
- msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO
- msdyn_purchaseorder_msdyn_bookingalerts
msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
Many-To-One Relationship: msdyn_purchaseorderbill msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
Property | Value |
---|---|
ReferencingEntity | msdyn_purchaseorderbill |
ReferencingAttribute | msdyn_purchaseorder |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder
Many-To-One Relationship: msdyn_purchaseorderproduct msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder
Property | Value |
---|---|
ReferencingEntity | msdyn_purchaseorderproduct |
ReferencingAttribute | msdyn_purchaseorder |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: Purchase Order MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder
Many-To-One Relationship: msdyn_purchaseorderreceipt msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder
Property | Value |
---|---|
ReferencingEntity | msdyn_purchaseorderreceipt |
ReferencingAttribute | msdyn_purchaseorder |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder
Many-To-One Relationship: msdyn_purchaseorderreceiptproduct msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder
Property | Value |
---|---|
ReferencingEntity | msdyn_purchaseorderreceiptproduct |
ReferencingAttribute | msdyn_purchaseorder |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO
Many-To-One Relationship: msdyn_rtv msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO
Property | Value |
---|---|
ReferencingEntity | msdyn_rtv |
ReferencingAttribute | msdyn_originalpurchaseorder |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseLabel Group: Details Label: Original Purchase Order MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_purchaseorder_msdyn_bookingalerts
Many-To-One Relationship: msdyn_bookingalert msdyn_purchaseorder_msdyn_bookingalerts
Property | Value |
---|---|
ReferencingEntity | msdyn_bookingalert |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | msdyn_purchaseorder_msdyn_bookingalerts |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference