JDBC Driver for Microsoft Dynamics GP

Build 22.0.8462

PurchaseOrderLines

Return a list of: PurchaseOrderLines

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
LinesExtensionsExtensionAggregate String
LinesBackoutTaxAmountCurrency String
LinesBackoutTaxAmount Decimal
LinesComment String
LinesCommentId String
LinesCostCategoryId String
LinesDocumentDate Datetime
LinesExtendedCostCurrency String
LinesExtendedCost Decimal
LinesFreeOnBoard String
LinesInventoryGLAccountId String
LinesInventoryGLAccountKeyIsEncrypted Bool
LinesIsCapitalItem Bool
LinesIsNonInventory Bool
LinesItemDescription String
LinesItemId String
LinesItemTaxScheduleId String
LinesJobNumber String
LinesKeyLineSequenceNumber [KEY] Int
LinesKeyPurchaseTransactionId [KEY] String
LinesLandedCostGroupId String
LinesLineOrigin String
LinesProjectId String
LinesPromisedDate Datetime
LinesPromisedShipDate Datetime
LinesQuantityCanceled Decimal
LinesQuantityOrdered Decimal
LinesReleaseByDate Datetime
LinesReleasedDate Datetime
LinesRequestedBy String
LinesRequestedDate Datetime
LinesShipToAddressExtensionsExtensionAggregate String
LinesShipToAddressCity String
LinesShipToAddressLine1 String
LinesShipToAddressLine2 String
LinesShipToAddressLine3 String
LinesShipToAddressPostalCode String
LinesShipToAddressState String
LinesShipToAddressCountryRegion String
LinesShipToAddressFaxCountryCode String
LinesShipToAddressFaxExtension String
LinesShipToAddressFax String
LinesShipToAddressPhone1CountryCode String
LinesShipToAddressPhone1Extension String
LinesShipToAddressPhone1 String
LinesShipToAddressPhone2CountryCode String
LinesShipToAddressPhone2Extension String
LinesShipToAddressPhone2 String
LinesShipToAddressPhone3CountryCode String
LinesShipToAddressPhone3Extension String
LinesShipToAddressPhone3 String
LinesShipToAddressCountryRegionCodeId String
LinesShipToAddressContactPerson String
LinesShipToAddressName String
LinesShipToAddressId String
LinesShippingMethodId String
LinesSourceDocumentLineNumber String
LinesSourceDocumentNumber String
LinesStatus String
LinesTaxAmountCurrency String
LinesTaxAmount Decimal
LinesTaxBasis String
LinesTaxesAggregate String
LinesUnitCostCurrency String
LinesUnitCost Decimal
LinesUofM String
LinesVendorItemDescription String
LinesVendorItemNumber String
LinesWarehouseId String
LinesWarehouseTaxScheduleId 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
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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462