Specify purchase order bill.
Messages
The following table lists the messages for the Purchase Order Bill (msdyn_purchaseorderbill) 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_purchaseorderbills(msdyn_purchaseorderbillid)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_purchaseorderbillsSee Create |
Create records |
CreateMultiple Event: True |
CreateMultiple | CreateMultipleRequest |
Delete Event: True |
DELETE /msdyn_purchaseorderbills(msdyn_purchaseorderbillid)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_purchaseorderbills(msdyn_purchaseorderbillid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /msdyn_purchaseorderbillsSee 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_purchaseorderbills(msdyn_purchaseorderbillid)Update the statecode and statuscode properties. |
SetStateRequest |
Update Event: True |
PATCH /msdyn_purchaseorderbills(msdyn_purchaseorderbillid)See Update |
Update records |
UpdateMultiple Event: True |
UpdateMultiple | UpdateMultipleRequest |
Upsert Event: False |
PATCH /msdyn_purchaseorderbills(msdyn_purchaseorderbillid)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 Bill (msdyn_purchaseorderbill) table.
Property | Value |
---|---|
DisplayName | Purchase Order Bill |
DisplayCollectionName | Purchase Order Bills |
SchemaName | msdyn_purchaseorderbill |
CollectionSchemaName | msdyn_purchaseorderbills |
EntitySetName | msdyn_purchaseorderbills |
LogicalName | msdyn_purchaseorderbill |
LogicalCollectionName | msdyn_purchaseorderbills |
PrimaryIdAttribute | msdyn_purchaseorderbillid |
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_BillDate
- msdyn_name
- msdyn_Note
- msdyn_PaymentTerm
- msdyn_PurchaseOrder
- msdyn_purchaseorderbillId
- msdyn_ShippingAmount
- msdyn_Subtotal
- msdyn_TaxAmount
- msdyn_TaxCode
- msdyn_TotalAmount
- msdyn_VendorInvoiceNumber
- 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_BillDate
Property | Value |
---|---|
Description | |
DisplayName | Bill Date |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_billdate |
RequiredLevel | ApplicationRequired |
Type | DateTime |
CanChangeDateTimeBehavior | True |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Auto |
SourceTypeMask | 0 |
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_Note
Property | Value |
---|---|
Description | |
DisplayName | Note |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_note |
RequiredLevel | None |
Type | Memo |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 2000 |
msdyn_PaymentTerm
Property | Value |
---|---|
Description | Unique identifier for Payment Term associated with Purchase Order Bill. |
DisplayName | Payment Term |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_paymentterm |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_paymentterm |
msdyn_PurchaseOrder
Property | Value |
---|---|
Description | Unique identifier for Purchase Order associated with Purchase Order Bill. |
DisplayName | Purchase Order |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_purchaseorder |
RequiredLevel | ApplicationRequired |
Type | Lookup |
Targets | msdyn_purchaseorder |
msdyn_purchaseorderbillId
Property | Value |
---|---|
Description | Shows the entity instances. |
DisplayName | Purchase Order Bill |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_purchaseorderbillid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
msdyn_ShippingAmount
Property | Value |
---|---|
Description | |
DisplayName | Shipping Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_shippingamount |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 1000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_Subtotal
Property | Value |
---|---|
Description | |
DisplayName | Subtotal |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_subtotal |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 900000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_TaxAmount
Property | Value |
---|---|
Description | |
DisplayName | Tax Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_taxamount |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 1000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_TaxCode
Property | Value |
---|---|
Description | Unique identifier for Tax Code associated with Purchase Order Bill. |
DisplayName | Tax Code |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_taxcode |
RequiredLevel | None |
Type | Lookup |
Targets | msdyn_taxcode |
msdyn_TotalAmount
Property | Value |
---|---|
Description | |
DisplayName | Total Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalamount |
RequiredLevel | None |
Type | Money |
ImeMode | Auto |
IsBaseCurrency | False |
MaxValue | 1000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_VendorInvoiceNumber
Property | Value |
---|---|
Description | |
DisplayName | Vendor Invoice Number |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_vendorinvoicenumber |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 100 |
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 Bill |
DisplayName | Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
DefaultFormValue | |
GlobalChoiceName | msdyn_purchaseorderbill_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 Bill |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
DefaultFormValue | |
GlobalChoiceName | msdyn_purchaseorderbill_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 | None |
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_shippingamount_Base
- msdyn_subtotal_Base
- msdyn_taxamount_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_shippingamount_Base
Property | Value |
---|---|
Description | Shows the value of the shipping amount in the base currency. |
DisplayName | Shipping Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_shippingamount_base |
RequiredLevel | None |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | True |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_subtotal_Base
Property | Value |
---|---|
Description | Shows the value of the subtotal in the base currency. |
DisplayName | Subtotal (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_subtotal_base |
RequiredLevel | None |
Type | Money |
ImeMode | Disabled |
IsBaseCurrency | True |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 1 (Organization.PricingDecimalPrecision) |
msdyn_taxamount_Base
Property | Value |
---|---|
Description | Shows the value of the tax amount in the base currency. |
DisplayName | Tax Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_taxamount_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_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
- msdyn_msdyn_taxcode_msdyn_purchaseorderbill_TaxCode
msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
One-To-Many Relationship: msdyn_purchaseorder msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
Property | Value |
---|---|
ReferencedEntity | msdyn_purchaseorder |
ReferencedAttribute | msdyn_purchaseorderid |
ReferencingAttribute | msdyn_purchaseorder |
ReferencingEntityNavigationPropertyName | msdyn_purchaseorder |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade RollupView: NoCascade Share: Cascade Unshare: Cascade |
msdyn_msdyn_taxcode_msdyn_purchaseorderbill_TaxCode
One-To-Many Relationship: msdyn_taxcode msdyn_msdyn_taxcode_msdyn_purchaseorderbill_TaxCode
Property | Value |
---|---|
ReferencedEntity | msdyn_taxcode |
ReferencedAttribute | msdyn_taxcodeid |
ReferencingAttribute | msdyn_taxcode |
ReferencingEntityNavigationPropertyName | msdyn_taxcode |
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_purchaseorderbill_msdyn_purchaseorderreceiptproduct_PurchaseOrderBill
- msdyn_purchaseorderbill_msdyn_bookingalerts
msdyn_msdyn_purchaseorderbill_msdyn_purchaseorderreceiptproduct_PurchaseOrderBill
Many-To-One Relationship: msdyn_purchaseorderreceiptproduct msdyn_msdyn_purchaseorderbill_msdyn_purchaseorderreceiptproduct_PurchaseOrderBill
Property | Value |
---|---|
ReferencingEntity | msdyn_purchaseorderreceiptproduct |
ReferencingAttribute | msdyn_purchaseorderbill |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_purchaseorderbill_msdyn_purchaseorderreceiptproduct_PurchaseOrderBill |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_purchaseorderbill_msdyn_bookingalerts
Many-To-One Relationship: msdyn_bookingalert msdyn_purchaseorderbill_msdyn_bookingalerts
Property | Value |
---|---|
ReferencingEntity | msdyn_bookingalert |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | msdyn_purchaseorderbill_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