ODBC Driver for Microsoft Dynamics GP

Build 24.0.9062

PurchaseInvoiceLines

Return a list of: PurchaseInvoiceLines

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
LinesExtensionsExtensionAggregate String
LinesBackoutTaxAmountCurrency String
LinesBackoutTaxAmount Decimal
LinesCostCategoryId String
LinesExtendedCostCurrency String
LinesExtendedCost Decimal
LinesIsLandedCost Bool
LinesIsNonInventory Bool
LinesItemId String
LinesItemTaxScheduleId String
LinesKeyLineSequenceNumber [KEY] Int
LinesKeyPurchaseTransactionId [KEY] String
LinesProjectId String
LinesPurchaseOrderId String
LinesPurchaseOrderLineKeyLineSequenceNumber Int
LinesPurchaseOrderLineKeyPurchaseTransactionId String
LinesQuantityInvoiced Decimal
LinesReceiptsAggregate String
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxBasis String
LinesTaxesAggregate String
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUofM String
LinesVarianceGLAccountId String
LinesVarianceGLAccountKeyIsEncrypted Bool
LinesVendorItemDescription String
LinesVendorItemNumber String
LinesWarehouseTaxScheduleId 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062