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 |