OpenPickLines
OpenPickLines
Columns
| Name | Type | Description |
| PickSlip | Long | PickSlip of OpenPickLines |
| PickSlipLine | Long | PickSlipLine of OpenPickLines |
| PickSlipType | String | PickSlipType of OpenPickLines |
| PickWave | Double | PickWave of OpenPickLines |
| DueDate | Date | DueDate of OpenPickLines |
| Organization | String | Organization of OpenPickLines |
| Item | String | Item of OpenPickLines |
| Revision | String | Revision of OpenPickLines |
| RequestedQuantity | Double | RequestedQuantity of OpenPickLines |
| UOM | String | UOM of OpenPickLines |
| SecondaryRequestedQuantity | Double | SecondaryRequestedQuantity of OpenPickLines |
| SecondaryUOM | String | SecondaryUOM of OpenPickLines |
| SourceSubinventory | String | SourceSubinventory of OpenPickLines |
| SourceLocatorId | Long | SourceLocatorId of OpenPickLines |
| SourceLocator | String | SourceLocator of OpenPickLines |
| DestinationSubinventory | String | DestinationSubinventory of OpenPickLines |
| DestinationAccount | String | DestinationAccount of OpenPickLines |
| DestinationLocator | String | DestinationLocator of OpenPickLines |
| Order | String | Order of OpenPickLines |
| SourceOrder | String | SourceOrder of OpenPickLines |
| SourceOrderLine | String | SourceOrderLine of OpenPickLines |
| ShippingPriority | String | ShippingPriority of OpenPickLines |
| Customer | String | Customer of OpenPickLines |
| Shipment | String | Shipment of OpenPickLines |
| ShipToLocation | String | ShipToLocation of OpenPickLines |
| ShippingMethod | String | ShippingMethod of OpenPickLines |
| RequiredDate | Date | RequiredDate of OpenPickLines |
| CreationDate | Datetime | CreationDate of OpenPickLines |
| TransactionId [KEY] | Long | TransactionId of OpenPickLines |
| TransactionType | String | TransactionType of OpenPickLines |
| MovementRequest | String | MovementRequest of OpenPickLines |
| MovementRequestLine | Long | MovementRequestLine of OpenPickLines |
| AllowUseOfCommonSuppliesFlag | Bool | AllowUseOfCommonSuppliesFlag of OpenPickLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |
| PItem | String | pItem |
| PMovementRequest | String | pMovementRequest |
| POrder | String | pOrder |
| POrganization | String | pOrganization |
| POrganizationId | String | pOrganizationId |
| PPickSlip | String | pPickSlip |
| PPickWave | String | pPickWave |
| PSourceSubinventory | String | pSourceSubinventory |
| PTransactionType | String | pTransactionType |