ManufacturingOrderPickList
Return a list of: ManufacturingOrderPickList
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| ActualDemand | Decimal | |
| BOMCategory | String | |
| BOMRevisionLevel | String | |
| ComponentCalculation | String | |
| DateCompleted | Datetime | |
| Description | String | |
| DrawFromSite | String | |
| EndDate | Datetime | |
| EndingQty | Decimal | |
| IsArchivedMO | Bool | |
| IsQuickMO | Bool | |
| ItemId | String | |
| LastModifiedDate | Datetime | |
| LotNumber | String | |
| ManufacturingOrderDocumentId | String | |
| Notes | String | |
| OrderStatus | String | |
| OutSourced | String | |
| PickNumber | String | |
| PlanName | String | |
| PostToSite | String | |
| Priority | String | |
| RoutingName | String | |
| RoutingRevisionLevel | String | |
| ScheduleMethod | String | |
| SchedulingPreference | String | |
| StartDate | Datetime | |
| StartingQty | Decimal | |
| PickListActualConsumedQty | Decimal | |
| PickListAllocatedBy | String | |
| PickListAllocatedQty | Decimal | |
| PickListAllowedQty | Decimal | |
| PickListAlternateItemForId | String | |
| PickListAlternateItemSequence | Int | |
| PickListBOMCategory | String | |
| PickListBOMName | String | |
| PickListBOMSequence | Int | |
| PickListBOMUserDef1 | String | |
| PickListBOMUserDef2 | String | |
| PickListBackFlushedQty | Decimal | |
| PickListBaseUOMQty | Decimal | |
| PickListCurrentConsumedQty | Decimal | |
| PickListCurrentReturnToStockQty | Decimal | |
| PickListCurrentScrappedQty | Decimal | |
| PickListDateAllocated | Datetime | |
| PickListDateRequired | Datetime | |
| PickListDateResourcePlanIssued | Datetime | |
| PickListExplodedQty | Decimal | |
| PickListFixedQty | Decimal | |
| PickListIsActualConsumedChecked | Bool | |
| PickListIsAllocated | Bool | |
| PickListIsAlternateItem | Bool | |
| PickListIsBOMApproved | Bool | |
| PickListIsBOMSingleLot | Bool | |
| PickListIsBackFlushed | Bool | |
| PickListIsBackOrdered | Bool | |
| PickListIsFloorStock | Bool | |
| PickListIsIssued | Bool | |
| PickListIsOptionedItem | Bool | |
| PickListIsPhantomItem | Bool | |
| PickListIsResourcePlanCalculated | Bool | |
| PickListIsSubAssemblyItem | Bool | |
| PickListIssuedBy | String | |
| PickListIssuedQty | Decimal | |
| PickListItemId | String | |
| PickListLastModifiedDate | Datetime | |
| PickListLeadTimeOffset | Decimal | |
| PickListLinkToSequence | Int | |
| PickListLocation | String | |
| PickListMRPAmountCurrency | String | |
| PickListMRPAmount | Decimal | |
| PickListMRPAmount2Currency | String | |
| PickListMRPAmount2 | Decimal | |
| PickListManufacturingNote | String | |
| PickListManufacturingOrderDocumentId | String | |
| PickListMarkdownAmtCurrency | String | |
| PickListMarkdownAmt | Decimal | |
| PickListNonInventoryCreditIndex | Int | |
| PickListNonInventoryItemDescription | String | |
| PickListOffsetFrom | Decimal | |
| PickListOrderStatus | String | |
| PickListPOLineLineSequenceNumber | Int | |
| PickListPOLinePurchaseTransactionId | String | |
| PickListParentPartNumberId | String | |
| PickListPositionNumber | Int | |
| PickListPositionNumber2 | Int | |
| PickListPromotion | String | |
| PickListRefillCostCurrency | String | |
| PickListRefillCost | Decimal | |
| PickListReturnToStockQty | Decimal | |
| PickListRoutingName | String | |
| PickListRoutingSequence | String | |
| PickListScrappedQty | Decimal | |
| PickListSequence [KEY] | Int | |
| PickListSubAssemblyItemForId | String | |
| PickListSubAssemblyItemSequence | Int | |
| PickListSuggestedQty | Decimal | |
| PickListUnitCostCurrency | String | |
| PickListUnitCost | Decimal | |
| PickListUofM | String | |
| PickListVendorId | String | |
| PickListVendorName | String | |
| PickListWorkCenter | String | |
| RouteAggregate | 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 |