Table "CRM Invoice"
ID 5355
Namespace: Microsoft.Integration.D365Sales
Properties
| Name | Value |
|---|---|
| Caption | CRM Invoice |
| Description | Order that has been billed. |
| ExternalName | invoice |
| TableType | CRM |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| InvoiceId | Guid | |
| OpportunityId | Guid | |
| PriorityCode | Option | |
| SalesOrderId | Guid | |
| OwningUser | Guid | |
| OwningBusinessUnit | Guid | |
| LastBackofficeSubmit | Date | |
| PriceLevelId | Guid | |
| AccountId | Guid | |
| ContactId | Guid | |
| InvoiceNumber | Text[100] | |
| Name | Text[2048] | |
| Description | Blob | |
| DiscountAmount | Decimal | |
| FreightAmount | Decimal | |
| TotalAmount | Decimal | |
| TotalLineItemAmount | Decimal | |
| TotalLineItemDiscountAmount | Decimal | |
| TotalAmountLessFreight | Decimal | |
| TotalDiscountAmount | Decimal | |
| CreatedBy | Guid | |
| TotalTax | Decimal | |
| CreatedOn | DateTime | |
| ModifiedBy | Guid | |
| ModifiedOn | DateTime | |
| StateCode | Option | |
| StatusCode | Option | |
| ShipTo_Name | Text[200] | |
| VersionNumber | BigInteger | |
| PricingErrorCode | Option | |
| ShipTo_Line1 | Text[250] | |
| ShipTo_Line2 | Text[250] | |
| ShipTo_Line3 | Text[250] | |
| ShipTo_City | Text[80] | |
| ShipTo_StateOrProvince | Text[50] | |
| ShipTo_Country | Text[80] | |
| ShipTo_PostalCode | Text[20] | |
| WillCall | Boolean | |
| ShipTo_Telephone | Text[50] | |
| BillTo_Name | Text[200] | |
| ShipTo_FreightTermsCode | Option | |
| ShipTo_Fax | Text[50] | |
| BillTo_Line1 | Text[250] | |
| BillTo_Line2 | Text[250] | |
| BillTo_Line3 | Text[250] | |
| BillTo_City | Text[80] | |
| BillTo_StateOrProvince | Text[50] | |
| BillTo_Country | Text[80] | |
| BillTo_PostalCode | Text[20] | |
| BillTo_Telephone | Text[50] | |
| BillTo_Fax | Text[50] | |
| DiscountPercentage | Decimal | |
| ContactIdName | Text[160] | |
| AccountIdName | Text[160] | |
| OpportunityIdName | Text[2048] | |
| SalesOrderIdName | Text[2048] | |
| PriceLevelIdName | Text[100] | |
| CreatedByName | Text[200] | |
| ModifiedByName | Text[200] | |
| CustomerId | Guid | |
| CustomerIdType | Option | |
| OwnerId | Guid | |
| OwnerIdType | Option | |
| IsPriceLocked | Boolean | |
| DateDelivered | Date | |
| DueDate | Date | |
| TimeZoneRuleVersionNumber | Integer | |
| ImportSequenceNumber | Integer | |
| OverriddenCreatedOn | Date | |
| ExchangeRate | Decimal | |
| UTCConversionTimeZoneCode | Integer | |
| TransactionCurrencyId | Guid | |
| TransactionCurrencyIdName | Text[100] | |
| TotalLineItemAmount_Base | Decimal | |
| TotalLineItemDiscountAmount_Ba | Decimal | |
| TotalTax_Base | Decimal | |
| TotalAmountLessFreight_Base | Decimal | |
| DiscountAmount_Base | Decimal | |
| TotalAmount_Base | Decimal | |
| FreightAmount_Base | Decimal | |
| TotalDiscountAmount_Base | Decimal | |
| CreatedOnBehalfBy | Guid | |
| CreatedOnBehalfByName | Text[200] | |
| ModifiedOnBehalfBy | Guid | |
| ModifiedOnBehalfByName | Text[200] | |
| OwningTeam | Guid | |
| BillTo_Composite | Blob | |
| ShipTo_Composite | Blob | |
| ProcessId | Guid | |
| StageId | Guid | |
| EntityImageId | Guid | |
| TraversedPath | Text[250] | |
| CompanyId | Guid | |
| PaymentTermsCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Payment Terms Code" | |
| ShippingMethodCodeEnum | Enum Microsoft.Integration.Dataverse."CDS Shipping Agent Code" | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |