PurchaseOrderMiscellaneousTaxes
Return a list of: PurchaseOrderMiscellaneousTaxes
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
BackoutFreightTaxAmountCurrency | String | |
BackoutFreightTaxAmount | Decimal | |
BackoutMiscellaneousTaxAmountCurrency | String | |
BackoutMiscellaneousTaxAmount | Decimal | |
BackoutTaxAmountCurrency | String | |
BackoutTaxAmount | Decimal | |
BillToAddressId | String | |
BuyerId | String | |
CanceledSubtotalCurrency | String | |
CanceledSubtotal | Decimal | |
Comment | String | |
CommentId | String | |
ConfirmWith | String | |
ContractEndDate | Datetime | |
ContractNumber | String | |
CreatedBy | String | |
CreatedDate | Datetime | |
CurrencyKeyISOCode | String | |
CustomerId | String | |
Date | Datetime | |
DoesAllowSalesOrderCommitments | Bool | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FreightAmountCurrency | String | |
FreightAmount | Decimal | |
FreightTaxAmountCurrency | String | |
FreightTaxAmount | Decimal | |
FreightTaxBasis | String | |
FreightTaxScheduleId | String | |
FreightTaxesAggregate | String | |
IsOnHold | Bool | |
Id | String | |
LastEditDate | Datetime | |
LastPrintedDate | Datetime | |
LinesAggregate | String | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxAmountCurrency | String | |
MiscellaneousTaxAmount | Decimal | |
MiscellaneousTaxBasis | String | |
MiscellaneousTaxScheduleId | String | |
MiscellaneousTaxesExtensionsExtensionAggregate | String | |
MiscellaneousTaxesAuditTrailCode | String | |
MiscellaneousTaxesIsBackoutTax | Bool | |
MiscellaneousTaxesKeyPurchaseTransactionId [KEY] | String | |
MiscellaneousTaxesKeySequenceNumber [KEY] | Int | |
MiscellaneousTaxesKeyTaxDetailId [KEY] | String | |
MiscellaneousTaxesTaxAmountCurrency | String | |
MiscellaneousTaxesTaxAmount | Decimal | |
MiscellaneousTaxesTaxableAmountCurrency | String | |
MiscellaneousTaxesTaxableAmount | Decimal | |
MiscellaneousTaxesTotalAmountCurrency | String | |
MiscellaneousTaxesTotalAmount | Decimal | |
MiscellaneousTaxesTotalTaxPotentialAmountCurrency | String | |
MiscellaneousTaxesTotalTaxPotentialAmount | Decimal | |
ModifiedDate | Datetime | |
PaymentTermsId | String | |
PromisedDate | Datetime | |
PromisedShipDate | Datetime | |
PurchaseAddressExtensionsExtensionAggregate | String | |
PurchaseAddressCity | String | |
PurchaseAddressLine1 | String | |
PurchaseAddressLine2 | String | |
PurchaseAddressLine3 | String | |
PurchaseAddressPostalCode | String | |
PurchaseAddressState | String | |
PurchaseAddressCountryRegion | String | |
PurchaseAddressFaxCountryCode | String | |
PurchaseAddressFaxExtension | String | |
PurchaseAddressFax | String | |
PurchaseAddressPhone1CountryCode | String | |
PurchaseAddressPhone1Extension | String | |
PurchaseAddressPhone1 | String | |
PurchaseAddressPhone2CountryCode | String | |
PurchaseAddressPhone2Extension | String | |
PurchaseAddressPhone2 | String | |
PurchaseAddressPhone3CountryCode | String | |
PurchaseAddressPhone3Extension | String | |
PurchaseAddressPhone3 | String | |
PurchaseAddressCountryRegionCodeId | String | |
PurchaseAddressContactPerson | String | |
PurchaseAddressName | String | |
PurchaseAddressId | String | |
RemainingSubtotalCurrency | String | |
RemainingSubtotal | Decimal | |
RequestedDate | Datetime | |
RequisitionDate | Datetime | |
RevisionNumber | Int | |
ShipToAddressExtensionsExtensionAggregate | String | |
ShipToAddressCity | String | |
ShipToAddressLine1 | String | |
ShipToAddressLine2 | String | |
ShipToAddressLine3 | String | |
ShipToAddressPostalCode | String | |
ShipToAddressState | String | |
ShipToAddressCountryRegion | String | |
ShipToAddressFaxCountryCode | String | |
ShipToAddressFaxExtension | String | |
ShipToAddressFax | String | |
ShipToAddressPhone1CountryCode | String | |
ShipToAddressPhone1Extension | String | |
ShipToAddressPhone1 | String | |
ShipToAddressPhone2CountryCode | String | |
ShipToAddressPhone2Extension | String | |
ShipToAddressPhone2 | String | |
ShipToAddressPhone3CountryCode | String | |
ShipToAddressPhone3Extension | String | |
ShipToAddressPhone3 | String | |
ShipToAddressCountryRegionCodeId | String | |
ShipToAddressContactPerson | String | |
ShipToAddressName | String | |
ShipToAddressId | String | |
ShippingMethodId | String | |
Status | String | |
StatusGroup | String | |
SubtotalCurrency | String | |
Subtotal | Decimal | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxRegistrationNumber | String | |
TaxScheduleId | String | |
TaxesAggregate | String | |
TermsDiscountItem | String | |
TermsDiscountAvailableAmountCurrency | String | |
TermsDiscountAvailableAmount | Decimal | |
TermsDiscountDate | Datetime | |
TermsDueDate | Datetime | |
TimesPrinted | Int | |
TotalAmountCurrency | String | |
TotalAmount | Decimal | |
TradeDiscountAmountCurrency | String | |
TradeDiscountAmount | Decimal | |
TransactionState | String | |
Type | String | |
VendorId | String | |
VendorName | String | |
WorkflowPriority | String | |
WorkflowsAggregate | String |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
PagingColumn | String |