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 |