PurchaseOrderTaxes
Return a list of: PurchaseOrderTaxes
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 | |
| MiscellaneousTaxesAggregate | String | |
| 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 | |
| TaxesExtensionsExtensionAggregate | String | |
| TaxesAuditTrailCode | String | |
| TaxesIsBackoutTax | Bool | |
| TaxesKeyPurchaseTransactionId [KEY] | String | |
| TaxesKeySequenceNumber [KEY] | Int | |
| TaxesKeyTaxDetailId [KEY] | String | |
| TaxesTaxAmountCurrency | String | |
| TaxesTaxAmount | Decimal | |
| TaxesTaxableAmountCurrency | String | |
| TaxesTaxableAmount | Decimal | |
| TaxesTotalAmountCurrency | String | |
| TaxesTotalAmount | Decimal | |
| TaxesTotalTaxPotentialAmountCurrency | String | |
| TaxesTotalTaxPotentialAmount | Decimal | |
| 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 |