PurchaseInvoiceMiscellaneousTaxes
Return a list of: PurchaseInvoiceMiscellaneousTaxes
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| Amount1099Currency | String | |
| Amount1099 | Decimal | |
| AuditTrailCode | String | |
| BatchKeyCreatedDateTime | Datetime | |
| BatchId | String | |
| BatchKeySource | String | |
| CreatedBy | String | |
| CreatedDate | Datetime | |
| CurrencyKeyISOCode | String | |
| Date | Datetime | |
| DistributionsAggregate | String | |
| ExchangeDate | Datetime | |
| ExchangeRate | Decimal | |
| FreightAmountCurrency | String | |
| FreightAmount | Decimal | |
| FreightTaxAmountCurrency | String | |
| FreightTaxAmount | Decimal | |
| FreightTaxBasis | String | |
| FreightTaxScheduleId | String | |
| FreightTaxesAggregate | String | |
| GeneralLedgerPostingDate | Datetime | |
| Id | String | |
| 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 | |
| MiscellaneousTaxesGLAccountId | String | |
| MiscellaneousTaxesGLAccountKeyIsEncrypted | Bool | |
| ModifiedDate | Datetime | |
| PaymentTermsId | String | |
| PostedBy | String | |
| PostedDate | Datetime | |
| Reference | String | |
| RemitToAddressId | String | |
| SubtotalCurrency | String | |
| Subtotal | Decimal | |
| TaxAmountCurrency | String | |
| TaxAmount | Decimal | |
| TaxScheduleId | String | |
| TaxesAggregate | String | |
| TermsDiscountItem | String | |
| TermsDiscountAvailableAmountCurrency | String | |
| TermsDiscountAvailableAmount | Decimal | |
| TermsDiscountDate | Datetime | |
| TermsDueDate | Datetime | |
| TradeDiscountAmountCurrency | String | |
| TradeDiscountAmount | Decimal | |
| TransactionState | String | |
| VendorDocumentNumber | String | |
| VendorId | String | |
| VendorName | String | |
| VoucherNumber | 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 |