PlannedOrderItems
Return a list of: PlannedOrderItems
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| DueDate | Datetime | |
| IsCRPScheduled | Bool | |
| ItemId | String | |
| ItemsAllocatedByOpenMO | Decimal | |
| ItemsAllocatedByReleasedMO | Decimal | |
| ItemsCanceled | Bool | |
| ItemsConsumedByOpenMO | Decimal | |
| ItemsConsumedByReleasedMO | Decimal | |
| ItemsDueDate | Datetime | |
| ItemsExceptionsHasException1 | Bool | |
| ItemsExceptionsHasException10 | Bool | |
| ItemsExceptionsHasException11 | Bool | |
| ItemsExceptionsHasException12 | Bool | |
| ItemsExceptionsHasException13 | Bool | |
| ItemsExceptionsHasException14 | Bool | |
| ItemsExceptionsHasException15 | Bool | |
| ItemsExceptionsHasException16 | Bool | |
| ItemsExceptionsHasException17 | Bool | |
| ItemsExceptionsHasException18 | Bool | |
| ItemsExceptionsHasException19 | Bool | |
| ItemsExceptionsHasException2 | Bool | |
| ItemsExceptionsHasException20 | Bool | |
| ItemsExceptionsHasException3 | Bool | |
| ItemsExceptionsHasException4 | Bool | |
| ItemsExceptionsHasException5 | Bool | |
| ItemsExceptionsHasException6 | Bool | |
| ItemsExceptionsHasException7 | Bool | |
| ItemsExceptionsHasException8 | Bool | |
| ItemsExceptionsHasException9 | Bool | |
| ItemsItemId | String | |
| ItemsLocationId | String | |
| ItemsMRPParentType | String | |
| ItemsMRPType | String | |
| ItemsMoveIn | Bool | |
| ItemsMoveOut | Bool | |
| ItemsOriginalDueDate | Datetime | |
| ItemsPhantomParent | String | |
| ItemsPlannedOrderId | String | |
| ItemsRequiredByOpenMO | Decimal | |
| ItemsRequiredByReleasedMO | Decimal | |
| ItemsSequenceNumber [KEY] | Int | |
| ItemsStatus | String | |
| ItemsStatusDescription | String | |
| LLC | Int | |
| LocationId | String | |
| PlannedOrderId | String | |
| QuantityToOrder | Decimal | |
| ReleaseDate | Datetime | |
| Replenishment | String | |
| RunNumber | Int | |
| Transferred | Bool | |
| UnitOfMeasure | String | |
| VendorId | 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 |