PurchaseInvoiceFreightTaxes
Return a list of: PurchaseInvoiceFreightTaxes
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 | |
FreightTaxesExtensionsExtensionAggregate | String | |
FreightTaxesAuditTrailCode | String | |
FreightTaxesIsBackoutTax | Bool | |
FreightTaxesKeyPurchaseTransactionId [KEY] | String | |
FreightTaxesKeySequenceNumber [KEY] | Int | |
FreightTaxesKeyTaxDetailId [KEY] | String | |
FreightTaxesTaxAmountCurrency | String | |
FreightTaxesTaxAmount | Decimal | |
FreightTaxesTaxableAmountCurrency | String | |
FreightTaxesTaxableAmount | Decimal | |
FreightTaxesTotalAmountCurrency | String | |
FreightTaxesTotalAmount | Decimal | |
FreightTaxesTotalTaxPotentialAmountCurrency | String | |
FreightTaxesTotalTaxPotentialAmount | Decimal | |
FreightTaxesGLAccountId | String | |
FreightTaxesGLAccountKeyIsEncrypted | Bool | |
GeneralLedgerPostingDate | Datetime | |
Id | String | |
LinesAggregate | String | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxAmountCurrency | String | |
MiscellaneousTaxAmount | Decimal | |
MiscellaneousTaxBasis | String | |
MiscellaneousTaxScheduleId | String | |
MiscellaneousTaxesAggregate | String | |
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 |