SalesDocumentMiscellaneousTaxes
The DynamicsGP table SalesDocumentMiscellaneousTaxes.
Columns
Name | Type | Description |
MiscellaneousTaxesKeyTaxDetailId [KEY] | String | The MiscellaneousTaxesKeyTaxDetailId column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesKeySequenceNumber [KEY] | Int32 | The MiscellaneousTaxesKeySequenceNumber column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesKeySalesDocumentId [KEY] | String | The MiscellaneousTaxesKeySalesDocumentId column for the table SalesDocumentMiscellaneousTaxes. |
ActualShipDate | Datetime | The ActualShipDate column for the table SalesDocumentMiscellaneousTaxes. |
AuditTrailCode | String | The AuditTrailCode column for the table SalesDocumentMiscellaneousTaxes. |
BackorderDate | Datetime | The BackorderDate column for the table SalesDocumentMiscellaneousTaxes. |
BatchKeyCreatedDateTime | Datetime | The BatchKeyCreatedDateTime column for the table SalesDocumentMiscellaneousTaxes. |
BatchId | String | The BatchId column for the table SalesDocumentMiscellaneousTaxes. |
BatchKeySource | String | The BatchKeySource column for the table SalesDocumentMiscellaneousTaxes. |
BillToAddressKeyCustomerId | String | The BillToAddressKeyCustomerId column for the table SalesDocumentMiscellaneousTaxes. |
BillToAddressId | String | The BillToAddressId column for the table SalesDocumentMiscellaneousTaxes. |
Comment | String | The Comment column for the table SalesDocumentMiscellaneousTaxes. |
CommentId | String | The CommentId column for the table SalesDocumentMiscellaneousTaxes. |
CommissionAmountCurrency | String | The CommissionAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
CommissionAmount | Decimal | The CommissionAmount column for the table SalesDocumentMiscellaneousTaxes. |
CommissionBasedOn | String | The CommissionBasedOn column for the table SalesDocumentMiscellaneousTaxes. |
CommissionSaleAmountCurrency | String | The CommissionSaleAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
CommissionSaleAmount | Decimal | The CommissionSaleAmount column for the table SalesDocumentMiscellaneousTaxes. |
CommissionsSalesCommissionAggregate | String | The CommissionsSalesCommissionAggregate column for the table SalesDocumentMiscellaneousTaxes. |
CreatedBy | String | The CreatedBy column for the table SalesDocumentMiscellaneousTaxes. |
CreatedDate | Datetime | The CreatedDate column for the table SalesDocumentMiscellaneousTaxes. |
CurrencyKeyISOCode | String | The CurrencyKeyISOCode column for the table SalesDocumentMiscellaneousTaxes. |
CustomerId | String | The CustomerId column for the table SalesDocumentMiscellaneousTaxes. |
CustomerName | String | The CustomerName column for the table SalesDocumentMiscellaneousTaxes. |
CustomerPONumber | String | The CustomerPONumber column for the table SalesDocumentMiscellaneousTaxes. |
Date | Datetime | The Date column for the table SalesDocumentMiscellaneousTaxes. |
DiscountAmountCurrency | String | The DiscountAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
DiscountAmount | Decimal | The DiscountAmount column for the table SalesDocumentMiscellaneousTaxes. |
DocumentTypeId | String | The DocumentTypeId column for the table SalesDocumentMiscellaneousTaxes. |
DocumentTypeKeyType | String | The DocumentTypeKeyType column for the table SalesDocumentMiscellaneousTaxes. |
ExchangeDate | Datetime | The ExchangeDate column for the table SalesDocumentMiscellaneousTaxes. |
ExchangeRate | Decimal | The ExchangeRate column for the table SalesDocumentMiscellaneousTaxes. |
FreightAmountCurrency | String | The FreightAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
FreightAmount | Decimal | The FreightAmount column for the table SalesDocumentMiscellaneousTaxes. |
FreightTaxAmountCurrency | String | The FreightTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
FreightTaxAmount | Decimal | The FreightTaxAmount column for the table SalesDocumentMiscellaneousTaxes. |
FreightTaxBasis | String | The FreightTaxBasis column for the table SalesDocumentMiscellaneousTaxes. |
FreightTaxScheduleId | String | The FreightTaxScheduleId column for the table SalesDocumentMiscellaneousTaxes. |
FreightTaxesSalesDocumentTaxAggregate | String | The FreightTaxesSalesDocumentTaxAggregate column for the table SalesDocumentMiscellaneousTaxes. |
FrontOfficeIntegrationId | String | The FrontOfficeIntegrationId column for the table SalesDocumentMiscellaneousTaxes. |
FulfillDate | Datetime | The FulfillDate column for the table SalesDocumentMiscellaneousTaxes. |
IntegrationId | String | The IntegrationId column for the table SalesDocumentMiscellaneousTaxes. |
IntegrationSource | Int32 | The IntegrationSource column for the table SalesDocumentMiscellaneousTaxes. |
InvoiceDate | Datetime | The InvoiceDate column for the table SalesDocumentMiscellaneousTaxes. |
IsIntrastatDocument | Boolean | The IsIntrastatDocument column for the table SalesDocumentMiscellaneousTaxes. |
IsVoided | Boolean | The IsVoided column for the table SalesDocumentMiscellaneousTaxes. |
Id | String | The Id column for the table SalesDocumentMiscellaneousTaxes. |
LastModifiedDate | Datetime | The LastModifiedDate column for the table SalesDocumentMiscellaneousTaxes. |
LineTotalAmountCurrency | String | The LineTotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
LineTotalAmount | Decimal | The LineTotalAmount column for the table SalesDocumentMiscellaneousTaxes. |
MasterNumber | Int32 | The MasterNumber column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousAmountCurrency | String | The MiscellaneousAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousAmount | Decimal | The MiscellaneousAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxAmountCurrency | String | The MiscellaneousTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxAmount | Decimal | The MiscellaneousTaxAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxBasis | String | The MiscellaneousTaxBasis column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxScheduleId | String | The MiscellaneousTaxScheduleId column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesGLAccountId | String | The MiscellaneousTaxesGLAccountId column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesGLAccountKeyIsEncrypted | Boolean | The MiscellaneousTaxesGLAccountKeyIsEncrypted column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesIsTaxableTax | Boolean | The MiscellaneousTaxesIsTaxableTax column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTotalTaxPotentialAmountCurrency | String | The MiscellaneousTaxesTotalTaxPotentialAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTotalTaxPotentialAmount | Decimal | The MiscellaneousTaxesTotalTaxPotentialAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesIsBackoutTax | Boolean | The MiscellaneousTaxesIsBackoutTax column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTaxAmountCurrency | String | The MiscellaneousTaxesTaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTaxAmount | Decimal | The MiscellaneousTaxesTaxAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTaxableAmountCurrency | String | The MiscellaneousTaxesTaxableAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTaxableAmount | Decimal | The MiscellaneousTaxesTaxableAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTotalAmountCurrency | String | The MiscellaneousTaxesTotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesTotalAmount | Decimal | The MiscellaneousTaxesTotalAmount column for the table SalesDocumentMiscellaneousTaxes. |
MiscellaneousTaxesExtensionsExtensionAggregate | String | The MiscellaneousTaxesExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes. |
ModifiedDate | Datetime | The ModifiedDate column for the table SalesDocumentMiscellaneousTaxes. |
Note | String | The Note column for the table SalesDocumentMiscellaneousTaxes. |
OriginalSalesDocumentId | String | The OriginalSalesDocumentId column for the table SalesDocumentMiscellaneousTaxes. |
OriginalSalesDocumentType | String | The OriginalSalesDocumentType column for the table SalesDocumentMiscellaneousTaxes. |
PaymentTermsId | String | The PaymentTermsId column for the table SalesDocumentMiscellaneousTaxes. |
PriceLevelId | String | The PriceLevelId column for the table SalesDocumentMiscellaneousTaxes. |
ProcessHoldsSalesProcessHoldAggregate | String | The ProcessHoldsSalesProcessHoldAggregate column for the table SalesDocumentMiscellaneousTaxes. |
QuoteDate | Datetime | The QuoteDate column for the table SalesDocumentMiscellaneousTaxes. |
Reference | String | The Reference column for the table SalesDocumentMiscellaneousTaxes. |
RequestedShipDate | Datetime | The RequestedShipDate column for the table SalesDocumentMiscellaneousTaxes. |
ReturnDate | Datetime | The ReturnDate column for the table SalesDocumentMiscellaneousTaxes. |
SalesTerritoryId | String | The SalesTerritoryId column for the table SalesDocumentMiscellaneousTaxes. |
SalespersonId | String | The SalespersonId column for the table SalesDocumentMiscellaneousTaxes. |
ShipCompleteOnly | Boolean | The ShipCompleteOnly column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressExtensionsExtensionAggregate | String | The ShipToAddressExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressCity | String | The ShipToAddressCity column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressLine1 | String | The ShipToAddressLine1 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressLine2 | String | The ShipToAddressLine2 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressLine3 | String | The ShipToAddressLine3 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPostalCode | String | The ShipToAddressPostalCode column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressState | String | The ShipToAddressState column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressCountryRegion | String | The ShipToAddressCountryRegion column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressFaxCountryCode | String | The ShipToAddressFaxCountryCode column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressFaxExtension | String | The ShipToAddressFaxExtension column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressFax | String | The ShipToAddressFax column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone1CountryCode | String | The ShipToAddressPhone1CountryCode column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone1Extension | String | The ShipToAddressPhone1Extension column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone1 | String | The ShipToAddressPhone1 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone2CountryCode | String | The ShipToAddressPhone2CountryCode column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone2Extension | String | The ShipToAddressPhone2Extension column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone2 | String | The ShipToAddressPhone2 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone3CountryCode | String | The ShipToAddressPhone3CountryCode column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone3Extension | String | The ShipToAddressPhone3Extension column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressPhone3 | String | The ShipToAddressPhone3 column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressCountryRegionCodeId | String | The ShipToAddressCountryRegionCodeId column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressContactPerson | String | The ShipToAddressContactPerson column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressName | String | The ShipToAddressName column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressKeyCustomerId | String | The ShipToAddressKeyCustomerId column for the table SalesDocumentMiscellaneousTaxes. |
ShipToAddressId | String | The ShipToAddressId column for the table SalesDocumentMiscellaneousTaxes. |
ShippingMethodId | String | The ShippingMethodId column for the table SalesDocumentMiscellaneousTaxes. |
TaxAmountCurrency | String | The TaxAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
TaxAmount | Decimal | The TaxAmount column for the table SalesDocumentMiscellaneousTaxes. |
TaxExemptNumber1 | String | The TaxExemptNumber1 column for the table SalesDocumentMiscellaneousTaxes. |
TaxExemptNumber2 | String | The TaxExemptNumber2 column for the table SalesDocumentMiscellaneousTaxes. |
TaxRegistrationNumber | String | The TaxRegistrationNumber column for the table SalesDocumentMiscellaneousTaxes. |
TaxScheduleId | String | The TaxScheduleId column for the table SalesDocumentMiscellaneousTaxes. |
TaxesSalesDocumentTaxAggregate | String | The TaxesSalesDocumentTaxAggregate column for the table SalesDocumentMiscellaneousTaxes. |
TotalAmountCurrency | String | The TotalAmountCurrency column for the table SalesDocumentMiscellaneousTaxes. |
TotalAmount | Decimal | The TotalAmount column for the table SalesDocumentMiscellaneousTaxes. |
TrackingNumbersSalesTrackingNumberAggregate | String | The TrackingNumbersSalesTrackingNumberAggregate column for the table SalesDocumentMiscellaneousTaxes. |
TradeDiscountItem | String | The TradeDiscountItem column for the table SalesDocumentMiscellaneousTaxes. |
TransactionState | String | The TransactionState column for the table SalesDocumentMiscellaneousTaxes. |
Type | String | The Type column for the table SalesDocumentMiscellaneousTaxes. |
UPSZone | String | The UPSZone column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedDate01 | Datetime | The UserDefinedDate01 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedDate02 | Datetime | The UserDefinedDate02 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedList01 | String | The UserDefinedList01 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedList02 | String | The UserDefinedList02 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedList03 | String | The UserDefinedList03 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedText01 | String | The UserDefinedText01 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedText02 | String | The UserDefinedText02 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedText03 | String | The UserDefinedText03 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedText04 | String | The UserDefinedText04 column for the table SalesDocumentMiscellaneousTaxes. |
UserDefinedText05 | String | The UserDefinedText05 column for the table SalesDocumentMiscellaneousTaxes. |
WarehouseId | String | The WarehouseId column for the table SalesDocumentMiscellaneousTaxes. |
ExtensionsExtensionAggregate | String | The ExtensionsExtensionAggregate column for the table SalesDocumentMiscellaneousTaxes. |