SalesDocumentCommissions
The DynamicsGP table SalesDocumentCommissions.
Columns
| Name | Type | Description |
| CommissionsKeySequenceNumber [KEY] | Int32 | The CommissionsKeySequenceNumber column for the table SalesDocumentCommissions. |
| CommissionsKeySalesDocumentId [KEY] | String | The CommissionsKeySalesDocumentId column for the table SalesDocumentCommissions. |
| ActualShipDate | Datetime | The ActualShipDate column for the table SalesDocumentCommissions. |
| AuditTrailCode | String | The AuditTrailCode column for the table SalesDocumentCommissions. |
| BackorderDate | Datetime | The BackorderDate column for the table SalesDocumentCommissions. |
| BatchKeyCreatedDateTime | Datetime | The BatchKeyCreatedDateTime column for the table SalesDocumentCommissions. |
| BatchId | String | The BatchId column for the table SalesDocumentCommissions. |
| BatchKeySource | String | The BatchKeySource column for the table SalesDocumentCommissions. |
| BillToAddressKeyCustomerId | String | The BillToAddressKeyCustomerId column for the table SalesDocumentCommissions. |
| BillToAddressId | String | The BillToAddressId column for the table SalesDocumentCommissions. |
| Comment | String | The Comment column for the table SalesDocumentCommissions. |
| CommentId | String | The CommentId column for the table SalesDocumentCommissions. |
| CommissionAmountCurrency | String | The CommissionAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionAmount | Decimal | The CommissionAmount column for the table SalesDocumentCommissions. |
| CommissionBasedOn | String | The CommissionBasedOn column for the table SalesDocumentCommissions. |
| CommissionSaleAmountCurrency | String | The CommissionSaleAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionSaleAmount | Decimal | The CommissionSaleAmount column for the table SalesDocumentCommissions. |
| CommissionsCommissionAmountCurrency | String | The CommissionsCommissionAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionsCommissionAmount | Decimal | The CommissionsCommissionAmount column for the table SalesDocumentCommissions. |
| CommissionsCommissionPercent | Decimal | The CommissionsCommissionPercent column for the table SalesDocumentCommissions. |
| CommissionsCommissionSaleAmountCurrency | String | The CommissionsCommissionSaleAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionsCommissionSaleAmount | Decimal | The CommissionsCommissionSaleAmount column for the table SalesDocumentCommissions. |
| CommissionsNoncommissionedAmountCurrency | String | The CommissionsNoncommissionedAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionsNoncommissionedAmount | Decimal | The CommissionsNoncommissionedAmount column for the table SalesDocumentCommissions. |
| CommissionsPercentOfSale | Decimal | The CommissionsPercentOfSale column for the table SalesDocumentCommissions. |
| CommissionsSalesAmountCurrency | String | The CommissionsSalesAmountCurrency column for the table SalesDocumentCommissions. |
| CommissionsSalesAmount | Decimal | The CommissionsSalesAmount column for the table SalesDocumentCommissions. |
| CommissionsSalesTerritoryId | String | The CommissionsSalesTerritoryId column for the table SalesDocumentCommissions. |
| CommissionsSalespersonId | String | The CommissionsSalespersonId column for the table SalesDocumentCommissions. |
| CommissionsExtensionsExtensionAggregate | String | The CommissionsExtensionsExtensionAggregate column for the table SalesDocumentCommissions. |
| CreatedBy | String | The CreatedBy column for the table SalesDocumentCommissions. |
| CreatedDate | Datetime | The CreatedDate column for the table SalesDocumentCommissions. |
| CurrencyKeyISOCode | String | The CurrencyKeyISOCode column for the table SalesDocumentCommissions. |
| CustomerId | String | The CustomerId column for the table SalesDocumentCommissions. |
| CustomerName | String | The CustomerName column for the table SalesDocumentCommissions. |
| CustomerPONumber | String | The CustomerPONumber column for the table SalesDocumentCommissions. |
| Date | Datetime | The Date column for the table SalesDocumentCommissions. |
| DiscountAmountCurrency | String | The DiscountAmountCurrency column for the table SalesDocumentCommissions. |
| DiscountAmount | Decimal | The DiscountAmount column for the table SalesDocumentCommissions. |
| DocumentTypeId | String | The DocumentTypeId column for the table SalesDocumentCommissions. |
| DocumentTypeKeyType | String | The DocumentTypeKeyType column for the table SalesDocumentCommissions. |
| ExchangeDate | Datetime | The ExchangeDate column for the table SalesDocumentCommissions. |
| ExchangeRate | Decimal | The ExchangeRate column for the table SalesDocumentCommissions. |
| FreightAmountCurrency | String | The FreightAmountCurrency column for the table SalesDocumentCommissions. |
| FreightAmount | Decimal | The FreightAmount column for the table SalesDocumentCommissions. |
| FreightTaxAmountCurrency | String | The FreightTaxAmountCurrency column for the table SalesDocumentCommissions. |
| FreightTaxAmount | Decimal | The FreightTaxAmount column for the table SalesDocumentCommissions. |
| FreightTaxBasis | String | The FreightTaxBasis column for the table SalesDocumentCommissions. |
| FreightTaxScheduleId | String | The FreightTaxScheduleId column for the table SalesDocumentCommissions. |
| FreightTaxesSalesDocumentTaxAggregate | String | The FreightTaxesSalesDocumentTaxAggregate column for the table SalesDocumentCommissions. |
| FrontOfficeIntegrationId | String | The FrontOfficeIntegrationId column for the table SalesDocumentCommissions. |
| FulfillDate | Datetime | The FulfillDate column for the table SalesDocumentCommissions. |
| IntegrationId | String | The IntegrationId column for the table SalesDocumentCommissions. |
| IntegrationSource | Int32 | The IntegrationSource column for the table SalesDocumentCommissions. |
| InvoiceDate | Datetime | The InvoiceDate column for the table SalesDocumentCommissions. |
| IsIntrastatDocument | Boolean | The IsIntrastatDocument column for the table SalesDocumentCommissions. |
| IsVoided | Boolean | The IsVoided column for the table SalesDocumentCommissions. |
| Id | String | The Id column for the table SalesDocumentCommissions. |
| LastModifiedDate | Datetime | The LastModifiedDate column for the table SalesDocumentCommissions. |
| LineTotalAmountCurrency | String | The LineTotalAmountCurrency column for the table SalesDocumentCommissions. |
| LineTotalAmount | Decimal | The LineTotalAmount column for the table SalesDocumentCommissions. |
| MasterNumber | Int32 | The MasterNumber column for the table SalesDocumentCommissions. |
| MiscellaneousAmountCurrency | String | The MiscellaneousAmountCurrency column for the table SalesDocumentCommissions. |
| MiscellaneousAmount | Decimal | The MiscellaneousAmount column for the table SalesDocumentCommissions. |
| MiscellaneousTaxAmountCurrency | String | The MiscellaneousTaxAmountCurrency column for the table SalesDocumentCommissions. |
| MiscellaneousTaxAmount | Decimal | The MiscellaneousTaxAmount column for the table SalesDocumentCommissions. |
| MiscellaneousTaxBasis | String | The MiscellaneousTaxBasis column for the table SalesDocumentCommissions. |
| MiscellaneousTaxScheduleId | String | The MiscellaneousTaxScheduleId column for the table SalesDocumentCommissions. |
| MiscellaneousTaxesSalesDocumentTaxAggregate | String | The MiscellaneousTaxesSalesDocumentTaxAggregate column for the table SalesDocumentCommissions. |
| ModifiedDate | Datetime | The ModifiedDate column for the table SalesDocumentCommissions. |
| Note | String | The Note column for the table SalesDocumentCommissions. |
| OriginalSalesDocumentId | String | The OriginalSalesDocumentId column for the table SalesDocumentCommissions. |
| OriginalSalesDocumentType | String | The OriginalSalesDocumentType column for the table SalesDocumentCommissions. |
| PaymentTermsId | String | The PaymentTermsId column for the table SalesDocumentCommissions. |
| PriceLevelId | String | The PriceLevelId column for the table SalesDocumentCommissions. |
| ProcessHoldsSalesProcessHoldAggregate | String | The ProcessHoldsSalesProcessHoldAggregate column for the table SalesDocumentCommissions. |
| QuoteDate | Datetime | The QuoteDate column for the table SalesDocumentCommissions. |
| Reference | String | The Reference column for the table SalesDocumentCommissions. |
| RequestedShipDate | Datetime | The RequestedShipDate column for the table SalesDocumentCommissions. |
| ReturnDate | Datetime | The ReturnDate column for the table SalesDocumentCommissions. |
| SalesTerritoryId | String | The SalesTerritoryId column for the table SalesDocumentCommissions. |
| SalespersonId | String | The SalespersonId column for the table SalesDocumentCommissions. |
| ShipCompleteOnly | Boolean | The ShipCompleteOnly column for the table SalesDocumentCommissions. |
| ShipToAddressExtensionsExtensionAggregate | String | The ShipToAddressExtensionsExtensionAggregate column for the table SalesDocumentCommissions. |
| ShipToAddressCity | String | The ShipToAddressCity column for the table SalesDocumentCommissions. |
| ShipToAddressLine1 | String | The ShipToAddressLine1 column for the table SalesDocumentCommissions. |
| ShipToAddressLine2 | String | The ShipToAddressLine2 column for the table SalesDocumentCommissions. |
| ShipToAddressLine3 | String | The ShipToAddressLine3 column for the table SalesDocumentCommissions. |
| ShipToAddressPostalCode | String | The ShipToAddressPostalCode column for the table SalesDocumentCommissions. |
| ShipToAddressState | String | The ShipToAddressState column for the table SalesDocumentCommissions. |
| ShipToAddressCountryRegion | String | The ShipToAddressCountryRegion column for the table SalesDocumentCommissions. |
| ShipToAddressFaxCountryCode | String | The ShipToAddressFaxCountryCode column for the table SalesDocumentCommissions. |
| ShipToAddressFaxExtension | String | The ShipToAddressFaxExtension column for the table SalesDocumentCommissions. |
| ShipToAddressFax | String | The ShipToAddressFax column for the table SalesDocumentCommissions. |
| ShipToAddressPhone1CountryCode | String | The ShipToAddressPhone1CountryCode column for the table SalesDocumentCommissions. |
| ShipToAddressPhone1Extension | String | The ShipToAddressPhone1Extension column for the table SalesDocumentCommissions. |
| ShipToAddressPhone1 | String | The ShipToAddressPhone1 column for the table SalesDocumentCommissions. |
| ShipToAddressPhone2CountryCode | String | The ShipToAddressPhone2CountryCode column for the table SalesDocumentCommissions. |
| ShipToAddressPhone2Extension | String | The ShipToAddressPhone2Extension column for the table SalesDocumentCommissions. |
| ShipToAddressPhone2 | String | The ShipToAddressPhone2 column for the table SalesDocumentCommissions. |
| ShipToAddressPhone3CountryCode | String | The ShipToAddressPhone3CountryCode column for the table SalesDocumentCommissions. |
| ShipToAddressPhone3Extension | String | The ShipToAddressPhone3Extension column for the table SalesDocumentCommissions. |
| ShipToAddressPhone3 | String | The ShipToAddressPhone3 column for the table SalesDocumentCommissions. |
| ShipToAddressCountryRegionCodeId | String | The ShipToAddressCountryRegionCodeId column for the table SalesDocumentCommissions. |
| ShipToAddressContactPerson | String | The ShipToAddressContactPerson column for the table SalesDocumentCommissions. |
| ShipToAddressName | String | The ShipToAddressName column for the table SalesDocumentCommissions. |
| ShipToAddressKeyCustomerId | String | The ShipToAddressKeyCustomerId column for the table SalesDocumentCommissions. |
| ShipToAddressId | String | The ShipToAddressId column for the table SalesDocumentCommissions. |
| ShippingMethodId | String | The ShippingMethodId column for the table SalesDocumentCommissions. |
| TaxAmountCurrency | String | The TaxAmountCurrency column for the table SalesDocumentCommissions. |
| TaxAmount | Decimal | The TaxAmount column for the table SalesDocumentCommissions. |
| TaxExemptNumber1 | String | The TaxExemptNumber1 column for the table SalesDocumentCommissions. |
| TaxExemptNumber2 | String | The TaxExemptNumber2 column for the table SalesDocumentCommissions. |
| TaxRegistrationNumber | String | The TaxRegistrationNumber column for the table SalesDocumentCommissions. |
| TaxScheduleId | String | The TaxScheduleId column for the table SalesDocumentCommissions. |
| TaxesSalesDocumentTaxAggregate | String | The TaxesSalesDocumentTaxAggregate column for the table SalesDocumentCommissions. |
| TotalAmountCurrency | String | The TotalAmountCurrency column for the table SalesDocumentCommissions. |
| TotalAmount | Decimal | The TotalAmount column for the table SalesDocumentCommissions. |
| TrackingNumbersSalesTrackingNumberAggregate | String | The TrackingNumbersSalesTrackingNumberAggregate column for the table SalesDocumentCommissions. |
| TradeDiscountItem | String | The TradeDiscountItem column for the table SalesDocumentCommissions. |
| TransactionState | String | The TransactionState column for the table SalesDocumentCommissions. |
| Type | String | The Type column for the table SalesDocumentCommissions. |
| UPSZone | String | The UPSZone column for the table SalesDocumentCommissions. |
| UserDefinedDate01 | Datetime | The UserDefinedDate01 column for the table SalesDocumentCommissions. |
| UserDefinedDate02 | Datetime | The UserDefinedDate02 column for the table SalesDocumentCommissions. |
| UserDefinedList01 | String | The UserDefinedList01 column for the table SalesDocumentCommissions. |
| UserDefinedList02 | String | The UserDefinedList02 column for the table SalesDocumentCommissions. |
| UserDefinedList03 | String | The UserDefinedList03 column for the table SalesDocumentCommissions. |
| UserDefinedText01 | String | The UserDefinedText01 column for the table SalesDocumentCommissions. |
| UserDefinedText02 | String | The UserDefinedText02 column for the table SalesDocumentCommissions. |
| UserDefinedText03 | String | The UserDefinedText03 column for the table SalesDocumentCommissions. |
| UserDefinedText04 | String | The UserDefinedText04 column for the table SalesDocumentCommissions. |
| UserDefinedText05 | String | The UserDefinedText05 column for the table SalesDocumentCommissions. |
| WarehouseId | String | The WarehouseId column for the table SalesDocumentCommissions. |
| ExtensionsExtensionAggregate | String | The ExtensionsExtensionAggregate column for the table SalesDocumentCommissions. |