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